Any Oracle performance guru's?
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 3 123 LastLast
Results 1 to 10 of 21

Thread: Any Oracle performance guru's?

  1. #1
    Join Date
    Oct 2000
    Posts
    103

    Question Any Oracle performance guru's?

    Does anyone want to take a stab at this? I have been getting a lot of complaints from the mangers and users of system performance problems. Iknow thats very genral and I am trying to get more specifics from them. In the meantime I have run a bunch of reports and made a few graphs in toad but I need help deciphering the results. I attached them in a zipfile below.

    Thanks in advance to anyone who helps,
    SM

    p.s I fixed the redo log size problems already

    well i tried to attach the file but it was to large? 1/2 mb oh well i can mail it if someone want to take a look

  2. #2
    Join Date
    Jan 2001
    Posts
    642
    Check the RBS contentions,
    Check the Hit ratios
    Check the I/O wait, locks etc.,

    Email me the zipfile, so that I can try to look at it while the other guru's can respond.

    Badrinath
    There is always a better way to do the things.

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you can either RTFM or contract an experienced DBA

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    The short answer is you are waiting on something. Finding out what you are waiting on is a different story.

    Start by looking at http://otn.oracle.com/deploy/perform...nt.html#Tuning

    I suggest learning about statspack and it's reports.
    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."

  5. #5
    Join Date
    Oct 2000
    Posts
    103
    Thanks badrinathn but your email is not in your profile.

    Pando, what is RTFM ?

    Marist thanks I will begin reading them.

  6. #6
    Join Date
    Oct 2000
    Posts
    103
    I was able to post the file here for anyone who wants to take a look.

    www.nexsen.com/Oracle_805_Performance.zip

    Thanks again,
    SM

  7. #7
    Join Date
    Jul 2000
    Posts
    521
    Pretty good effort !!

    My suggestion is - take one thing at a time. Ask your customers to quantify the performance problems. One specific job, one specific module or whatever. Looking at the graphs, there seems to have been a drastic change in the overall load at one point.

    Looks like the application doesn't use 'reusable' sql statements - meaning with bind variables. It seems to be using literals. Can that be avoided ?

    Lot of MSACCESS users. They always kill your prod databases !! Look at what they are trying to do. Look at their queries.

    Is this a 'soon-after-go-live' situation ? Or, things have changed 'off-late' ?
    svk

  8. #8
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Originally posted by supermega


    Pando, what is RTFM ?

    Lemme guess...ummm
    Read
    The
    F....g
    Manual
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  9. #9
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by Tarry
    [B]Lemme guess...ummm
    F....g
    This part isnt sounding good.....and it isnt professional also...

    Rather RTM would be better...

    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
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by abhaysk
    This part isnt sounding good.....and it isnt professional also...

    Rather RTM would be better...

    Abhay.
    Here's the difference.

    if you pay someone for advice, you get "RTM".

    if you want free advice, you get "RTFM"
    David Aldridge,
    "The Oracle Sponge"

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

    Oracle ACE

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