ITPub博客

今天查看数据库的alert日志总出现了如下的警告。Archived Log entry 202 added for thread 1 sequence 202 ID 0x1ed7a02c dest 1:Sat Mar 15 01:37:30 2014Completed checkpoint up to RBA [0xca.2.10], SCN: 267711453Sat Mar 15 01:44:58 2014Active Session History (ASH) performed an emergency flush. This may ...

老是在用ASH，昨天心血来潮，想看看ash视图里面是怎么样的，过程也算曲折，不过也算抛砖引玉。先看看v$active_session_history的情况。-->是个同义词SQL> select owner,object_name,object_type from dba_objects where object_name='V$ACTIVE_SESSION_HISTORY';OWNER      &nb...