Re: Optimal values in init.ora file

Mark D Powell wrote:
> 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 begining to read about the statpack...

> 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 or PQO, so, that means I can delete the value? or set it to 0?

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

it's just a client/server application with 40 concurrent users, Forms Developer
in the client side.
How many open cursors I should have so?

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

Sorry if this are dumb questions, but how do I calculate the object statistics?
thanks in advance.
regards,
  -eduardo s.m. Received on Wed Dec 01 2004 - 09:20:44 CST