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/，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- 在windows 打补丁遇到CODE=41的错误
- CIO 必须有技术的预判能力
- windows下测试IO性能的工具
- 11G 新特性： 新加的提示 CHANGE_DUPKEY_ERROR_INDEX
- 11G 新特性： 新加的提示IGNORE_ROW_ON_DUPKEY_INDEX
- 11G 新特性： 可通过DUPLICATE 命令不需要连接目标数据来复制数据库
- 初始 Oracle Secure Backup (OSB) Cloud Module
- Oracle 11G 新特性 Automatic block repair
- 在AIX 平台下遇到ORA-01031: insufficient privileges
- 在关闭数据库时遇到 waiting for active calls to complete
