session_cached_cursors

Hi ,

Do i need to increase the session_cached_cursors which is 0?

I have checked parse count against 'session cursor cache hits' , 'session cursor cache hits ' is always zero for all the sessions . Below is an output belonging to a session which has high parse count value. This is a rac system and datawarehouse.

INST_ID	SID	STATISTIC#	VALUE	INST_ID_1	STATISTIC#_1	NAME	CLASS
1	207	232	2804	1	232	parse count (total)	64
1	207	233	51	1	233	parse count (hard)	64
1	207	205	0	1	205	session cursor cache hits	64
1	207	234	0	1	234	parse count (failures)	64

Kind Regards,
tolga Received on Thu Jun 03 2004 - 07:36:55 CDT