OraFAQ Forum: Performance Tuning » who is the user executing query which is using more disk space?

Home » RDBMS Server » Performance Tuning » who is the user executing query which is using more disk space?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

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

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)

Report message to a moderator

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

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hi

Thanks for your reply Michel Bartov

From :- Sunil

Report message to a moderator

Previous Topic:	Document security model
Next Topic:	HELP ON STATSPACK

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 18:04:03 CDT 2024