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: Wed, 17 Oct 2007 15:18:25 GMT
Message-ID: <5JpRi.4817$GR1.150@trnddc08>


DA Morgan wrote:

> Chuck 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.
>
> What about the output of OEM Grid is insufficient for your purposes?

I must not be familiar with that page. Are you saying there is a page for active objects? Is it by chance only available on 10g targets? Most of my databases or still on 9iR2. Received on Wed Oct 17 2007 - 10:18:25 CDT

Original text of this message

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