Re: Oracle 10g = bloatware?

From: Matthias Hoys <matthias.hoys_at_gmail.com>
Date: Fri, 13 Apr 2012 01:19:33 -0700 (PDT)
Message-ID: <18247968.1214.1334305173490.JavaMail.geo-discussion-forums_at_vbhy1>

On Thursday, April 12, 2012 8:28:16 PM UTC+2, Mladen Gogala wrote:
>
> Both 900MB and 200MB seem like an enormous allocation for 6800 records.
>
>

I did some more research on this; the table itself is only 10MB. It's the "SYS_LOB0000050125C00017$$" segment which has all the air (the table has a BLOB column which stores uploaded images and scripts and such).

select segment_name,sum(bytes)/1024/1024 MB from dba_extents where owner = 'FLOWS_FILES' group by segment_name order by 2 asc;

WWV_FLOW_FILE_OBJ_PK
SEGMENT_NAME,MB

WWV_FLOW_FILE_OBJ_PK,0.3125
WWV_FLOW_FILES_USER_IDX,0.375
SYS_C004982,0.5
WWV_FLOW_FILES_FILE_IDX,0.5625
SYS_IL0000050125C00017$$,3
WWV_FLOW_FILE_OBJECTS$,10
SYS_LOB0000050125C00017$$,931

Matthias Received on Fri Apr 13 2012 - 03:19:33 CDT