statspack analysis
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: statspack analysis

  1. #1
    Join Date
    Aug 2005
    Posts
    12

    statspack analysis

    We have been getting a lot of ora-04030-out of process memory errors lately.
    I installed statspack on our database that is 29 terabytes. I noticed a lot of pct misses in the dictionary cache, library cache, and latch activity.
    I am of the assumption that this is pointing to SGA problems. My boss seems to the think that it is PGA problems. Here is a copy of my report:
    Attached Files Attached Files

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    What is the total RAM in the Server?

    Do you really need 88 GB cache?

    Tamil

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    negative logical reads seems suspicious, no? I would try that again with a shorter duration, 'cos I wonder whether your numbers "wrapped round" in the 2 hour window you're using
    David Aldridge,
    "The Oracle Sponge"

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

    Oracle ACE

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    Dave,
    You are right.
    Israel, Reduce the interval to 10 or 15 min.
    His problem is with OS Memory. 88 GB cache, 18 GB PGA etc....
    What is the UNIX OS?

    Tamil

  5. #5
    Join Date
    Aug 2005
    Posts
    12
    Thank you everyone for your replies.
    Now:

    Unix OS-HP-UX
    Total Ram: 128GB

    I am not sure about the 88GB of cache. What is that?

  6. #6
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    In the statspack report it says

    Cache Sizes (end)
    ~~~~~~~~~~~~~~~~~
    Buffer Cache: 90,112M Std Block Size: 32K
    Shared Pool Size: 512M Log Buffer: 49,152K


    Buffer Cache is 90,112M or 90,112/1024=88Gb

    do you need that much amount of cache :-)

    regards
    Hrishy

  7. #7
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    Quote Originally Posted by israel05
    Thank you everyone for your replies.
    Now:

    Unix OS-HP-UX
    Total Ram: 128GB

    I am not sure about the 88GB of cache. What is that?
    How long have you been working with Oracle?

    Tamil

  8. #8
    Join Date
    May 2003
    Location
    Pretoria, Rep of South Africa
    Posts
    191
    another point regarding your stats report.

    When last did you do some index management on your tables?

    Able was I ere I saw Elba

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