Re: how can I proove Oracle doesn't measure every SQL-execution

From: Neeraj Bhatia <neeraj.dba_at_gmail.com>
Date: Tue, 21 Apr 2009 14:13:17 +0530
Message-ID: <a8fd4d730904210143u24bc5362m466ca24ad0de7831_at_mail.gmail.com>

Hi Martin,
In future, you can configure such functionality using database triggers. But there is no point to do such a thing.

Neeraj.

On Tue, Apr 21, 2009 at 1:47 PM, Martin Berger <martin.a.berger_at_gmail.com>wrote:

> Hi List,
>
> Today I have to face a more or less non technical question:
> I have to search, ifthere is any possibility to measure the execution time
> of [any|set of|every] SQL thrown onto a database.
> Even I'm pretty sure my boss doesn't know exactly what he wants, I would
> translate it to an ideal view similar to
> instance_id, session_id, username, start-time, sql_id, sql_child_id,
> end-time, ...
> for a given periode into the past (let's say 30 min minimum).
>
> Does anyone know how to convince the management there is no way (either
> oracle internals or 3rd party products) to do this?
>
> In this particular case I doesn't even know how to open a SR at metalink or
> ask for external support to clairfy.
>
> thanks in advance,
> Martin
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Apr 21 2009 - 03:43:17 CDT