Offload Efficiency

Database Space Reconciliation

Candidate Advisor Data

OFFLOAD	RETAIN
12,000.24 GB	591.25 GB
95.31%	4.69%

Volume: 12,591.49 GB

Table Classification Summary

Partial Offload
Candidates

3

OFFLOAD	11,958.95 GB
RETAIN	508.48 GB

Full Offload
Candidates

103

OFFLOAD	41.29 GB
RETAIN	0.00 GB

Unable
to Offload

5

OFFLOAD	0.00 GB
RETAIN	82.73 GB

Not
Supported

12

OFFLOAD	0.00 GB
RETAIN	0.05 GB

Unable
to Analyze

0

OFFLOAD	0.00 GB
RETAIN	0.00 GB

Table Classification Detail

Shows the table-level breakdown for each of the Table Classification Summary categories.

The information in each of the categories is grouped by schema. The collapsed schema-level shows the number of tables, together with offload and/or retention volumes. The Partial Offload Candidates section also shows the offload efficiency (calculated as the percentage of the total volume that can be offloaded).

Each schema can be expanded by clicking on the icon. This reveals the table-level results for the schema.

Each expanded schema section has Search, Filter and Sort capabilities.

To Search, begin typing in the search field and dynamic filtering will be applied as you type.

To Filter, enter a lower threshold figure for Offload or Retained GB and click Go. Tables below this figure will be filtered out. Click Reset to clear the filter.

To Sort, click on the icon in the column header you wish to sort by. Click again to reverse the sort direction. The results are initially sorted by Offload or Retained GB in descending order.

Partial Offload Candidates

For each partitioned table in this list, the Advisor has worked sequentially through each partition starting with the first partition. For each partition, historical segment modification data has been mined from AWR to determine the lowest partition with total block modifications greater than 100000 over the last 7 days.

If the Advisor has detected block modifications above the threshold at partition n, partition n - 1 will be marked as the last partition that could be offloaded. This is known as the Partition High Water Mark (HWM) and is the partition name shown in the Partition Name (HWM) column.

All partitions up to and including the Partition High Water Mark will be recommended for offload by the Advisor. The number and volume of those partitions is shown in the Offload Partitions and Offload GB columns, respectively.

Any partition above the Partition High Water Mark cannot be recommended for offload by the Advisor and will therefore be reported as retained. The number and volume of these partitions is shown in the Retained Partitions and Retained GB columns, respectively.

If this execution of the Advisor was invoked with the --include-ash parameter then clicking on the icon reveals a popup window detailing the top sessions from Active Session History that have accessed the first partition with block modifications above the threshold (partition n). The purpose of this section is to highlight potential causes of those block modifications. Hovering over SQL ID for a row will reveal the SQL Text. Hovering over Last Seen will reveal the earliest and latest sample times recorded in ASH for that row.

If a partitioned table is in this category because it has either a MAXVALUE or DEFAULT partition, this will be indicated by an icon. Hovering over this icon will reveal the name of the MAXVALUE or DEFAULT partition.

Full Offload Candidates

For each table in this list, the Advisor has mined historical segment modification data from AWR and has not detected total block modifications greater than 100000 over the last 7 days.

For partitioned tables (of any partitioning type) this will be true for all (sub)partitions of that table.

For non-partitioned tables, modifications are aggregated at the table level. For subpartitioned tables, modifications are aggregated at the subpartition level, otherwise they are aggregated at partition level.

Unable to Offload

For each table in this list, the Advisor has mined historical segment modification data from AWR and has detected total block modifications greater than 100000 over the last 7 days.

For a RANGE-partitioned table that is partitioned on a column of DATE, NUMBER or TIMESTAMP, this will be true for the first partition.

For any other type of partitioned table this will be true for any partition.

Not Supported

For each table in this list, the Advisor has detected that the table is not supported for offloading, due to one of the Unsupported Reason types detailed below.

Unsupported Reason	Further Information
Secondary Table	Secondary tables are created to support user-defined indexes and are not supported for offload.
Nested Table	Nested tables are secondary objects that are not currently supported for offload. Tables containing nested table columns will be listed as unsupported under the Table Column Type category.
Materialized View	Materialized views are not currently supported for offload.
Table Column Type	Tables with columns of data types that are not in the following list are not supported for offload: `VARCHAR2, NVARCHAR2, CHAR, NCHAR, NUMBER, FLOAT, BINARY_DOUBLE, BINARY_FLOAT, DATE, TIMESTAMP, INTERVAL DAY TO SECOND, INTERVAL YEAR TO MONTH, RAW, CLOB, BLOB`.
Deferred Segment Creation	Tables without segments have no data and are therefore not candidates for offload.
IOT Overflow	Overflow segments for Index-Organized Tables (IOTs) are secondary objects and cannot be offloaded independently. Master IOTs can be offloaded and the space consumption of any overflow segments will be accounted for in the corresponding master IOTs' reported offload efficiency figures.
Table In Cluster	Clustered tables are not supported for offload because their space cannot be independently reclaimed or calculated.

Partial Offload Candidates

The following schemas contain range-partitioned tables that can be partially offloaded

GEO_DATAWHS

TABLES 3

OFFLOAD 11,958.95 GB

RETAIN 508.48 GB

EFFICIENCY 95.92 %

Table Name	Partition Name (HWM)	Offload Partitions	Offload GB	Retained Partitions	Retained GB	Offload Percent
AFRICAN_WEST_FULL	AF_WE_201612	174	3,594.10	36	158.03	95.79
SWEDEN_NORTHEAST_FULL	SW_NE_201701	174	6,372.95	36	274.12	95.88
FINLAND_SOUTHEAST_FULL	FI_SE_201702	176	1,991.89	29	76.33	96.31

Full Offload Candidates

The following schemas contain tables that can be fully offloaded

GEO_DATAWHS

TABLES 103

OFFLOAD 41.29 GB

Table Name	Partition Type	Offload GB	Offload Percent
COLUMBIA_NORTH_SEP	None	0.00	100.00
CHINA_NORTHWEST_JAN	None	0.00	100.00
CHILEAN_NORTH_Q1	None	0.00	100.00
RUSSIA_NORTH_FEB	None	0.00	100.00
NOVA_WEST_Q3	None	0.00	100.00
HUNGARY_SOUTHEAST_JUN	None	0.00	100.00
MEXICO_SOUTHWEST_Q3	None	0.00	100.00
MEXICO_SOUTHWEST_Q1	None	0.00	100.00
FRANCE_SOUTHWEST_Q1	None	0.00	100.00
AFRICA_NORTH_Q1	None	0.00	100.00
SCOTLAND_SOUTH_APR	None	0.00	100.00
EUROPE_SOUTHEAST_Q1	None	0.00	100.00
CHINA_SOUTHEAST_Q1	None	0.00	100.00
TAIWAN_EAST_JUL	None	0.00	100.00
BANGLADESH_NORTHEAST_Q1	None	0.00	100.00
NIGERIA_SOUTHEAST_AUG	None	0.00	100.00
ZEALAND_SOUTHWEST_MAY	None	0.00	100.00
BANGLADESH_SOUTHEAST_MAY	None	0.00	100.00
CHILEAN_NORTH_Q4	None	0.00	100.00
AUSTRIA_SOUTHEAST_Q3	None	0.00	100.00
ITALY_EAST_JUL	None	0.00	100.00
TAIWAN_SOUTHWEST_Q4	None	0.00	100.00
ARGENTINA_SOUTHEAST_MAY	None	0.00	100.00
CHILEAN_EAST_DEC	None	0.00	100.00
BERMUDA_SOUTHEAST_JUN	None	0.00	100.00
PORTUGAL_SOUTH_FEB	None	0.00	100.00
ARGENTINA_SOUTHEAST_APR	None	0.00	100.00
ARGENTINA_NORTHWEST_Q4	None	0.00	100.00
LATIN_WEST_Q3	None	0.00	100.00
SWISS_SOUTH_DEC	None	0.00	100.00
SPAIN_NORTHWEST_SEP	None	0.00	100.00
EUROPE_NORTHWEST_Q4	None	0.00	100.00
CHINA_SOUTHWEST_JUN	None	0.00	100.00
TURKEY_SOUTH_DEC	None	0.00	100.00
CHINA_SOUTHEAST_Q1	None	0.00	100.00
ASIA_NORTHWEST_Q2	None	0.00	100.00
CHINA_WEST_MAR	None	0.00	100.00
BRAZILIAN_NORTHEAST_JUL	None	0.00	100.00
THAILAND_NORTH_DEC	None	0.00	100.00
MALAYSIA_NORTH_SEP	None	0.00	100.00
AFRICAN_EAST_JUL	None	0.00	100.00
LATIN_SOUTHEAST_OCT	None	0.00	100.00
MALAYSIA_NORTH_NOV	None	0.00	100.00
CHILE_SOUTHEAST_AUG	None	0.00	100.00
AUSTRIA_SOUTHEAST_JAN	None	0.00	100.00
USA_SOUTH_JUL	None	0.00	100.00
EUROPE_EAST_JUN	None	0.00	100.00
MEXICAN_SOUTH_Q4	None	0.00	100.00
VIETNAM_SOUTHEAST_FEB	None	0.00	100.00
JAPAN_NORTHEAST_JUN	None	0.00	100.00
EUROPE_SOUTHWEST_JUL	None	0.00	100.00
SCOTLAND_SOUTH_APR	None	0.00	100.00
USA_EAST_NOV	None	0.00	100.00
HUNGARY_NORTHEAST_Q3	None	0.00	100.00
INDIA_SOUTHWEST_DEC	None	0.00	100.00
FRANCE_NORTH_DEC	None	0.00	100.00
ARGENTINA_NORTHEAST_DEC	None	0.00	100.00
SUISSE_NORTHEAST_Q3	None	0.00	100.00
RUSSIA_NORTHWEST_JUL	None	0.00	100.00
COSTA_WEST_MAY	None	0.00	100.00
ARGENTINA_SOUTH_AUG	None	0.00	100.00
ITALIAN_WEST_MAY	None	0.00	100.00
RICA_NORTHWEST_Q2	None	0.16	100.00
RICA_NORTH_FEB	None	0.41	100.00
USA_SOUTHWEST_Q4	None	0.05	100.00
SCOTIA_NORTHWEST_SEP	None	0.04	100.00
ARGENTINA_WEST_MAR	None	0.00	100.00
USA_SOUTHEAST_JUN	None	0.00	100.00
JAPAN_WEST_SEP	None	0.00	100.00
INDONESIA_SOUTHEAST_DEC	None	0.00	100.00
SPAIN_NORTHWEST_MAR	None	0.00	100.00
ARGENTINA_SOUTHEAST_JAN	None	0.00	100.00
SWITZERLAND_SOUTHWEST_FEB	None	0.01	100.00
JAPAN_NORTHWEST_APR	None	0.00	100.00
CHILEAN_SOUTHEAST_JUN	None	0.00	100.00
CHINESE_SOUTH_Q1	None	0.01	100.00
SCOTLAND_SOUTHEAST_DEC	None	0.00	100.00
INDONESIA_NORTH_JUL	RANGE	0.02	100.00
PUERTO_NORTHWEST_MAR	RANGE	0.02	100.00
SWITZERLAND_NORTHWEST_Q4	None	0.02	100.00
FRANCE_NORTH_Q4	RANGE	0.02	100.00
ZEALAND_SOUTHWEST_AUG	None	0.01	100.00
SWISS_WEST_Q3	None	0.00	100.00
PUERTO_WEST_NOV	RANGE	0.02	100.00
ZEALAND_SOUTHWEST_SEP	RANGE	0.01	100.00
EUROPEAN_NORTH_OCT	None	0.00	100.00
TAIWAN_SOUTHWEST_FEB	None	0.44	100.00
SUISSE_SOUTHWEST_OCT	RANGE	0.02	100.00
ITALY_EAST_NOV	None	0.00	100.00
ITALIAN_NORTHEAST_JUN	None	0.00	100.00
ITALY_SOUTHWEST_DEC	None	0.00	100.00
VENEZUELA_SOUTH_Q1	None	0.00	100.00
AUSTRIA_NORTHEAST_Q1	RANGE	5.27	100.00
BELGIUM_EAST_FEB	None	0.00	100.00
INDONESIA_SOUTHEAST_JUN	None	0.00	100.00
DENMARK_EAST_DEC	None	0.07	100.00
EUROPEAN_SOUTHEAST_Q4	None	0.00	100.00
CANADIAN_NORTHEAST_JUN	None	0.00	100.00
ARGENTINA_NORTH_SEP	RANGE	34.47	100.00
PHILIPPINES_SOUTHWEST_FEB	None	0.00	100.00
AFRICAN_SOUTHWEST_Q4	None	0.19	100.00
ITALIAN_WEST_Q3	None	0.00	100.00
AUSTRIA_SOUTHWEST_AUG	None	0.00	100.00

No Offload (Modified Tables)

The following schemas contain tables that should not be offloaded

GEO_DATAWHS

TABLES 5

RETAIN 82.73 GB

Table Name	Partition Type	Retained GB
AUSTRIA_SOUTHWEST_FEB	None	1.09
BRAZIL_WEST_MAY	None	0.12
POLAND_NORTH_Q4	None	2.67
PORTUGAL_SOUTHWEST_SEP	None	0.24
JAPAN_SOUTHWEST_DEC	RANGE	78.60

No Offload (Unsupported Tables)

The following schemas contain tables that are not supported for offload

GEO_DATAWHS

TABLES 12

RETAIN 0.05 GB

Table Name	Partition Type	Unsupported Reason	Retained GB
BANGLADESH_SOUTHEAST_Q2	None	Materialized View	0.00
CANADIAN_SOUTHWEST_JUN	None	Materialized View	0.00
RICA_SOUTHWEST_JUL	None	Materialized View	0.00
CHILE_SOUTHWEST_JUN	None	Materialized View	0.00
VIETNAM_NORTHWEST_MAR	None	Materialized View	0.00
INDONESIA_NORTHWEST_Q2	None	Materialized View	0.00
ASIA_SOUTH_SEP	None	Materialized View	0.00
SWITZERLAND_NORTHWEST_FEB	None	Materialized View	0.01
RUSSIA_SOUTHEAST_SEP	None	Materialized View	0.02
KOREA_EAST_Q3	None	Materialized View	0.01
INDONESIA_SOUTHEAST_Q4	None	Materialized View	0.00
GERMANY_SOUTHEAST_AUG	None	Table Column Type [LONG]	0.00

--commands	:	FALSE
--days	:	7
--log_level	:	INFO
--max_block_changes	:	100000
--output	:	HTML
--schema	:	GEO_DATAWHS
--show_rec	:	TRUE
--table	:	NONE

Candidate Data	Data that can be analyzed by the Gluent Offload Advisor.
Temporary/Undo Space	Data in temporary and undo tablespaces cannot be offloaded and is excluded from analysis.
Free Space	Unallocated space in datafiles belonging to permanent tablespaces (calculation excludes temporary/undo tablespaces).
Excluded Schemas	Default or supplied Oracle schemas (e.g. `SYS`, `SYSTEM`) are excluded from Advisor analysis. The Excluded Schemas calculation excludes SYS-owned UNDO segments (accounted for under Temporary/Undo Space) but includes SYS-owned ROLLBACK segments (typically stored in SYSTEM tablespace) and excludes recyclebin objects (accounted for under Free Space).
Other	Space that cannot be analyzed (such as headers in permanent tablespaces) or objects that are either currently or permanently out-of-scope for Advisor analysis, including IOTs, LOBs, Global Indexes, Clusters and Advisor repository tables (`GLUENT_ADV_%`). If this execution of the Advisor was invoked at the Schema or Table level, Other will also contain objects in the remaining in-scope schemas.

Invocation Options

Storage and Compute Cost Savings

You must enter valid numbers only

Offload GB

Potential Gluent Cost Savings

Offload Efficiency

Database Space Reconciliation

Candidate Advisor Data

Table Classification Summary

Partial Offload
Candidates

3

Full Offload
Candidates

103

Unable
to Offload

5

Not
Supported

12

Unable
to Analyze

0

Table Classification Detail

Partial Offload Candidates

Full Offload Candidates

No Offload (Modified Tables)

No Offload (Unsupported Tables)

Invocation Options

Storage and Compute Cost Savings

You must enter valid numbers only

Offload GB

Potential Gluent Cost Savings

Offload Efficiency

Database Space Reconciliation

Candidate Advisor Data

Table Classification Summary

Partial OffloadCandidates

3

Full OffloadCandidates

103

Unable to Offload

5

Not Supported

12

Unable to Analyze

0

Table Classification Detail

Partial Offload Candidates

Full Offload Candidates

No Offload (Modified Tables)

No Offload (Unsupported Tables)

Partial Offload
Candidates

Full Offload
Candidates

Unable
to Offload

Not
Supported

Unable
to Analyze