Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> when the library cache area released

when the library cache area released

From: Pauro Tanaka <syoujit_at_tsi.co.jp>
Date: 1997/06/04
Message-ID: <970604182640.M0121291@s_haiden1.tsi.co.jp>#1/1

        Hi,

	Our customer uses oracle7.3 and X/open interfaces.
	There are many many tables. There are many many columns
	in tables. And there are many many resident sesssions. 
	
	I am anxious about the shared pool size, especially about
	library cache.

	The first question is,
	When is the library cache released ?

	I have tried some cases and the test results follows.
				
			hold_cursor=yes		hold_cursor=no

	prepare		allocate		allocate

	open cursor	allocate		allocate	

	close cursor	allocate		sometimes allocated but
						sometimes released !

	Is this spec of oracle7 or bug, or,,,,,
	Especially, I cannot understand that "sometomes allocated but
	sometimes released".

	My next question is,

	How much shared pool can be used for library cache.
	I tried some tests and I can't uses more than 60% of the shared
	pool for library cache.
		Is this spec ?
		The percentage of the usable shared pool for library cache
		is always 60% ? ( For example, many user requires dictionary
		cache, can we use 60% shared library for library cache ?)
		And When is the dictionary cache allocated and released ?
Received on Wed Jun 04 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US