FreeLists / oracle-l / RE: ** keep/pin objects in sga

[A Joshi <ajoshi977@xxxxxxxxx>]

Thanks Laimutis and  Mark Bobak, jame tong, Eagle fan, Tanel Poder, Beranrd 
Polarski.
   
  I looked at everything. I think cursor_space_for_time will not suit our env 
going by what Tanel said. About sessions_cached_cursors according to metalink 
note 208857.1 sql I used to see the recommendation : it suggests the current 
value of 300 is fully used and could be candidate for increase. However, from 
below document http://www.miracleas.dk/tools/Miracle_2_cursor.pdf
by bjorn ensig of miracle it says : 'There is some overhead in CPU, effectively 
making this parameter useless for values higher than 50-100. 
  So am trying to decide which way to go : high or low. I think if it could 
help with memory so should I reduce it. 
I think apart from that I am trying to pin objects and pinning 
  package,package body,function,procedure,  trigger,type, sequence
   I think individual sql can also be pinned but I do not know how easy and 
beneficial that is. Is there anything else I can pin? 
   
  I am planning to set 
  _kghdsidx_count to 1 explicitly. I assume there is no issue with that. It is 
having 2 subpool now. I do not know in what way 2 subpool helps. 
   
  Thanks for all the help.

Laimutis Nedzinskas <Laimutis.Nedzinskas@xxxxxxxxxxxxx> wrote:
      Take a look at this too:
   
  http://download-uk.oracle.com/oowsf2005/003wp.pdf
   
  It is really one of the best explanations I´ve ever seen. At least it sounds 
close to what Oracle programmers really did.
   

    
---------------------------------
  From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of jame tong
Sent: 24. október 2006 07:43
To: ORACLE-L
Subject: Re: ** keep/pin objects in sga


  
have a read at this document .

http://www.miracleas.dk/tools/Miracle_2_cursor.pdf
  
Fyrirvari/Disclaimer
http://www.landsbanki.is/disclaimer


 
---------------------------------
Cheap Talk? Check out Yahoo! Messenger's low  PC-to-Phone call rates.