RE: ** keep/pin objects in sga

None of the X$ tables are documented by Oracle.  

Briefly:  

X$KGHLU - Statistics about shared pool LRU lists
X$KSMSP - Listing of chunks in the shared pool
X$KSMSS - Map of SGA memory chunks.  Basis for V$SGASTAT view.
 
 

Hope that helps,  

-Mark

--

Mark J. Bobak

Senior Oracle Architect

ProQuest Information & Learning

There is nothing so useless as doing efficiently that which shouldn't be
done at all.  -Peter F. Drucker, 1909-2005

 



________________________________


From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of A Joshi
Sent: Monday, October 23, 2006 3:37 PM
To: eagle.f_at_gmail.com
Cc: fuadar_at_yahoo.com; oracle-l_at_freelists.org
Subject: Re: ** keep/pin objects in sga


Eagle fan,
  Thanks. I tried to look up the REFERENCE manual for 9i but could not
find explanation for x$ views : x$kghlu, x$ksmss, x$ksmsp
I did find v$ views listed. Can you tell where I can find the
explanation. Thanks
About cursor_space_for_time : My current shared pool is 600MB. If I set
cursor_space_for_time to true then I assume I will need to increase the
shared pool. Any way I can compute or guess how much I need to increase.
Thanks 

Go eagles. 

eagle fan <eagle.f_at_gmail.com> wrote:

	hi:
	
	If you have literal sql issue, I suggest you use bind variables
rather than cusor_sharing.
	
	The parameter cursor_space_for_time is used to pin shared sql in
shared_pool. You can find more info about this parameter..
	
	For advance warning, you can check the x$ tables: x$kghlu,
x$ksmss, x$ksmsp
	
	
	On 10/22/06, A Joshi <ajoshi977_at_yahoo.com > wrote: 

		Fuad,
		   Thanks. So no short cut there. OK. So I guess we
still need to do keeping of objects and sql. And put in bind variables.
I assume there is some improvement in 9i in handling all this. Is there
anything else that can be done to improve the sga usage and avoid its
fragmentation and is there way to get advance warning when it is
fragmented and could be heading for problems. Thanks 
		


		Fuad Arshad <fuadar_at_yahoo.com> wrote:

			cursor sharing still has a lot of bugs.
			it depends on the environment but tom kyte also
asked for the use of this only at session level rather than system level
			
			
			----- Original Message ---- 
			From: A Joshi <ajoshi977_at_yahoo.com>
			To: oracle-l_at_freelists.org
			Sent: Friday, October 20, 2006 3:20:15 PM
			Subject: ** keep/pin objects in sga
			
			
			Hi,
			  For efficient use of shared pool and SGA : On
9i : I assume it is beneficial to keep objects and sql in sga. Or is it
not needed on 9i? I think parameter CURSOR SHARING can be set to FORCE
as alternative to using bind variables  and that will help SGA use but
there were issues with it. I assume in 9i it is better. Any body with
experience otherwise or any other catch? Thanks for your help.  


________________________________


			How low will we go? Check out Yahoo! Messengers
low PC-to-Phone call rates.
<http://us.rd.yahoo.com/mail_us/taglines/postman8/*http://us.rd.yahoo.co
m/evt=39663/*http://voice.yahoo.com> 



		


________________________________


		Want to be your own boss? Learn how on Yahoo! Small
Business.
<http://us.rd.yahoo.com/evt=41244/*http://smallbusiness.yahoo.com/r-inde
x> 




	-- 
	Eagle Fan
	
	Oracle DBA 




________________________________


Want to be your own boss? Learn how on Yahoo! Small Business.
<http://us.rd.yahoo.com/evt=41244/*http://smallbusiness.yahoo.com/r-inde
x>  

--
http://www.freelists.org/webpage/oracle-l