RE: OPEN_CURSORS

[Christopher Spence]

Title: OPEN_CURSORS

A few bytes, I think it is something like 16 bytes per open cursor setting.� I think Steve Adams once mentioned an exact number. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:    (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, September 17, 2001 4:45 PM To: Multiple recipients of list ORACLE-L Subject: OPEN_CURSORS   Hi all,         I was just wondering what was the performance and impact of having open_cursors set to 1000. Will it require more shared_memory, etc...         Thanks Cyril Jaouich (Consultant Unix) ------------------------------- Centre de support informatique CSI ---------------------------------- T�l 514-289-2211 x6237 (jusqu'au 7 sept) T�l 514-840-3000 x5527 (� partir du 10 sept)