ASH 试图没有数据
2012-2-14
Kevin Zou
在一个11G的环境中,发现V$ACTIVE_SESSION_HISTORY没有任何数据。
SQL> select * from v$version where rownum < 2;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
SQL> select count(*) from v$active_session_history;
COUNT(*)
----------
0
SQL> show parameter control_management_pack_access
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_management_pack_access string NONE
SQL> show parameter statistics_level
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
statistics_level string TYPICAL
statistics_level 参数已经设置为TYPICAL,怎么还是没有收集到SESSION的活动信息呢?
原来打开会话的收集,除了大家知道的参数外,还有一个新的参数CONTROL_MANAGEMENT_PACK_ACCESS 。它的值可以为NONE | DIAGNOSTIC | DIAGNOSTIC+TUNING,
默认值为DIAGNOSTIC+TUNING。
每个数值代表的意义:
The DIAGNOSTIC pack includes AWR, ADDM, and so on.
The TUNING pack includes SQL Tuning Advisor, SQLAccess Advisor, and so on.
A license for DIAGNOSTIC is required for enabling the TUNING pack.
设置该参数为DIAGNOSTIC+TUNING,看下效果:
SQL> select count(*) from test;
COUNT(*)
----------
63595
Elapsed: 00:00:00.16
SQL> select count(*) from v$active_session_history;
COUNT(*)
----------
0
Elapsed: 00:00:00.00
SQL>
SQL> alter system set control_management_pack_access="DIAGNOSTIC+TUNING" scope=s
pfile;
System altered.
Elapsed: 00:00:00.01
SQL> startup force
ORACLE instance started.
Total System Global Area 3140026368 bytes
Fixed Size 2179856 bytes
Variable Size 1845497072 bytes
Database Buffers 1275068416 bytes
Redo Buffers 17281024 bytes
Database mounted.
Database opened.
SQL> select count(*) from v$actice_session_history;
select count(*) from v$actice_session_history
*
ERROR at line 1:
ORA-00942: table or view does not exist
Elapsed: 00:00:00.05
SQL> select count(*) from v$active_session_history;
COUNT(*)
----------
30
Elapsed: 00:00:00.06
-THE END-
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/40239/viewspace-716206/,如需转载,请注明出处,否则将追究法律责任。