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%.