what is "state objects" ??

From: oppa <yhoyho11_at_chollian.net>
Date: Thu, 10 May 2001 11:25:45 +0900
Message-ID: <bVmK6.9618$de.429850@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:25:45 CDT