since 8i). See Note 146599.1 Diagnosing and Resolving Error ORA-04031.
John
-Original Message-
From: John Kanagaraj [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 13, 2004 2:59 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Shared Pool fragmentation
Rick,
I think the best
Kanagaraj [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 13, 2004 2:59 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Shared Pool fragmentation
Rick,
I think the best answer is 'know thy application'. And in
this, knowledge of
bind var vs hardcoded value usage, looking at V$SQL
-
From: John Kanagaraj [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 13, 2004 2:59 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Shared Pool fragmentation
Rick,
I think the best answer is 'know thy application'. And in
this, knowledge of
bind var vs hardcoded value usage
since 8i). See Note 146599.1 Diagnosing and Resolving Error ORA-04031.
John
-Original Message-
From: John Kanagaraj [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 13, 2004 2:59 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Shared Pool fragmentation
Rick,
I think
On a
side note, before I kill myself with the Friendly Manual, does anyone have a
fast way to determine how much space in the shared pool a package is
using?
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: Rick Stephenson
[mailto:[EMAIL
!
-Original Message-From: Goulet, Dick
[mailto:[EMAIL PROTECTED]Sent: Tuesday, January 13, 2004 1:20
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Shared Pool fragmentation
On a
side note, before I kill myself with the Friendly Manual, does anyone have a
fast way to determine
shared pool usage, then you
have to start taking shared pool heapdumps
Tanel.
- Original Message -
From:
Jamadagni, Rajendra
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, January 13, 2004 11:09
PM
Subject: RE: Shared Pool
fragmentation
Rick,
I think the best answer is 'know thy application'. And in this, knowledge of
bind var vs hardcoded value usage, looking at V$SQL and V$SQLAREA, the ratio
(!!) of 'parse count (hard)' to 'parse count (total)', pinning of
packages/sequences, etc., can help...
You cannot actually 'catch' a
recipients of list ORACLE-L
Subject: RE: Shared Pool fragmentation
Rick,
I think the best answer is 'know thy application'. And in
this, knowledge of
bind var vs hardcoded value usage, looking at V$SQL and
V$SQLAREA, the ratio
(!!) of 'parse count (hard)' to 'parse count (total)', pinning of
packages