Skip to Main Content

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!

Database Peak load Time how to find

gl32546848Sep 14 2009 — edited Sep 14 2009
Oracle : 10.2.0.4
os : Linux -64

Query : How to calculate the High peak load time and Low peak load on the data from the data for the last 24 hrs.

V$ACTIVE_SESSION_HISTORY can give sessions

to get Peak load on CPU in the last 24 hrs.

If you have any ready sql pl. help me.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 12 2009
Added on Sep 14 2009
2 comments
3,051 views