Why sga component's size not shows
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
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
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.
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.
SELECT COMPONENT , CURRENT_SIZE/1024/1024 MB
WHERE CURRENT_SIZE <>0
Click Here to Expand Forum to Full Width