Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to calculate percentage of DB idle through time?

468057Apr 24 2010 — edited Apr 24 2010

So, let's say that I have a demanding procedure (I/O usually) that I would like to run during working time on Oracle DB (11gR2, aix) in calcualted amount of work...
to do that first I would need to know what is current percentage of DB being used...
so, how could I get this info during runtime?
could I get any of that data in certain time periods also? (15 sec, 1 min, etc.)

note that I run Oracle on 8 proc. AIX, so I would need to get this calc on each proc. possibly

Locked Post

New comments cannot be posted to this locked post.

Locked on May 22 2010

Added on Apr 24 2010

#db, #general-database-discussions, #time

6 comments

1,499 views