Oracle 常用性能视图一览表(10g)

ゝ一纸荒年。 2022-05-15 07:34 378阅读 0赞

\--\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*  
\-- Oracle 常用性能视图一览表(10g)   
\--\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*  
  
Advisors   
Information related to cache advisors

> v$pga\_target\_advice v$shared\_pool\_advice v$pga\_target\_advice\_histogram v$java\_pool\_advice v$mttr\_target\_advice v$streams\_pool\_advice(10.2) v$px\_buffer\_advice v$sga\_target\_advice(10.2) v$db\_cache\_advice v$advisor\_progress(10.2)

> v$asm\_alias(10.1) v$asm\_diskgroup\_stat(10.2) v$asm\_client(10.1) v$asm\_file(10.1) v$asm\_disk(10.1) v$asm\_operation(10.1) v$asm\_disk\_stat(10.2) v$asm\_template(10.1) v$asm\_diskgroup(10.1)

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*/  
Backup/recovery   
Information related to database backups and recovery, including last backup, archive logs,  
state of files for backup, and recovery

> v$archive v$backup\_archivelog\_details(10.2) v$archived\_log v$backup\_archivelog\_summary(10.2) v$archive\_dest v$backup\_controlfile\_details(10.2) v$archive\_dest\_status v$backup\_controlfile\_summary(10.2) v$archive\_gap v$backup\_copy\_details(10.2) v$archive\_processes v$backup\_copy\_summary(10.2) v$backup v$backup\_files(10.1) v$backup\_async\_io v$backup\_piece\_details(10.2) v$backup\_corruption v$backup\_set\_details(10.2) v$backup\_datafile v$backup\_set\_summary(10.2) v$backup\_device v$backup\_spfile v$backup\_piece v$backup\_spfile\_details(10.2) v$backup\_redolog v$backup\_spfile\_summary(10.2) v$backup\_set v$datafile\_header v$backup\_sync\_io v$flash\_recovery\_area\_usage(10.2) v$block\_change\_tracking v$flashback\_database\_log(10.1) v$copy\_corruption v$flashback\_database\_stat(10.1) v$database\_block\_corruption v$obsolete\_backup\_files v$database\_incarnation v$offline\_range v$datafile\_copy v$proxy\_archivelog\_details(10.2) v$deleted\_object v$proxy\_archivelog\_summary(10.2) v$fast\_start\_servers v$proxy\_copy\_details(10.2) v$fast\_start\_transactions v$proxy\_copy\_summary(10.2) v$instance\_recovery v$recovery\_file\_dest(10, 1) v$mttr\_target\_advice v$restore\_point(10.2) v$proxy\_archivedlog v$rman\_backup\_job\_details(10.2) v$proxy\_datafile v$rman\_backup\_subjob\_details(10.2) v$rman\_configuration v$rman\_backup\_type(10.2) v$recovery\_file\_status v$rman\_encryption\_algorithms(10.2) v$recovery\_log v$rman\_output(10.1) v$recovery\_progress v$rman\_status(10.1) v$recovery\_status v$unusable\_backupfile\_details(10.2) v$recover\_file

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*/  
Caches   
Information related to the various caches, including objects, library, cursors, and the dictionary  
V$ Views:

> v$access v$sga v$buffer\_pool v$sgastat v$buffer\_pool\_statistics v$sga\_current\_resize\_ops v$db\_cache\_advice v$sga\_dynamic\_components v$db\_object\_cache v$sga\_dynamic\_free\_memory v$java\_pool\_advice v$sga\_resize\_ops v$librarycache v$sgainfo v$library\_cache\_memory v$shared\_pool\_advice v$pgastat v$shared\_pool\_reserved v$pga\_target\_advice v$system\_cursor\_cache v$pga\_target\_advice\_histogram v$subcache v$rowcache v$java\_library\_cache\_memory(10.1) v$rowcache\_parent v$process\_memory(10.2) v$rowcache\_subordinate v$sga\_target\_advice(10.2) v$session\_cursor\_cache

Cache fusion / rac

> v$active\_instances v$ges\_blocking\_enqueue v$bh v$ges\_convert\_local v$cluster\_interconnects(10.2) v$ges\_convert\_remote v$configured\_interconnects(10.2) v$ges\_enqueue v$cr\_block\_server v$ges\_latch v$current\_block\_server(10.1) v$ges\_resource v$gc\_element v$ges\_statistics v$gcshvmaster\_info v$hvmaster\_info v$gcspfmaster\_info v$instance\_cache\_transfer v$resource\_limit

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*/  
Control files   
Information related to instance control files  
V$ Views:

> v$controlfile v$controlfile\_record\_section

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*/  
Cursors/SQL statements   
Information related to cursors and SQL statements, including the open cursors, statistics, and actual SQL text  
V$ Views:

> v$open\_cursor v$session\_cursor\_cache v$sql v$sql\_shared\_cursor v$sqlarea v$sql\_shared\_memory v$sqltext v$sql\_workarea v$sqltext\_with\_newlines v$sql\_workarea\_active v$sql\_bind\_data v$sql\_workarea\_histogram v$sql\_bind\_metadata v$system\_cursor\_cache v$mutex\_sleep(10.2) v$sql\_cursor v$mutex\_sleep\_history(10.2)(FOR those dubious shared latches) v$sql\_optimizer\_env v$sql\_bind\_capture(10.1) v$sql\_plan v$sql\_join\_filter(10.2) v$sql\_plan\_statistics v$sql\_area\_plan\_hash(10.2) v$sql\_plan\_statistics\_all v$sqlstats(10.2) v$sql\_redirection v$sys\_optimizer\_env(10.1) v$vpd\_policy

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*/  
Database instances   
Information related to the actual database instance  
V$ Views:

> v$active\_instances v$sga v$bgprocess v$sgastat v$database v$blocking\_quiesce(10.2) v$instance v$client\_stats(10.1) v$process

RAC Views:

> v$bh v$active\_instances

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*/  
Direct Path Operations   
Information related to the SQL\*Loader direct load option  
V$ Views:

> v$loadistat v$loadpstat

> v$dblink v$hs\_agent v$global\_transaction v$hs\_parameter v$global\_blocked\_locks v$hs\_session

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*/  
Fixed view   
Information related to the v$ tables themselves  
V$ Views:

> v$fixed\_table v$fixed\_view\_definition v$indexed\_fixed\_column

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*/  
General   
General information related to various system information  
V$ Views:

> v$dbpipes v$timezone\_names v$context v$type\_size v$globalcontext v$\_sequences v$license v$version v$option v$db\_transportable\_platform(10.2) v$reserved\_words v$transportable\_platform(10.1) v$timer v$scheduler\_running\_jobs(10.2)

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*/  
I/O   
Information related to I/O, including files and statistics  
V$ Views:

> v$dbfile v$sysaux\_occupants(10.1) v$filestat v$tablespace v$waitstat v$temp\_histogram(10.1) v$tempstat v$temp\_space\_header v$file\_histogram(10.1) v$tempfile v$filemetric(10.1) v$tempseg\_usage v$filemetric\_history(10.1)

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*/  
Latches/locks Information related to latches and locks  
V$ Views:

> v$enqueue\_lock v$latch\_misses v$enqueue\_stat v$latch\_parent v$event\_name v$lock v$file\_cache\_transfer v$locked\_object v$global\_blocked\_locks v$resource v$latch v$resource\_limit v$latchholder v$transaction\_enqueue v$latchname v$\_lock v$latch\_children v$\_lock1 v$enqueue\_statistics

RAC Views:

> v$cr\_block\_server v$ges\_enqueue v$gcshvmaster\_info v$hvmaster\_info v$gcspfmaster\_info v$ges\_latch v$gc\_element v$ges\_resources v$ges\_blocking\_enqueue

> v$logmnr\_callback v$logmnr\_process v$logmnr\_contents v$logmnr\_region v$logmnr\_dictionary v$logmnr\_session v$logmnr\_latch v$logmnr\_stats v$logmnr\_logfile v$logmnr\_transaction v$logmnr\_logs v$logmnr\_dictionary\_load(10.2) v$logmnr\_parameters

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*/  
Metrics Information related to Metrics (ALL New in 10g!)  
V$ Views:

> v$metricname v$sessmetric v$servicemetric v$sysmetric v$eventmetric v$sysmetric\_history v$filemetric v$sysmetric\_summary v$filemetric\_history v$threshold\_types v$servicemetric\_history v$waitclassmetric v$waitclassmetric\_history

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*/  
Multithreaded/shared servers  
Information related to multithreaded and parallel servers, including connections, queues,dispatchers, and shared servers  
V$ Views:

> v$circuit v$reqdist v$dispatcher v$shared\_server v$dispatcher\_rate v$shared\_server\_monitor v$queue v$dispatcher\_config(10.1) v$queueing\_mth

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*/  
Object Usage  
Information related to object use and dependencies  
V$ Views:

> v$object\_dependency v$object\_usage

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*/  
Overall system   
information related TO THE overall system performance v$ tables :

> v$global\_transaction v$tempfile v$shared\_pool\_reserved v$temporary\_lobs v$resumable v$temp\_extent\_map v$sort\_segment v$temp\_extent\_pool v$tempseg\_usage v$temp\_space\_header v$statname v$transaction v$sys\_optimizer\_env v$alert\_types(10.1) v$sys\_time\_model v$event\_histogram(10.1) v$sysstat v$osstat(10.1) v$system\_cursor\_cache v$system\_wait\_class(10.1) v$system\_event v$temp\_histogram(10.1) v$xml\_audit\_trail

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*/  
Parallel Query Information related to the Parallel Query option  
V$ Views:

> v$execution v$pq\_tqstat v$parallel\_degree\_limit\_mth v$px\_process v$pq\_sesstat v$px\_process\_sysstat v$pq\_slave v$px\_session v$pq\_sysstat v$px\_sesstat

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*/  
Parameters   
Information related to various Oracle parameters, including initialization and NLS per session  
V$ Views:

> v$nls\_parameters v$spparameter v$nls\_valid\_values v$system\_parameter v$obsolete\_parameter v$system\_parameter2 v$parameter v$parameter\_valid\_values(10.2) v$parameter2

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*/  
Redo logs Information related to redo logs, including statistics and history  
V$ Views:

> v$log v$logfile v$loghist v$log\_history v$thread (rac related)

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*/  
Replication and materialized views  
Information related to replication and materialized views  
V$ Views:

> v$mvrefresh v$replprop v$replqueue

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*/  
Resource Manager Information related to resource management  
V$ Views:

> v$active\_session\_pool\_mth v$rsrc\_plan v$active\_session\_pool\_history v$rsrc\_plan\_cpu\_mth v$rsrc\_cons\_group\_history(10.2) v$rsrc\_plan\_history(10.2) v$rsrc\_consumer\_group v$rsrc\_session\_info(10.2) v$rsrc\_consumer\_group\_cpu\_mth

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*/  
Rollback segments And Undo  
Information on rollback segments, including statistics and transactions  
V$ Views:

> v$rollname v$rollstat v$transaction v$undostat

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*/  
Security/privilegesInformation related to security  
V$ Views:

> v$enabledprivs v$pwfile\_users v$vpd\_policy v$wallet(10.2) v$xml\_audit\_trail(10.2)

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*/  
Sessions (includes some replication information and heterogeneous services)  
Information related to a session, including object access, cursors, processes, and statistics  
V$ Views:

> v$active\_session\_history v$session\_object\_cache v$mystat v$session\_wait v$process v$session\_wait\_class v$sess\_time\_model v$session\_wait\_history v$session v$sesstat v$session\_connect\_info v$sess\_io v$session\_cursor\_cache v$ses\_optimizer\_env v$session\_event v$sessmetric v$session\_longops v$client\_stats v$tsm\_sessions(10.2)

> v$active\_services v$serv\_mod\_act\_stats v$service\_event v$service\_stats v$service\_wait\_class v$services

> v$sort\_segment v$tempseg\_usage v$temp\_extent\_map v$temp\_extent\_pool v$temp\_histogram(10.1) v$temp\_space\_header v$tempfile v$tempstat

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*/  
Standby databases (DataGuard)  
Information related to standby databases  
V$ Views:

> v$dataguard\_status v$dataguard\_stats(10.2) v$logstdby v$logstdby\_process(10.2) v$logstdby\_stats v$logstdby\_progress(10.2) v$managed\_standby v$logstdby\_state(10.2) v$standby\_log v$logstdby\_transaction(10.2) v$dataguard\_config(10.1)

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*/  
File mapping interface   
Information related to file mapping  
V$ Views:

> v$map\_comp\_list v$map\_file\_extent v$map\_element v$map\_file\_io\_stack v$map\_ext\_element v$map\_library v$map\_file v$map\_subelement

> v$aq v$buffered\_subscribers(10.1) v$streams\_apply\_coordinator v$propagation\_receiver(10.1) v$streams\_apply\_reader v$propagation\_sender(10.1) v$streams\_apply\_server v$rule(10.1) v$streams\_capture v$rule\_set(10.1) v$buffered\_publishers(10.1) v$rule\_set\_aggregate\_stats(10.1) v$buffered\_queues(10.1) v$streams\_transaction(10.2)

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*/  
Statistics Information related to statistics in general  
V$ Views:

> v$segment\_statistics v$segstat v$segstat\_name v$statistics\_level v$statname v$waitstat

/\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*/  
Transactions Information related to transactions in general  
V$ Views:

> v$global\_transaction v$logstdby\_transaction v$resumable v$streams\_transaction v$transaction v$transaction\_enqueue

参照整理： Oracle Database 10g 性能调整与优化(尼米克 (Richard J.Niemiec))

快捷参考

有关性能优化请参考

[Oracle硬解析与软解析][Oracle]

[共享池的调整与优化(Sharedpool Tuning)][Sharedpool Tuning]

[Buffercache 的调整与优化(一)][Buffercache]

[Oracle表缓存(cachingtable)的使用][Oracle_cachingtable]

有关ORACLE体系结构请参考

[Oracle表空间与数据文件][Oracle 1]

[Oracle密码文件][Oracle 2]

[Oracle参数文件][Oracle 3]

[Oracle联机重做日志文件(ONLINE LOG FILE)][Oracle_ONLINE LOG FILE]

[Oracle控制文件(CONTROLFILE)][Oracle_CONTROLFILE]

[Oracle归档日志][Oracle 4]

[Oracle回滚(ROLLBACK)和撤销(UNDO)][Oracle_ROLLBACK_UNDO]

[Oracle数据库实例启动关闭过程][Oracle 5]

[Oracle10g SGA 的自动化管理][Oracle10g SGA]

[Oracle实例和Oracle数据库(Oracle体系结构)][Oracle_Oracle_Oracle]

有关闪回特性请参考

[Oracle闪回特性(FLASHBACK DATABASE)][Oracle_FLASHBACK DATABASE]

[Oracle闪回特性(FLASHBACK DROP & RECYCLEBIN)][Oracle_FLASHBACK DROP _ RECYCLEBIN]

[Oracle闪回特性(Flashback Query、FlashbackTable)][Oracle_Flashback Query_FlashbackTable]

[Oracle闪回特性(Flashback Version、Flashback Transaction)][Oracle_Flashback Version_Flashback Transaction]

有关基于用户管理的备份和备份恢复的概念请参考

[Oracle冷备份][Oracle 6]

[Oracle热备份][Oracle 7]

[Oracle备份恢复概念][Oracle 8]

[Oracle实例恢复][Oracle 9]

[Oracle基于用户管理恢复的处理][Oracle 10](详细描述了介质恢复及其处理)

[SYSTEM表空间管理及备份恢复][SYSTEM]

[SYSAUX表空间管理及恢复][SYSAUX]

有关RMAN的备份恢复与管理请参考

[RMAN 概述及其体系结构][RMAN]

[RMAN 配置、监控与管理][RMAN 1]

[RMAN 备份详解][RMAN 2]

[RMAN 还原与恢复][RMAN 3]

[RMANcatalog 的创建和使用][RMANcatalog]

[基于catalog 创建RMAN存储脚本][catalog _RMAN]

[基于catalog 的RMAN 备份与恢复][catalog _RMAN 1]

[使用RMAN迁移文件系统数据库到ASM][RMAN_ASM]

[RMAN 备份路径困惑(使用plus archivelog时)][RMAN _plus archivelog]

有关ORACLE故障请参考

[ORA-32004的错误处理][ORA-32004]

[ORA-01658错误][ORA-01658]

[CRS-0215错误处理][CRS-0215]

[ORA-00119，ORA-00132 错误处理][ORA-00119_ORA-00132]

[又一例SPFILE设置错误导致数据库无法启动][SPFILE]

[对参数FAST\_START\_MTTR\_TARGET= 0 的误解及设定][FAST_START_MTTR_TARGET_ 0]

[SPFILE错误导致数据库无法启动(ORA-01565)][SPFILE_ORA-01565]

有关ASM请参考

[创建ASM实例及ASM数据库][ASM_ASM]

[ASM 磁盘、目录的管理][ASM]

[使用 ASMCMD 工具管理ASM目录及文件][ASMCMD _ASM]

有关SQL/PLSQL请参考

[SQLPlus常用命令][SQLPlus]

[替代变量与SQL\*Plus环境设置][SQL_Plus]

[使用Uniread实现SQLplus翻页功能][Uniread_SQLplus]

[SQL 基础*-->SELECT 查询*][SQL _--_SELECT]

[SQL 基础*--> NEW\_VALUE的使用*][SQL _--_ NEW_VALUE]

[SQL 基础*--> 集合运算(UNION与UNION ALL)*][SQL _--_ _UNION_UNION ALL]

[SQL 基础*--> 常用函数*][SQL _--_]

[SQL 基础*--> 视图(CREATEVIEW)*][SQL _--_ _CREATEVIEW]

[SQL 基础*--> 创建和管理表*][SQL _--_ 1]

[SQL 基础*--> 多表查询*][SQL _--_ 2]

[SQL 基础*--> 过滤和排序*][SQL _--_ 3]

[SQL 基础*--> 子查询*][SQL _--_ 4]

[SQL 基础*--> 分组与分组函数*][SQL _--_ 5]

[SQL 基础*--> 层次化查询(STARTBY ... CONNECT BY PRIOR)*][SQL _--_ _STARTBY ... CONNECT BY PRIOR]

[SQL 基础*--> ROLLUP与CUBE运算符实现数据汇总*][SQL _--_ ROLLUP_CUBE]

[PL/SQL*--> 游标*][PL_SQL_--_]

[PL/SQL*--> 异常处理(Exception)*][PL_SQL_--_ _Exception]

[PL/SQL*--> 语言基础*][PL_SQL_--_ 1]

[PL/SQL*--> 流程控制*][PL_SQL_--_ 2]

[PL/SQL*--> PL/SQL记录*][PL_SQL_--_ PL_SQL]

[PL/SQL*--> 包的创建与管理*][PL_SQL_--_ 3]

[PL/SQL*--> 隐式游标(SQL%FOUND)*][PL_SQL_--_ _SQL_FOUND]

[PL/SQL*--> 包重载、初始化*][PL_SQL_--_ 4]

[PL/SQL*--> DBMS\_DDL包的使用*][PL_SQL_--_ DBMS_DDL]

[PL/SQL*--> DML 触发器*][PL_SQL_--_ DML]

[PL/SQL*--> INSTEAD OF 触发器*][PL_SQL_--_ INSTEAD OF]

[PL/SQL*--> 存储过程*][PL_SQL_--_ 5]

[PL/SQL*--> 函数*][PL_SQL_--_ 6]

[PL/SQL*--> 动态SQL*][PL_SQL_--_ _SQL]

[PL/SQL*--> 动态SQL的常见错误*][PL_SQL_--_ _SQL 1]

有关ORACLE其它特性

[Oracle常用目录结构(10g)][Oracle_10g]

[使用OEM,SQL\*Plus,iSQL\*Plus 管理Oracle实例][OEM_SQL_Plus_iSQL_Plus _Oracle]

[日志记录模式(LOGGING、FORCE LOGGING 、NOLOGGING)][LOGGING_FORCE LOGGING _NOLOGGING]

[表段、索引段上的LOGGING与NOLOGGING][LOGGING_NOLOGGING]

[OralceOMF 功能详解][OralceOMF]

[Oracle用户、对象权限、系统权限 ][Oracle_]

[Oracle角色、配置文件][Oracle 11]

[Oracle分区表][Oracle 12]

[Oracle外部表][Oracle 13]

[使用外部表管理Oracle 告警日志(ALAERT\_$SID.LOG)][Oracle _ALAERT_SID.LOG]

[簇表及簇表管理(Index clustered tables)][Index clustered tables]

[数据泵 EXPDP 导出工具的使用][EXPDP]

[数据泵 IMPDP 导入工具的使用][IMPDP]

[导入导出 Oracle 分区表数据][Oracle 14]

[SQL\*Loader使用方法][SQL_Loader]

[启用用户进程跟踪][Link 1]

[配置非默认端口的动态服务注册][Link 2]

[配置ORACLE 客户端连接到数据库][ORACLE]

[systemsys，sysoper sysdba 的区别][systemsys_sysoper sysdba]

[ORACLE\_SID、DB\_NAME、INSTANCE\_NAME、DB\_DOMIAN、GLOBAL\_NAME][ORACLE_SID_DB_NAME_INSTANCE_NAME_DB_DOMIAN_GLOBAL_NAME]

[Oracle补丁全集 (Oracle 9i 10g 11g Path)][Oracle_ _Oracle 9i 10g 11g Path]

[Oracle10.2.0.1 升级到10.2.0.4][Oracle10.2.0.1 _10.2.0.4]

[Oracle彻底 kill session][Oracle_ kill session]

[Oracle]: http://blog.csdn.net/robinson_0612/archive/2011/02/19/6195483.aspx
[Sharedpool Tuning]: http://blog.csdn.net/robinson_0612/archive/2011/02/25/6208268.aspx
[Buffercache]: http://blog.csdn.net/robinson_0612/archive/2011/02/25/6208594.aspx
[Oracle_cachingtable]: http://blog.csdn.net/robinson_0612/archive/2011/03/06/6226767.aspx
[Oracle 1]: http://blog.csdn.net/robinson_0612/archive/2010/05/20/5611738.aspx
[Oracle 2]: http://blog.csdn.net/robinson_0612/archive/2010/05/20/5611672.aspx
[Oracle 3]: http://blog.csdn.net/robinson_0612/archive/2010/05/05/5559174.aspx
[Oracle_ONLINE LOG FILE]: http://blog.csdn.net/robinson_0612/archive/2010/07/20/5749556.aspx
[Oracle_CONTROLFILE]: http://blog.csdn.net/robinson_0612/archive/2010/07/15/5737527.aspx
[Oracle 4]: http://blog.csdn.net/robinson_0612/archive/2010/08/03/5784713.aspx
[Oracle_ROLLBACK_UNDO]: http://blog.csdn.net/robinson_0612/archive/2010/07/13/5731158.aspx
[Oracle 5]: http://blog.csdn.net/robinson_0612/archive/2010/04/29/5542983.aspx
[Oracle10g SGA]: http://blog.csdn.net/robinson_0612/archive/2010/04/27/5534832.aspx
[Oracle_Oracle_Oracle]: http://blog.csdn.net/robinson_0612/archive/2010/04/26/5529239.aspx
[Oracle_FLASHBACK DATABASE]: http://blog.csdn.net/robinson_0612/archive/2010/12/27/6100429.aspx
[Oracle_FLASHBACK DROP _ RECYCLEBIN]: http://blog.csdn.net/robinson_0612/archive/2010/12/29/6105327.aspx
[Oracle_Flashback Query_FlashbackTable]: http://blog.csdn.net/robinson_0612/archive/2011/01/02/6112607.aspx
[Oracle_Flashback Version_Flashback Transaction]: http://blog.csdn.net/robinson_0612/archive/2011/01/02/6112981.aspx
[Oracle 6]: http://blog.csdn.net/robinson_0612/archive/2010/08/05/5791597.aspx
[Oracle 7]: http://blog.csdn.net/robinson_0612/archive/2010/08/16/5816012.aspx
[Oracle 8]: http://blog.csdn.net/robinson_0612/archive/2010/08/05/5791585.aspx
[Oracle 9]: http://blog.csdn.net/robinson_0612/archive/2010/07/27/5768233.aspx
[Oracle 10]: http://blog.csdn.net/robinson_0612/archive/2010/11/28/6041217.aspx
[SYSTEM]: http://blog.csdn.net/robinson_0612/archive/2010/11/28/6041207.aspx
[SYSAUX]: http://blog.csdn.net/robinson_0612/archive/2010/08/13/5810732.aspx
[RMAN]: http://blog.csdn.net/robinson_0612/archive/2010/11/24/6032525.aspx
[RMAN 1]: http://blog.csdn.net/robinson_0612/archive/2010/11/24/6032597.aspx
[RMAN 2]: http://blog.csdn.net/robinson_0612/archive/2010/11/24/6032739.aspx
[RMAN 3]: http://blog.csdn.net/robinson_0612/archive/2010/11/28/6041247.aspx
[RMANcatalog]: http://blog.csdn.net/robinson_0612/archive/2010/11/29/6043649.aspx
[catalog _RMAN]: http://blog.csdn.net/robinson_0612/archive/2010/12/13/6073020.aspx
[catalog _RMAN 1]: http://blog.csdn.net/robinson_0612/archive/2010/12/13/6073069.aspx
[RMAN_ASM]: http://blog.csdn.net/robinson_0612/archive/2011/05/30/6453954.aspx
[RMAN _plus archivelog]: http://blog.csdn.net/robinson_0612/archive/2011/05/12/6414338.aspx
[ORA-32004]: http://blog.csdn.net/robinson_0612/archive/2011/02/19/6195475.aspx
[ORA-01658]: http://blog.csdn.net/robinson_0612/archive/2011/03/14/6249202.aspx
[CRS-0215]: http://blog.csdn.net/robinson_0612/archive/2011/04/05/6303583.aspx
[ORA-00119_ORA-00132]: http://blog.csdn.net/robinson_0612/archive/2011/05/05/6396989.aspx
[SPFILE]: http://blog.csdn.net/robinson_0612/archive/2010/08/03/5784736.aspx
[FAST_START_MTTR_TARGET_ 0]: http://blog.csdn.net/robinson_0612/archive/2010/08/02/5782516.aspx
[SPFILE_ORA-01565]: http://blog.csdn.net/robinson_0612/archive/2010/07/29/5774795.aspx
[ASM_ASM]: http://blog.csdn.net/robinson_0612/archive/2010/12/16/6080659.aspx
[ASM]: http://blog.csdn.net/robinson_0612/archive/2011/01/13/6134071.aspx
[ASMCMD _ASM]: http://blog.csdn.net/robinson_0612/archive/2011/01/13/6134163.aspx
[SQLPlus]: http://blog.csdn.net/robinson_0612/archive/2010/04/06/5454382.aspx
[SQL_Plus]: http://blog.csdn.net/robinson_0612/archive/2010/12/18/6084376.aspx
[Uniread_SQLplus]: http://blog.csdn.net/robinson_0612/archive/2010/03/30/5431655.aspx
[SQL _--_SELECT]: http://blog.csdn.net/robinson_0612/archive/2010/04/15/5487668.aspx
[SQL _--_ NEW_VALUE]: http://blog.csdn.net/robinson_0612/archive/2011/02/18/6192944.aspx
[SQL _--_ _UNION_UNION ALL]: http://blog.csdn.net/robinson_0612/archive/2010/05/20/5611716.aspx
[SQL _--_]: http://blog.csdn.net/robinson_0612/archive/2010/04/16/5495170.aspx
[SQL _--_ _CREATEVIEW]: http://blog.csdn.net/robinson_0612/archive/2010/05/28/5630426.aspx
[SQL _--_ 1]: http://blog.csdn.net/robinson_0612/archive/2010/06/23/5689199.aspx
[SQL _--_ 2]: http://blog.csdn.net/robinson_0612/archive/2010/05/06/5563199.aspx
[SQL _--_ 3]: http://blog.csdn.net/robinson_0612/archive/2010/04/15/5487992.aspx
[SQL _--_ 4]: http://blog.csdn.net/robinson_0612/archive/2010/05/14/5592002.aspx
[SQL _--_ 5]: http://blog.csdn.net/robinson_0612/archive/2010/05/05/5559110.aspx
[SQL _--_ _STARTBY ... CONNECT BY PRIOR]: http://blog.csdn.net/robinson_0612/archive/2010/05/22/5616877.aspx
[SQL _--_ ROLLUP_CUBE]: http://blog.csdn.net/robinson_0612/archive/2010/06/01/5640031.aspx
[PL_SQL_--_]: http://blog.csdn.net/robinson_0612/archive/2010/12/15/6078622.aspx
[PL_SQL_--_ _Exception]: http://blog.csdn.net/robinson_0612/archive/2010/12/16/6080119.aspx
[PL_SQL_--_ 1]: http://blog.csdn.net/robinson_0612/archive/2010/12/08/6063399.aspx
[PL_SQL_--_ 2]: http://blog.csdn.net/robinson_0612/archive/2010/12/08/6063422.aspx
[PL_SQL_--_ PL_SQL]: http://blog.csdn.net/robinson_0612/archive/2010/12/18/6084390.aspx
[PL_SQL_--_ 3]: http://blog.csdn.net/robinson_0612/archive/2010/12/18/6084475.aspx
[PL_SQL_--_ _SQL_FOUND]: http://blog.csdn.net/robinson_0612/archive/2010/12/22/6092066.aspx
[PL_SQL_--_ 4]: http://blog.csdn.net/robinson_0612/archive/2010/12/22/6092097.aspx
[PL_SQL_--_ DBMS_DDL]: http://blog.csdn.net/robinson_0612/archive/2010/12/25/6098248.aspx
[PL_SQL_--_ DML]: http://blog.csdn.net/robinson_0612/archive/2010/12/25/6098258.aspx
[PL_SQL_--_ INSTEAD OF]: http://blog.csdn.net/robinson_0612/archive/2010/12/25/6098263.aspx
[PL_SQL_--_ 5]: http://blog.csdn.net/robinson_0612/archive/2010/12/08/6063434.aspx
[PL_SQL_--_ 6]: http://blog.csdn.net/robinson_0612/archive/2010/12/11/6069531.aspx
[PL_SQL_--_ _SQL]: http://blog.csdn.net/robinson_0612/archive/2011/01/05/6118010.aspx
[PL_SQL_--_ _SQL 1]: http://blog.csdn.net/robinson_0612/archive/2011/01/05/6118049.aspx
[Oracle_10g]: http://blog.csdn.net/robinson_0612/archive/2010/05/29/5633093.aspx
[OEM_SQL_Plus_iSQL_Plus _Oracle]: http://blog.csdn.net/robinson_0612/archive/2010/04/26/5529260.aspx
[LOGGING_FORCE LOGGING _NOLOGGING]: http://blog.csdn.net/robinson_0612/archive/2011/01/12/6130866.aspx
[LOGGING_NOLOGGING]: http://blog.csdn.net/robinson_0612/archive/2011/01/12/6131176.aspx
[OralceOMF]: http://blog.csdn.net/robinson_0612/archive/2010/04/12/5478323.aspx
[Oracle_]: http://blog.csdn.net/robinson_0612/archive/2010/06/23/5688875.aspx
[Oracle 11]: http://blog.csdn.net/robinson_0612/archive/2010/06/23/5688997.aspx
[Oracle 12]: http://blog.csdn.net/robinson_0612/archive/2010/10/07/5925572.aspx
[Oracle 13]: http://blog.csdn.net/robinson_0612/archive/2010/12/15/6078481.aspx
[Oracle _ALAERT_SID.LOG]: http://blog.csdn.net/robinson_0612/archive/2011/02/18/6192979.aspx
[Index clustered tables]: http://blog.csdn.net/robinson_0612/archive/2010/10/07/5925501.aspx
[EXPDP]: http://blog.csdn.net/robinson_0612/archive/2010/10/07/5925592.aspx
[IMPDP]: http://blog.csdn.net/robinson_0612/archive/2010/10/08/5926276.aspx
[Oracle 14]: http://blog.csdn.net/robinson_0612/archive/2011/03/13/6246738.aspx
[SQL_Loader]: http://blog.csdn.net/robinson_0612/archive/2010/10/08/5926296.aspx
[Link 1]: http://blog.csdn.net/robinson_0612/archive/2010/10/07/5925564.aspx
[Link 2]: http://blog.csdn.net/robinson_0612/archive/2010/10/07/5925526.aspx
[ORACLE]: http://blog.csdn.net/robinson_0612/archive/2010/09/30/5917103.aspx
[systemsys_sysoper sysdba]: http://blog.csdn.net/robinson_0612/archive/2010/11/05/5989565.aspx
[ORACLE_SID_DB_NAME_INSTANCE_NAME_DB_DOMIAN_GLOBAL_NAME]: http://blog.csdn.net/robinson_0612/archive/2010/09/30/5917082.aspx
[Oracle_ _Oracle 9i 10g 11g Path]: http://blog.csdn.net/robinson_0612/archive/2011/04/06/6304124.aspx
[Oracle10.2.0.1 _10.2.0.4]: http://blog.csdn.net/robinson_0612/archive/2011/05/05/6396783.aspx
[Oracle_ kill session]: http://blog.csdn.net/robinson_0612/archive/2011/05/23/6439019.aspx