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
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!