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博客

11G 中的V$ACTIVE_SESSION_HISTORY 视图没有数据

最新文章