RE: OPEN_CURSORS

<span style='font-size:

10.0pt;font-family:Arial;color:navy'>A few bytes, I think it is something like 16 bytes per open cursor setting. 
I think <span
 style='font-size:10.0pt;font-family:Arial;color:navy'>Steve Adams<font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial; color:navy'> once mentioned an exact number.

<span style='font-size:12.0pt;

color:navy;mso-no-proof:yes'>"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."

<span style='font-size:18.0pt;

font-family:"Comic Sans MS";color:navy;mso-no-proof:yes'>Christopher R. Spence<font color=navy>
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>Oracle DBA<span style='color:navy;
mso-no-proof:yes'>
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>Phone: (978) 322-5744<span
style='color:navy;mso-no-proof:yes'>
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>Fax:    (707) 885-2275<span
style='color:navy;mso-no-proof:yes'>

<span style='font-size:10.0pt;

font-family:"Comic Sans MS";color:navy;mso-no-proof:yes'>Fuelspot<font color=navy>
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>73 Princeton Street<span style='color:navy; mso-no-proof:yes'>
<span

style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy;mso-no-proof: yes'>North, Chelmsford 01863<span
style='color:navy;mso-no-proof:yes'>
 

<span

style='font-size:10.0pt;font-family:Tahoma'>-----Original Message----- From: Jaouich.Cyril_at_hydro.qc.ca
[mailto:Jaouich.Cyril_at_hydro.qc.ca]
Sent<span
style='font-weight:bold'>: Monday, September 17, 2001 4:45 PM To: Multiple recipients of list <font
 size=2 face=Tahoma>ORACLE-L<font
size=2 face=Tahoma>
Subject: OPEN_CURSORS

<span

style='font-size:12.0pt'> 

<span

style='font-size:10.0pt;font-family:Arial;color:blue'>Hi all,

<span

style='font-size:12.0pt'>        <font
size=2 color=blue face=Arial><span style='font-size:10.0pt;font-family:Arial; color:blue'>I was just wondering what was the performance and impact of having open_cursors set to 1000. Will it require more shared_memory, etc...

<span

style='font-size:12.0pt'>        <font
size=2 color=blue face=Arial><span style='font-size:10.0pt;font-family:Arial; color:blue'>Thanks

<span

style='font-size:10.0pt;font-family:"Courier New"'>Cyril Jaouich (Consultant Unix)

Centre
de support informatique <font
size=2 face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"; font-weight:bold'>CSI

Tél
514-289-2211 x6237 (jusqu'au 7 sept)
Tél
514-840-3000 x5527 (à partir du 10 sept) Received on Mon Sep 17 2001 - 15:08:37 CDT