RE: failure notice - OFF TOPIC

For Any message Sent to oracledba_at_quickdoc.co.uk , following ERROR message received

Though mails sent by OTHER Users to this ID are reaching me . NOT certain How many Though

Any info would be gratefully accepted

> -----Original Message-----
> From: MAILER-DAEMON_at_ginger.caribdata.co.uk
> [SMTP:MAILER-DAEMON_at_ginger.caribdata.co.uk]
> Sent: Tuesday, September 05, 2000 4:45 PM
> To: VIVEK_SHARMA
> Subject: failure notice
>
> Hi. This is the qmail-send program at ginger.caribdata.co.uk.
> I'm afraid I wasn't able to deliver your message to the following
> addresses.
> This is a permanent error; I've given up. Sorry it didn't work out.
>
> <oracledba_at_quickdoc.co.uk>:
> Sorry, you are not allowed to post to this list :Are you posting from a
> different email address to the one you subscribed ?
>
> --- Below this line is a copy of the message.
>
> Return-Path: <VIVEK_SHARMA_at_infy.com>
> Received: (qmail 9201 invoked from network); 5 Sep 2000 11:15:16 -0000
> Received: from softdnserror (HELO infbosvw.inf.com) (216.52.49.35)
> by ginger.caribdata.co.uk with SMTP; 5 Sep 2000 11:15:16 -0000
> Received: from 204.4.54.41 by infbosvw.inf.com (InterScan E-Mail VirusWall
> NT); Tue, 05 Sep 2000 07:11:49 -0400 (Eastern Daylight Time)
> Received: by KEC-01-MSG with Internet Mail Service (5.5.2650.21)
> id <RY6BQX0M>; Tue, 5 Sep 2000 16:42:46 +0530
> Message-ID: <19CC5A519D17D2118E9C0008C7F432750174B7AF_at_TWRMSG02>
> From: VIVEK_SHARMA <VIVEK_SHARMA_at_infy.com>
> To: 'K Gopalakrishnan' <kaygopal_at_yahoo.com>
> Cc: "'ORACLE-L_at_fatcity.com'" <ORACLE-L_at_fatcity.com>,
> "'oracledba_at_quickdoc.co.uk'" <oracledba_at_quickdoc.co.uk>
> Subject: RE: Re: Benchmark runs - Waits on enqueue , latch free - & AGAIN
> Date: Tue, 5 Sep 2000 16:41:50 +0530
> MIME-Version: 1.0
> X-Mailer: Internet Mail Service (5.5.2650.21)
> Content-Type: text/plain
>
>
> Do you mean _kgl_latch_count (number of library cache latches) instead of
>
> _kgl_bucket_count (index to the bucket count array) ?
>
> Qs. How to Get the CURRENT Values for the Same ?
> Qs. Is it OK to Change these parameters in ORA 7.3.4.5.0 on Digital Unix
> 4.0 G ?
>
> NOTE - 2 Actions Carried Out :-
> 1) Increased the RAM in DB server to 4 GB from 3 GB thereby making it
> Equal
> to the RAM on APP Server
> 2) Cached ALL the Packages of SYS User + Application Software Related
> Oracle Users into the shared_pool
>
> RESULT - CPU Utilization on APP Server became Equal to That on DB Server ,
> Both = 55 % Approx.
> Qs. NOT Sure which of them made the Difference
>
>
>
> > -----Original Message-----
> > From: K Gopalakrishnan [SMTP:kaygopal_at_yahoo.com]
> > Sent: Thursday, August 31, 2000 3:33 PM
> > To: VIVEK_SHARMA
> > Subject: Re: Re: Benchmark runs - Waits on enqueue , latch free - &
> > AGAIN
> >
> > Hi Vivek !!
> >
> > No problem. There is a parameter called '_kgl_bucket_count'
> > which controls the number of child latches for library cache.
> >
> > What is the current setting ( i guess it should be a PRIME number).
> > SOme times increasing this will also help
> >
> > Best Regards,
> > K Gopalakrishnan,
> > Bangalore, INDIA
> >
> >
> >
> > ----- Original Message -----
> > From: VIVEK_SHARMA <VIVEK_SHARMA_at_infy.com>
> > To: <kaygopal_at_yahoo.com>
> > Cc: <ORACLE-L_at_fatcity.com>; <oracledba_at_quickdoc.co.uk>
> > Sent: Wednesday, August 30, 2000 7:36 AM
> > Subject: RE: Re: Benchmark runs - Waits on enqueue , latch free - &
> AGAIN
> >
> >
> > >
> > > Setting CURSOR_SPACE_FOR_TIME=TRUE Caused Performance to FALL
> > >
> > > NOTE - CPU Utilization on APP Server = 51 %
> > > whereas CPU Utilization on DB Server = 67 %
> > >
> > > Qs.2 What can be Done to make the CPU Utilization on APP Server
> GREATER
> > than
> > > or EQUAL to CPU Utilization on DB Server ?
> > >
> > > NOTE Previously On DB Server by increasing the init.ora parameter
> > > shared_pool_reserved_size to 40 M from 10 MB the CPU Utilization
> > > on APP server shot up from 33 % to 51 % as a result
> > >
> > > Vivek Sharma
> > > Phone 080 6588668
> > >
> > >
> > > > -----Original Message-----
> > > > From: VIVEK_SHARMA
> > > > Sent: Wednesday, August 30, 2000 10:46 AM
> > > > To: 'kaygopal_at_yahoo.com'
> > > > Cc: 'ORACLE-L_at_fatcity.com'; 'oracledba_at_quickdoc.co.uk'
> > > > Subject: Re: Benchmark runs - Waits on enqueue , latch free - &
> > > > AGAIN
> > > >
> > > > NO packages pinned .
> > > > Qs.1 How to pin the SYS packages ?
> > > >
> > > > PENDING Will check out by Setting CURSOR_SPACE_FOR_TIME=TRUE &
> revert
> > back
> > > >
> > > > SCRIPT :-
> > > > SQL> select owner || '.' || name OBJECT
> > > > 2 , type
> > > > 3 , to_char(sharable_mem/1024,'9,999.9') "SPACE(K)"
> > > > 4 , loads
> > > > 5 , executions execs
> > > > 6 , kept
> > > > 7 from v$db_object_cache
> > > > 8 where type in ('FUNCTION','PACKAGE','PACKAGE BODY','PROCEDURE')
> > > > 9 and owner not in ('SYS')
> > > > 10 order by owner, name
> > > > 11 /
> > > >
> > > > OBJECT
> > >
> > >
> >
> --------------------------------------------------------------------------
> > > > ------
> > > > TYPE SPACE(K) LOADS EXECS KEP
> > > > -------------- -------- ---------- ---------- ---
> > > > TBAADM.LASP0003
> > > > PACKAGE 4.7 1 38 NO
> > > >
> > > > TBAADM.LASP0003
> > > > PACKAGE BODY 27.9 1 20 NO
> > > >
> > > >
> > > > SQL>
> > > > SQL> select to_char(sum(sharable_mem)/1024,'9,999,999.9') "TOTAL
> SPACE
> > > > (K)"
> > > > 2 from v$db_object_cache
> > > > 3 where type in ('FUNCTION','PACKAGE','PACKAGE BODY','PROCEDURE')
> > > > 4 and owner not in ('SYS');
> > > >
> > > > TOTAL SPACE
> > > > ------------
> > > > 32.6
> > > >
> > > > NOTE the menu option Corresponding to package LASP0003 quite well
> > > > performing
> > > > Hence NO pinning may be Required
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: K Gopalakrishnan [SMTP:kaygopal_at_yahoo.com]
> > > > Sent: Tuesday, August 29, 2000 3:45 PM
> > > > To: Multiple recipients of list ORACLE-L
> > > > Subject: Re: Benchmark runs - Waits on enqueue , latch free
> > > > - & AGAIN
> > > >
> > > > Hi Vivek !
> > > >
> > > >
> > > > Still benchmarking :)
> > > >
> > > > > > RESULT - Most of the waits Occuring on "library
> > > > > cache"
> > > > > > a few waits on row cache objects & shared pool
> > > > > also exist
> > > > > >
> > > > > > Qs. How can this be Addressed ?
> > > >
> > > > Waits for library cache can be reduced (!!) if you set
> > > > the paremeter CURSOR_SPACE_FOR_TIME. But in this case
> > > > you need a little bigger shared pool size. I guess you
> > > > have pinned most of the SYS packages and heavy reload
> > > > packages in Shared Pool.
> > > >
> > > >
> > > >
> > > >
> > > > =====
> > > > With Regards !
> > > > K Gopalakrishnan
> > > > -----------------------------------------------------------
> > > > #489,EastEnd Main Road,
> > > > Jayanagar IX Block East,
> > > > Bangalore-560069, INDIA
> > > > Ph # + (91)-(80)- 6543672
Received on Tue Sep 05 2000 - 06:27:39 CDT