How do you know which SQL uses more system resources?
Please share your views.
Thanks in advance.
No Comments Posted for this Article.
Processes that Used Too Much CPU Resources
- Use 'top' command to find which processes (PID) eat much CPUs. - Join v$process & v$session & v$sqlarea to know what happens in. Check alert log for any error messages/trace file generated...
Oracle Service Consuming Lot of CPU Resource
System Config : OS : Win 2000 A.S Oracle 11.5.8 Rdbms : 8.1.7 Usaully my Oracle use to work very good but some times once in a blue moon , when I restarted my Database after performing a...