Objects for queries.

From: Mark Malakanov <markmal_at_sprint.ca>
Date: Sun, 5 Sep 1999 10:39:04 -0300
Message-ID: <UevA3.5563$qY3.213260@newscontent-01.sprint.ca>

Hi all.

There is static view V$SQLAREA where the recent users queries are stored. But where are stored the objects(tables,indexes,clusters) used in above queries.

I know the command EXPLAIN PLAN is available, but I would like to get the objects of query without inserts into PLAN_TABLE.

I know Oracle has the parse trees in the SGA shared pool. What name of static table/view to see it?

Thanks in advance,
Mark Received on Sun Sep 05 1999 - 08:39:04 CDT