Re: SQL History in Statspack: Parsing schema?
Date: Sun, 21 Jun 2009 20:07:40 -0700 (PDT)
Unfortunately, Statspack tables don't record parsing_schema_xxx columns. If the SQL is run not too infrequently, you may find it in v$sql so you get the parsing schema there. Otherwise, if you have license, views like DBA_HIST_SQLSTAT and WRH$_SQLSTAT have that column as well.
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
> Thanks a lot in advance!