From cspence@FuelSpot.com Mon, 17 Sep 2001 13:08:37 -0700 From: Christopher Spence Date: Mon, 17 Sep 2001 13:08:37 -0700 Subject: RE: OPEN_CURSORS Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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: Jaouich.Cyril@hydro.qc.ca [mailto:Jaouich.Cyril@hydro.qc.ca] 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)