!! Please do not post Off Topic to this List !!Are you regularly performing the
appropriate analysis
of optimiser stats?
Its not too uncommon for performance to suddenly go
over the edge rather than degrade in the nice linear
fashion. For example, sorts suddenly needing to go to
disk - just
!! Please do not post Off Topic to this List !!
Connor,
For the most part I agree, but I have also seen circumstances where a
function (in my case) works very consistently for months and then goes totally
south right out of the clear blue. This gets especially nerve racking when
there are
!! Please do not post Off Topic to this List !!
I have noticed in the past that if you pin certain packages or functions in
memory, they can become corrupt. They still show their state as being
'VALID', but they are of no use. The only thing I have found to do is
recompile. We try to
Hi,
We have a cgi that displays data from oracle tables.
The program has been running for several months perfectly.
Last week every time it started, it seemed to almost freeze the Oracle
server ,
it didn' t end the operation (many Select statements).
After several hours of work we removed