Low performance on Table
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Low performance on Table

  1. #1
    Join Date
    Dec 2001
    Location
    Atlanta
    Posts
    175

    Low performance on Table

    I have few heavily accessed tables with less than 1 million rows in each of them that are really taken a long time to return data. Could someone give me guidelines on how to improve performance on those tables?
    I sincerely appreciate your assistance.

    KC
    Data Analyst

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Use indexes?

    Seriously, we need more info....

    What is "slow"?
    What are the query plans?
    What's your I/O setup?
    What are you waiting on?
    How about a tkprof?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Dec 2001
    Location
    Atlanta
    Posts
    175
    Jeff,

    Thanks. I do not have DBA privilege and therefore cannot perform some of those tasks. This particular table has about 1 million rows and several indexes about 10 on heavily accessed fields and columns. The plan is RBO and the DBA's are moving to CBO soon. What else can I do from a developer/database analyst perspective to improve table performance?

    Thank you.

  4. #4
    Join Date
    Jan 2001
    Posts
    3,131
    Uh oh, another developer doing a DBA's job.
    Gotta go clean my gun collection.

    When was the last time the tables was analyzed?
    Can you view the indexes and try to code accordingly?
    Do you think any performance type indexes would help?
    When was the last time you bought your DBA lunch?
    I remember when this place was cool.

  5. #5
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Tell your DBA's that you need them to run "Statspack" while those tables are being queried. Make sure thay have timing set on.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  6. #6
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    Tkprof is the greatest tool to figure the problem.
    Also, you can try 10046 event with level 12/8 to generate trace file.
    Use it wisely.

    Tamil

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Originally posted by marist89

    What is "slow"?
    What are the query plans?
    What's your I/O setup?
    What are you waiting on?
    None of these things need dba privileges.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  8. #8
    Join Date
    Dec 2001
    Location
    Atlanta
    Posts
    175
    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.

  9. #9
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by akwete
    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.
    Then you should better read PT Guide..

    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"

  10. #10
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    Originally posted by abhaysk
    Then you should better read PT Guide..

    Abhay.
    Abhay,
    I believe you're asking too much for a data analyst.
    Even if she/he can somehow grasp the terminologies
    used in in PT. She will still be wondering of what to
    do next. So, she/he will come back here and ask question
    again. And you might recomend to read another documents
    like DBA books itself.

    I rather agree with Mr. Hanky for at least the latter part:
    Uh oh, another developer doing a DBA's job.
    Gotta go clean my gun collection.

    When was the last time the tables was analyzed?
    Can you view the indexes and try to code accordingly?
    Do you think any performance type indexes would help?
    When was the last time you bought your DBA lunch?

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