I am working on a very large database project (Oracle V7.3.4). Currently we
are trying to prevent rogue (unbounded) queries bringing down the
performance of the system. We are trying to find a suitable mechanism to
identify such queries. Is it a case of just looking at the CPU usage of the
UNIX processes associated with the Oracle activity or is there some internal
Oracle mechanism or add on available, that can identify such queries as they
are running. Also, does anyone have a strategy once you have identified
these queries (we have been looking at the UNIX utility NICE). We are
working with two databases - one using Rule-Based Optimization , the other
CBO.
Thanks for you help,
Conor
Received on Sun May 02 1999 - 07:24:18 CDT
