OS : HP-UX 11.0
Oracle version : 8.1.6
"oppa" <yhoyho11_at_chollian.net> wrote in message
news:bVmK6.9618$de.429850_at_news.hananet.net...
> I have a problem. with a "ORA-4031"
>
> Qurey
> select pool,name,bytes/1024/1024 from v$sgastat
> where name like 'state %'
> or name='sql area'
> or name like 'free%'
> or name like 'Stat%'
> /
> RESULT
> POOL NAME bytes/1024/1024
> ====================================================
> shared pool free memory 1.142593
> shared pool State objects 1.61787415
> shared pool state objects 560.242164612 <==?
> red pool sql area 6.06278229
> large pool free memory .5859375
> java pool free memory .03125
>
> what is a state objects?
> what is a different with State objects and state objects ?
> (small s, large S)
> why use a large space ?
>
>
>
>
>
>
Received on Wed May 09 2001 - 21:48:37 CDT
