who is the user executing query which is using more disk space? [message #123113] |
Thu, 09 June 2005 20:53 |
sunil_v_mishra
Messages: 506 Registered: March 2005
|
Senior Member |
|
|
hi,
I can find the SQL text(i.e. query) which are using more disk space but i want to know which user is executing that query can any one let me know by wich query i can find the username who is executing that query.
---------------------------------------------------------------
Note:- To find query which is using more disk space is as below
---------------------------------------------------------------
SQL>Select sql_TEXT, DISK_READS FROM V$SQLAREA ORDER BY DISK_READS DESC;
Get first 10 SQL where disk reads are higest and get first 10 SQL where buffer_gets are higest
----------------------------------------------------------------------------------
Thanks in Advance
From:- sunilkumar
[Updated on: Thu, 09 June 2005 20:55] Report message to a moderator
|
|
|
|
|