Skip to Main Content
Forums

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!

V$ACTIVE_SESSION_HISTORY not populating

NadviJul 16 2010 — edited Jul 19 2010
Hi,

V$ACTIVE_SESSION_HISTORY & DBA_HIST_ACTIVE_SESS_HISTORY are not populating after a recent shutdown of instances.
DBA_HIST_ACTIVE_SESS_HISTORY holding some data until the instance shutdown time and V$ACTIVE_SESSION_HISTORY is blank.

Both these views were fine before the instance shutdown. As per my recent post, I am also facing problem with AWR report; populates with missing fields and with WARNING (-20023) ORA-20023:

Database is in good health and performing fine.

Thanks
This post has been answered by Centinul on Jul 16 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 16 2010
Added on Jul 16 2010
#general-database-discussions
16 comments
7,372 views