-
Heavy load on the server
Hi All,
We are running with Oracle 9.0.1.4 on RH linux 7.2. From yesterday onwards, Load on the server is just increasing heavily and at a point it reached to 19.95% and 100% of CPU Utilization. When i tried to track the processes running on the server, i could not find any of the SQL statement in TOAD or OEM using that SPID tracked in the TOP Session. Can any one help me please , how to find the machine name/IP address and its SQL text for that session, username, schemaname etc given an SPID. We had to restart the machine for twice. please help me ...
Thanks in advance
PNRDBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|