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: Chuck <skilover_nospam_at_bluebottle.com>
Date: Mon, 15 Oct 2007 19:36:55 GMT
Message-ID: <rjPQi.727$H92.394@trnddc07>


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? Received on Mon Oct 15 2007 - 14:36:55 CDT

Original text of this message

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