| Trace sqlplus [message #55946] |
Wed, 26 February 2003 01:40  |
Ukritk
Messages: 2
Registered: February 2003
|
Junior Member |
|
|
Hello,
I would like to know how can I trace the script that developers who use the database.
We have about 1o developers here and sometimes they will not let me know what they are running which sometimes down grade the database performance so that how can I get that sql script so I can test it by myself and make sure they know what they are doing now.
|
|
|
|
| Re: Trace sqlplus [message #55947 is a reply to message #55946] |
Wed, 26 February 2003 02:00  |
K.K. Raj kumar
Messages: 33
Registered: July 2002
|
Member |
|
|
You can use the dynamic view v$sqlarea.
select sql_text,disk_reads from
V$sqlarea order by disk_reads desc
will give U the sql text which r consuming huge disk_reads and hence degrading the performance
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
