Re: Monitoring SQL statements in oracle

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Thu, 22 Jan 2004 17:35:40 -0800
Message-ID: <MT_Pb.15981$AA6.5628@fed1read03>

Stop TOP POSTING!

Ertan wrote:

> It means an sql statement that oracle raises a parsing error.
> 
> "Ana C. Dent" <anacedent_at_hotmail.com> wrote in message news:<04GPb.15148$AA6.5911_at_fed1read03>...
>

>>Ertan wrote:
>>
>>>I'm trying to monitor "erroneous" SQL statements issued by an
>>>application. Is there a way to do this?
>>
>>Define "erroneous SQL", please.

Most applications are written using packages. Packages with "erroneous" SQL will be flagged as in valid

SELECT OBJECT_NAME, OBJECT_TYPE
FROM USER_OBJECTS
WHERE STATUS = 'INVALID'; Received on Thu Jan 22 2004 - 19:35:40 CST