Rather indicative that we don't have an answer to this question!
Originally posted by Mr.Hanky
When was the last time you bought your DBA lunch?
I thank everyone for your feedback and wonderful comments. We will run Statspack, Analyze the table as well as use Tkprof.
Tamil, what is 10046 event 6 with level 12/8. Please reduce the terminology for me.
By the way, I have done some light DBA tasks not the heavy stuff. I am more of an Oracle BI DBA primarily implementing Oracle and third party software that interact with Oracle Database.
Level 1 is equivalent to set sql_trace=true.
Level 4 is for getting the bind variables and their values in the trace file.
Level 8 is for getting wait events (db_file_sequential_read etc).
Level 12 is the combined setting of level 4 and level 8.
Is PT Guide not a part of ** DBA books itself **
Originally posted by reydp
And you might recomend to read another documents
like DBA books itself.
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
Click Here to Expand Forum to Full Width