Re: SQL History in Statspack: Parsing schema?

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.

Yong Huang

-----Original message-----

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!
      

--
http://www.freelists.org/webpage/oracle-l