oracle 查看指标 tps(Transactions Per Second)

最新推荐文章于 2024-06-30 08:30:00 发布
最新推荐文章于 2024-06-30 08:30:00 发布
阅读量2.6k 收藏 2
点赞数
分类专栏： orale 文章标签： oracle
原文链接：https://blog.csdn.net/ctypyb2002/article/details/102930616
版权

oracle 查看指标 tps(Transactions Per Second)

https://blog.csdn.net/ctypyb2002/article/details/102930616

metric相关表及视图

v$metricgroup
v$metricname

v$metric
v$metric_history

v$sysmetric
v$sysmetric_history
v$sysmetric_summary

############################

metric 分类及名称

############################

**

v$metricgroup信息

**

SQL> select group_id,name,interval_size,max_interval from v$metricgroup;

  GROUP_ID NAME 			       INTERVAL_SIZE MAX_INTERVAL
---------- ----------------------------------- ------------- ------------
	 0 Event Metrics				6000		1
	 1 Event Class Metrics				6000	       60
	11 I/O Stats by Function Metrics		6000	       60
	 2 System Metrics Long Duration 		6000	       60
	 3 System Metrics Short Duration		1500	       12
	 4 Session Metrics Long Duration		6000	       60
	 5 Session Metrics Short Duration		1500		1
	 6 Service Metrics				6000	       60
	 7 File Metrics Long Duration		       60000		6
	 9 Tablespace Metrics Long Duration		6000		0
	19 Recovery Area Metric Group			6000		0
	10 Service Metrics (Short)			 500	       24
	12 Resource Manager Stats			6000	       60
	13 WCR metrics					6000	       60
	14 WLM PC Metrics				 500		1
	15 Service Per Region Metrics			3000		1
	16 Chunks					3000		1
	17 Resource Manager PDB Stats			6000	       60
	18 PDB System Metrics Long Duration		6000	       60

19 rows selected.

**

v$metricname

**

  GROUP_ID GROUP_NAME				     METRIC_ID METRIC_NAME					  METRIC_UNIT
---------- ---------------------------------------- ---------- -------------------------------------------------- --------------------------------------------------
	 2 System Metrics Long Duration 		  2000 Buffer Cache Hit Ratio				  % (LogRead - PhyRead)/LogRead
	 3 System Metrics Short Duration		  2000 Buffer Cache Hit Ratio				  % (LogRead - PhyRead)/LogRead
	 2 System Metrics Long Duration 		  2001 Memory Sorts Ratio				  % MemSort/(MemSort + DiskSort)
	 3 System Metrics Short Duration		  2001 Memory Sorts Ratio				  % MemSort/(MemSort + DiskSort)
	 2 System Metrics Long Duration 		  2002 Redo Allocation Hit Ratio			  % (#Redo - RedoSpaceReq)/#Redo
	 2 System Metrics Long Duration 		  2003 User Transaction Per Sec 			  Transactions Per Second
	 3 System Metrics Short Duration		  2003 User Transaction Per Sec 			  Transactions Per Second
	 2 System Metrics Long Duration 		  2004 Physical Reads Per Sec				  Reads Per Second
	 3 System Metrics Short Duration		  2004 Physical Reads Per Sec				  Reads Per Second
	 2 System Metrics Long Duration 		  2005 Physical Reads Per Txn				  Reads Per Txn
	 3 System Metrics Short Duration		  2005 Physical Reads Per Txn				  Reads Per Txn
	 2 System Metrics Long Duration 		  2006 Physical Writes Per Sec				  Writes Per Second
	 3 System Metrics Short Duration		  2006 Physical Writes Per Sec				  Writes Per Second
	 2 System Metrics Long Duration 		  2007 Physical Writes Per Txn				  Writes Per Txn
	 3 System Metrics Short Duration		  2007 Physical Writes Per Txn				  Writes Per Txn
	 2 System Metrics Long Duration 		  2008 Physical Reads Direct Per Sec			  Reads Per Second
	 3 System Metrics Short Duration		  2008 Physical Reads Direct Per Sec			  Reads Per Second
	 2 System Metrics Long Duration 		  2009 Physical Reads Direct Per Txn			  Reads Per Txn
	 3 System Metrics Short Duration		  2009 Physical Reads Direct Per Txn			  Reads Per Txn
	 2 System Metrics Long Duration 		  2010 Physical Writes Direct Per Sec			  Writes Per Second
	 2 System Metrics Long Duration 		  2011 Physical Writes Direct Per Txn			  Writes Per Txn
	 2 System Metrics Long Duration 		  2012 Physical Reads Direct Lobs Per Sec		  Reads Per Second
	 2 System Metrics Long Duration 		  2013 Physical Reads Direct Lobs Per Txn		  Reads Per Txn
	 2 System Metrics Long Duration 		  2014 Physical Writes Direct Lobs Per Sec		  Writes Per Second
	 2 System Metrics Long Duration 		  2015 Physical Writes Direct Lobs  Per Txn		  Writes Per Txn
	 2 System Metrics Long Duration 		  2016 Redo Generated Per Sec				  Bytes Per Second
	 3 System Metrics Short Duration		  2016 Redo Generated Per Sec				  Bytes Per Second
	 2 System Metrics Long Duration 		  2017 Redo Generated Per Txn				  Bytes Per Txn
	 3 System Metrics Short Duration		  2017 Redo Generated Per Txn				  Bytes Per Txn
	 2 System Metrics Long Duration 		  2018 Logons Per Sec					  Logons Per Second
	 3 System Metrics Short Duration		  2018 Logons Per Sec					  Logons Per Second
	 2 System Metrics Long Duration 		  2019 Logons Per Txn					  Logons Per Txn
	 3 System Metrics Short Duration		  2019 Logons Per Txn					  Logons Per Txn
	 2 System Metrics Long Duration 		  2020 Open Cursors Per Sec				  Cursors Per Second
	 2 System Metrics Long Duration 		  2021 Open Cursors Per Txn				  Cursors Per Txn
	 2 System Metrics Long Duration 		  2022 User Commits Per Sec				  Commits Per Second
	 2 System Metrics Long Duration 		  2023 User Commits Percentage				  % (UserCommit/TotalUserTxn)
	 2 System Metrics Long Duration 		  2024 User Rollbacks Per Sec				  Rollbacks Per Second
	 2 System Metrics Long Duration 		  2025 User Rollbacks Percentage			  % (UserRollback/TotalUserTxn)
	 2 System Metrics Long Duration 		  2026 User Calls Per Sec				  Calls Per Second
	 3 System Metrics Short Duration		  2026 User Calls Per Sec				  Calls Per Second
	 2 System Metrics Long Duration 		  2027 User Calls Per Txn				  Calls Per Txn
	 3 System Metrics Short Duration		  2027 User Calls Per Txn				  Calls Per Txn
	 2 System Metrics Long Duration 		  2028 Recursive Calls Per Sec				  Calls Per Second
	 2 System Metrics Long Duration 		  2029 Recursive Calls Per Txn				  Calls Per Txn
	 2 System Metrics Long Duration 		  2030 Logical Reads Per Sec				  Reads Per Second
	 3 System Metrics Short Duration		  2030 Logical Reads Per Sec				  Reads Per Second
	 2 System Metrics Long Duration 		  2031 Logical Reads Per Txn				  Reads Per Txn
	 3 System Metrics Short Duration		  2031 Logical Reads Per Txn				  Reads Per Txn
	 2 System Metrics Long Duration 		  2032 DBWR Checkpoints Per Sec 			  Check Points Per Second
	 2 System Metrics Long Duration 		  2033 Background Checkpoints Per Sec			  Check Points Per Second
	 2 System Metrics Long Duration 		  2034 Redo Writes Per Sec				  Writes Per Second
	 3 System Metrics Short Duration		  2034 Redo Writes Per Sec				  Writes Per Second
	 2 System Metrics Long Duration 		  2035 Redo Writes Per Txn				  Writes Per Txn
	 3 System Metrics Short Duration		  2035 Redo Writes Per Txn				  Writes Per Txn
	 2 System Metrics Long Duration 		  2036 Long Table Scans Per Sec 			  Scans Per Second
	 2 System Metrics Long Duration 		  2037 Long Table Scans Per Txn 			  Scans Per Txn
	 2 System Metrics Long Duration 		  2038 Total Table Scans Per Sec			  Scans Per Second
	 3 System Metrics Short Duration		  2038 Total Table Scans Per Sec			  Scans Per Second
	 2 System Metrics Long Duration 		  2039 Total Table Scans Per Txn			  Scans Per Txn
	 3 System Metrics Short Duration		  2039 Total Table Scans Per Txn			  Scans Per Txn
	 2 System Metrics Long Duration 		  2040 Full Index Scans Per Sec 			  Scans Per Second
	 3 System Metrics Short Duration		  2040 Full Index Scans Per Sec 			  Scans Per Second
	 2 System Metrics Long Duration 		  2041 Full Index Scans Per Txn 			  Scans Per Txn
	 3 System Metrics Short Duration		  2041 Full Index Scans Per Txn 			  Scans Per Txn
	 2 System Metrics Long Duration 		  2042 Total Index Scans Per Sec			  Scans Per Second
	 2 System Metrics Long Duration 		  2043 Total Index Scans Per Txn			  Scans Per Txn
	 2 System Metrics Long Duration 		  2044 Total Parse Count Per Sec			  Parses Per Second
	 2 System Metrics Long Duration 		  2045 Total Parse Count Per Txn			  Parses Per Txn
	 2 System Metrics Long Duration 		  2046 Hard Parse Count Per Sec 			  Parses Per Second
	 2 System Metrics Long Duration 		  2047 Hard Parse Count Per Txn 			  Parses Per Txn
	 2 System Metrics Long Duration 		  2048 Parse Failure Count Per Sec			  Parses Per Second
	 2 System Metrics Long Duration 		  2049 Parse Failure Count Per Txn			  Parses Per Txn
	 2 System Metrics Long Duration 		  2050 Cursor Cache Hit Ratio				  % CursorCacheHit/SoftParse
	 2 System Metrics Long Duration 		  2051 Disk Sort Per Sec				  Sorts Per Second
	 2 System Metrics Long Duration 		  2052 Disk Sort Per Txn				  Sorts Per Txn
	 2 System Metrics Long Duration 		  2053 Rows Per Sort					  Rows Per Sort
	 2 System Metrics Long Duration 		  2054 Execute Without Parse Ratio			  % (ExecWOParse/TotalExec)
	 3 System Metrics Short Duration		  2054 Execute Without Parse Ratio			  % (ExecWOParse/TotalExec)
	 2 System Metrics Long Duration 		  2055 Soft Parse Ratio 				  % SoftParses/TotalParses
	 3 System Metrics Short Duration		  2055 Soft Parse Ratio 				  % SoftParses/TotalParses
	 2 System Metrics Long Duration 		  2056 User Calls Ratio 				  % UserCalls/AllCalls
	 2 System Metrics Long Duration 		  2058 Network Traffic Volume Per Sec			  Bytes Per Second
	 2 System Metrics Long Duration 		  2059 Enqueue Timeouts Per Sec 			  Timeouts Per Second
	 2 System Metrics Long Duration 		  2060 Enqueue Timeouts Per Txn 			  Timeouts Per Txn
	 2 System Metrics Long Duration 		  2061 Enqueue Waits Per Sec				  Waits Per Second
	 2 System Metrics Long Duration 		  2062 Enqueue Waits Per Txn				  Waits Per Txn
	 2 System Metrics Long Duration 		  2063 Enqueue Deadlocks Per Sec			  Deadlocks Per Second
	 2 System Metrics Long Duration 		  2064 Enqueue Deadlocks Per Txn			  Deadlocks Per Txn
	 2 System Metrics Long Duration 		  2065 Enqueue Requests Per Sec 			  Requests Per Second
	 2 System Metrics Long Duration 		  2066 Enqueue Requests Per Txn 			  Requests Per Txn
	 2 System Metrics Long Duration 		  2067 DB Block Gets Per Sec				  Blocks Per Second
	 3 System Metrics Short Duration		  2067 DB Block Gets Per Sec				  Blocks Per Second
	 2 System Metrics Long Duration 		  2068 DB Block Gets Per Txn				  Blocks Per Txn
	 3 System Metrics Short Duration		  2068 DB Block Gets Per Txn				  Blocks Per Txn
	 2 System Metrics Long Duration 		  2069 Consistent Read Gets Per Sec			  Blocks Per Second
	 3 System Metrics Short Duration		  2069 Consistent Read Gets Per Sec			  Blocks Per Second
	 2 System Metrics Long Duration 		  2070 Consistent Read Gets Per Txn			  Blocks Per Txn
	 3 System Metrics Short Duration		  2070 Consistent Read Gets Per Txn			  Blocks Per Txn
	 2 System Metrics Long Duration 		  2071 DB Block Changes Per Sec 			  Blocks Per Second
	 3 System Metrics Short Duration		  2071 DB Block Changes Per Sec 			  Blocks Per Second
	 2 System Metrics Long Duration 		  2072 DB Block Changes Per Txn 			  Blocks Per Txn
	 3 System Metrics Short Duration		  2072 DB Block Changes Per Txn 			  Blocks Per Txn
	 2 System Metrics Long Duration 		  2073 Consistent Read Changes Per Sec			  Blocks Per Second
	 3 System Metrics Short Duration		  2073 Consistent Read Changes Per Sec			  Blocks Per Second
	 2 System Metrics Long Duration 		  2074 Consistent Read Changes Per Txn			  Blocks Per Txn
	 3 System Metrics Short Duration		  2074 Consistent Read Changes Per Txn			  Blocks Per Txn
	 2 System Metrics Long Duration 		  2075 CPU Usage Per Sec				  CentiSeconds Per Second
	 2 System Metrics Long Duration 		  2076 CPU Usage Per Txn				  CentiSeconds Per Txn
	 2 System Metrics Long Duration 		  2077 CR Blocks Created Per Sec			  Blocks Per Second
	 2 System Metrics Long Duration 		  2078 CR Blocks Created Per Txn			  Blocks Per Txn
	 2 System Metrics Long Duration 		  2079 CR Undo Records Applied Per Sec			  Undo Records Per Second
	 2 System Metrics Long Duration 		  2080 CR Undo Records Applied Per Txn			  Records Per Txn
	 2 System Metrics Long Duration 		  2081 User Rollback UndoRec Applied Per Sec		  Records Per Second
	 2 System Metrics Long Duration 		  2082 User Rollback Undo Records Applied Per Txn	  Records Per Txn
	 2 System Metrics Long Duration 		  2083 Leaf Node Splits Per Sec 			  Splits Per Second
	 2 System Metrics Long Duration 		  2084 Leaf Node Splits Per Txn 			  Splits Per Txn
	 2 System Metrics Long Duration 		  2085 Branch Node Splits Per Sec			  Splits Per Second
	 2 System Metrics Long Duration 		  2086 Branch Node Splits Per Txn			  Splits Per Txn
	 2 System Metrics Long Duration 		  2087 PX downgraded 1 to 25% Per Sec			  PX Operations Per Second
	 2 System Metrics Long Duration 		  2088 PX downgraded 25 to 50% Per Sec			  PX Operations Per Second
	 2 System Metrics Long Duration 		  2089 PX downgraded 50 to 75% Per Sec			  PX Operations Per Second
	 2 System Metrics Long Duration 		  2090 PX downgraded 75 to 99% Per Sec			  PX Operations Per Second
	 2 System Metrics Long Duration 		  2091 PX downgraded to serial Per Sec			  PX Operations Per Second
	 2 System Metrics Long Duration 		  2142 PX operations not downgraded Per Sec		  PX Operations Per Second
	 2 System Metrics Long Duration 		  2139 Queries parallelized Per Sec			  Queries Per Second
	 2 System Metrics Long Duration 		  2140 DML statements parallelized Per Sec		  Statements Per Second
	 2 System Metrics Long Duration 		  2141 DDL statements parallelized Per Sec		  Statements Per Second
	 2 System Metrics Long Duration 		  2092 Physical Read Total IO Requests Per Sec		  Requests Per Second
	 2 System Metrics Long Duration 		  2093 Physical Read Total Bytes Per Sec		  Bytes Per Second
	 2 System Metrics Long Duration 		  2094 GC CR Block Received Per Second			  Blocks Per Second
	 2 System Metrics Long Duration 		  2095 GC CR Block Received Per Txn			  Blocks Per Txn
	 2 System Metrics Long Duration 		  2096 GC Current Block Received Per Second		  Blocks Per Second
	 2 System Metrics Long Duration 		  2097 GC Current Block Received Per Txn		  Blocks Per Txn
	 2 System Metrics Long Duration 		  2098 Global Cache Average CR Get Time 		  CentiSeconds Per Get
	 2 System Metrics Long Duration 		  2099 Global Cache Average Current Get Time		  CentiSeconds Per Get
	 2 System Metrics Long Duration 		  2100 Physical Write Total IO Requests Per Sec 	  Requests Per Second
	 2 System Metrics Long Duration 		  2101 Global Cache Blocks Corrupted			  Blocks
	 2 System Metrics Long Duration 		  2102 Global Cache Blocks Lost 			  Blocks
	 2 System Metrics Long Duration 		  2103 Current Logons Count				  Logons
	 2 System Metrics Long Duration 		  2104 Current Open Cursors Count			  Cursors
	 2 System Metrics Long Duration 		  2105 User Limit %					  % Sessions/License_Limit
	 2 System Metrics Long Duration 		  2106 SQL Service Response Time			  CentiSeconds Per Call
	 2 System Metrics Long Duration 		  2107 Database Wait Time Ratio 			  % Wait/DB_Time
	 2 System Metrics Long Duration 		  2108 Database CPU Time Ratio				  % Cpu/DB_Time
	 3 System Metrics Short Duration		  2108 Database CPU Time Ratio				  % Cpu/DB_Time
	 2 System Metrics Long Duration 		  2109 Response Time Per Txn				  CentiSeconds Per Txn
	 2 System Metrics Long Duration 		  2110 Row Cache Hit Ratio				  % Hits/Gets
	 2 System Metrics Long Duration 		  2111 Row Cache Miss Ratio				  % Misses/Gets
	 2 System Metrics Long Duration 		  2112 Library Cache Hit Ratio				  % Hits/Pins
	 3 System Metrics Short Duration		  2112 Library Cache Hit Ratio				  % Hits/Pins
	 2 System Metrics Long Duration 		  2113 Library Cache Miss Ratio 			  % Misses/Gets
	 2 System Metrics Long Duration 		  2114 Shared Pool Free %				  % Free/Total
	 3 System Metrics Short Duration		  2114 Shared Pool Free %				  % Free/Total
	 2 System Metrics Long Duration 		  2115 PGA Cache Hit %					  % Bytes/TotalBytes
	 2 System Metrics Long Duration 		  2118 Process Limit %					  % Processes/Limit
	 2 System Metrics Long Duration 		  2119 Session Limit %					  % Sessions/Limit
	 2 System Metrics Long Duration 		  2143 Session Count					  Sessions
	 2 System Metrics Long Duration 		  2137 PQ QC Session Count				  Sessions
	 2 System Metrics Long Duration 		  2138 PQ Slave Session Count				  Sessions
	 2 System Metrics Long Duration 		  2148 Active Serial Sessions				  Sessions
	 2 System Metrics Long Duration 		  2149 Active Parallel Sessions 			  Sessions
	 2 System Metrics Long Duration 		  2120 Executions Per Txn				  Executes Per Txn
	 3 System Metrics Short Duration		  2120 Executions Per Txn				  Executes Per Txn
	 2 System Metrics Long Duration 		  2121 Executions Per Sec				  Executes Per Second
	 3 System Metrics Short Duration		  2121 Executions Per Sec				  Executes Per Second
	 2 System Metrics Long Duration 		  2122 Txns Per Logon					  Txns Per Logon
	 3 System Metrics Short Duration		  2122 Txns Per Logon					  Txns Per Logon
	 2 System Metrics Long Duration 		  2123 Database Time Per Sec				  CentiSeconds Per Second
	 3 System Metrics Short Duration		  2123 Database Time Per Sec				  CentiSeconds Per Second
	 2 System Metrics Long Duration 		  2147 Average Active Sessions				  Active Sessions
	 3 System Metrics Short Duration		  2147 Average Active Sessions				  Active Sessions
	 2 System Metrics Long Duration 		  2124 Physical Write Total Bytes Per Sec		  Bytes Per Second
	 2 System Metrics Long Duration 		  2125 Physical Read IO Requests Per Sec		  Requests Per Second
	 2 System Metrics Long Duration 		  2126 Physical Read Bytes Per Sec			  Bytes Per Second
	 2 System Metrics Long Duration 		  2127 Physical Write IO Requests Per Sec		  Requests Per Second
	 2 System Metrics Long Duration 		  2128 Physical Write Bytes Per Sec			  Bytes Per Second
	 2 System Metrics Long Duration 		  2057 Host CPU Utilization (%) 			  % Busy/(Idle+Busy)
	 3 System Metrics Short Duration		  2057 Host CPU Utilization (%) 			  % Busy/(Idle+Busy)
	 2 System Metrics Long Duration 		  2129 DB Block Changes Per User Call			  Blocks Per Call
	 2 System Metrics Long Duration 		  2130 DB Block Gets Per User Call			  Blocks Per Call
	 2 System Metrics Long Duration 		  2131 Executions Per User Call 			  Executes Per Call
	 2 System Metrics Long Duration 		  2132 Logical Reads Per User Call			  Reads Per Call
	 2 System Metrics Long Duration 		  2133 Total Sorts Per User Call			  Sorts Per Call
	 2 System Metrics Long Duration 		  2134 Total Table Scans Per User Call			  Tables Per Call
	 2 System Metrics Long Duration 		  2135 Current OS Load					  Number Of Processes
	 2 System Metrics Long Duration 		  2136 Streams Pool Usage Percentage			  % Memory allocated / Size of Streams pool
	 2 System Metrics Long Duration 		  2144 Average Synchronous Single-Block Read Latency	  Milliseconds
	 2 System Metrics Long Duration 		  2145 I/O Megabytes per Second 			  Megabtyes per Second
	 2 System Metrics Long Duration 		  2146 I/O Requests per Second				  Requests per Second
	 2 System Metrics Long Duration 		  2150 Captured user calls				  calls
	 2 System Metrics Long Duration 		  2151 Replayed user calls				  calls
	 2 System Metrics Long Duration 		  2152 Workload Capture and Replay status		  status
	 2 System Metrics Long Duration 		  2153 Background CPU Usage Per Sec			  CentiSeconds Per Second
	 2 System Metrics Long Duration 		  2154 Background Time Per Sec				  Active Sessions
	 2 System Metrics Long Duration 		  2155 Host CPU Usage Per Sec				  CentiSeconds Per Second
	 3 System Metrics Short Duration		  2155 Host CPU Usage Per Sec				  CentiSeconds Per Second
	 2 System Metrics Long Duration 		  2156 Cell Physical IO Interconnect Bytes		  bytes
	 3 System Metrics Short Duration		  2156 Cell Physical IO Interconnect Bytes		  bytes
	 2 System Metrics Long Duration 		  2157 Temp Space Used					  bytes
	 3 System Metrics Short Duration		  2157 Temp Space Used					  bytes
	 2 System Metrics Long Duration 		  2158 Total PGA Allocated				  bytes
	 3 System Metrics Short Duration		  2158 Total PGA Allocated				  bytes
	 2 System Metrics Long Duration 		  2159 Total PGA Used by SQL Workareas			  bytes
	 3 System Metrics Short Duration		  2159 Total PGA Used by SQL Workareas			  bytes
	 2 System Metrics Long Duration 		  2160 Run Queue Per Sec				  Processes
	 2 System Metrics Long Duration 		  2161 VM in bytes Per Sec				  bytes per sec
	 2 System Metrics Long Duration 		  2162 VM out bytes Per Sec				  bytes per sec
	 4 Session Metrics Long Duration		  4000 Blocked User Session Count			  Sessions
	 5 Session Metrics Short Duration		  5000 User Transaction Count (Session) 		  Transactions
	 5 Session Metrics Short Duration		  5001 CPU Time (Session)				  CentiSeconds
	 5 Session Metrics Short Duration		  5002 Physical Reads (Session) 			  Reads
	 5 Session Metrics Short Duration		  5003 PGA Memory (Session)				  Bytes
	 5 Session Metrics Short Duration		  5004 Hard Parse Count (Session)			  Parses
	 5 Session Metrics Short Duration		  5008 Soft Parse Count 				  Parses
	 5 Session Metrics Short Duration		  5005 Total Parse Count (Session)			  Parses
	 5 Session Metrics Short Duration		  5006 Physical Reads Ratio (Sess/Sys) %		  % SessPhyRead/SystemPhyRead
	 5 Session Metrics Short Duration		  5007 Logical Reads Ratio (Sess/Sys) % 		  % SessLogRead/SystemLogRead
	 5 Session Metrics Short Duration		  5009 Logical Read Count				  Reads
	 7 File Metrics Long Duration			  7000 Average File Read Time (Files-Long)		  CentiSeconds Per Read
	 7 File Metrics Long Duration			  7001 Average File Write Time (Files-Long)		  CentiSeconds Per Write
	 7 File Metrics Long Duration			  7002 Physical Reads (Files-Long)			  Reads
	 7 File Metrics Long Duration			  7003 Physical Writes (Files-Long)			  Writes
	 7 File Metrics Long Duration			  7004 Physical Block Reads (Files-Long)		  Blocks
	 7 File Metrics Long Duration			  7005 Physical Block Writes (Files-Long)		  Blocks
	 6 Service Metrics				  6000 Elapsed Time Per User Call			  Microseconds Per Call
	10 Service Metrics (Short)			  6000 Elapsed Time Per User Call			  Microseconds Per Call
	 6 Service Metrics				  6004 DB Time Per User Call				  Microseconds Per Call
	10 Service Metrics (Short)			  6004 DB Time Per User Call				  Microseconds Per Call
	 6 Service Metrics				  6001 CPU Time Per User Call				  Microseconds Per Call
	10 Service Metrics (Short)			  6001 CPU Time Per User Call				  Microseconds Per Call
	 6 Service Metrics				  6002 User Calls Per Second				  User Calls Per Second
	10 Service Metrics (Short)			  6002 User Calls Per Second				  User Calls Per Second
	 6 Service Metrics				  6003 DB Time Per Second				  CentiSeconds
	10 Service Metrics (Short)			  6003 DB Time Per Second				  CentiSeconds
	 6 Service Metrics				  6005 Main Function User Calls Per Second		  Usercalls Per Second
	10 Service Metrics (Short)			  6005 Main Function User Calls Per Second		  Usercalls Per Second
	 6 Service Metrics				  6006 Elapsed Time Per Main Function Usercall		  Microseconds Per Roundtrip
	10 Service Metrics (Short)			  6006 Elapsed Time Per Main Function Usercall		  Microseconds Per Roundtrip
	 6 Service Metrics				  6007 CPU Time Per Main Function Usercall		  Microseconds Per Roundtrip
	10 Service Metrics (Short)			  6007 CPU Time Per Main Function Usercall		  Microseconds Per Roundtrip
	 0 Event Metrics				     0 Number of Sessions Waiting (Event)		  Sessions
	 0 Event Metrics				     1 Total Time Waited				  CentiSeconds
	 0 Event Metrics				     2 Total Wait Counts				  Waits
	 0 Event Metrics				     3 Total Time Waited (Foreground)			  CentiSeconds
	 0 Event Metrics				     4 Total Wait Counts (Foreground)			  Waits
	 1 Event Class Metrics				  1000 Average Users Waiting Counts			  Users
	 1 Event Class Metrics				  1001 Database Time Spent Waiting (%)			  % (TimeWaited / DBTime)
	 1 Event Class Metrics				  1003 Total Time Waited				  CentiSeconds
	 1 Event Class Metrics				  1002 Total Wait Counts				  Waits
	 1 Event Class Metrics				  1005 Total Time Waited (Foreground)			  CentiSeconds
	 1 Event Class Metrics				  1004 Total Wait Counts (Foreground)			  Waits
	 9 Tablespace Metrics Long Duration		  9000 Tablespace Space Usage				  Tablespace Blocks
	 9 Tablespace Metrics Long Duration		  9001 Tablespace Bytes Space Usage			  Tablespace KiloBytes
	19 Recovery Area Metric Group			 19000 Recovery Area Space Usage			  Bytes
	11 I/O Stats by Function Metrics		 11000 MegaBytes of Small Reads per Second		  MegaBytes per Second
	11 I/O Stats by Function Metrics		 11001 MegaBytes of Small Writes per Second		  MegaBytes per Second
	11 I/O Stats by Function Metrics		 11002 MegaBytes of Large Reads per Second		  MegaBytes per Second
	11 I/O Stats by Function Metrics		 11003 MegaBytes of Large Writes per Second		  MegaBytes per Second
	11 I/O Stats by Function Metrics		 11004 Small Read Requests per Second			  Requests per Second
	11 I/O Stats by Function Metrics		 11005 Small Write Requests per Second			  Requests per Second
	11 I/O Stats by Function Metrics		 11006 Large Read Requests per Second			  Requests per Second
	11 I/O Stats by Function Metrics		 11007 Large Write Requests per Second			  Requests per Second
	11 I/O Stats by Function Metrics		 11008 Number of Waits					  Waits
	11 I/O Stats by Function Metrics		 11009 Average Wait Time				  Milliseconds
	12 Resource Manager Stats			 12000 Resource Manager IDentifier			  Number
	12 Resource Manager Stats			 12001 Consumed CPU Time				  Milliseconds
	12 Resource Manager Stats			 12002 CPU Wait Time					  Milliseconds
	12 Resource Manager Stats			 12003 I/O Requests					  Number of Requests
	12 Resource Manager Stats			 12004 MegaBytes of I/O 				  MegaBytes
	12 Resource Manager Stats			 12005 PQ Active Time					  Milliseconds
	12 Resource Manager Stats			 12006 PQ Queued Time					  Milliseconds
	12 Resource Manager Stats			 12007 Parallel Server Active Time			  Milliseconds
	12 Resource Manager Stats			 12008 Parallel Server Queued Time			  Milliseconds
	17 Resource Manager PDB Stats			 17000 Resource Manager IDentifier			  Number
	17 Resource Manager PDB Stats			 17001 Consumed CPU Time				  Milliseconds
	17 Resource Manager PDB Stats			 17002 CPU Wait Time					  Milliseconds
	17 Resource Manager PDB Stats			 17003 I/O Requests					  Number of Requests
	17 Resource Manager PDB Stats			 17004 MegaBytes of I/O 				  MegaBytes
	17 Resource Manager PDB Stats			 17005 I/O Requests Throttle Exempt			  Number of Requests
	17 Resource Manager PDB Stats			 17006 MegaBytes of I/O Throttle Exempt 		  MegaBytes
	17 Resource Manager PDB Stats			 17007 I/O Throttle Time				  Milliseconds
	17 Resource Manager PDB Stats			 17008 PQ Active Time					  Milliseconds
	17 Resource Manager PDB Stats			 17009 PQ Queued Time					  Milliseconds
	17 Resource Manager PDB Stats			 17010 Parallel Server Active Time			  Milliseconds
	17 Resource Manager PDB Stats			 17011 Parallel Server Queued Time			  Milliseconds
	17 Resource Manager PDB Stats			 17012 SGA used 					  Bytes
	17 Resource Manager PDB Stats			 17013 Buffer Cache used				  Bytes
	17 Resource Manager PDB Stats			 17014 Shared Pool used 				  Bytes
	17 Resource Manager PDB Stats			 17015 PGA used 					  Bytes
	13 WCR metrics					 13000 WRC average IO latency				  sec
	13 WCR metrics					 13001 Percentage of replay threads on CPU		  %
	13 WCR metrics					 13002 Percentage of replay threads doing IO		  %
	14 WLM PC Metrics				 14000 User Calls Per Second				  User Calls Per Second
	14 WLM PC Metrics				 14001 DB Time Per User Request 			  Microseconds Per Request
	14 WLM PC Metrics				 14002 DB CPU Per User Request				  Microseconds Per Request
	14 WLM PC Metrics				 14006 File IO Service Time Per User Request		  Centiseconds Per Request
	14 WLM PC Metrics				 14007 File IO Wait Time Per User Request		  Centiseconds Per Request
	14 WLM PC Metrics				 14008 GC CR Time Per User Request			  Microseconds Per Request
	14 WLM PC Metrics				 14009 GC CUR Time Per User Request			  Microseconds Per Request
	14 WLM PC Metrics				 14003 Scheduler Wait Time Per User Request		  Microseconds Per Request
	14 WLM PC Metrics				 14004 Non-idle Wait Time Per User Request		  Microseconds Per Request
	14 WLM PC Metrics				 14005 Non-idle Wait Count Per User Request		  Waits Count Per Request
	14 WLM PC Metrics				 14010 OS CPU Qt Wait Time Per User Request		  OS Qt Wait Time Per Request
	14 WLM PC Metrics				 14011 In call idle Wait Time Per User Request		  Microseconds Per Request
	14 WLM PC Metrics				 14012 User Requests Per Second 			  User Requests Per Second
	15 Service Per Region Metrics			 15000 User Requests Per Second 			  User Requests Per Second
	16 Chunks					 16000 User Requests Per Second 			  User Requests Per Second
	18 PDB System Metrics Long Duration		 18000 Session Count					  Sessions
	18 PDB System Metrics Long Duration		 18001 PQ QC Session Count				  Sessions
	18 PDB System Metrics Long Duration		 18002 PQ Slave Session Count				  Sessions
	18 PDB System Metrics Long Duration		 18003 Average Active Sessions				  Active Sessions
	18 PDB System Metrics Long Duration		 18004 Active Serial Sessions				  Sessions
	18 PDB System Metrics Long Duration		 18005 Active Parallel Sessions 			  Sessions
	18 PDB System Metrics Long Duration		 18006 CPU Usage Per Sec				  CentiSeconds Per Second
	18 PDB System Metrics Long Duration		 18007 CPU Usage Per Txn				  CentiSeconds Per Txn
	18 PDB System Metrics Long Duration		 18008 Background CPU Usage Per Sec			  CentiSeconds Per Second
	18 PDB System Metrics Long Duration		 18009 Background Time Per Sec				  Active Sessions
	18 PDB System Metrics Long Duration		 18010 User Commits Per Sec				  Commits Per Second
	18 PDB System Metrics Long Duration		 18011 User Commits Percentage				  % (UserCommit/TotalUserTxn)
	18 PDB System Metrics Long Duration		 18012 Open Cursors Per Sec				  Cursors Per Second
	18 PDB System Metrics Long Duration		 18013 Open Cursors Per Txn				  Cursors Per Txn
	18 PDB System Metrics Long Duration		 18014 Redo Generated Per Sec				  Bytes Per Second
	18 PDB System Metrics Long Duration		 18015 Redo Generated Per Txn				  Bytes Per Txn
	18 PDB System Metrics Long Duration		 18016 Logical Reads Per Sec				  Reads Per Second
	18 PDB System Metrics Long Duration		 18017 Logical Reads Per Txn				  Reads Per Txn
	18 PDB System Metrics Long Duration		 18018 Executions Per Sec				  Executes Per Second
	18 PDB System Metrics Long Duration		 18019 Executions Per Txn				  Executes Per Txn
	18 PDB System Metrics Long Duration		 18020 Physical Reads Per Sec				  Reads Per Second
	18 PDB System Metrics Long Duration		 18021 Physical Reads Per Txn				  Reads Per Txn
	18 PDB System Metrics Long Duration		 18022 Physical Writes Per Sec				  Writes Per Second
	18 PDB System Metrics Long Duration		 18023 Physical Writes Per Txn				  Writes Per Txn
	18 PDB System Metrics Long Duration		 18024 Physical Write Bytes Per Sec			  Bytes Per Second
	18 PDB System Metrics Long Duration		 18025 Physical Write Total Bytes Per Sec		  Bytes Per Second
	18 PDB System Metrics Long Duration		 18026 Physical Read Bytes Per Sec			  Bytes Per Second
	18 PDB System Metrics Long Duration		 18027 Physical Read Total Bytes Per Sec		  Bytes Per Second
	18 PDB System Metrics Long Duration		 18028 DB Block Changes Per Sec 			  Blocks Per Second
	18 PDB System Metrics Long Duration		 18029 DB Block Changes Per Txn 			  Blocks Per Txn
	18 PDB System Metrics Long Duration		 18030 Total Parse Count Per Sec			  Parses Per Second
	18 PDB System Metrics Long Duration		 18031 Total Parse Count Per Txn			  Parses Per Txn
	18 PDB System Metrics Long Duration		 18032 Hard Parse Count Per Sec 			  Parses Per Second
	18 PDB System Metrics Long Duration		 18033 Hard Parse Count Per Txn 			  Parses Per Txn
	18 PDB System Metrics Long Duration		 18034 Soft Parse Ratio 				  % SoftParses/TotalParses
	18 PDB System Metrics Long Duration		 18035 Execute Without Parse Ratio			  % (ExecWOParse/TotalExec)
	18 PDB System Metrics Long Duration		 18036 Parse Failure Count Per Sec			  Parses Per Second
	18 PDB System Metrics Long Duration		 18037 Logons Per Sec					  Logons Per Second
	18 PDB System Metrics Long Duration		 18038 Logons Per Txn					  Logons Per Txn
	18 PDB System Metrics Long Duration		 18039 User Transaction Per Sec 			  Transactions Per Second
	18 PDB System Metrics Long Duration		 18040 User Calls Per Sec				  Calls Per Second
	18 PDB System Metrics Long Duration		 18041 User Calls Per Txn				  Calls Per Txn
	18 PDB System Metrics Long Duration		 18042 User Rollbacks Per Sec				  Rollbacks Per Second
	18 PDB System Metrics Long Duration		 18043 User Rollbacks Percentage			  % (UserRollback/TotalUserTxn)
	18 PDB System Metrics Long Duration		 18044 Current Logons Count				  Logons
	18 PDB System Metrics Long Duration		 18045 Current Open Cursors Count			  Cursors
	18 PDB System Metrics Long Duration		 18046 Network Traffic Volume Per Sec			  Bytes Per Second
	18 PDB System Metrics Long Duration		 18047 Database Wait Time Ratio 			  % Wait/DB_Time
	18 PDB System Metrics Long Duration		 18048 Database CPU Time Ratio				  % Cpu/DB_Time
	18 PDB System Metrics Long Duration		 18049 SQL Service Response Time			  CentiSeconds Per Call
	18 PDB System Metrics Long Duration		 18050 Response Time Per Txn				  CentiSeconds Per Txn

359 rows selected.

#################################

ASH

#################################

**

GV s y s m e t r i c 和 g v sysmetric和gv sysmetric和gvmetric的区别？

gv$sysmetric

**
最新的metric数据

SQL> select to_char(begin_time,'yyyy-mm-dd hh24:mi:ss') begin_time,to_char(end_time,'yyyy-mm-dd hh24:mi:ss') end_time,group_id,metric_id,metric_name,value,metric_unit from gv$sysmetric where inst_id=1;

BEGIN_TIME	    END_TIME		  GROUP_ID  METRIC_ID METRIC_NAME					      VALUE METRIC_UNIT
------------------- ------------------- ---------- ---------- -------------------------------------------------- ---------- ---------------------------------------------
2020-07-03 15:36:02 2020-07-03 15:37:02 	 2	 2000 Buffer Cache Hit Ratio				 99.9999997 % (LogRead - PhyRead)/LogRead
2020-07-03 15:36:02 2020-07-03 15:37:02 	 2	 2001 Memory Sorts Ratio					100 % MemSort/(MemSort + DiskSort)
2020-07-03 15:36:02 2020-07-03 15:37:02 	 2	 2002 Redo Allocation Hit Ratio 				100 % (#Redo - RedoSpaceReq)/#Redo
2020-07-03 15:36:02 2020-07-03 15:37:02 	 2	 2003 User Transaction Per Sec				 .033283408 Transactions Per Second
2020-07-03 15:36:02 2020-07-03 15:37:02 	 2	 2004 Physical Reads Per Sec				 .049925112 Reads Per Second
2020-07-03 15:36:02 2020-07-03 15:37:02 	 2	 2005 Physical Reads Per Txn					1.5 Reads Per Txn
2020-07-03 15:36:02 2020-07-03 15:37:02 	 2	 2006 Physical Writes Per Sec				 .382759195 Writes Per Second
...
...

208 rows selected.

SQL> select begin_time,end_time,intsize_csec,group_id,metric_id,metric_name,value,metric_unit from V$metric where group_id=2;

BEGIN_TIM END_TIME  INTSIZE_CSEC   GROUP_ID  METRIC_ID METRIC_NAME					       VALUE METRIC_UNIT
--------- --------- ------------ ---------- ---------- -------------------------------------------------- ---------- ------------------------------------------
03-JUL-20 03-JUL-20	    6015	  2	  2000 Buffer Cache Hit Ratio				  99.9999022 % (LogRead - PhyRead)/LogRead
03-JUL-20 03-JUL-20	    6015	  2	  2001 Memory Sorts Ratio					 100 % MemSort/(MemSort + DiskSort)
03-JUL-20 03-JUL-20	    6015	  2	  2002 Redo Allocation Hit Ratio				 100 % (#Redo - RedoSpaceReq)/#Redo
03-JUL-20 03-JUL-20	    6015	  2	  2003 User Transaction Per Sec 			  .532003325 Transactions Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2004 Physical Reads Per Sec				  35.8104738 Reads Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2005 Physical Reads Per Txn				     67.3125 Reads Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2006 Physical Writes Per Sec				  50.9393184 Writes Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2007 Physical Writes Per Txn				       95.75 Writes Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2008 Physical Reads Direct Per Sec			  25.5195345 Reads Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2009 Physical Reads Direct Per Txn			    47.96875 Reads Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2010 Physical Writes Direct Per Sec			  25.5195345 Writes Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2011 Physical Writes Direct Per Txn			    47.96875 Writes Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2012 Physical Reads Direct Lobs Per Sec			   0 Reads Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2013 Physical Reads Direct Lobs Per Txn			   0 Reads Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2014 Physical Writes Direct Lobs Per Sec			   0 Writes Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2015 Physical Writes Direct Lobs  Per Txn			   0 Writes Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2016 Redo Generated Per Sec				  128181.945 Bytes Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2017 Redo Generated Per Txn				      240942 Bytes Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2018 Logons Per Sec					  1.64588529 Logons Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2019 Logons Per Txn					     3.09375 Logons Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2020 Open Cursors Per Sec				   581.59601 Cursors Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2021 Open Cursors Per Txn				  1093.21875 Cursors Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2022 User Commits Per Sec				  .532003325 Commits Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2023 User Commits Percentage					 100 % (UserCommit/TotalUserTxn)
03-JUL-20 03-JUL-20	    6015	  2	  2024 User Rollbacks Per Sec					   0 Rollbacks Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2025 User Rollbacks Percentage				   0 % (UserRollback/TotalUserTxn)
03-JUL-20 03-JUL-20	    6015	  2	  2026 User Calls Per Sec				  16888.5786 Calls Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2027 User Calls Per Txn				    31745.25 Calls Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2028 Recursive Calls Per Sec				  18336.9077 Calls Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2029 Recursive Calls Per Txn				  34467.6563 Calls Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2030 Logical Reads Per Sec				  10520136.6 Reads Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2031 Logical Reads Per Txn				  19774569.2 Reads Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2032 DBWR Checkpoints Per Sec 			  .066500416 Check Points Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2033 Background Checkpoints Per Sec				   0 Check Points Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2034 Redo Writes Per Sec				  3.92352452 Writes Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2035 Redo Writes Per Txn				       7.375 Writes Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2036 Long Table Scans Per Sec 				   0 Scans Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2037 Long Table Scans Per Txn 				   0 Scans Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2038 Total Table Scans Per Sec			  9.54280964 Scans Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2039 Total Table Scans Per Txn			     17.9375 Scans Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2040 Full Index Scans Per Sec 			  .033250208 Scans Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2041 Full Index Scans Per Txn 			       .0625 Scans Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2042 Total Index Scans Per Sec			  17461.3965 Scans Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2043 Total Index Scans Per Txn			  32821.9688 Scans Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2044 Total Parse Count Per Sec			  108.977556 Parses Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2045 Total Parse Count Per Txn			   204.84375 Parses Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2046 Hard Parse Count Per Sec 			  14.6799667 Parses Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2047 Hard Parse Count Per Txn 			    27.59375 Parses Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2048 Parse Failure Count Per Sec				   0 Parses Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2049 Parse Failure Count Per Txn				   0 Parses Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2050 Cursor Cache Hit Ratio				  811204.055 % CursorCacheHit/SoftParse
03-JUL-20 03-JUL-20	    6015	  2	  2051 Disk Sort Per Sec					   0 Sorts Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2052 Disk Sort Per Txn					   0 Sorts Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2053 Rows Per Sort					  8.68378039 Rows Per Sort
03-JUL-20 03-JUL-20	    6015	  2	  2054 Execute Without Parse Ratio			   99.375609 % (ExecWOParse/TotalExec)
03-JUL-20 03-JUL-20	    6015	  2	  2055 Soft Parse Ratio 				  86.5293669 % SoftParses/TotalParses
03-JUL-20 03-JUL-20	    6015	  2	  2056 User Calls Ratio 				  47.9442027 % UserCalls/AllCalls
03-JUL-20 03-JUL-20	    6015	  2	  2057 Host CPU Utilization (%) 			  79.2182929 % Busy/(Idle+Busy)
03-JUL-20 03-JUL-20	    6015	  2	  2058 Network Traffic Volume Per Sec			  3838517.64 Bytes Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2059 Enqueue Timeouts Per Sec 			  .016625104 Timeouts Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2060 Enqueue Timeouts Per Txn 			      .03125 Timeouts Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2061 Enqueue Waits Per Sec				  2.72651704 Waits Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2062 Enqueue Waits Per Txn				       5.125 Waits Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2063 Enqueue Deadlocks Per Sec				   0 Deadlocks Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2064 Enqueue Deadlocks Per Txn				   0 Deadlocks Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2065 Enqueue Requests Per Sec 			  120.831255 Requests Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2066 Enqueue Requests Per Txn 			     227.125 Requests Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2067 DB Block Gets Per Sec				  415.494597 Blocks Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2068 DB Block Gets Per Txn					 781 Blocks Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2069 Consistent Read Gets Per Sec			  10519548.8 Blocks Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2070 Consistent Read Gets Per Txn			  19773464.4 Blocks Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2071 DB Block Changes Per Sec 			  330.972569 Blocks Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2072 DB Block Changes Per Txn 			     622.125 Blocks Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2073 Consistent Read Changes Per Sec			  .997506234 Blocks Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2074 Consistent Read Changes Per Txn			       1.875 Blocks Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2075 CPU Usage Per Sec				  3917.63288 CentiSeconds Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2076 CPU Usage Per Txn				  7363.92555 CentiSeconds Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2077 CR Blocks Created Per Sec			  .266001663 Blocks Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2078 CR Blocks Created Per Txn				  .5 Blocks Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2079 CR Undo Records Applied Per Sec			  .581878637 Undo Records Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2080 CR Undo Records Applied Per Txn			     1.09375 Records Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2081 User Rollback UndoRec Applied Per Sec		  .033250208 Records Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2082 User Rollback Undo Records Applied Per Txn	       .0625 Records Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2083 Leaf Node Splits Per Sec 			   2.1446384 Splits Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2084 Leaf Node Splits Per Txn 			     4.03125 Splits Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2085 Branch Node Splits Per Sec			  .016625104 Splits Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2086 Branch Node Splits Per Txn			      .03125 Splits Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2087 PX downgraded 1 to 25% Per Sec				   0 PX Operations Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2088 PX downgraded 25 to 50% Per Sec				   0 PX Operations Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2089 PX downgraded 50 to 75% Per Sec				   0 PX Operations Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2090 PX downgraded 75 to 99% Per Sec				   0 PX Operations Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2091 PX downgraded to serial Per Sec				   0 PX Operations Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2092 Physical Read Total IO Requests Per Sec		   242.44389 Requests Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2093 Physical Read Total Bytes Per Sec		   713312876 Bytes Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2094 GC CR Block Received Per Second			  4070.68994 Blocks Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2095 GC CR Block Received Per Txn			    7651.625 Blocks Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2096 GC Current Block Received Per Second		  8.71155445 Blocks Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2097 GC Current Block Received Per Txn		      16.375 Blocks Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2098 Global Cache Average CR Get Time 		  .064577786 CentiSeconds Per Get
03-JUL-20 03-JUL-20	    6015	  2	  2099 Global Cache Average Current Get Time		  .053435115 CentiSeconds Per Get
03-JUL-20 03-JUL-20	    6015	  2	  2100 Physical Write Total IO Requests Per Sec 	  19.3183707 Requests Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2101 Global Cache Blocks Corrupted				   0 Blocks
03-JUL-20 03-JUL-20	    6015	  2	  2102 Global Cache Blocks Lost 				   0 Blocks
03-JUL-20 03-JUL-20	    6015	  2	  2103 Current Logons Count					 353 Logons
03-JUL-20 03-JUL-20	    6015	  2	  2104 Current Open Cursors Count				1444 Cursors
03-JUL-20 03-JUL-20	    6015	  2	  2105 User Limit %					  8.2189E-06 % Sessions/License_Limit
03-JUL-20 03-JUL-20	    6015	  2	  2106 SQL Service Response Time			  .387689702 CentiSeconds Per Call
03-JUL-20 03-JUL-20	    6015	  2	  2107 Database Wait Time Ratio 			  71.3131757 % Wait/DB_Time
03-JUL-20 03-JUL-20	    6015	  2	  2108 Database CPU Time Ratio				  28.6868243 % Cpu/DB_Time
03-JUL-20 03-JUL-20	    6015	  2	  2109 Response Time Per Txn				  25670.0619 CentiSeconds Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2110 Row Cache Hit Ratio				  99.3419103 % Hits/Gets
03-JUL-20 03-JUL-20	    6015	  2	  2111 Row Cache Miss Ratio				  .658089688 % Misses/Gets
03-JUL-20 03-JUL-20	    6015	  2	  2112 Library Cache Hit Ratio				   99.914852 % Hits/Pins
03-JUL-20 03-JUL-20	    6015	  2	  2113 Library Cache Miss Ratio 			  .085148033 % Misses/Gets
03-JUL-20 03-JUL-20	    6015	  2	  2114 Shared Pool Free %				  23.5816905 % Free/Total
03-JUL-20 03-JUL-20	    6015	  2	  2115 PGA Cache Hit %					  99.5287333 % Bytes/TotalBytes
03-JUL-20 03-JUL-20	    6015	  2	  2118 Process Limit %					       11.34 % Processes/Limit
03-JUL-20 03-JUL-20	    6015	  2	  2119 Session Limit %					  7.59210526 % Sessions/Limit
03-JUL-20 03-JUL-20	    6015	  2	  2120 Executions Per Txn				  32806.9688 Executes Per Txn
03-JUL-20 03-JUL-20	    6015	  2	  2121 Executions Per Sec				  17453.4165 Executes Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2122 Txns Per Logon					  .323232323 Txns Per Logon
03-JUL-20 03-JUL-20	    6015	  2	  2123 Database Time Per Sec				  13656.5583 CentiSeconds Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2124 Physical Write Total Bytes Per Sec		  653189.426 Bytes Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2125 Physical Read IO Requests Per Sec		  4.22277639 Requests Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2126 Physical Read Bytes Per Sec			  293359.401 Bytes Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2127 Physical Write IO Requests Per Sec		  14.2144638 Requests Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2128 Physical Write Bytes Per Sec			  417294.896 Bytes Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2129 DB Block Changes Per User Call			   .01959742 Blocks Per Call
03-JUL-20 03-JUL-20	    6015	  2	  2130 DB Block Gets Per User Call			  .024602106 Blocks Per Call
03-JUL-20 03-JUL-20	    6015	  2	  2131 Executions Per User Call 			  1.03344496 Executes Per Call
03-JUL-20 03-JUL-20	    6015	  2	  2132 Logical Reads Per User Call			   622.91427 Reads Per Call
03-JUL-20 03-JUL-20	    6015	  2	  2133 Total Sorts Per User Call			  .009395106 Sorts Per Call
03-JUL-20 03-JUL-20	    6015	  2	  2134 Total Table Scans Per User Call			  .000565045 Tables Per Call
03-JUL-20 03-JUL-20	    6015	  2	  2135 Current OS Load					   112.65918 Number Of Processes
03-JUL-20 03-JUL-20	    6015	  2	  2136 Streams Pool Usage Percentage				   0 % Memory allocated / Size of Streams pool
03-JUL-20 03-JUL-20	    6015	  2	  2137 PQ QC Session Count					   0 Sessions
03-JUL-20 03-JUL-20	    6015	  2	  2138 PQ Slave Session Count					   0 Sessions
03-JUL-20 03-JUL-20	    6015	  2	  2139 Queries parallelized Per Sec				   0 Queries Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2140 DML statements parallelized Per Sec			   0 Statements Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2141 DDL statements parallelized Per Sec			   0 Statements Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2142 PX operations not downgraded Per Sec			   0 PX Operations Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2143 Session Count						 577 Sessions
03-JUL-20 03-JUL-20	    6015	  2	  2144 Average Synchronous Single-Block Read Latency	  .307369525 Milliseconds
03-JUL-20 03-JUL-20	    6015	  2	  2145 I/O Megabytes per Second 			  680.897756 Megabtyes per Second
03-JUL-20 03-JUL-20	    6015	  2	  2146 I/O Requests per Second				  91.4546966 Requests per Second
03-JUL-20 03-JUL-20	    6015	  2	  2147 Average Active Sessions				  136.565583 Active Sessions
03-JUL-20 03-JUL-20	    6015	  2	  2148 Active Serial Sessions					 171 Sessions
03-JUL-20 03-JUL-20	    6015	  2	  2149 Active Parallel Sessions 				   0 Sessions
03-JUL-20 03-JUL-20	    6015	  2	  2150 Captured user calls					   0 calls
03-JUL-20 03-JUL-20	    6015	  2	  2151 Replayed user calls					   0 calls
03-JUL-20 03-JUL-20	    6015	  2	  2152 Workload Capture and Replay status			   0 status
03-JUL-20 03-JUL-20	    6015	  2	  2153 Background CPU Usage Per Sec			  435.422495 CentiSeconds Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2154 Background Time Per Sec				  4.71279498 Active Sessions
03-JUL-20 03-JUL-20	    6015	  2	  2155 Host CPU Usage Per Sec				  7594.69659 CentiSeconds Per Second
03-JUL-20 03-JUL-20	    6015	  2	  2156 Cell Physical IO Interconnect Bytes		  4.3024E+10 bytes
03-JUL-20 03-JUL-20	    6015	  2	  2157 Temp Space Used						   0 bytes
03-JUL-20 03-JUL-20	    6015	  2	  2158 Total PGA Allocated				  3940070400 bytes
03-JUL-20 03-JUL-20	    6015	  2	  2159 Total PGA Used by SQL Workareas			    90828800 bytes
03-JUL-20 03-JUL-20	    6015	  2	  2160 Run Queue Per Sec					   0 Processes
03-JUL-20 03-JUL-20	    6015	  2	  2161 VM in bytes Per Sec					   0 bytes per sec
03-JUL-20 03-JUL-20	    6015	  2	  2162 VM out bytes Per Sec					   0 bytes per sec

161 rows selected.

V S Y S M E T R I C d i s p l a y s t h e s y s t e m m e t r i c v a l u e s c a p t u r e d f o r t h e m o s t c u r r e n t t i m e i n t e r v a l f o r b o t h t h e l o n g d u r a t i o n ( 60 − s e c o n d ) a n d s h o r t d u r a t i o n ( 15 − s e c o n d ) s y s t e m m e t r i c s . V SYSMETRIC displays the system metric values captured for the most current time interval for both the long duration (60-second) and short duration (15-second) system metrics. V SYSMETRICdisplaysthesystemmetricvaluescapturedforthemostcurrenttimeintervalforboththelongduration(60−second)andshortduration(15−second)systemmetrics.VSYSMETRIC_HISTORY displays all system metric values available in the database. Both long duration (60-second with 1 hour history) and short duration (15-second with one-interval only （with 3 mins？）) metrics are displayed by this view.
V$SYSMETRIC_SUMMARY displays a summary of all system Metric values for the long-duration system metrics. The average, maximum value, minimum value, and the value of one standard deviation for the last hour are displayed for each metric item.

###############################

AWR

###############################

查看tps数据
intsize 是interval size，单位为百分之秒

SQL> select to_char(t0.begin_time,'yyyy-mm-dd hh24:mi:ss') as begin_time,
  2             to_char(t0.end_time,'yyyy-mm-dd hh24:mi:ss') as end_time,
  3         t0.snap_id,
  4         t0.instance_number,
  5         t0.value,
  6         t0.intsize
  7    from dba_hist_sysmetric_history t0
  8   where t0.begin_time between sysdate - 0.5
  9                           and sysdate
 10     and t0.group_id=2
 11     and t0.metric_id=2003 and t0.instance_number=1
 12   order by t0.begin_time ,t0.snap_id, t0.instance_number
 13  ;

BEGIN_TIME          END_TIME               SNAP_ID INSTANCE_NUMBER      VALUE    INTSIZE
------------------- ------------------- ---------- --------------- ---------- ----------
2020-07-02 23:44:02 2020-07-02 23:45:02       1619               1 .182845745       6016
2020-07-02 23:45:02 2020-07-02 23:46:02       1619               1 .515121303       6018
2020-07-02 23:46:02 2020-07-02 23:47:02       1619               1  .38237739       6015
2020-07-02 23:47:02 2020-07-02 23:48:02       1619               1 .548628429       6015
2020-07-02 23:48:02 2020-07-02 23:49:03       1619               1 1.44734653       6011
2020-07-02 23:49:03 2020-07-02 23:50:02       1619               1 .456543794       5914
2020-07-02 23:50:02 2020-07-02 23:51:02       1619               1 .482128013       6015
2020-07-02 23:51:02 2020-07-02 23:52:02       1619               1 .033250208       6015
2020-07-02 23:52:02 2020-07-02 23:53:02       1619               1 .349243306       6013
2020-07-02 23:53:02 2020-07-02 23:54:02       1619               1 .266090138       6013
2020-07-02 23:54:02 2020-07-02 23:55:02       1619               1  .09976721       6014
wgz7747147820
关注
专栏目录
数据库面试题集
qq_41302958的博客
09-18 4624
数据库理论与应用 一、基本概念 1. 名词解释：数据库、数据库管理系统 数据库：根据某种数据模型进行组织，并存放到计算机存储设备的数据集合。笼统来讲，就是存放数据的仓库。 数据库管理系统：英文写作Database Management System（简称DBMS），是位于操作系统和用户之间的专门进行数据管理的软件系统。常见的DBMS： Oralce, MySQL, DB2, SQL Server, Informix。 2. 请描述数据管理的三个阶段及每阶段特点 1）人工管理阶段：计算机不通过数据管
oracle数据库tps优化_oracle tps
weixin_31829293的博客
12-29 523
http://blog.csdn.net/nilxin/article/details/5812480sample 1:定义TPS：Transactions Per Second(每秒传输的事物处理个数)，即服务器每秒处理的事务数。TPS包括一条消息入和一条消息出，加上一次用户数据库访问。(业务TPS = CAPS × 每个呼叫平均TPS)TPMC：Transactions Per Minute(...
oracle TPS和QPS
sqlora的专栏
11-12 5452
Oracle作为RDBMS的一哥，很多细节设计的比较完善。在v$SYSMETRIC*这些视图中，已经帮你计算好了TPS和QPS。 方法1：查询V$SYSMETRIC或V$SYSMETRIC_HISTORY QPS： 最近1分钟QPS select value from v$sysmetric where metric_name in ('Executions Per Sec') where group_id=2； 最近15秒QPS select value from v$sysmetric wh
Oracle、MySQL、PostGreSQL、SQL Server-查询每秒事务数
最新发布
weixin_tank88921的博客
06-30 982
在做 db benchmarks 时，qps、tps 是衡量数据库性能的关键指标,TPS : Transactions Per Second 是每秒事务数，即数据库服务器在单位时间内处理的事务数。横向对比计划几类数据库计算tps的方法。
oracle tps
weixin_34301132的博客
11-10 760
http://blog.csdn.net/nilxin/article/details/5812480 sample 1: 定义 TPS：Transactions Per Second（每秒传输的事物处理个数），即服务器每秒处理的事务数。TPS包括一条消息入和一条消息出，加上一次用户数据库访问。（业务TPS = CAPS × 每个呼叫平均TPS） TPMC：Transactions ...
oracle数据库tps测试,用orabm测试oracle服务器的TPS值
weixin_39543647的博客
04-06 696
一、TPS概念简介TPS：transaction per second 服务器每秒处理的事务数。Transactions Per Second(每秒传输的事物处理个数)，即服务器每秒处理的事务数。它是软件测试结果的测量单位。一个事务是指一个客户机向服务器发送请求然后服务器做出反应的过程。客户机在发送请求时开始计时，收到服务器响应后结束计时，以此来计算使用的时间和完成的事务个数，最终利用这些信息来估...
oracle 如何查看tps,用orabm测试oracle服务器的TPS值
weixin_36053398的博客
04-05 979
还好的是，orabm预先提供windows版本的数据装载程序，在 orabm/bin/windows 目录下就是。将orabm拷贝或者FTP到windows平台的机器上，配置好oracle连接，即可装载数据了，如下：E:\temp>set LOCAL=ccbverE:\temp>orabmload Warehouse 1Connected to ORACLE as user: ORAB...
oracle性能指标
07-27
可以通过每秒事务数（Transactions Per Second，TPS）或每秒查询数（Queries Per Second，QPS）来衡量。 3. 并发性（Concurrency）：指数据库同时处理多个并发用户或事务的能力。高并发性可以提高系统的吞吐量和...
oracle IO 使用情况
01-15
在项目的实际应用中， 使用此 sql 代码可以查找运行过程中， 哪些 sql 语句占用 io 内存比较大， 以便于进行优化， 使项目运行更加便利。
jvm调优（四）吞吐量、tps、qps概念、jvm等概念
方方园园的博客
06-07 1752
1、吞吐量 2、平均响应时间 3、tps 4、qps
用orabm测试oracle服务器的TPS值
婷婷小屋
07-19 765
研发论坛讨论主题葛宏宾109649/user/zte_ltd昨天 16:16.主题:.用orabm测试oracle服务器的TPS值.分类:测试 用orabm测试oracle服务器的TPS值1、orabm简介Orabm是一个开源的oracle性能测试工具，，包含了一套SQL脚本和几个命令行程序。作者Geoff Ingram，是《High-Performance Oracle: P
查oracle的tps,Oracle TPS指标
weixin_39844515的博客
04-04 1952
定义TPS：Transactions Per Second(每秒传输的事物处理个数)，即服务器每秒处理的事务数。TPS包括一条消息入和一条消息出，加上一次用户数据库访问。(业务TPS = CAPS × 每个呼叫平均TPS)TPMC：Transactions Per Minute(每分钟处理的交易量)，tpmC值在国内外被广泛用于衡量计算机系统的事务处理能力。--查看某段时间数据库的TPS指标，通过...
oracle查看每秒io吞吐量,Oracle IO性能测试
weixin_31437187的博客
04-04 2264
d.name,i.asynch_ioFROMv$datafile d,v$iostat_file iWHERE d.file# =i.file_noAND i.filetype_name = ‘Data File‘;如果异步IO是关闭的，可以通过以下方式开启：ALTER SYSTEM SET filesystemio_options=setall SCOPE=SPFILE;SHUTDOW...
统计ORACLE读块的IO能力
海鲨MYSQL精英架构师
06-15 1802
忽然想到了测试数据库的真实IO能力,虽然硬件工程师有套方法测试IOPS ,虽然ORACLE也推出了ORAXXX的测试小工具. 实际应用环境中 因为表空间,表的设置,块的大小等因素影响到IOPS. 比如想一个全表扫描,需要多久才能出来呢? 分别在工作负责空闲情况下,高的情况下,并行的情况下.做公司的研发数据库上做了相应的实验,就在空闲情况下得到的时间不太有效.比如一个表有1万个块,每个块8K  得到
一个每日生产指标的ORACLE SQL查询语句（备忘录）
老杨的专栏
09-07 825
select zname, case when zname='月计划厂用电率' then (select to_char(index_value)||'%' from JH.T_YDSCZB where index_name ='厂用电率' and JH.T_YDSCZB.PLAN_YAERMONTH= to_char(sysdate,'yyyy-mm')) when zn
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值