Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

report on CPU utilization frim each session

Printaporn_1
Esteemed Contributor

report on CPU utilization frim each session

Hi,
I have server that running mutiple Oracle instance , each instance have mutiple schema.
I need to have report on CPU usage on all oracle session in this machine ( at a given time) on how many CPU% it taken from servers.
how can I have query on those info.
thanks in advance,
enjoy any little thing in my life
4 REPLIES
Ravi_8
Honored Contributor

Re: report on CPU utilization frim each session

HI,

#top

will give you more info.

if you still need detaled info look into "glance plus"
never give up
Con O'Kelly
Honored Contributor

Re: report on CPU utilization frim each session

Hi

If you have Measureware (OVPA) installed then this is by far the best method to report on resource usage (CPU, memory, disk etc) by individual sets of applications.

You can group each Oracle instance into its own application group and then report on the CPU usage for each application group.
The application groups are configured in the MWA parm file (/var/opt/perf/parm).
See the Measureware Users guide for details on setting up Application Groups (Its in the Parm file section in chapter 2).
http://ovweb.external.hp.com/ovnsmdps/pdf/ara1204_mwausers_c0382_may04.pdf

You can also view the applcation group usage in glance as follows:
$ glance -A

Cheers
Con

Printaporn_1
Esteemed Contributor

Re: report on CPU utilization frim each session

sorry , I forgot to tell that I want information at specific oracle session also , like client machine name. similar info as in Oracle EM , session detail.
thanks
enjoy any little thing in my life
Wim Rombauts
Honored Contributor

Re: report on CPU utilization frim each session

I think you will have to do this from within Oracle.
If you activate the Oracle Resource Manager, you can put every user in a separate Resource Consumer Group and with view V$RSRC_RESOURCE_GROUP you can query the used CPU-time (in µsec) for every Resource Consumer Grou