oracle 常见v$视图整理

5nckh0mpm5

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:
<wbr>List of manual advice (result of the ADVISEFAILUREcommand)<br>? V$IR_REPAIR:<br><wbr>List of repairs (result of the ADVISEAILUREcommand)<br>? V$IR_FAILURE_SET:<br>Cross-reference of failure and advice identifiers<br><br>3.<br>V$DATABASE_BLOCK_CORRUPTION<br>查看损坏的数据块<br><br>4.V$TRANSACTION<br>哪个事务正在使用的undo segment<br><br>5.V$UNDOSTAT<br>You can query V$UNDOSTAT.TUNED_UNDORETENTIONto determine the amountof time for which undo is retained for the current undotablespace.<br><br>6.<br>V$MEMORY_TARGET_ADVISOR<br>Note:You can also look at the memory target advisor<br><br>7.<br>V$MEMORY_DYNAMIC_COMPONENTS<br>has the current status of all memory components<br><wbr><br>V$MEMORY_RESIZE_OPS<br>has a circular history buffer of the last 800 memory resizerequests<br><br>V$MEMORY_TARGET_ADVICE<br>provides tuning advice for the MEMORY_TARGETinitializationparameter<br><br>8.实例统计信息<br>V$SGASTAT<br>? pool<br>? name<br>? bytes<br>V$SYSSTAT<br>? statistic#<br>? name<br>? class<br>? value<br>? stat_id<br>V$SYSTEM_EVENT<br>? event<br>? total_waits<br>? total_timeouts<br>? time_waited<br>? average_wait<br>? time_waited_micro<br>V$EVENT_NAME<br>? event_number<br>? event_id<br>? name<br>? parameter1<br>? parameter2<br>? parameter3<br>? wait_class<br>V$SYSTEM_WAIT_CLASS<br>? wait_class_id<br>? wait_class#<br>? wait_class<br>? total_waits<br>? time_waited<br><br><br>9.会话相关的统计信息<br>V$STATNAME<br>?statistic#<br>?name<br>?class<br><br>V$SESSTAT<br>?sid<br>?statistic#<br>?value<br><br>V$SESSION<br>?sid<br>?serial#<br>?username<br>?command<br>?osuser<br>?seq#<br>?event#<br>?event<br>?p1/2/3text<br>?p1/2/3<br>?p1/2/3raw<br>?wait_class<br>?wait_time<br>?seconds_in_wait<br>?state<br>?...<br><br>V$SESSION_EVENT<br>?sid<br>?event<br>?total_waits<br>?total_timeouts<br>?time_waited<br>?average_wait<br>?max_wait<br>?time_waited_micro<br>?event_id<br><br>V$EVENT_NAME<br>?event#<br>?name<br>?parameter1<br>?parameter2<br>?parameter3<br><br>10.服务相关的统计信息<br>V$SERVICE_EVENT<br>:Aggregated wait counts and wait times for each service, on a perevent basis<br><br>? V$SERVICE_WAIT_CLASS:<br>Aggregated wait counts and wait times for each service on a waitclass basis<br><br><br>11.Troubleshooting and Tuning Views<br>Instance/Database<br>V$DATABASE<br>V$INSTANCE<br>V$PARAMETER<br>V$SPPARAMETER<br>V$SYSTEM_PARAMETER<br>V$PROCESS<br>V$BGPROCESS<br>V$PX_PROCESS_SYSSTAT<br>V$SYSTEM_EVENT<br><br>Disk<br>V$DATAFILE<br>V$FILESTAT<br>V$LOG<br>V$LOG_HISTORY<br>V$DBFILE<br>V$TEMPFILE<br>V$TEMPSEG_USAGE<br>V$SEGMENT_STATISTICS<br><br>Contention<br>V$LOCK<br>V$UNDOSTAT<br>V$WAITSTAT<br>V$LATCH<br><br>Memory<br>V$BUFFER_POOL_STATISTICS<br>V$LIBRARYCACHE<br>V$SGAINFO<br>V$PGASTAT</wbr></wbr></wbr>