Re: Optimal values in init.ora file

> Rather than just take wild guesses about what your settings should be
> I think you should run a statspack report and look to see if any
areas
> appear to be a problem.

OK, I'm reading now on how to do this...

> The selected parameters you show indicate that you have a large pool
> allocated larger than the shared pool but you do not display any MTS
> or PQO parameters that would require use of the large pool parameter
> at other than the calculated value. Incomplete information often
> results in incorrect advice.

We don't use any MTS feature, that means I can have a shared_pool_size of 0
or delete it from the init file?

> What kind of application do you have that needs a session to be able
> to hold a 1,000 open cursors?

Well, I think I blow up with this one... If I have it too high will affect the database performance?

> Since you apparently rebuilt the database I hope you recalculated the
> object statistics.

Will research about how to do this...
regards,
  -eduardo s.m. Received on Wed Dec 01 2004 - 10:02:20 CST