Re: Objects for queries.

Hi,

There are no indexes in V$ACCESS.

Mark

Sybrand Bakker <postmaster_at_sybrandb.demon.nl> wrote in message news:936569230.6719.0.pluto.d4ee154e_at_news.demon.nl...
> To see which objects are accessed use the v$access view.
> To view the definition of those objects use dba_objects, dba_tables,
> dba_indexes and so on.
>
> Hth,
>
> --
> Sybrand Bakker, Oracle DBA
> Mark Malakanov <markmal_at_sprint.ca> wrote in message
> news:UevA3.5563$qY3.213260_at_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 Thu Sep 09 1999 - 12:24:04 CDT