Re: Profiling Oracle database objects
From: Andrew Hodgson <andrew_at_tcamiga.demon.co.uk>
Date: Wed, 30 Sep 1998 22:45:39 +0100
Message-ID: <sLT1dCADaqE2EwlX_at_tcamiga.demon.co.uk>
Date: Wed, 30 Sep 1998 22:45:39 +0100
Message-ID: <sLT1dCADaqE2EwlX_at_tcamiga.demon.co.uk>
In article <6u91j5$h5k$1_at_nnrp1.dejanews.com>, amar_kapadia_at_mydejanews.
com writes
>We are trying to profile Oracle procedures, functions and packages (not just
>individual SQL statements) to find out whether a given routine executed and if
>so, how many times and the success/failure of the execution.
>
>Are there any tools available from Oracle or other vendors which help in doing
>this?
>
>Thanks,
>Amar
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Why not try switching on Audit trail in your database, then audit sucessful calls & failed calls to your PL/SQL.
-- | Andrew Hodgson - Andrew_at_tcamiga.demon.co.uk | | www.tcamiga.demon.co.uk | | Amiga 1200 030 33Mhz | 6x86 P150+ | | 250Mb HD HD Disk Drive | Quad Spd CD 5.3 Gb HD | | 6Mb Ram | CDTV | Motorola SurfR 56K | 80Mb Ram | Resistance is futile...Received on Wed Sep 30 1998 - 23:45:39 CEST