Asked: Feb 21 2008 10:12 AM GMT
Asked by: IRFANB146
Database problem of Stop working
Oracle administration,
Oracle 10g,
Debian
We are working in Oracle 10g on Linux Debian 32 bit, A week back we had a problem that i was unable to access any tool of oracle in the morning, Everything was fine previously . when i try to write any command server was too slow and when i use sqlplus it is unable to run no reply then i use top command where i find CPU is too busy by USer using 40% and system using 25% in VMSTAT it was quite clear that there are runnable queue waiting for CPU time. But we could not find out the session which is doing so . When we kill Oracle user then CPU wqas fine after that i went to see Oracle alert log but no clue in that then i see ADDM report, Last snap shot was at 2:00 AM after an hour no snap wsa taken by Oracle. Now i do not know what happened to the database. No was working at 2:00 AM
