Xref: alice comp.databases.oracle.server:65163
Path: alice!news-feed.fnsi.net!newspump.monmouth.com!newspeer.monmouth.com!news.maxwell.syr.edu!u-2.maxwell.syr.edu!east1.newsfeed.sprint-canada.net!HME1-2.newsfeed.sprint.ca!newscontent-01.sprint.ca.POSTED!not-for-mail
From: "Mark Malakanov" <markmal@sprint.ca>
Newsgroups: comp.databases.oracle.server
References: <UevA3.5563$qY3.213260@newscontent-01.sprint.ca> <936569230.6719.0.pluto.d4ee154e@news.demon.nl>
Subject: Re: Objects for queries.
Lines: 40
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <QVSB3.9844$qY3.419970@newscontent-01.sprint.ca>
Date: Thu, 9 Sep 1999 14:24:04 -0300
X-Complaints-To: abuse@sprint.ca
X-Trace: newscontent-01.sprint.ca 936901360 209.148.138.43 (Thu, 09 Sep 1999 14:22:40 EDT)
NNTP-Posting-Date: Thu, 09 Sep 1999 14:22:40 EDT
Organization: Sprint Canada Inc.

Hi,

There are no indexes in V$ACCESS.

Mark

Sybrand Bakker <postmaster@sybrandb.demon.nl> wrote in message
news:936569230.6719.0.pluto.d4ee154e@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@sprint.ca> wrote in message
> news: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
> >
> >
>
>