Performance - EBS (MOSC)

MOSC Banner

Resize the OE_ORDER_LINES_ALL table

edited Feb 2, 2012 10:14PM in Performance - EBS (MOSC) 2 commentsAnswered
I have check the allocation Size vs Actual Size, I think the shrink space should release 4G space but after I alter the table the sql result is same.Did I miss something? Thanks in advance

select table_name,round((blocks*8),2)/1024/1024||'G' "Allocate Size"
,round((num_rows*avg_row_len/1024),2)/1024/1024||'G' "Actual Size"
from all_tables
where 1=1
and table_name in ('OE_ORDER_LINES_ALL','AR_RECEIVABLE_APPLICATIONS_ALL','AP_INVOICES_ALL','OE_ORDER_HEADERS_ALL')
--and tablespace_name = 'APPS_TS_TX_DATA'
and round((blocks*8),2)/1024/1024 >1;

TABLE_NAME                    Allocate Size    Actual Size
OE_ORDER_LINES_ALL    7.756 G              2.733G

alter table ont.oe_order_lines_all enable row movement;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Performance Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center