Re: Shared Pool Size (Hard to Explain)
Date: 1996/03/12
Message-ID: <4i4q5n$5l6_at_news.Belgium.EU.net>#1/1
In article <Pine.SUN.3.91.960311144204.16780A-100000_at_reddog.csustan.edu>,
John Landers (jcl_at_csustan.edu) says...
!>
!>I am running a database that has one user doing inserts,deletes,updates
!>and selects. There are several triggers and procedures. Currently the
!>shared pool size is 9M and We get an ora-4031 saying to increase
!>our shared pool size. I can rationalize how one process can need
!>more that 9M. I think someithing else needs to be tuned. But haven't
!>stubled on it. Any ideas or places to search please email response.
!>If increaseing it is ok then an affirmative would be nice to here.
!>Oracle 7.2.24 for Os/2.
!>Thanks,
!>
!> John Landers
!> Computer Science Major
!> CSUS
!> jcl_at_altair.csustan.edu
!>
I'm afraid you might have to enlarge it. Do the 9Mb include db_block_buffers? The room you need depends on the size of Oracle's and your procedures and SQL, not on the number of users (except if you were using MTS, you wouldn't, would you, for one user?). So if this one user is running very complex queries, fires long triggers, etc. etc., you may run out of luck (and space). You can monitor the SGA and see what's in it.
-- Kind reGards \ / | X | / \ s GerardReceived on Tue Mar 12 1996 - 00:00:00 CET