Re: Identify source of a query

From: Lily <n_nhuha_at_hotmail.com>
Date: 4 Dec 2003 12:37:55 -0800
Message-ID: <541d6c7a.0312041237.214ab088@posting.google.com>

Oops, sorry, okay here goes again..... :)

RDBMS Version: 9iR2
Operating System and Version: Solaris 2.8

The first part of the query is as followed:

---

SELECT /*+cursor_sharing_exact dynamic_sampling(0) no_monitoring*/ count(*),count(distinct
"ID"),sum(vsize("ID")),substrb(dump(min("ID"),16,0,32),1,120),substrb(dump(max("ID"),16,0,32),1,120),count(distinct
"TABLE_NAME"),sum(vsize("TABLE_NAME")),substrb(dump(min(substrb("TABLE_NAME",1,32)),16,0,32),1,120),substrb(dump(max(substrb
...
...
from TABLE_NAME;

---

And am assuming this query is generated after invoking dbms_stats.gather_table_stats procedure. And my question now is how can I find out which user executed this procedure, and how often it's being executed. It seems to affect performance.

Thank you much,
Lily Received on Thu Dec 04 2003 - 14:37:55 CST