On Oct 10, 11:02 am, Jagjeet Singh <jagjeet.ma..._at_gmail.com> wrote:
> I have not tested this but it seems this will not return the result
> partitioned tables/indexes
>
> First - You are joining dba_Segment.segment_Type = v$access.type. For
> partitioned tables/indexes
> dba_Segment.segment_Type is "TABLE PARTITIONED" ....
>
> Second - Even if you fix this in join like "segment_Type like v
> $access.type%.." but still it would
> give you all the tablespaces where your partition are lying
> because in v$access table
> it would show you just Segment_name not directly partition
> name
>
> like the query "Delete from Tab_X Partition (p1)" would be
> actually accessing the tablespace
> where it is lying but it would show you all the partitions
> tablespaces.
>
> Regards,
> Jagjeet Singh
I do not have a system in front of me to test with but doesn't v
$access only show objects that have DML activity against the objects?
A table that appears in a select is in use so the tablespace that
houses the object whould also be in use. I do not think that the
query in question will show all active tablespace usage.
Received on Wed Oct 10 2007 - 10:51:43 CDT
