Low performance on Table - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Low performance on Table

  1. #11
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Originally posted by Mr.Hanky
    When was the last time you bought your DBA lunch?
    Rather indicative that we don't have an answer to this question!

  2. #12
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    =======
    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

  3. #13
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by reydp
    Abhay,
    And you might recomend to read another documents
    like DBA books itself.

    Is PT Guide not a part of ** DBA books itself **

    Abhay.
    funky...

    "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"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width