Storage Management (ASM ACFS DNFS ODM) (MOSC)

MOSC Banner

Table partitioning difference between environments

Hello All

I am trying to figure out why the difference in space utilization between environments with the same table and partitioning 

Development : PDB ASM 19c

17G / 3 million + records

Stage: Standalone ASM 19c

12.4G / 33k rows

----did some segment adviser tasks found no wasted space

Production : Standalone File system 12c

18G / 33K records

----did some segment adviser tasks and now 

Production : 6.53G / 33K records


select count(*) from dba_tab_PARTITIONs where table_name='ORDER_SEARCH'

1594

DBMS_METADATA.get_ddl 

CREATE TABLE "SCHEMA"."ORDER_SEARCH" 

  ( "DO_SEARCH_SEQ_ID" NUMBER GENERATED ALWAYS AS IDENTITY MINVALUE 1 MAXVALUE

 9999999999999999999999999999 INCREMENT BY 1 START WITH 33001 CACHE 20 NOORDER  

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center