Home » RDBMS Server » Server Administration » session_cached_cursor
session_cached_cursor [message #387782] Fri, 20 February 2009 10:41 Go to next message
caprikar
Messages: 226
Registered: March 2007
Senior Member
Hi,
I have oracle 10g database running on HP-UX. I set session_cached_cursor to 100. How can i find whether this value is good engough or i need to increase to more?
thanks
Re: session_cached_cursor [message #387785 is a reply to message #387782] Fri, 20 February 2009 10:48 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
GOOGLE is your friend, but only when you use it.
Results 1 - 10 of about 2,810 for oracle session_cached_cursor
Re: session_cached_cursor [message #388122 is a reply to message #387782] Mon, 23 February 2009 05:31 Go to previous messageGo to next message
ahudspith
Messages: 26
Registered: January 2009
Location: Avoiding the tax man.
Junior Member
Lets just say that your user community would have let you know by now if it was too small...

However 100 is tiny.
Re: session_cached_cursor [message #388125 is a reply to message #388122] Mon, 23 February 2009 05:41 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams189.htm#CHDGECHD
Previous Topic: Error while Recreating controlfile
Next Topic: Execution plan - parameters
Goto Forum:
  


Current Time: Tue Dec 06 16:04:00 CST 2016

Total time taken to generate the page: 0.09740 seconds