v$osstat 收集系统信息

来源：互联网发布：增值税申报软件编辑：程序博客网时间：2024/05/12 15:01

SQL>select * from v$sys_time_model

   STAT_ID STAT_NAME                                                                        VALUE
---------- ---------------------------------------------------------------- ---------------------
3649082374 DB time                                                                   265730119650
2748282437 DB CPU                                                                     56787079225
4157170894 background elapsed time                                                    51132791872
2451517896 background cpu time                                                         1526410040
4127043053 sequence load elapsed time                                                     2050642
1431595225 parse time elapsed                                                          1035281413
372226525 hard parse elapsed time                                                      678543086
2821698184 sql execute elapsed time                                                  161805893146
1990024365 connection management call elapsed time                                    36779758928
1824284809 failed parse elapsed time                                                      2397323
4125607023 failed parse (out of shared memory) elapsed time                                     0
3138706091 hard parse (sharing criteria) elapsed time                                    51063716
268357648 hard parse (bind mismatch) elapsed time                                       14250243
2643905994 PL/SQL execution elapsed time                                             132790742600
290749718 inbound PL/SQL rpc elapsed time                                                      0
1311180441 PL/SQL compilation elapsed time                                               56093133
751169994 Java execution elapsed time                                                    4587196
1159091985 repeated bind elapsed time                                                     8402663
2411117902 RMAN cpu time (backup/restore)                                                       0

OSSTAT:操作系统统计数据
select * from v$osstat;

STAT_NAME                                     VALUE OSSTAT_ID
---------------------------------------- ---------- ----------
NUM_CPUS                                          4          0
IDLE_TIME                                 104349845          1
BUSY_TIME                                   4421586          2
USER_TIME                                   1193121          3
SYS_TIME                                    3228465          4
IOWAIT_TIME                                 2508768          5
AVG_IDLE_TIME                              26080690          7
AVG_BUSY_TIME                               1098594          8
AVG_USER_TIME                                291494          9
AVG_SYS_TIME                                 800322         10
AVG_IOWAIT_TIME                              620370         11
OS_CPU_WAIT_TIME                           26812200         13
RSRC_MGR_CPU_WAIT_TIME                            0         14
LOAD                                     1.18066406         15
NUM_CPU_CORES                                     2         16
NUM_VCPUS                                         1         18
NUM_LCPUS                                         4         19
PHYSICAL_MEMORY_BYTES                    2147483648       1008
VM_IN_BYTES                               177094656       1009
VM_OUT_BYTES                             3571150848       1010