系统和会话统计信息（v$sysstat v$sesstat）

--系统和会话统计信息（v$sysstat v$sesstat）


在v$sysstat视图中包含两个关键列:
name标识统计信息。

value提供与统计信息相关的指标。

SYS@PROD1> select name,value from v$sysstat where name like '%commit%';

NAME								      VALUE
---------------------------------------------------------------- ----------
user commits								 87
commit cleanout failures: write disabled				  0
commit cleanout failures: block lost					  0
commit cleanout failures: cannot pin					  0
commit cleanout failures: hot backup in progress			  0
commit cleanout failures: buffer being written				  0
commit cleanout failures: callback failure				  0
commit cleanouts							687
commit cleanouts successfully completed 				687
commit txn count during cleanout					 17
commit batch/immediate requested					  9
commit batch requested							  0
commit immediate requested						  9
commit batch/immediate performed					  9
commit batch perfo