OTN Discussion Forums : how excuted the query?? ...

Reply to this Thread

Search Forum

Back to Thread List

Replies: 4 - Pages: 1 - Last Post: Aug 28, 2007 6:44 AM Last Post By: Maran Viswarayar

Senthil kumar

Posts: 355
Registered: 02/06/06

how excuted the query??
Posted: Aug 27, 2007 11:15 AM

Hi All,

I am using oracle 10rR2 in Sun Soloris, i want to clarify about the space issue.

One user excuted some query in clinet side (USA), for that query genaretes more redo logs and Archive logs. we runing out of space Now.

there are So many users are working in that database, may i know which user excutes that query?, and what is the query contain?.

Regards
S.Senthil Kumar

athos.joao@orac...

Posts: 96
Registered: 09/19/06

Re: how excuted the query??
Posted: Aug 27, 2007 11:46 AM

in response to: Senthil kumar

if you find the user sid, you could issue the following query to retrive the sql text.

select q.sql_fulltext from v$sql q, v$session s where
q.sql_id = s.sql_id and
s.sid = '&1';

&1 = user sid number.

to view the entire text issue the following:

set long 10000

yingkuan

Posts: 10,898
Registered: 10/08/98

Re: how excuted the query??
Posted: Aug 27, 2007 11:49 AM

in response to: Senthil kumar

If the query has been flush out of shared pool, try to use log miner to find out,

Using LogMiner to Analyze Redo Logs

Helio Dias

Posts: 461
Registered: 06/09/04

Re: how excuted the query??
Posted: Aug 28, 2007 6:14 AM

in response to: Senthil kumar

Dear Senthil Kumar ,

You may query
select * from (
select s.sid, s.serial#,i.block_changes from v$session s, v$sess_io i where s.sid = i.sid order by 3 desc)
where rownum<=10 order by 3

Regards

Hélio Dias
http://heliodias.com

Maran Viswarayar

Posts: 5,696
Registered: 09/22/05

Re: how excuted the query??
Posted: Aug 28, 2007 6:44 AM

in response to: Senthil kumar

Senthil

Do you have the query with you

Pages: 1

Back to Thread List

Legend
	Guru : 2500 - 1000000 pts
	Expert : 1000 - 2499 pts
	Pro : 500 - 999 pts
	Journeyman : 200 - 499 pts
	Newbie : 0 - 199 pts
	Oracle ACE Director
	Oracle ACE Member
	Oracle Employee ACE
	Helpful Answer (5 pts)
	Correct Answer (10 pts)