Well, well, well!
It's Sergio Sánchez! Hehe. How have you been? Try checking it with V$SESSION or V$SESSION_LONGOPS.

Have a great Day!





Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Jeanine Blomberg is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: Sergio Sánchez [mailto:oracledba-ezmlmshield-x92445994.[Email address protected]
Sent: Monday, July 30, 2007 10:30 PM
To: LazyDBA Discussion
Subject: elapsed_time in v$sqlarea

Hi:

Attention, excuse my english!!! ;)

I'm working with Oracle 9i. I've a problem. I have a query (I think is a
query) what is make working the cpu at 100%. I want to know how to
determinate which query is the problem. I'm watching the view v$sqlarea
and I see that some queries have a very big value at elapsed_time column
(see query text below).

Questions:
1. Do exists some tool what can help me to know what is the bad query ?
2. What means the big value of the elapsed_time column?


Select cpu_time/1000000000 cpu, elapsed_time/1000000000 elapsed,
ROWS_PROCESSED, sql_text,

from v$sqlarea

order by elapsed_time desc

Results (only 3 rows for the example)
------------------------------------------------------------------------
------------------------------------------------------------------------
---------------
1.88234375 18446744069.9878 2639788 SELECT SUM(MP.PAGADOCAP)
FROM MP WHERE CDGEM = :b10 AND .......
0.0184375 18446744067.9494 78 SELECT
NOMBREC(PRC.CDGEM,PRC.CDGCL,'I', 'N','','','','') as nombreC, NULL
AS.....
2.223359375 2.396141509 10456137 SELECT DIA_NOMBRE(:b1),
INICIOREAL(:b3,:b2, :b1) FROM DUAL

Regards.



ISC. Sergio Humberto Sánchez Durón
DACOMP SC
Tel. (449)915-4861
Aguascalientes, Ags



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

Oracle LazyDBA home page