Re: Query for active tablespaces

On Oct 15, 2:36 pm, Chuck <skilover_nos..._at_bluebottle.com> wrote:
> EdStevens wrote:
> > 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.
>
> I am the OP. It's not useless to me. If the info were useless why would
> there be a v$access view to start with?

Well, I did say "*IF* I understand what (you) wanted...". ;-)

So, how useful is it to know of an object is being accessed NOW if the answer changed 3ms before your query hit the server, and again 3ms after ... ? Received on Tue Oct 16 2007 - 07:35:19 CDT