Re: SQL History in Statspack: Parsing schema?
- From: Martin Klier <usn@xxxxxxxxx>
- To: Oracle-L Group <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 19 Jun 2009 10:37:55 +0200
CORRIGENDA:
of course it's stats$sql_summary and stats$sqltext, not sql_status
Sorry.
Martin Klier schrieb:
> Dear list,
>
> I am using statspack in a 10gR2 database to collect and display SQL
> history. It's selected from stats$sql_status and stats$sql_summary.
>
> Now my question: How can I find out, which schema did parse there SQLs?
> I can't find a column with a speaking information, did I miss anything
> obvious?
>
> Thanks a lot in advance!
--
Usn's IT Blog for Linux, Oracle, Asterisk
http://www.usn-it.de
--
http://www.freelists.org/webpage/oracle-l
Other related posts: