Rather indicative that we don't have an answer to this question!Quote:
Originally posted by Mr.Hanky
When was the last time you bought your DBA lunch?
Printable View
Rather indicative that we don't have an answer to this question!Quote:
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.
Tamil
Is PT Guide not a part of ** DBA books itself ** :confused:Quote:
Originally posted by reydp
Abhay,
And you might recomend to read another documents
like DBA books itself.:D
Abhay.