SQL History in Statspack: Parsing schema?

From: Martin Klier <usn_at_usn-it.de>
Date: Fri, 19 Jun 2009 10:33:37 +0200
Message-ID: <4A3B4D61.2020905_at_usn-it.de>

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 Received on Fri Jun 19 2009 - 03:33:37 CDT

This message: [ Message body ]
Next message: Saibabu Devabhaktuni: "RE: How to make a session active with wait event of 'sql*net message FROM client'?"
Previous message: Saibabu Devabhaktuni: "RE: Monitoring CBO degrading Switches in xplans?"
Next in thread: Yong Huang: "Re: SQL History in Statspack: Parsing schema?"
Maybe reply: Yong Huang: "Re: SQL History in Statspack: Parsing schema?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message