SQL> SQL> SELECT * 2 FROM TABLE(DBMS_WORKLOAD_REPOSITORY.select_baseline_metric('SYSTEM_MOVING_WINDOW')); BASELINE_NAME DBID INSTANCE_NUMBER BEG_TIME END_TIME --------------- ---------- --------------- --------------------------------------------------------------------------- --------------------------------------------------------------------------- METRIC_NAME METRIC_UNIT NUM_INTERVAL INTERVAL_SIZE AVERAGE MINIMUM MAXIMUM ---------------------------------------------------------------- ---------------------------------------------------------------- ------------ ------------- ---------- ---------- ---------- SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Physical Writes Direct Per Sec Writes Per Second 12414 108064 .059240174 0 75.982024 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM User Rollbacks Percentage % (UserRollback/TotalUserTxn) 12414 108064 .000671285 0 8.33333333 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Recursive Calls Per Sec Calls Per Second 12414 108064 12.7557887 0 1461.5048 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Logical Reads Per Txn Reads Per Txn 12414 108064 240.53724 0 99586.3333 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM DBWR Checkpoints Per Sec Check Points Per Second 12414 108064 .00034437 0 .773153479 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Long Table Scans Per Txn Scans Per Txn 12414 108064 .006696865 0 20 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Total Table Scans Per Sec Scans Per Second 12414 108064 .251030756 0 158.649149 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Total Parse Count Per Sec Parses Per Second 12414 108064 .524208187 0 67.983925 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Hard Parse Count Per Txn Parses Per Txn 12414 108064 .177616064 0 248 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM User Calls Ratio % UserCalls/AllCalls 12414 108064 .380478697 0 44.6735395 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Enqueue Deadlocks Per Txn Deadlocks Per Txn 12414 108064 0 0 0 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM DB Block Gets Per Sec Blocks Per Second 12414 108064 11.5311522 0 8813.11071 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM DB Block Changes Per Sec Blocks Per Second 12414 108064 11.2496831 0 9201.67791 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM DB Block Changes Per Txn Blocks Per Txn 12414 108064 70.0493331 0 91735.3333 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM CPU Usage Per Sec CentiSeconds Per Second 12414 108064 .284175993 0 89.4022655 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM CR Undo Records Applied Per Txn Records Per Txn 12414 108064 .033059873 0 10.5384615 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM User Rollback UndoRec Applied Per Sec Records Per Second 12414 108064 .000699413 0 .978928157 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Branch Node Splits Per Sec Splits Per Second 12414 108064 .000139576 0 .033189512 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Branch Node Splits Per Txn Splits Per Txn 12414 108064 .000923118 0 1 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Physical Read Total Bytes Per Sec Bytes Per Second 12414 108064 44570.4048 0 6335347.48 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Global Cache Blocks Corrupted Blocks 12414 108064 0 0 0 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Database CPU Time Ratio % Cpu/DB_Time 12414 108064 16.3211451 0 1515.51891 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Row Cache Miss Ratio % Misses/Gets 12414 108064 .160004885 0 33.9179518 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Process Limit % % Processes/Limit 12414 108064 17.7211213 0 24 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Physical Write Total Bytes Per Sec Bytes Per Second 12414 108064 23779.8617 0 1301367.72 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Physical Write IO Requests Per Sec Requests Per Second 12414 108064 .494292232 0 45.5897093 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Physical Write Bytes Per Sec Bytes Per Second 12414 108064 8558.21676 0 1162700.17 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Session Count Sessions 12414 108064 31.6833414 0 46 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Background Time Per Sec Active Sessions 12414 108064 .028510473 0 1.34740371 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Physical Writes Per Txn Writes Per Txn 12414 108064 52.4997763 0 7306 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Physical Reads Direct Per Txn Reads Per Txn 12414 108064 .311276782 0 2196 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM User Commits Per Sec Commits Per Second 12414 108064 .024006574 0 2.97936085 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Enqueue Waits Per Txn Waits Per Txn 12414 108064 .007339779 0 78 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Enqueue Requests Per Txn Requests Per Txn 12414 108064 403.577146 0 1463 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM DB Block Gets Per Txn Blocks Per Txn 12414 108064 70.0203256 0 92924.3333 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM User Rollback Undo Records Applied Per Txn Records Per Txn 12414 108064 .002867363 0 2.56521739 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM PX downgraded 25 to 50% Per Sec PX Operations Per Second 12414 108064 0 0 0 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Response Time Per Txn CentiSeconds Per Txn 12414 108064 5.63276768 0 5937.1627 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM PGA Cache Hit % % Bytes/TotalBytes 12414 108064 98.2106734 0 100 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Executions Per Sec Executes Per Second 12414 108064 2.36112562 0 565.813836 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Background CPU Usage Per Sec CentiSeconds Per Second 12414 108064 .312897023 0 43.9291335 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Total PGA Allocated bytes 12414 108064 29908477.5 0 94219264 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Physical Writes Per Sec Writes Per Second 12414 108064 1.0447042 0 141.931173 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Redo Generated Per Sec Bytes Per Second 12414 108064 3850.56697 0 1193076.95 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Redo Generated Per Txn Bytes Per Txn 12414 108064 26554.3456 0 11664381.3 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Recursive Calls Per Txn Calls Per Txn 12414 108064 412.332461 0 14126 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Logical Reads Per Sec Reads Per Second 12414 108064 36.0629895 0 10971.1041 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Redo Writes Per Sec Writes Per Second 12414 108064 .14293493 0 13.5234284 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Total Index Scans Per Sec Scans Per Second 12414 108064 3.76348565 0 2714.31412 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Total Index Scans Per Txn Scans Per Txn 12414 108064 42.3459951 0 14894.1818 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Parse Failure Count Per Txn Parses Per Txn 12414 108064 .002764398 0 3 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Host CPU Utilization (%) % Busy/(Idle+Busy) 12414 108064 13.4775267 0 49.2092823 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Enqueue Waits Per Sec Waits Per Second 12414 108064 .00055054 0 1.51742538 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Physical Read Total IO Requests Per Sec Requests Per Second 12414 108064 2.63465845 0 438.516667 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Global Cache Average CR Get Time CentiSeconds Per Get 12414 108064 0 0 0 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Physical Write Total IO Requests Per Sec Requests Per Second 12414 108064 1.30694661 0 47.3772135 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Current Logons Count Logons 12414 108064 23.5786209 0 33 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Row Cache Hit Ratio % Hits/Gets 12414 108064 99.8399951 0 100 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM User Limit % % Sessions/License_Limit 12414 108064 5.4898E-07 0 7.6834E-07 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Txns Per Logon Txns Per Logon 12414 108064 .62950524 0 100 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Physical Read Bytes Per Sec Bytes Per Second 12414 108064 11815.3565 0 6307963.23 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM DB Block Gets Per User Call Blocks Per Call 12414 108064 146.908515 0 178583 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Current OS Load Number Of Processes 12414 108064 0 0 0 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM PQ QC Session Count Sessions 12414 108064 0 0 0 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM DML statements parallelized Per Sec Statements Per Second 12414 108064 0 0 0 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM I/O Requests per Second Requests per Second 12414 108064 3.93093068 0 442.166667 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Replayed user calls calls 12414 108064 0 0 0 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Logons Per Sec Logons Per Second 12414 108064 .014771839 0 .302979296 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM User Rollbacks Per Sec Rollbacks Per Second 12414 108064 1.3415E-06 0 .016652789 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Disk Sort Per Sec Sorts Per Second 12414 108064 0 0 0 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Soft Parse Ratio % SoftParses/TotalParses 12414 108064 51.5186554 0 100 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM CR Blocks Created Per Sec Blocks Per Second 12414 108064 .00359321 0 3.43376536 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Leaf Node Splits Per Txn Splits Per Txn 12414 108064 .361051482 0 48 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Database Wait Time Ratio % Wait/DB_Time 12414 108064 9.54733766 0 100 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Library Cache Miss Ratio % Misses/Gets 12414 108064 .347510682 0 20.5882353 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Session Limit % % Sessions/Limit 12414 108064 12.7755409 0 18.5483871 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Executions Per Txn Executes Per Txn 12414 108064 40.6061532 0 6436 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM PX operations not downgraded Per Sec PX Operations Per Second 12414 108064 0 0 0 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Buffer Cache Hit Ratio % (LogRead - PhyRead)/LogRead 12414 108064 99.7850699 0 100 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Physical Reads Per Sec Reads Per Second 12414 108064 1.44230416 0 769.998329 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Physical Reads Direct Lobs Per Sec Reads Per Second 12414 108064 .000429011 0 2.37094333 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Open Cursors Per Txn Cursors Per Txn 12414 108064 21.6667378 0 6400 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM User Calls Per Sec Calls Per Second 12414 108064 .048269677 0 7.31023102 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM User Calls Per Txn Calls Per Txn 12414 108064 1.56810643 0 443 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Total Table Scans Per Txn Scans Per Txn 12414 108064 1.68909139 0 1212 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Parse Failure Count Per Sec Parses Per Second 12414 108064 .00188185 0 1.77494977 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Enqueue Timeouts Per Txn Timeouts Per Txn 12414 108064 .000291952 0 3 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Consistent Read Gets Per Txn Blocks Per Txn 12414 108064 170.517158 0 92826 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM CR Undo Records Applied Per Sec Undo Records Per Second 12414 108064 .005277994 0 23.0600909 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM PX downgraded 1 to 25% Per Sec PX Operations Per Second 12414 108064 0 0 0 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM GC CR Block Received Per Txn Blocks Per Txn 12414 108064 0 0 0 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM GC Current Block Received Per Second Blocks Per Second 12414 108064 0 0 0 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM GC Current Block Received Per Txn Blocks Per Txn 12414 108064 0 0 0 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Current Open Cursors Count Cursors 12414 108064 31.0540519 0 74 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Physical Read IO Requests Per Sec Requests Per Second 12414 108064 .6323203 0 435.833333 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM PQ Slave Session Count Sessions 12414 108064 0 0 0 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM DDL statements parallelized Per Sec Statements Per Second 12414 108064 0 0 0 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Active Parallel Sessions Sessions 12414 108064 0 0 0 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Redo Allocation Hit Ratio % (#Redo - RedoSpaceReq)/#Redo 12414 108064 99.9998408 0 100 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Physical Reads Per Txn Reads Per Txn 12414 108064 16.4781525 0 46069 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Physical Reads Direct Per Sec Reads Per Second 12414 108064 .01910471 0 36.7408399 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Physical Writes Direct Per Txn Writes Per Txn 12414 108064 .079662619 0 78.4117647 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Open Cursors Per Sec Cursors Per Second 12414 108064 1.95703643 0 546.911294 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Background Checkpoints Per Sec Check Points Per Second 12414 108064 .000093978 0 .033411293 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Total Parse Count Per Txn Parses Per Txn 12414 108064 8.36283032 0 371 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Cursor Cache Hit Ratio % CursorCacheHit/SoftParse 12414 108064 183.220909 0 34023.2877 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Disk Sort Per Txn Sorts Per Txn 12414 108064 0 0 0 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Enqueue Requests Per Sec Requests Per Second 12414 108064 8.34372951 0 100.083375 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM CPU Usage Per Txn CentiSeconds Per Txn 12414 108064 1.93508742 0 4104.6875 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM PX downgraded 50 to 75% Per Sec PX Operations Per Second 12414 108064 0 0 0 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM GC CR Block Received Per Second Blocks Per Second 12414 108064 0 0 0 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Shared Pool Free % % Free/Total 12414 108064 13.6728249 0 76.2217607 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Executions Per User Call Executes Per Call 12414 108064 41.2719073 0 12911 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Logical Reads Per User Call Reads Per Call 12414 108064 436.477937 0 226708 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Total Sorts Per User Call Sorts Per Call 12414 108064 15.6212676 0 2405 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Average Synchronous Single-Block Read Latency Milliseconds 12414 108064 4.43388865 0 60.1 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM I/O Megabytes per Second Megabtyes per Second 12414 108064 .065183815 0 6.11733244 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Active Serial Sessions Sessions 12414 108064 1.03310778 0 6 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Captured user calls calls 12414 108064 0 0 0 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Physical Writes Direct Lobs Per Sec Writes Per Second 12414 108064 .000372805 0 .806858296 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Logons Per Txn Logons Per Txn 12414 108064 .449300343 0 7 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Full Index Scans Per Txn Scans Per Txn 12414 108064 .006215481 0 8.73684211 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Hard Parse Count Per Sec Parses Per Second 12414 108064 .031503073 0 18.6369725 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Execute Without Parse Ratio % (ExecWOParse/TotalExec) 12414 108064 88.2675968 0 100 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Network Traffic Volume Per Sec Bytes Per Second 12414 108064 1.16863167 0 1873.43234 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Enqueue Timeouts Per Sec Timeouts Per Second 12414 108064 .000060679 0 .485599464 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Enqueue Deadlocks Per Sec Deadlocks Per Second 12414 108064 0 0 0 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Consistent Read Changes Per Txn Blocks Per Txn 12414 108064 .22227636 0 486.363636 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM PX downgraded to serial Per Sec PX Operations Per Second 12414 108064 0 0 0 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Global Cache Average Current Get Time CentiSeconds Per Get 12414 108064 0 0 0 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Global Cache Blocks Lost Blocks 12414 108064 0 0 0 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM SQL Service Response Time CentiSeconds Per Call 12414 108064 .009604131 0 9.02682266 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM DB Block Changes Per User Call Blocks Per Call 12414 108064 147.558791 0 186456.667 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Streams Pool Usage Percentage % Memory allocated / Size of Streams pool 12414 108064 0 0 0 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Queries parallelized Per Sec Queries Per Second 12414 108064 0 0 0 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Workload Capture and Replay status status 12414 108064 0 0 0 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Temp Space Used bytes 12414 108064 17034925.5 0 29360128 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Total PGA Used by SQL Workareas bytes 12414 108064 2191.03335 0 3530752 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Memory Sorts Ratio % MemSort/(MemSort + DiskSort) 12414 108064 100 0 100 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM User Transaction Per Sec Transactions Per Second 12414 108064 .024007916 0 2.97936085 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Physical Reads Direct Lobs Per Txn Reads Per Txn 12414 108064 .010398373 0 14.1 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Physical Writes Direct Lobs Per Txn Writes Per Txn 12414 108064 .004131925 0 12 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM User Commits Percentage % (UserCommit/TotalUserTxn) 12414 108064 19.5015037 0 100 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Redo Writes Per Txn Writes Per Txn 12414 108064 4.39188284 0 323 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Long Table Scans Per Sec Scans Per Second 12414 108064 .001166133 0 .631964078 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Full Index Scans Per Sec Scans Per Second 12414 108064 .007050405 0 5.99464166 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Rows Per Sort Rows Per Sort 12414 108064 25.1654053 0 11061.9241 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Consistent Read Gets Per Sec Blocks Per Second 12414 108064 24.5318372 0 10853.2153 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Consistent Read Changes Per Sec Blocks Per Second 12414 108064 .095397042 0 88.6348575 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM CR Blocks Created Per Txn Blocks Per Txn 12414 108064 .037030372 0 9 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Leaf Node Splits Per Sec Splits Per Second 12414 108064 .059013446 0 2.05490989 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM PX downgraded 75 to 99% Per Sec PX Operations Per Second 12414 108064 0 0 0 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Library Cache Hit Ratio % Hits/Pins 12414 108064 99.6528115 0 104 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Database Time Per Sec CentiSeconds Per Second 12414 108064 1.0375165 0 686.426462 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Total Table Scans Per User Call Tables Per Call 12414 108064 2.03286603 0 860 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Average Active Sessions Active Sessions 12414 108064 .010375165 0 6.86426462 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Host CPU Usage Per Sec CentiSeconds Per Second 12414 108064 50.0894046 0 191.712707 SYSTEM_MOVING_W 1546135824 1 18-APR-12 11.59.21.000 PM 27-APR-12 03.00.02.000 PM Cell Physical IO Interconnect Bytes bytes 12414 108064 4100829.15 0 384118784 158 rows selected. SQL>