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

来源：互联网发布：python数据分析实战编辑：程序博客网时间：2024/05/17 22:16

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

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

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

SYS@PROD1> select name,value from v$sysstat where name like '%commit%';NAME      VALUE---------------------------------------------------------------- ----------user commits 87commit cleanout failures: write disabled  0commit cleanout failures: block lost  0commit cleanout failures: cannot pin  0commit cleanout failures: hot backup in progress  0commit cleanout failures: buffer being written  0commit cleanout failures: callback failure  0commit cleanouts687commit cleanouts successfully completed 687commit txn count during cleanout 17commit batch/immediate requested  9commit batch requested  0commit immediate requested  9commit batch/immediate performed  9commit batch performed  0commit immediate performed  9commit wait/nowait requested  0commit nowait requested   0commit wait requested  0commit wait/nowait performed  0commit nowait performed   0commit wait performed  0IMU commits  0cell commit cache queries  0cell transactions found in commit cache   0cell blocks helped by commit cache  0OTC commit optimization attempts  0OTC commit optimization hits  0OTC commit optimization failure - setup   029 rows selected.--显示磁盘I/O操作处理的总数据量SYS@PROD1> select name,value from v$sysstat where name like '%physical% total bytes';NAME      VALUE---------------------------------------------------------------- ----------physical read total bytes  183073280physical write total bytes   59769856

0 0