Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: shared pool size
Stjepan Brbot wrote:
> Now in my database (Oracle8i PE, v8.1.7.0.0) shared pool size is 4MB.
> During the process of creating Designer6i (Rev 4) repository while
> installing "RM_ELEMENT" view I get error message that there is not
> enough shared pool (memory)! So, how to enlarge the shared pool? BTW,
> what is this shared pool for?
> --
> Stjepan Brbot <Stjepan.Brbot_at_ZG.HiNet.HR
The shared pool is a cache in memory for packages, sql statements enz.
To see what objects and sizes are in the shared pool size login as
system with sqlplus and:
SQLPLUS> select from v$sgastat
You can alter the size of the shared pool size but you have to shutdown
the database. Locate the init<instance_name>.ora file. make a backup of
this file. edit the file and search for the parameter shared_pool_size =
<value> where value is the size in bytes. enter a larger value ( be
carefull not to cause paging on your system if you choose a too large
size) Restart the database.
-- Ir. A.P. Djuly Gabon Straat 5 2622 Delft djuly_at_wanadoo.nl Posted via dBforums http://dbforums.comReceived on Mon Dec 31 2001 - 04:11:54 CST