Home » RDBMS Server » Performance Tuning » who is the user executing query which is using more disk space?
who is the user executing query which is using more disk space? [message #123113] Thu, 09 June 2005 20:53 Go to next message
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

Re: who is the user executing query which is using more disk space? [message #123262 is a reply to message #123113] Fri, 10 June 2005 18:04 Go to previous messageGo to next message
mbartov
Messages: 4
Registered: June 2005
Location: Dallas, TX
Junior Member
Select sql_TEXT, DISK_READS FROM V$SQLAREA ORDER BY DISK_READS DESC;

change to

Select username,sql_TEXT, DISK_READS FROM V$SQLAREA, dba_users
where parsing_user_id = user_id ORDER BY DISK_READS DESC;

Michel Bartov

http://www.odbtools.com (GUI Tools for the Oracle database)
Re: who is the user executing query which is using more disk space? [message #123559 is a reply to message #123262] Mon, 13 June 2005 23:13 Go to previous message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi

Thanks for your reply Michel Bartov

From :- Sunil
Previous Topic: Document security model
Next Topic: HELP ON STATSPACK
Goto Forum:
  


Current Time: Sat Sep 19 02:02:57 CDT 2020