Why sga component's size not shows
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Why sga component's size not shows

  1. #1
    Join Date
    Dec 2007
    Posts
    12

    Why sga component's size not shows

    hi all

    i createed a database in oracle 10g & using the mman feature that 10g includes.

    I put statistics_level to all
    and sga_target has also enough size.

    but when I m trying to see the size of sga components in v$parameter, it shows me 0 for all the components. As far as i know, 'mman' automatically decide the size of sga component as per the situation, but it should be given some size to all components, then why not it shows

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

    You have SGA_TARGET set and when that is set

    Default Values of Auto tuned parameters is zero
    If non zero then that value is lower bound
    Actual component szie maybe higher

    Basically you have turned on Automatic SGA management

    regards
    Hrishy

  3. #3
    Join Date
    Dec 2007
    Posts
    12
    I know that i turned it to automatic sga mgmt
    but wat i m seeking for is why not it shows me the size of component even if these components are physically taking some size coz if instance is created & queries are fired then parsing of these statements should be stored in sga it means it takes some area then why not it shows me that area.

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

    You can use the V$SGA_DYNAMIC_COMPONENTS view to see the values assigned to the auto-tuned components.
    Whereas the V$PARAMETER will display the value you set to the auto-tuned SGA parameter, not the value assigned by the ASMM.

    Code:
    SELECT COMPONENT , CURRENT_SIZE/1024/1024 MB
    FROM V$SGA_DYNAMIC_COMPONENTS
    WHERE CURRENT_SIZE <>0
    regards
    Hrishy

  5. #5
    Join Date
    Dec 2007
    Posts
    12
    thanxxxxxxxxxxx man

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