soft pare versus hard parse

thanks for all of the advises. I have one question, on the trace file and this file is huge, there were a huge number of the elapsed time and no time on cpu, below is the elaspe value:

Code:

---

call    count      cpu    elapsed      disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        3      0.00      0.00          0          0          0          0
Execute      6      0.005987400908.58          0          0          0          0
Fetch        6      0.00      0.00          0        58          0          1
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total      15      0.005987400908.58          0        58          0          1

---

what caused this elasped time so huge, could it be there was a lock??? but again that query is only the SELECT statement, so it's not possible.

Anyway, what could it be to make the elasped time so huge and cpu time is 0

Quote:

---

Originally posted by learning_bee
but again that query is only the SELECT statement, so it's not possible.

Anyway, what could it be to make the elasped time so huge and cpu time is 0

---

What about "SELECT * FROM dual FOR UPDATE NOWAIT;"? ;)

learning_bee,

please, Please, PLEASE, learn how to use the code and /code tags (that is the # button). I'd have thought after 261 posts . . . . the data you posted above is incomprehensible.

Remember, you are a LEARNING_bee.

Sorry dapi,

I will try to use code next time. Do you have any suggestions or comments on my questions????

thanks again

Quote:

---

Originally posted by learning_bee
Sorry dapi,

I will try to use code next time. Do you have any suggestions or comments on my questions????

thanks again

---

repost the output formatted correctly, it is unreadable as you had it

since he's so slow I put the code for him :s

Something skrewy here: that's 6'000 million seconds elapsed, there are only 31 million seconds in a year! On top of that the number is too big for the field in which it's printed . . . are you sure there's no copy/paste error?

Dapi,

I got this output from my colleague and I am not sure I am not it's typo on his part. right now is night time over there so I won't be able to ask him. Anyway, what could it be for the ELAPSED TIME so huge like that (assume it's typo on some figure). Could it be there is a lock during the transaction??? But it's impossible b/c the query was the SELECT statement not DML, that's just my thought and I want to double check with you guys.


thanks million.

could someone please give me recommendations or inputs about the questions above???

thanks