Hi,
I have partition table with lob segment. Below query is not giving valid size the partition . its not calculating log segments
SELECT owner, segment_name, segment_type, partition_name, ROUND(bytes/(1024*1024),2) SIZE_MB, tablespace_name
FROM DBA_SEGMENTS
WHERE SEGMENT_TYPE IN ('TABLE', 'TABLE PARTITION', 'TABLE SUBPARTITION',
'INDEX', 'INDEX PARTITION', 'INDEX SUBPARTITION', 'TEMPORARY', 'LOBINDEX', 'LOBSEGMENT', 'LOB PARTITION')
AND SEGMENT_NAME LIKE 'TEST'
ORDER BY bytes DESC;
OWNER SEGMENT_NAME SEGMENT_TYPE PARTITION_NAME SIZE_MB TABLESPACE_NAME
--------------------- --------------- ------------------ ------------------------------ ---------- ------------------------------
SCOTT TEST TABLE PARTITION T1 528 USERS
SCOTT TEST TABLE PARTITION T3 504 USERS
SCOTT TEST TABLE PARTITION T2 432 USERS
SCOTT TEST TABLE PARTITION T4 397 USERS
actual table size (120G).
How to check each partition size in the partition table with lob objects?
thanks,