Re: SQL History in Statspack: Parsing schema?

From: Yong Huang <>
Date: Sun, 21 Jun 2009 20:07:40 -0700 (PDT)
Message-ID: <>

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!

Received on Sun Jun 21 2009 - 22:07:40 CDT

Original text of this message