Re: Oracle rogue query monitor

To protect the system you could use profiles to limit the CPU per call, logical IO per call, or physical I/O per call.

To identify the queries the best I have come up with so far is a regular check of v$sql for logical I/O or physical I/O that exceeds a boundary value per execution.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Conor Brophy wrote in message <372c43bb_at_eeyore.callnetuk.com>...
>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.
Received on Sun May 02 1999 - 08:56:53 CDT