Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: session_cached_cursors pros & cons
Syed,
When I first came across SCS I called Oracle support and asked what they thought would be appropriate. They had no clue to what I was talking about and finally suggested some value less than 10.
Luckily I came across someone who suggested increments of 100 were far more appropriate. I remember Tom Kyte suggesting starting at a 100 for a new database and that memory usage was minimal. Steve Adams has a couple of scripts on his website to show you usage. Steve seemed more concerned about memory than Tom, but I don't know if he's still concerned for 9 or 10G. If you use Oraperf.com and send a statspack report they'll give you a pretty good idea of what to set it to.
Our values are generally between 100-1000, but we have one set at 6000.
Larry
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of
SJHussain_at_alfransi.com.sa
Sent: Monday, September 27, 2004 8:58 AM
To: oracle-l_at_freelists.org; oracle-l-bounce_at_freelists.org
Subject: Re: session_cached_cursors pros & cons
Sorry about the following in my previous mail;
>>I came across many people, rather I would say tuning
experts, telling to set this parameter = 10.
I mean value 100 not 10.
Best Regards,
Syed Jaffar Hussain
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Sep 27 2004 - 11:49:30 CDT
![]() |
![]() |