Hi Tanel , I was preparing for the 9i performance tuning exam , that is why
I was dealing with stuff like DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD.
I know its even below the last possible thing you would want to tune in
real life, but theoretical stuff seems to be a favourite with ocp
sometimes.
- Original Message -----
From: "Tanel Poder" <tanel.poder.003_at_mail.ee>
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Saturday, July 26, 2003 06:04
Subject: Re: Advice needed on dbms_shared_pool value
> Hi!
>
> Why do you want to tune this parameter? I've never needed it?
> I suggest just to keep it as it is if you don't have very specific shared
> pool problems. And usually those problems come from bad application or
bugs
> anyway...
>
> Tanel.
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Saturday, July 26, 2003 12:59 AM
>
>
> > Hello list I needed your advice on the following :
> > 1. What value do you all specify in
> > DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD
> > ( value ) ?
> > (1.a.) Should it be set equal to the shared_pool_size ?
> > (1.b.) Should it be greater than shared_pool_size ?
> > (But wouldn't that be impossible. The free list would not be able to
> > service a user request for a size greater than the shared_pool_size)
> > (1.c) Should it be set equal to shared_pool_size minus
> > shared_pool_reserved_size.
> > ( I am not clear on this . Please tell me : can the free list service
a
> > request by taking space from the reserved area AND the rest of shared
> pool
> > or is it 'one or the other and not both together' )
> >
> > 2. After sucessfully executing
> > DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD ( value )
> > (2.a) why doesn't the 'value' show up in
> > select aborted_request_threshold from v$shared_pool_reserved ; ?
> > (2.b) Where would I look to see the change ?
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: <bulbultyagi_at_now-india.net.in
> > INET: bulbultyagi_at_now-india.net.in
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Tanel Poder
> INET: tanel.poder.003_at_mail.ee
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Sat Jul 26 2003 - 07:52:10 CDT
