Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: OPEN_CURSORS

RE: OPEN_CURSORS

From: Christopher Spence <cspence_at_FuelSpot.com>
Date: Mon, 17 Sep 2001 13:08:37 -0700
Message-ID: <F001.00390E7E.20010917132151@fatcity.com>

<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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US