Segment Advisor Recommendation : OEM
Hi,
SelectTablespaceRecommendationsTablespace Size (MB)Evaluated Space (%)Reclaimable Space (MB)Extent ManagementSegment Space ManagementAPPS_TS_TX_IDX1114,170.122.47131.02LOCALAUTOAPPS_TS_SEED53,038.005.5575.33LOCALAUTOAPPS_TS_TX_DATA117,401.620.5864.59LOCALAUTOAPPS_TS_ARCHIVE2800.004.0627.29LOCALAUTOAPPS_TS_QUEUES1863.003.0722.02LOCALAUTOXXWPPRODTS1600.009.5013.33LOCALAUTO
SelectTablespaceRecommendationsTablespace Size (MB)Evaluated Space (%)Reclaimable Space (MB)Extent ManagementSegment Space ManagementAPPS_TS_TX_IDX1114,170.122.47131.02LOCALAUTOAPPS_TS_SEED53,038.005.5575.33LOCALAUTOAPPS_TS_TX_DATA117,401.620.5864.59LOCALAUTOAPPS_TS_ARCHIVE2800.004.0627.29LOCALAUTOAPPS_TS_QUEUES1863.003.0722.02LOCALAUTOXXWPPRODTS1600.009.5013.33LOCALAUTO
SelectSchemaSegmentRecommendationReclaimable Space (MB)Allocated Space (MB)Used Space (MB)Segment TypeAPPLSYSWF_ITEM_ACTIVITY_STATUSES_N115.3038.3323.03INDEXAPPLSYSWF_ITEM_ACTIVITY_STATUSES_PK13.1128.5015.39INDEXHRPAY_RUN_RESULTS_N5012.6232.3819.77INDEXPAPA_EXPENDITURE_ITEMS_N912.4933.3320.85INDEXPAPA_EXPENDITURE_ITEMS_N1812.3332.2719.94INDEXAPPLSYSAD_PATCH_RUN_BUG_ACTIONS_N112.1637.2525.09INDEXAPPLSYSAD_SNAPSHOT_BUGFIXES_N110.9430.8819.94INDEXXLAXLA_AE_HEADERS_N3.PA10.9127.2516.34INDEX PARTITIONPAPA_EXPENDITURE_ITEMS_N2210.8233.0622.24INDEXXLAXLA_TRANSACTION_ENTITIES_N1.CST
0