- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: report on CPU utilization frim each session
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-23-2004 04:02 PM
тАО11-23-2004 04:02 PM
report on CPU utilization frim each session
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,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-23-2004 04:08 PM
тАО11-23-2004 04:08 PM
Re: report on CPU utilization frim each session
#top
will give you more info.
if you still need detaled info look into "glance plus"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-23-2004 04:55 PM
тАО11-23-2004 04:55 PM
Re: report on CPU utilization frim each session
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-23-2004 05:19 PM
тАО11-23-2004 05:19 PM
Re: report on CPU utilization frim each session
thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-23-2004 06:48 PM
тАО11-23-2004 06:48 PM
Re: report on CPU utilization frim each session
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