Consult oracle administrator client performance monitoring tools.

wayj810

Installed, oracle administrator client, may I ask, is there a performance monitoring tool similar to sql server that can monitor the sql statement executed by the client.
Which tool is it?

whbilly

select sql_text from v $ sqlarea;

liub950511

select * from v $ sql; or select sql_text from v $ sqlarea;

Also:
You can use P6SPY + SQLProfiler, P6SPY + IronEye SQL in our J2EE application to get all the SQL requests issued by the J2EE application.

If anyone is interested in P6SPY + SQLProfiler, P6SPY + IronEye SQL (both open source projects), please contact me.

quantify

He depends on the execution plan and I generally use pl / sql developer

quantify

set autot on at sqlplus

quantify

SQL> explain plan for
  2 select * from emp1 a where a.empno = 24500;

Explained

SQL> SELECT * FROM TABLE (DBMS_XPLAN.DISPLAY ());

PLAN_TABLE_OUTPUT
-------------------------------------------------- ------------------------------
-------------------------------------------------- ------------------
| Id | Operation | Name | Rows | Bytes | Cost |
-------------------------------------------------- ------------------
| 0 | SELECT STATEMENT | | 32 | 576 | 10 |
| * 1 | TABLE ACCESS FULL | EMP1 | 32 | 576 | 10 |
-------------------------------------------------- ------------------
Predicate Information (identified by operation id):
-------------------------------------------------- -
   1-filter ("A". "EMPNO" = 24500)
Note: cpu costing is off