Hi, there!
We are having an awful situation: we have an Oracle server version 7.0.16
running on top of an SCO Unix that insists in parse every command each time
the command is to be executed (number of parses identical to number of
executions, according to tkprof).
We have checked and the shared pool is large enough and we are using
CURSOR_SPACE_FOR_TIME as TRUE and MAXOPENCURSORS as 1500.
Still we cannot tell the server to cache the SQL commands accordingly and we
think that this exactly what is killing performance.
Can anyone tell us what the problem is? Can it be a bug in Oracle 7.0.16?
P.S.: Yes, we have some BIG procedures, but those run only once a day (at
the end of the day) and we elliminated that as a cache consuming factor,
since the parsing problem is consistent during the whole day.
Thanks in advance.
Wanderley M. Ceschim
wceschim_at_dcc.unicamp.br
