Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Query for active tablespaces

Re: Query for active tablespaces

From: EdStevens <quetico_man_at_yahoo.com>
Date: Mon, 15 Oct 2007 12:27:45 -0700
Message-ID: <1192476465.689768.228430@e34g2000pro.googlegroups.com>


On Oct 15, 12:24 pm, Chuck <skilover_nos..._at_bluebottle.com> wrote:
> Jagjeet Singh wrote:
> > Thanks Tamkatten for the clarification.
>
> > When I said this can show the objects for select also. I meant if the
> > object is being accessed NOW
> > then you can see this in v$access which holds still true.
>
> I guess nobody already has the query written then.

If I understand what the OP wanted, I would think such a query would be pretty much useless, even/especially if it were accurate. He wants to know what is being accessed NOW, but NOW is pretty fleeting. Received on Mon Oct 15 2007 - 14:27:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US