| |

VerySource

 Forgot password?
 Register
Search
View: 26|Reply: 5

Consult oracle administrator client performance monitoring tools.

[Copy link]

1

Threads

1

Posts

2

Credits

Newbie

Rank: 1

Credits
2

 China

Post time: 2020-2-24 10:30:01
| Show all posts |Read mode
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?
Reply

Use magic Report

0

Threads

66

Posts

45

Credits

Newbie

Rank: 1

Credits
45

 China

Post time: 2020-5-8 18:00:01
| Show all posts
select sql_text from v $ sqlarea;
Reply

Use magic Report

0

Threads

10

Posts

10

Credits

Newbie

Rank: 1

Credits
10

 China

Post time: 2020-5-11 05:45:01
| Show all posts
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.
Reply

Use magic Report

0

Threads

4

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 China

Post time: 2020-5-16 20:30:01
| Show all posts
He depends on the execution plan and I generally use pl / sql developer
Reply

Use magic Report

0

Threads

4

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 Invalid IP Address

Post time: 2020-5-16 21:00:02
| Show all posts
set autot on at sqlplus
Reply

Use magic Report

0

Threads

4

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 United States

Post time: 2020-5-16 23:00:01
| Show all posts
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
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2020|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list