oracle 常见v$视图整理
来源:互联网 发布:更换断桥铝门窗 知乎 编辑:程序博客网 时间:2024/05/16 07:20
1.查看备份,恢复性能
V$BACKUP_SYNC_IO
V$BACKUP_ASYNC_IO
2.? V$IR_FAILURE:
List of all failures, including closed ones (result of the LISTFAILUREcommand)
? V$IR_MANUAL_CHECKLIST:
List of manual advice (result of the ADVISEFAILUREcommand)
? V$IR_REPAIR:
List of repairs (result of the ADVISEAILUREcommand)
? V$IR_FAILURE_SET:
Cross-reference of failure and advice identifiers
3.
V$DATABASE_BLOCK_CORRUPTION
查看损坏的数据块
4.V$TRANSACTION
哪个事务正在使用的undo segment
5.V$UNDOSTAT
You can query V$UNDOSTAT.TUNED_UNDORETENTIONto determine the amountof time for which undo is retained for the current undotablespace.
6.
V$MEMORY_TARGET_ADVISOR
Note:You can also look at the memory target advisor
7.
V$MEMORY_DYNAMIC_COMPONENTS
has the current status of all memory components
V$MEMORY_RESIZE_OPS
has a circular history buffer of the last 800 memory resizerequests
V$MEMORY_TARGET_ADVICE
provides tuning advice for the MEMORY_TARGETinitializationparameter
8.实例统计信息
V$SGASTAT
? pool
? name
? bytes
V$SYSSTAT
? statistic#
? name
? class
? value
? stat_id
V$SYSTEM_EVENT
? event
? total_waits
? total_timeouts
? time_waited
? average_wait
? time_waited_micro
V$EVENT_NAME
? event_number
? event_id
? name
? parameter1
? parameter2
? parameter3
? wait_class
V$SYSTEM_WAIT_CLASS
? wait_class_id
? wait_class#
? wait_class
? total_waits
? time_waited
9.会话相关的统计信息
V$STATNAME
?statistic#
?name
?class
V$SESSTAT
?sid
?statistic#
?value
V$SESSION
?sid
?serial#
?username
?command
?osuser
?seq#
?event#
?event
?p1/2/3text
?p1/2/3
?p1/2/3raw
?wait_class
?wait_time
?seconds_in_wait
?state
?...
V$SESSION_EVENT
?sid
?event
?total_waits
?total_timeouts
?time_waited
?average_wait
?max_wait
?time_waited_micro
?event_id
V$EVENT_NAME
?event#
?name
?parameter1
?parameter2
?parameter3
10.服务相关的统计信息
V$SERVICE_EVENT
:Aggregated wait counts and wait times for each service, on a perevent basis
? V$SERVICE_WAIT_CLASS:
Aggregated wait counts and wait times for each service on a waitclass basis
11.Troubleshooting and Tuning Views
Instance/Database
V$DATABASE
V$INSTANCE
V$PARAMETER
V$SPPARAMETER
V$SYSTEM_PARAMETER
V$PROCESS
V$BGPROCESS
V$PX_PROCESS_SYSSTAT
V$SYSTEM_EVENT
Disk
V$DATAFILE
V$FILESTAT
V$LOG
V$LOG_HISTORY
V$DBFILE
V$TEMPFILE
V$TEMPSEG_USAGE
V$SEGMENT_STATISTICS
Contention
V$LOCK
V$UNDOSTAT
V$WAITSTAT
V$LATCH
Memory
V$BUFFER_POOL_STATISTICS
V$LIBRARYCACHE
V$SGAINFO
V$PGASTAT
V$BACKUP_SYNC_IO
V$BACKUP_ASYNC_IO
2.? V$IR_FAILURE:
List of all failures, including closed ones (result of the LISTFAILUREcommand)
? V$IR_MANUAL_CHECKLIST:
? V$IR_REPAIR:
? V$IR_FAILURE_SET:
Cross-reference of failure and advice identifiers
3.
V$DATABASE_BLOCK_CORRUPTION
查看损坏的数据块
4.V$TRANSACTION
哪个事务正在使用的undo segment
5.V$UNDOSTAT
You can query V$UNDOSTAT.TUNED_UNDORETENTIONto determine the amountof time for which undo is retained for the current undotablespace.
6.
V$MEMORY_TARGET_ADVISOR
Note:You can also look at the memory target advisor
7.
V$MEMORY_DYNAMIC_COMPONENTS
has the current status of all memory components
V$MEMORY_RESIZE_OPS
has a circular history buffer of the last 800 memory resizerequests
V$MEMORY_TARGET_ADVICE
provides tuning advice for the MEMORY_TARGETinitializationparameter
8.实例统计信息
V$SGASTAT
? pool
? name
? bytes
V$SYSSTAT
? statistic#
? name
? class
? value
? stat_id
V$SYSTEM_EVENT
? event
? total_waits
? total_timeouts
? time_waited
? average_wait
? time_waited_micro
V$EVENT_NAME
? event_number
? event_id
? name
? parameter1
? parameter2
? parameter3
? wait_class
V$SYSTEM_WAIT_CLASS
? wait_class_id
? wait_class#
? wait_class
? total_waits
? time_waited
9.会话相关的统计信息
V$STATNAME
?statistic#
?name
?class
V$SESSTAT
?sid
?statistic#
?value
V$SESSION
?sid
?serial#
?username
?command
?osuser
?seq#
?event#
?event
?p1/2/3text
?p1/2/3
?p1/2/3raw
?wait_class
?wait_time
?seconds_in_wait
?state
?...
V$SESSION_EVENT
?sid
?event
?total_waits
?total_timeouts
?time_waited
?average_wait
?max_wait
?time_waited_micro
?event_id
V$EVENT_NAME
?event#
?name
?parameter1
?parameter2
?parameter3
10.服务相关的统计信息
V$SERVICE_EVENT
:Aggregated wait counts and wait times for each service, on a perevent basis
? V$SERVICE_WAIT_CLASS:
Aggregated wait counts and wait times for each service on a waitclass basis
11.Troubleshooting and Tuning Views
Instance/Database
V$DATABASE
V$INSTANCE
V$PARAMETER
V$SPPARAMETER
V$SYSTEM_PARAMETER
V$PROCESS
V$BGPROCESS
V$PX_PROCESS_SYSSTAT
V$SYSTEM_EVENT
Disk
V$DATAFILE
V$FILESTAT
V$LOG
V$LOG_HISTORY
V$DBFILE
V$TEMPFILE
V$TEMPSEG_USAGE
V$SEGMENT_STATISTICS
Contention
V$LOCK
V$UNDOSTAT
V$WAITSTAT
V$LATCH
Memory
V$BUFFER_POOL_STATISTICS
V$LIBRARYCACHE
V$SGAINFO
V$PGASTAT
- oracle 常见v$视图整理
- oracle 常见v$视图整理
- oracle v$database 视图
- oracle v$database 视图
- oracle v$视图
- oracle视图 v$type_size
- oracle v$视图
- oracle v$database 视图
- Oracle的v$动态视图
- oracle v$database视图分析
- Oracle v$session_longops 视图说明
- Oracle v$session_longops 视图说明
- ORACLE V$SQL视图说明
- ORACLE V$SQL视图说明
- oracle-动态性能(V$)视图
- oracle 动态性能(V$)视图
- Oracle dba 常用视图
- Oracle 数据字典视图(V$,GV$,X$)
- Oracle Database …
- impdp将不同路径下的dump文件同时…
- asm_diskstring 参数的设置使用
- oracle11g OMF 特性与添…
- HP-ux oracle 10.2.0.4&…
- oracle 常见v$视图整理
- oracle 11.2.0.3 for&nb…
- (转)ORACLE WITH AS 用法
- how to do with a slow oracle dat…
- AIX 64 11.0.2.3.0
- 如何在90天内学会一门语言
- IBM小机+ORACLE数据库迅猛提升事物…
- scn 与 timestamp的相互转换
- ocp11考纲