FreeLists / oracle-l / Re: sub heap & ORA-4031

["eagle fan" <eagle.f@xxxxxxxxx>]

Oracle version:9205  24 CPU  shared_pool_size=900M

And one more question, Once a chunk be allocated to a sub pool, is it
possible that it can be allocated to another sub pool?

On 7/6/06, eagle fan <eagle.f@xxxxxxxxx> wrote:
> hi:
>
> I run a script on x$kghlu to collect the shared pool info:
>
> column kghlurcr heading "RECURRENT|CHUNKS"
> column kghlutrn heading "TRANSIENT|CHUNKS"
> column kghlufsh heading "FLUSHED|CHUNKS"
> column kghluops heading "PINS AND|RELEASES"
> column kghlunfu heading "ORA-4031|ERRORS"
> column kghlunfs heading "LAST ERROR|SIZE"
>
> select
>   kghlurcr,
>   kghlutrn,
>   kghlufsh,
>   kghluops,
>   kghlunfu,
>   kghlunfs
> from
>   sys.x$kghlu
> where
>   inst_id = userenv('Instance')
> /
>
> SQL> /
>
>  RECURRENT  TRANSIENT    FLUSHED   PINS AND   ORA-4031 LAST ERROR
>     CHUNKS     CHUNKS     CHUNKS   RELEASES     ERRORS       SIZE
> ---------- ---------- ---------- ---------- ---------- ----------
>        613        740    1481527 6.0489E+10        920      25784
>       2625       7264       4326   73028011          0          0
>       3973       4387     283981  105939833          0          0
>       3795       5289      91121 9508929013          0          0
>       2502       4805     136468   93688365          0          0
>       8673      10944        392   96186804          0          0
>
> 6 rows selected.
>
> I have many questions about the results.
>
> 1. Here I have six sub pools. Why just the first one consistently get the
> 4031 errors?
>     Does each sub pool have different shared pool components?
>     I didn't find details info about the sub pools, if you have one,
> please send me a copy.
>
> 2. I did the heapdump at level 2. The dump files is about 60M, so I can't
> upload it.
>     How can I use the dump file to explain the 4031 errors?
>     I think each line "HEAP DUMP heap name="sga heap(1,0)" is related to
> one sub pool  , but which part is related to the first row in x$kghlu? Is it
> the "sga heap(1,0)"?
>
>
> 3. The "LAST ERROR SIZE" column shows the size is 25784 , Does this mean
> it's located in reserved list (>5000)?
>
>
> Thanks
>
> --
> Eagle Fan
>
> Oracle DBA



--
Eagle Fan

Oracle DBA