top of page
To see this working, head to your live site.
if a server contains n number of databases, cpu is 100% what is the command to check which db is consuming more cpu with out logging into db
if a server contains n number of databases, cpu is 100% what is the command to check which db is consuming more cpu with out logging into db
2 answers0 replies
Like
2 Comments
bottom of page
Hi @Piyush Ranjan Thanks for your reply, my question is how to check which database consuming more cpu out n number of databases to login into that particular db and check since we can't login into all the databases and check to confirm that.
Server statistics can be viewed in a variety of ways using standard server-side UNIX and Linux tools such as vmstat, glance , top and sar .
The goal is to ensure that the database server has enough CPU and RAM resources at all times in order to manage the Oracle requests.
Oracle has many operations that are CPU intensive, and tuning can reduce CPU:
Logical I/O (consistent gets) has high CPU overhead, and buffer touches can be reduced via SQL tuning (adding more selective indexes, materialized views).
Library cache contention (high parses) drives-up CPU
Having 100% CPU is not always a problem, it's normal for virtual memory servers to drive CPU consumption to 100%.