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.
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 O
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 lis