- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: CPU Utilization Breakdown by DB
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
тАО03-31-2005 06:42 AM
тАО03-31-2005 06:42 AM
Using Accounting, all db instances are bundled into one "oracle" line, so I can't see the breakdown by individual database. I understand why this is happening, but does anybody know how to make it report by oracle"dbname" rather than just oracle using Accounting?
Or....what do other people use if they need to break down CPU utilization by database? I'd love to be able to do this by day, week, month; but realistically just getting it broken out in real-time would be helpful.
Thanks...
Jim
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-31-2005 06:46 AM
тАО03-31-2005 06:46 AM
Re: CPU Utilization Breakdown by DB
application - database1
user = database_user1
file = oracle*,*ora_*
Same for other databases.
Restart scopeux.
There might be way to do that in accounting also, but there also I think you will have to different on the basis of user id.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-31-2005 06:57 AM
тАО03-31-2005 06:57 AM
Re: CPU Utilization Breakdown by DB
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-31-2005 07:00 AM
тАО03-31-2005 07:00 AM
Re: CPU Utilization Breakdown by DB
Do you have glance/measureware and perfview ??
if not, well I'd say it's time to tell management that you need it to perform the tasks they have assigned you.
live free or die
harry d brown jr
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-31-2005 07:06 AM
тАО03-31-2005 07:06 AM
Re: CPU Utilization Breakdown by DB
OS: HP-UX 11i
I do have GlancePlus and PRM at my disposal. PRM is not configured yet, part of this exercise was meant to be a precursor to configuring it.
Thx...Jim
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-31-2005 07:10 AM
тАО03-31-2005 07:10 AM
Re: CPU Utilization Breakdown by DB
Not sure about this.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-31-2005 07:15 AM
тАО03-31-2005 07:15 AM
Re: CPU Utilization Breakdown by DB
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-31-2005 11:50 AM
тАО03-31-2005 11:50 AM
Re: CPU Utilization Breakdown by DB
RAC mentions one option, presuming you have MeasureWare, you could breakout some things using the ~ /perf/parm file. If there is some uniqueness to each oracle, try and close in on what you can.
For that day/week/month thing, well your friend and mine, PW, developed a super fantastic webpage that pulls in MWA data that creates great graphs. We put it up on our systems and Mgmt doesn't call asking about performance anymore! This with perfview-and any fluxes in performance-and we can prove who/what/when & where.
....a picture says a thousand words....
[ shame they wait listed his presentation for this last year... ]
Rgrds,
Rita
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-01-2005 04:10 AM
тАО04-01-2005 04:10 AM
SolutionThis is very simple:
- Run each oracle instance with unique process template names like ora_dbwr_TESTDB (and so on all processes of that instance)
- in /var/opt/perf/parm: seperate each DB with its name:
application = TESTDB
file = *TESTDB
- and the end of the /var/opt/perf/parm, put a line like:
application = other_oracle
file = ora*
regards,
peyman;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-01-2005 04:33 AM
тАО04-01-2005 04:33 AM
Re: CPU Utilization Breakdown by DB
I'm messing with the /etc/prmconf file now and seeing some good results from 'prmanalyze -s prmid'. Just as I can with parm, I can group processes to form database groups.
Now it's just a matter of piecing it all together (ie: setting up cron for the accounting jobs- ckpacct, runacct, etc) and running reports against some long term data.
I'll keep this open till I finish this next week in case anybody has any refreshing thoughts....but thank you to everybody that has contributed so far. Hope all is well Rita.
Jim