V$ACTIVE_SESSION_HISTORY not populating [message #466041] |
Fri, 16 July 2010 10:03 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
nadvi
Messages: 46 Registered: May 2006 Location: Canada
|
Member |
![ferdousnadvi%40yahoo.com](/forum/theme/orafaq/images/yahoo.png)
|
|
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.
I am also facing problem with AWR report; populates with missing fields and with WARNING
Quote:WARNING (-20023) ORA-20023: Missing start and end values for time model stat: parse time elapsed WARNING (-20023) ORA-20023: Missing start and end values for time model stat: DB CPU WARNING (-20016) ORA-20016: Missing value for SGASTAT: free memory WARNING (-20016) ORA-20016: Missing value for SGASTAT: free memory WARNING (-20009) ORA-20009: Missing System Statistic logons current WARNING (-20009) ORA-20009: Missing System Statistic logons current WARNING (-20009) ORA-20009: Missing System Statistic opened cursors current WARNING (-20009) ORA-20009: Missing System Statistic opened cursors current WARNING (-20023) ORA-20023: Missing start and end values for time model stat: sql execute elapsed time WARNING (-20008) ORA-20008: Missing Init.ora parameter undo_management WARNING (-20008) ORA-20008: Missing Init.ora parameter db_block_size WARNING (-20016) ORA-20016: Missing value for SGASTAT: log_buffer WARNING (-20023) ORA-20023: Missing start and end values for time model stat: DB time WARNING (-20008) ORA-20008: Missing Init.ora parameter timed_statistics WARNING (-20008) ORA-20008: Missing Init.ora parameter timed_statistics WARNING (-20008) ORA-20008: Missing Init.ora parameter statistics_level WARNING (-20008) ORA-20008: Missing Init.ora parameter statistics_level WARNING (-20008) ORA-20008: Missing Init.ora parameter sga_target WARNING (-20008) ORA-20008: Missing Init.ora parameter pga_aggregate_target WARNING (-20023) ORA-20023: Missing start and end values for time model stat: background cpu time WARNING (-20023) ORA-20023: Missing start and end values for time model stat: background elapsed time WARNING (-20023) ORA-20023: Missing start and end values for time model stat: connection management call elapsed time WARNING (-20016) ORA-20016: Missing value for SGASTAT: buffer_cache WARNING (-20016) ORA-20016: Missing value for SGASTAT: buffer_cache WARNING: Since the DB Time is less than one second, there was minimal foreground activity in the snapshot period. Some of the percentage values will be invalid.
Database is in good health and performing fine.
Thanks
[Updated on: Fri, 16 July 2010 10:09] by Moderator Report message to a moderator
|
|
|
|
|
Re: V$ACTIVE_SESSION_HISTORY not populating [message #466129 is a reply to message #466046] |
Sat, 17 July 2010 02:37 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
I think this is a known problem, several mentions on metalink. You could try to drop your AWR with the catnoawr.sql script, then re-create it with catawr.sql but of course you would lose all the histotical data. Or possibly, following the hints in the metalink articles, you could try to fix the broken indexes? If that is what it is?
|
|
|