Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Query for active tablespaces
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
![]() |
![]() |