I don't think the cursor sharing will help. We've been going 'round and 'round with the shared pool fragmentation problem and the 4031 errors. Flushing the shared pool might or might not work; sometimes it cleans things up; sometimes it doesn't do anything (as far as I can tell). About all you can do is follow Oracle's recommendations on sizing and cross your fingers. You might have to schedule a periodic restart of the database -- sort of like Windows 3.1 huh?
And ... Oracle is still trying to figure out why index create/rebuild online on a busy table can lock things up. Other people have brought it to their attention, but we (apparently) are the first site that could make it happen at will. I guess there are times when those fat pig applications are useful for something. By the way, we are on Tru64, so I don't think the problems are platform specific. > -----Original Message----- > > After Migrating a production Database from 8.1.7.4 to > 9.2.0.3.0 (64 Bit) on Solaris 8 > following NON-Documented parameters were set by Oracle Corp > > _shared_pool_reserved_min_alloc=16384 > This was done to take care of the ORA-4031 errors. This > caused shared pool erros to STOP Occuring > though at the Cost of increasing the shared_pool_size to > 637MB & shared_pool_reserved_size to 131 MB > Such values seem very high to us . > > 04031, 00000, "unable to allocate %s bytes of shared memory > (\"%s\",\"%s\",\"%s\",\"%s\")" > // *Cause: More shared memory is needed than was allocated > in the shared pool. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
