statistics_level for individual statistics name

From: Sami Seerangan <dba.orcl_at_gmail.com>
Date: Sun, 7 Aug 2005 23:01:44 -0400
Message-ID: <f09dd62805080720015fa24301@mail.gmail.com>

Hi:

10g R1,Win 2000.

SQL> show parameter statistics_level
NAME TYPE VALUE
------------------------------------ -----------

---

statistics_level string TYPICAL

How to change the activation_level for each statistics name given below here?

SQL> select STATISTICS_NAME,ACTIVATION_LEVEL from v$statistics_level;

STATISTICS_NAME ACTIVAT
---------------------------------------------------------------- -------
Buffer Cache Advice TYPICAL
MTTR Advice TYPICAL
Timed Statistics TYPICAL
Timed OS Statistics ALL
Segment Level Statistics TYPICAL
PGA Advice TYPICAL
Plan Execution Statistics ALL
Shared Pool Advice TYPICAL
Modification Monitoring TYPICAL
Longops Statistics TYPICAL
Bind Data Capture TYPICAL
Ultrafast Latch Statistics TYPICAL
Threshold-based Alerts TYPICAL
Global Cache Statistics TYPICAL
Cache Stats Monitor TYPICAL
Active Session History TYPICAL
Undo Advisor, Alerts and Fast Ramp up TYPICAL

17 rows selected.

SQL>
--

http://www.freelists.org/webpage/oracle-l Received on Sun Aug 07 2005 - 22:03:44 CDT