Re: shared_Pool

2003-09-30 Thread bulbultyagi
ptember 30, 2003 06:29 > YES > > regards > navneet > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Tuesday, September 30, 2003 2:29 AM > > > > List, will the following two queries give the sam

Re: shared_Pool

2003-09-29 Thread zhu chao
t; Sent: Tuesday, September 30, 2003 4:59 AM > List, will the following two queries give the same value for the > shared_Pool-size ? > > select sum ( bytes) / (1024*1024) from v$sgastat where pool = 'shared pool'; > > and > > show parameter shared_pool_size >

Re: shared_Pool

2003-09-29 Thread Navneet Gupta
YES regards navneet - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, September 30, 2003 2:29 AM > List, will the following two queries give the same value for the > shared_Pool-size ? > > select sum ( bytes)

shared_Pool

2003-09-29 Thread bulbultyagi
List, will the following two queries give the same value for the shared_Pool-size ? select sum ( bytes) / (1024*1024) from v$sgastat where pool = 'shared pool'; and show parameter shared_pool_size I always get a difference , the first one gives a value greater than the second by 12

ora-06512 errors - flushing shared_pool takes care of it - WHY?

2003-03-07 Thread Fedock, John (KAM.RHQ)
processing heavy EDI will error off with "ORA-01858: a non-numeric character was found where a numeric was expected and ORA-06512: at line 1 errors."  Note that these errors are showing up in the EDI load logs and are NOT generated in the database (8.1.7.4, HP-UX).  If I flush the s

RE: Shared_pool

2002-11-07 Thread Govind . Arumugam
helps. Govind -Original Message- Sent: Wednesday, November 06, 2002 8:43 PM To: Multiple recipients of list ORACLE-L On Wed, Nov 06, 2002 at 04:34:28PM -0800, Jos Someone wrote: > > List, > > How do I find out how full my shared_pool is? -- Diagnosing and Resolving Err

RE: Shared_pool

2002-11-06 Thread Weaver, Walt
Same way I figure out how full my septic tank is. Take the top off. --Walt Weaver Bozeman, Montana On Wed, Nov 06, 2002 at 04:34:28PM -0800, Jos Someone wrote: > > List, > > How do I find out how full my shared_pool is? -- -- Please see the official ORACLE-L FAQ: http://ww

Re: Shared_pool

2002-11-06 Thread Ray Stell
On Wed, Nov 06, 2002 at 04:34:28PM -0800, Jos Someone wrote: > > List, > > How do I find out how full my shared_pool is? -- Diagnosing and Resolving Error ORA-04031 Type: Note Doc ID: 146599.1 Understanding and Tuning the Shared Pool in Oracle7, Oracle8, and Oracle8i Type:

Shared_pool

2002-11-06 Thread Jos Someone
List, How do I find out how full my shared_pool is? Jos Yahoo! Careers - 1,000's of jobs waiting online for you!

Re: shared_pool error

2002-09-20 Thread Reginald . W . Bailey
is a bug about memory leak and we planing upgrade to Oracle 8173 to fix it. In a mean time I increased the shared_pool and shared_pool_reserved_size , and also ping some packages in. Now error sad that: enable to allocate 4096 bytes of shared memory ('shared pool","BEGIN DB

shared_pool error

2002-09-20 Thread Greg Faktor
Hi All! We get ora-04031 on Oracle816 on Unix. I'm aware that this is a bug about memory leak and we planing upgrade to Oracle 8173 to fix it. In a mean time I increased the shared_pool and shared_pool_reserved_size , and also ping some packages in. Now error sad that: enable to allocate

RE: SESSION_CACHED_CURSORS and shared_pool sizing.

2002-06-24 Thread Aponte, Tony
Title: RE: SESSION_CACHED_CURSORS and shared_pool sizing. I don't recall where I read this but I remember a few things about it.  As you noted, the use of SESSION_CAHED_CURSORS has an impact on the UGA.  If you are using MTS then that becomes part of the SGA in the shared pool (or large

SESSION_CACHED_CURSORS and shared_pool sizing.

2002-06-24 Thread Jesse, Rich
Hi all, Trying to deal with SHARED_POOL sizing and perf tuning for an 8.1.6.0.0 DB that's used by 3rd party software. I can't seem to find if higher values of SESSION_CACHED_CURSORS adversely affects the shared pool in any way. Specifically, I'm wondering if the higher number of

Shared_pool in relation to the kernel (Solaris)

2001-08-20 Thread Jaouich . Cyril
Title: Shared_pool in relation to the kernel (Solaris) Hi all,     I've got a question related to the SHARED_POOL_SIZE parameter in my init file. Currently our kernel is defined with a 256MB of shared_memory (set shmsys:shminfo_shmmax=268435456) and we have 2 databases running on

RE: Waits on latch free for shared_pool & library Cache

2001-02-05 Thread VIVEK_SHARMA
Bull's eye . Will Check out the Steve Adams' Book & revert Thanks > -Original Message- > From: yong huang [SMTP:[EMAIL PROTECTED]] > Sent: Monday, February 05, 2001 10:30 AM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: Wai

RE: Waits on latch free for shared_pool & library Cache

2001-02-04 Thread VIVEK_SHARMA
> -Original Message- > From: VIVEK_SHARMA > Sent: Sunday, February 04, 2001 3:38 PM > To: '[EMAIL PROTECTED]' > Subject: Waits on latch free for shared_pool & library Cache > > > CASE Overall Fall in performance of a primarily OLTP Banki

RE: Waits on latch free for shared_pool & library Cache

2001-02-04 Thread VIVEK_SHARMA
> -Original Message- > From: VIVEK_SHARMA > Sent: Sunday, February 04, 2001 3:35 PM > To: '[EMAIL PROTECTED]' > Subject: Waits on latch free for shared_pool & library Cache > > > CASE Overall Fall in performance of a primarily OLTP Banki