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 Â