Re: Who executed top queries

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Wed, 29 Nov 2006 13:43:26 -0700
Message-Id: <20061129204300.D38244C493F@turing.freelists.org>

Is access to the dba_hist views part of the diagnostics pack? If so then it is a separately priced option, of course.
The parsing schema is available in 9i as well in the v$sql view. But that doesn't tell you who else is executing it.

At 01:30 PM 11/29/2006, Charles Schultz wrote:
>If using 10g EM, Top Activity makes this really obvious. So I have
>to assume you are either 1) not using 10g and/or 2) not using EM.
>If you are using 10g, I believe you can tie the dba_hist_sqltext to
>DBA_HIST_SQLSTAT to get the parsing_schema. I am not sure how EM
>builds a historical list of user ids for a particular sql_id.
>
>If using 9i, you are kinda stuck, especially if the sql has aged out
>of the library cache. But once again, I think you can only get the
>id of the original parser, not each sql_id that requested that sql_id.
>
>On 11/29/06, George Leonard
><<mailto:george_at_mighty.co.za>george_at_mighty.co.za > wrote:
>
>I gave them the standard report show top queries by number of times
>executed, rows accessed, buffer blocks accessed etc.
>They now turn around and asked if I can tell them who executed those queries.

Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com

This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email

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

Received on Wed Nov 29 2006 - 14:43:26 CST