Re: v$sql how to distinguish between internal dictionary selects and user selects

Mladen Gogala wrote:
> On Sun, 15 Oct 2006 16:31:22 -0700, DA Morgan wrote:
>

>> In 10gR2 gv$sql contains a SERVICE column too.

I don't follow.

If the OP wishes to exclude SQL statements not originating with users one solution is to exclude those resulting from background services.

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Oct 15 20:27:28 2006

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production With the Partitioning, OLAP and Data Mining options

SQL> select service, count(*)

   2 from gv$sql
   3 group by service;

SERVICE                COUNT(*)
-------------------- ----------
orabase                     151
SYS$BACKGROUND              455
SYS$USERS                  1322

SQL> It isn't the entire answer ... but it is a start.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org