实时监控oracle服务器,Oracle 11g实时SQL监控

sys@CCDB> set long 10000000

sys@CCDB> set longchunksize 10000000

sys@CCDB> set linesize 200

sys@CCDB> select dbms_sqltune.report_sql_monitor from dual;

REPORT_SQL_MONITOR

-----------------------------------

SQL Monitoring Report

SQL Text

--------------------------------------------------------------

--------------------------------------------------------------

Global Information

Status              :  DONE (ALL ROWS)

Instance ID         :  1

Session ID          :  982

SQL ID              :  gn3h2qrqdfwru

SQL Execution ID    :  16777216

Plan Hash Value     :  2959114426

Execution Started   :  02/28/2010 14:02:37

First Refresh Time  :  02/28/2010 14:02:41

Last Refresh Time   :  02/28/2010 14:02:42

--------------------------------------------------------------------

| Elapsed |   Cpu   |    IO    |  Other   | Fetch | Buffer | Reads |

| Time(s) | Time(s) | Waits(s) | Waits(s) | Calls |  Gets  |       |

--------------------------------------------------------------------

|    3.46 |    0.13 |     2.38 |     0.94 |     1 |   1752 |  1214 |

--------------------------------------------------------------------

SQL Plan Monitoring Details

============================================================================================================================================

| Id |         Operation         | Name |  Rows   | Cost |   Time    | Start  | Starts |   Rows   | Activity  |      Activity Detail         |

|    |                           |      | (Estim) |      | Active(s) | Active |        | (Actual) | (percent) | (sample #)         |

============================================================================================================================================

|  0 | SELECT STATEMENT          |      |         |      |         1 |     +5 |      1 |        1 |           |    |

|  1 | SORT AGGREGATE            |      |         |      |         1 |     +5 |      1 |        1 |           |    |

|  2 | APPROXIMATE NDV AGGREGATE |      |         |      |         2 |     +4 |      1 |    58610 |           |    |

REPORT_SQL_MONITOR

--------------------------------------------------------------------------------------------------------------------------------------------------

|  3 | TABLE ACCESS FULL         |      |         |      |         5 |     +1 |      1 |    86645 |    100.00 | Cpu (1)              |

|    |                           |      |         |      |           |        |        |          |           | db file scattered read (3) |

============================================================================================================================================