statistics_level
来源:互联网 发布:c语言数组初始化全0 编辑:程序博客网 时间:2024/05/17 04:13
statistics_level控制数据库收集统计信息的级别,有三个参数值:
BASIC :收集基本的统计信息
TYPICAL:收集大部分统计信息(数据库的默认设置)
ALL:收集全部统计信息
[oracle@linuxoracle oracle]$ sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on Fri Nov 16 09:47:38 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
sys@DG1> desc v$statistics_level;
Name Null? Type
----------------------------------------------------- -------- ------------------------------------
STATISTICS_NAME VARCHAR2(64)
DESCRIPTION VARCHAR2(4000)
SESSION_STATUS VARCHAR2(8)
SYSTEM_STATUS VARCHAR2(8)
ACTIVATION_LEVEL VARCHAR2(7)
STATISTICS_VIEW_NAME VARCHAR2(64)
SESSION_SETTABLE VARCHAR2(3)
sys@DG1> select STATISTICS_NAME,ACTIVATION_LEVEL,STATISTICS_VIEW_NAME from v$statistics_level;
STATISTICS_NAME ACTIVAT STATISTICS_VIEW_NAME
---------------------------------------- ------- ----------------------------------------------------------------
Buffer Cache Advice TYPICAL V$DB_CACHE_ADVICE
MTTR Advice TYPICAL V$MTTR_TARGET_ADVICE
Timed Statistics TYPICAL
Timed OS Statistics ALL
Segment Level Statistics TYPICAL V$SEGSTAT
PGA Advice TYPICAL V$PGA_TARGET_ADVICE
Plan Execution Statistics ALL V$SQL_PLAN_STATISTICS
Shared Pool Advice TYPICAL V$SHARED_POOL_ADVICE
8 rows selected.
- STATISTICS_LEVEL
- STATISTICS_LEVEL
- statistics_level
- oracle statistics_level
- V$STATISTICS_LEVEL
- statistics_level相关
- statistics_level 参数的应用
- statistics_level参数的介绍
- statistics_level 参数的应用
- 关于参数STATISTICS_LEVEL
- statistics_level参数说明
- OCP-043 STATISTICS_LEVEL initialization parameter
- 10g中表监控与statistics_level
- oracle 10g中表监控与statistics_level
- 10g中表监控与statistics_level
- 35、10g中表监控与statistics_level
- 11g自适应游标及statistics_level
- 设置 STATISTICS_LEVEL = BASIC 会禁用哪些数据库特性
- Winform 开机自动启动
- Maven 使用介绍
- BZOJ 1502 NOI 2005 月下柠檬树
- MySQL优化之JOIN
- Android 开发学习记录一 08-10-2015
- statistics_level
- 数据持久化-NSKeyedArchiver
- 使用limit头文件查看特定机器上数据类型数据范围
- hpuoj1697 CZY找句子【KMP】
- HDU 1081 To The Max(动态规划)
- OC学习 -- 浅拷贝和深拷贝
- 树, 二叉树, 二叉搜索树
- 非阻塞socket与epoll的ET模式结合使用注意事项
- HDOJ-2005-第几天