Sunday, June 15, 2014

Oracle Segment Adviser Recommendations and Redo/Undo Generation During Segment Shrink

Since Oracle 10g, Oracle provided facility to reclaim the unused space from Tables and Indexes by using"ALTER TABLE <TABLE_NAME> SHRINK SPACE | COMPACT"  command.
Before we go through details of Oracle Segment Adviser Recommendations, it should be noted that during shrink space operation, a lot of undo and redo data is generated. As per my experience, I was shrinking a 19G table which had 3.3 G of reclaimable space and the redo it generated was above 52G. MOS note 577375.1 says that table shrinking is done by delete/insert pair of every row movement and hence generates the redo. It also points to a bug 3888229 which was closed as NOT A BUG but, as expected behaviour

Segment Advisor
Oracle Segment Advisor runs automatically during daily and weekly maintenance windows to give you recommendations for the segments which can be shrunk for reclaiming unused space.
OEM (Cloud Control, Grid Control, Database Control) is the easiest way to look at the recommendations and implementing them. If OEM is not available, data dictionary views could be used to see the details of recommendations and their implementation.

In the following, you would see how information is extracted from data dictionary views for Segment Advisor tasks.

Findout Segment Advisor Tasks

set lines 200
set pages 1000
col message format a60
alter session set nls_date_format='DD-MON-YY HH24:MI:SS';
select TASK_NAME,EXECUTION_START,EXECUTION_END,status from DBA_ADVISOR_TASKS where task_name like '%AUTO%'order by EXECUTION_END ;

TASK_NAME                      EXECUTION_START    EXECUTION_END      STATUS
------------------------------ ------------------ ------------------ -----------
SYS_AUTO_SPCADV_190221362014   14-JUN-14 06:00:21 14-JUN-14 06:31:52 COMPLETED

Findout Findings, Recommendations and Actions (to implement recommendations) of this Tasks

Either you should use slqdeveloper or some other GUI tool for the following queries, or use html output spool from sqlplus.

set markup html on
spool segment_advisor.html

select owner,message,more_info from DBA_ADVISOR_FINDINGS where task_name='SYS_AUTO_SPCADV_190221362014';

select benefit_type from DBA_ADVISOR_RECOMMENDATIONS where task_name='SYS_AUTO_SPCADV_190221362014';

select command,attr1,attr2,attr3 from DBA_ADVISOR_ACTIONS where TASK_NAME='SYS_AUTO_SPCADV_190221362014';

In above statement, attr1 column shows the command for SHRINK SPACE COMPACT, attr2 column shows the command SHRINK SPACE, and attr3 shows the command ENABLE ROW MOVEMENT (For tables, and only for the tables which don't have row movement enabled).

Following is an html output example.


SQL> select owner,message,more_info from DBA_ADVISOR_FINDINGS where task_name='SYS_AUTO_SPCADV_190221362014';


OWNER

MESSAGE

MORE_INFO

SYS

Perform shrink, estimated savings is 152515307 bytes.

Allocated Space:6888827713: Used Space:6736312406: Reclaimable Space :152515307:

SYS

Perform shrink, estimated savings is 338077372 bytes.

Allocated Space:3965640175: Used Space:3627562803: Reclaimable Space :338077372:

SYS

Perform shrink, estimated savings is 972566831 bytes.

Allocated Space:7491616504: Used Space:6519049673: Reclaimable Space :972566831:

SYS

Enable row movement of the table LOCATION_ACTIVITY_DB.MENU_ITEM_FIXED_PERIOD_TOTAL and perform shrink, estimated savings is 7174778795 bytes.

Allocated Space:28587327488: Used Space:21412548693: Reclaimable Space :7174778795:

SYS

Perform shrink, estimated savings is 1695011163 bytes.

Allocated Space:3667262590: Used Space:1972251427: Reclaimable Space :1695011163:

SYS

Perform shrink, estimated savings is 26915027 bytes.

Allocated Space:272817251: Used Space:245902224: Reclaimable Space :26915027:

SYS

Perform shrink, estimated savings is 186165922 bytes.

Allocated Space:569549857: Used Space:383383935: Reclaimable Space :186165922:

SYS

Perform shrink, estimated savings is 3805087976 bytes.

Allocated Space:20801650688: Used Space:16996562712: Reclaimable Space :3805087976:

SYS

Perform shrink, estimated savings is 6571518631 bytes.

Allocated Space:14791213056: Used Space:8219694425: Reclaimable Space :6571518631:

SYS

Enable row movement of the table LOCATION_ACTIVITY_DB.GUEST_CHECK_LINE_ITEM_HIST and perform shrink, estimated savings is 45914073940 bytes.

Allocated Space:236381536256: Used Space:190467462316: Reclaimable Space :45914073940:

SYS

Perform shrink, estimated savings is 369138267 bytes.

Allocated Space:571017546: Used Space:201879279: Reclaimable Space :369138267:

SYS

Perform shrink, estimated savings is 1605121139 bytes.

Allocated Space:4417690273: Used Space:2812569134: Reclaimable Space :1605121139:

SYS

Perform shrink, estimated savings is 1361873923 bytes.

Allocated Space:2797883788: Used Space:1436009865: Reclaimable Space :1361873923:

SYS

Perform shrink, estimated savings is 582892504 bytes.

Allocated Space:1954883915: Used Space:1371991411: Reclaimable Space :582892504:

SYS

Perform shrink, estimated savings is 415096816 bytes.

Allocated Space:1207959552: Used Space:792862736: Reclaimable Space :415096816:

SYS

Perform shrink, estimated savings is 18624540 bytes.

Allocated Space:873596896: Used Space:854972356: Reclaimable Space :18624540:

SYS

Perform shrink, estimated savings is 174072396 bytes.

Allocated Space:759759905: Used Space:585687509: Reclaimable Space :174072396:

SYS

Perform shrink, estimated savings is 13669512498 bytes.

Allocated Space:39972765696: Used Space:26303253198: Reclaimable Space :13669512498:

SYS

Perform shrink, estimated savings is 1608177008 bytes.

Allocated Space:6342095033: Used Space:4733918025: Reclaimable Space :1608177008:

SYS

Perform shrink, estimated savings is 1140415597 bytes.

Allocated Space:3118465024: Used Space:1978049427: Reclaimable Space :1140415597:

SYS

Perform shrink, estimated savings is 14403745 bytes.

Allocated Space:184580637: Used Space:170176892: Reclaimable Space :14403745:

SYS

Perform shrink, estimated savings is 37412954 bytes.

Allocated Space:48751120: Used Space:11338166: Reclaimable Space :37412954:

SYS

Perform shrink, estimated savings is 1579004278 bytes.

Allocated Space:2965183085: Used Space:1386178807: Reclaimable Space :1579004278:

SYS

Enable row movement of the table LOCATION_ACTIVITY_DB.CUSTOMER and perform shrink, estimated savings is 13698342 bytes.

Allocated Space:286132713: Used Space:272434371: Reclaimable Space :13698342:

SYS

Perform shrink, estimated savings is 4776212475 bytes.

Allocated Space:11581521920: Used Space:6805309445: Reclaimable Space :4776212475:

SYS

Perform shrink, estimated savings is 21775884 bytes.

Allocated Space:836745045: Used Space:814969161: Reclaimable Space :21775884:

SYS

Perform shrink, estimated savings is 83184156 bytes.

Allocated Space:142430869: Used Space:59246713: Reclaimable Space :83184156:

SYS

Perform shrink, estimated savings is 617476668 bytes.

Allocated Space:1880568733: Used Space:1263092065: Reclaimable Space :617476668:

SYS

Perform shrink, estimated savings is 1543292155 bytes.

Allocated Space:5368709120: Used Space:3825416965: Reclaimable Space :1543292155:

SYS

Perform shrink, estimated savings is 1616630802 bytes.

Allocated Space:6592115719: Used Space:4975484917: Reclaimable Space :1616630802:

SYS

Perform shrink, estimated savings is 22487826 bytes.

Allocated Space:42991616: Used Space:20503790: Reclaimable Space :22487826:

SYS

Perform shrink, estimated savings is 11368732116 bytes.

Allocated Space:34092351488: Used Space:22723619372: Reclaimable Space :11368732116:

SYS

Perform shrink, estimated savings is 6523514368 bytes.

Allocated Space:21847080960: Used Space:15323566592: Reclaimable Space :6523514368:

SYS

Perform shrink, estimated savings is 3630829978 bytes.

Allocated Space:12722198991: Used Space:9091369013: Reclaimable Space :3630829978:

SYS

Perform shrink, estimated savings is 2785864111 bytes.

Allocated Space:6525407047: Used Space:3739542936: Reclaimable Space :2785864111:

SYS

Perform shrink, estimated savings is 1548030343 bytes.

Allocated Space:6405624363: Used Space:4857594020: Reclaimable Space :1548030343:

SYS

Perform shrink, estimated savings is 1114855395 bytes.

Allocated Space:3290431488: Used Space:2175576093: Reclaimable Space :1114855395:

SYS

Perform shrink, estimated savings is 69896742 bytes.

Allocated Space:144500485: Used Space:74603743: Reclaimable Space :69896742:

SYS

Perform shrink, estimated savings is 29947353 bytes.

Allocated Space:100963207: Used Space:71015854: Reclaimable Space :29947353:

SYS

Enable row movement of the table LOCATION_ACTIVITY_DB.MENU_ITEM_DAILY_TOTAL_COM and perform shrink, estimated savings is 17011879 bytes.

Allocated Space:408362145: Used Space:391350266: Reclaimable Space :17011879:

SYS

Perform shrink, estimated savings is 138625040 bytes.

Allocated Space:528171253: Used Space:389546213: Reclaimable Space :138625040:

SYS

Perform shrink, estimated savings is 27682695 bytes.

Allocated Space:72188743: Used Space:44506048: Reclaimable Space :27682695:

SYS

Enable row movement of the table LOCATION_ACTIVITY_DB.MYFORECAST_DETAIL and perform shrink, estimated savings is 22250014 bytes.

Allocated Space:637534208: Used Space:615284194: Reclaimable Space :22250014:

SYS

Perform shrink, estimated savings is 2672724787 bytes.

Allocated Space:6951010304: Used Space:4278285517: Reclaimable Space :2672724787:

SYS

Perform shrink, estimated savings is 38011132 bytes.

Allocated Space:209098157: Used Space:171087025: Reclaimable Space :38011132:

SYS

Perform shrink, estimated savings is 1716505983 bytes.

Allocated Space:2922381312: Used Space:1205875329: Reclaimable Space :1716505983:

SYS

Perform shrink, estimated savings is 6904370274 bytes.

Allocated Space:23085449216: Used Space:16181078942: Reclaimable Space :6904370274:

SYS

Perform shrink, estimated savings is 478154588 bytes.

Allocated Space:2281701376: Used Space:1803546788: Reclaimable Space :478154588:

SYS

Perform shrink, estimated savings is 142287020 bytes.

Allocated Space:252452072: Used Space:110165052: Reclaimable Space :142287020:


49 rows selected.


SQL> select benefit_type from DBA_ADVISOR_RECOMMENDATIONS where task_name='SYS_AUTO_SPCADV_190221362014';


BENEFIT_TYPE

Perform shrink, estimated savings is 152515307 bytes.

Perform shrink, estimated savings is 338077372 bytes.

Perform shrink, estimated savings is 972566831 bytes.

Enable row movement of the table LOCATION_ACTIVITY_DB.MENU_ITEM_FIXED_PERIOD_TOTAL and perform shrink, estimated savings is 7174778795 bytes.

Perform shrink, estimated savings is 1695011163 bytes.

Perform shrink, estimated savings is 26915027 bytes.

Perform shrink, estimated savings is 186165922 bytes.

Perform shrink, estimated savings is 3805087976 bytes.

Perform shrink, estimated savings is 6571518631 bytes.

Enable row movement of the table LOCATION_ACTIVITY_DB.GUEST_CHECK_LINE_ITEM_HIST and perform shrink, estimated savings is 45914073940 bytes.

Perform shrink, estimated savings is 369138267 bytes.

Perform shrink, estimated savings is 1605121139 bytes.

Perform shrink, estimated savings is 1361873923 bytes.

Perform shrink, estimated savings is 582892504 bytes.

Perform shrink, estimated savings is 415096816 bytes.

Perform shrink, estimated savings is 18624540 bytes.

Perform shrink, estimated savings is 174072396 bytes.

Perform shrink, estimated savings is 13669512498 bytes.

Perform shrink, estimated savings is 1608177008 bytes.

Perform shrink, estimated savings is 1140415597 bytes.

Perform shrink, estimated savings is 14403745 bytes.

Perform shrink, estimated savings is 37412954 bytes.

Perform shrink, estimated savings is 1579004278 bytes.

Enable row movement of the table LOCATION_ACTIVITY_DB.CUSTOMER and perform shrink, estimated savings is 13698342 bytes.

Perform shrink, estimated savings is 4776212475 bytes.

Perform shrink, estimated savings is 21775884 bytes.

Perform shrink, estimated savings is 83184156 bytes.

Perform shrink, estimated savings is 617476668 bytes.

Perform shrink, estimated savings is 1543292155 bytes.

Perform shrink, estimated savings is 1616630802 bytes.

Perform shrink, estimated savings is 22487826 bytes.

Perform shrink, estimated savings is 11368732116 bytes.

Perform shrink, estimated savings is 6523514368 bytes.

Perform shrink, estimated savings is 3630829978 bytes.

Perform shrink, estimated savings is 2785864111 bytes.

Perform shrink, estimated savings is 1548030343 bytes.

Perform shrink, estimated savings is 1114855395 bytes.

Perform shrink, estimated savings is 69896742 bytes.

Perform shrink, estimated savings is 29947353 bytes.

Enable row movement of the table LOCATION_ACTIVITY_DB.MENU_ITEM_DAILY_TOTAL_COM and perform shrink, estimated savings is 17011879 bytes.

Perform shrink, estimated savings is 138625040 bytes.

Perform shrink, estimated savings is 27682695 bytes.

Enable row movement of the table LOCATION_ACTIVITY_DB.MYFORECAST_DETAIL and perform shrink, estimated savings is 22250014 bytes.

Perform shrink, estimated savings is 2672724787 bytes.

Perform shrink, estimated savings is 38011132 bytes.

Perform shrink, estimated savings is 1716505983 bytes.

Perform shrink, estimated savings is 6904370274 bytes.

Perform shrink, estimated savings is 478154588 bytes.

Perform shrink, estimated savings is 142287020 bytes.

49 rows selected.

SQL> select command,attr1,attr2,attr3 from DBA_ADVISOR_ACTIONS where TASK_NAME='SYS_AUTO_SPCADV_190221362014';


COMMAND

ATTR1

ATTR2

ATTR3

SHRINK SPACE

alter table "PORTALDB"."PORTAL_WEATHER" shrink space

alter table "PORTALDB"."PORTAL_WEATHER" shrink space COMPACT


SHRINK SPACE

alter table "LOCATION_ACTIVITY_DB"."KPI_JC_FIXED_PERIOD_TOTAL" shrink space

alter table "LOCATION_ACTIVITY_DB"."KPI_JC_FIXED_PERIOD_TOTAL" shrink space COMPACT


SHRINK SPACE

alter table "LOCATION_ACTIVITY_DB"."TRANSACTION_KEY" shrink space

alter table "LOCATION_ACTIVITY_DB"."TRANSACTION_KEY" shrink space COMPACT


SHRINK SPACE

alter table "LOCATION_ACTIVITY_DB"."MENU_ITEM_FIXED_PERIOD_TOTAL" shrink space

alter table "LOCATION_ACTIVITY_DB"."MENU_ITEM_FIXED_PERIOD_TOTAL" shrink space COMPACT

alter table "LOCATION_ACTIVITY_DB"."MENU_ITEM_FIXED_PERIOD_TOTAL" enable row movement

SHRINK SPACE

alter index "LOCATION_ACTIVITY_DB"."XPKTRANSACTION_KEY" shrink space

alter index "LOCATION_ACTIVITY_DB"."XPKTRANSACTION_KEY" shrink space COMPACT


SHRINK SPACE

alter table "LOCATION_ACTIVITY_DB"."MYFORECAST_DAY_PART_TOTAL" shrink space

alter table "LOCATION_ACTIVITY_DB"."MYFORECAST_DAY_PART_TOTAL" shrink space COMPACT


SHRINK SPACE

alter table "LOCATION_ACTIVITY_DB"."DELIVERY_DETAIL" shrink space

alter table "LOCATION_ACTIVITY_DB"."DELIVERY_DETAIL" shrink space COMPACT


SHRINK SPACE

alter table "LOCATION_ACTIVITY_DB"."GUEST_CHECK_HIST" shrink space

alter table "LOCATION_ACTIVITY_DB"."GUEST_CHECK_HIST" shrink space COMPACT


SHRINK SPACE

alter index "LOCATION_ACTIVITY_DB"."XTRMENU_ITEM_FP_TOTAL" shrink space

alter index "LOCATION_ACTIVITY_DB"."XTRMENU_ITEM_FP_TOTAL" shrink space COMPACT


SHRINK SPACE

alter table "LOCATION_ACTIVITY_DB"."GUEST_CHECK_LINE_ITEM_HIST" shrink space

alter table "LOCATION_ACTIVITY_DB"."GUEST_CHECK_LINE_ITEM_HIST" shrink space COMPACT

alter table "LOCATION_ACTIVITY_DB"."GUEST_CHECK_LINE_ITEM_HIST" enable row movement

SHRINK SPACE

alter table "LOCATION_ACTIVITY_DB"."GUEST_CHECK_LINE_ITEM" shrink space

alter table "LOCATION_ACTIVITY_DB"."GUEST_CHECK_LINE_ITEM" shrink space COMPACT


SHRINK SPACE

alter table "LOCATION_ACTIVITY_DB"."OPERATIONS_FIXED_PERIOD_TOTAL" shrink space

alter table "LOCATION_ACTIVITY_DB"."OPERATIONS_FIXED_PERIOD_TOTAL" shrink space COMPACT


SHRINK SPACE

alter table "LOCATION_ACTIVITY_DB"."JOB_CODE_FIXED_PERIOD_TOTAL" shrink space

alter table "LOCATION_ACTIVITY_DB"."JOB_CODE_FIXED_PERIOD_TOTAL" shrink space COMPACT


SHRINK SPACE

alter index "PORTALDB"."XN1PORTAL_WEATHER" shrink space

alter index "PORTALDB"."XN1PORTAL_WEATHER" shrink space COMPACT


SHRINK SPACE

alter index "PORTALDB"."XN2PORTAL_WEATHER" shrink space

alter index "PORTALDB"."XN2PORTAL_WEATHER" shrink space COMPACT


SHRINK SPACE

alter table "LOCATION_ACTIVITY_DB"."MENU_ITEM_PRICE" shrink space

alter table "LOCATION_ACTIVITY_DB"."MENU_ITEM_PRICE" shrink space COMPACT


SHRINK SPACE

alter table "LOCATION_ACTIVITY_DB"."NON_SALES_DETAIL" shrink space

alter table "LOCATION_ACTIVITY_DB"."NON_SALES_DETAIL" shrink space COMPACT


SHRINK SPACE

alter index "LOCATION_ACTIVITY_DB"."XN2GUEST_CHECK_LINE_ITEM_HIST" shrink space

alter index "LOCATION_ACTIVITY_DB"."XN2GUEST_CHECK_LINE_ITEM_HIST" shrink space COMPACT


SHRINK SPACE

alter table "LOCATION_ACTIVITY_DB"."LABOR_CATEGORY_FP_TOTAL" shrink space

alter table "LOCATION_ACTIVITY_DB"."LABOR_CATEGORY_FP_TOTAL" shrink space COMPACT


SHRINK SPACE

alter index "LOCATION_ACTIVITY_DB"."XN1GUEST_CHECK_HIST" shrink space

alter index "LOCATION_ACTIVITY_DB"."XN1GUEST_CHECK_HIST" shrink space COMPACT


SHRINK SPACE

alter table "LOCATION_ACTIVITY_DB"."MENU_ITEM" shrink space

alter table "LOCATION_ACTIVITY_DB"."MENU_ITEM" shrink space COMPACT


SHRINK SPACE

alter table "LOCATION_ACTIVITY_DB"."GUEST_CHECK" shrink space

alter table "LOCATION_ACTIVITY_DB"."GUEST_CHECK" shrink space COMPACT


SHRINK SPACE

alter index "LOCATION_ACTIVITY_DB"."XTRKPI_JC_FP_TOTAL" shrink space

alter index "LOCATION_ACTIVITY_DB"."XTRKPI_JC_FP_TOTAL" shrink space COMPACT


SHRINK SPACE

alter table "LOCATION_ACTIVITY_DB"."CUSTOMER" shrink space

alter table "LOCATION_ACTIVITY_DB"."CUSTOMER" shrink space COMPACT

alter table "LOCATION_ACTIVITY_DB"."CUSTOMER" enable row movement

SHRINK SPACE

alter index "LOCATION_ACTIVITY_DB"."XN1MENU_ITEM_FP_TOTAL" shrink space

alter index "LOCATION_ACTIVITY_DB"."XN1MENU_ITEM_FP_TOTAL" shrink space COMPACT


SHRINK SPACE

alter table "COREDB"."CORE_LOG" shrink space

alter table "COREDB"."CORE_LOG" shrink space COMPACT


SHRINK SPACE

alter index "LOCATION_ACTIVITY_DB"."XTRGUEST_CHECK_LINE_ITEM" shrink space

alter index "LOCATION_ACTIVITY_DB"."XTRGUEST_CHECK_LINE_ITEM" shrink space COMPACT


SHRINK SPACE

alter table "LOCATION_ACTIVITY_DB"."TENDER_MEDIA_FP_TOTAL" shrink space

alter table "LOCATION_ACTIVITY_DB"."TENDER_MEDIA_FP_TOTAL" shrink space COMPACT


SHRINK SPACE

alter index "LOCATION_ACTIVITY_DB"."XCNLABOR_CAT_FP_TOT" shrink space

alter index "LOCATION_ACTIVITY_DB"."XCNLABOR_CAT_FP_TOT" shrink space COMPACT


SHRINK SPACE

alter table "LOCATION_ACTIVITY_DB"."INVENTORY_ITEM_DAILY_TOTAL" shrink space

alter table "LOCATION_ACTIVITY_DB"."INVENTORY_ITEM_DAILY_TOTAL" shrink space COMPACT


SHRINK SPACE

alter index "LOCATION_ACTIVITY_DB"."XN5GUEST_CHECK_LINE_ITEM" shrink space

alter index "LOCATION_ACTIVITY_DB"."XN5GUEST_CHECK_LINE_ITEM" shrink space COMPACT


SHRINK SPACE

alter index "LOCATION_ACTIVITY_DB"."XTRGUEST_CHECK_LINE_ITEM_HIST" shrink space

alter index "LOCATION_ACTIVITY_DB"."XTRGUEST_CHECK_LINE_ITEM_HIST" shrink space COMPACT


SHRINK SPACE

alter index "LOCATION_ACTIVITY_DB"."XN4GUEST_CHECK_LINE_ITEM_HIST" shrink space

alter index "LOCATION_ACTIVITY_DB"."XN4GUEST_CHECK_LINE_ITEM_HIST" shrink space COMPACT


SHRINK SPACE

alter table "LOCATION_ACTIVITY_DB"."EMPLOYEE_DP_MENU_ITEM_TOTAL" shrink space

alter table "LOCATION_ACTIVITY_DB"."EMPLOYEE_DP_MENU_ITEM_TOTAL" shrink space COMPACT


SHRINK SPACE

alter table "LOCATION_ACTIVITY_DB"."CASH_MGMT_DETAIL" shrink space

alter table "LOCATION_ACTIVITY_DB"."CASH_MGMT_DETAIL" shrink space COMPACT


SHRINK SPACE

alter table "LOCATION_ACTIVITY_DB"."MENU_ITEM_DAILY_TOTAL" shrink space

alter table "LOCATION_ACTIVITY_DB"."MENU_ITEM_DAILY_TOTAL" shrink space COMPACT


SHRINK SPACE

alter index "LOCATION_ACTIVITY_DB"."XAKJOB_CODE_FP_TOTAL" shrink space

alter index "LOCATION_ACTIVITY_DB"."XAKJOB_CODE_FP_TOTAL" shrink space COMPACT


SHRINK SPACE

alter index "LOCATION_ACTIVITY_DB"."XN1GUEST_CHECK_LINE_ITEM" shrink space

alter index "LOCATION_ACTIVITY_DB"."XN1GUEST_CHECK_LINE_ITEM" shrink space COMPACT


SHRINK SPACE

alter index "AGGREGATE_DB"."XN5AGG_IC_CUSTOMER_ACCOUNT" shrink space

alter index "AGGREGATE_DB"."XN5AGG_IC_CUSTOMER_ACCOUNT" shrink space COMPACT


SHRINK SPACE

alter table "LOCATION_ACTIVITY_DB"."MENU_ITEM_DAILY_TOTAL_COM" shrink space

alter table "LOCATION_ACTIVITY_DB"."MENU_ITEM_DAILY_TOTAL_COM" shrink space COMPACT

alter table "LOCATION_ACTIVITY_DB"."MENU_ITEM_DAILY_TOTAL_COM" enable row movement

SHRINK SPACE

alter index "LOCATION_ACTIVITY_DB"."XCNMENU_ITEM_PRICE" shrink space

alter index "LOCATION_ACTIVITY_DB"."XCNMENU_ITEM_PRICE" shrink space COMPACT


SHRINK SPACE

alter index "LOCATION_ACTIVITY_DB"."XTROPS_FP_TOTAL_COM" shrink space

alter index "LOCATION_ACTIVITY_DB"."XTROPS_FP_TOTAL_COM" shrink space COMPACT


SHRINK SPACE

alter table "LOCATION_ACTIVITY_DB"."MYFORECAST_DETAIL" shrink space

alter table "LOCATION_ACTIVITY_DB"."MYFORECAST_DETAIL" shrink space COMPACT

alter table "LOCATION_ACTIVITY_DB"."MYFORECAST_DETAIL" enable row movement

SHRINK SPACE

alter index "LOCATION_ACTIVITY_DB"."XAKMENU_ITEM_DAILY_TOTAL" shrink space

alter index "LOCATION_ACTIVITY_DB"."XAKMENU_ITEM_DAILY_TOTAL" shrink space COMPACT


SHRINK SPACE

alter table "LOCATION_ACTIVITY_DB"."INVENTORY_TRANSFER_LOG" shrink space

alter table "LOCATION_ACTIVITY_DB"."INVENTORY_TRANSFER_LOG" shrink space COMPACT


SHRINK SPACE

alter index "LOCATION_ACTIVITY_DB"."XTRJOB_CODE_FP_TOTAL" shrink space

alter index "LOCATION_ACTIVITY_DB"."XTRJOB_CODE_FP_TOTAL" shrink space COMPACT


SHRINK SPACE

alter index "LOCATION_ACTIVITY_DB"."XPKGUEST_CHECK_LINE_ITEM_HIST" shrink space

alter index "LOCATION_ACTIVITY_DB"."XPKGUEST_CHECK_LINE_ITEM_HIST" shrink space COMPACT


SHRINK SPACE

alter index "LOCATION_ACTIVITY_DB"."XCNJOB_CODE_FP_TOTAL" shrink space

alter index "LOCATION_ACTIVITY_DB"."XCNJOB_CODE_FP_TOTAL" shrink space COMPACT


SHRINK SPACE

alter table "LOCATION_ACTIVITY_DB"."WEBSERVICE_ACCESS_LOG" shrink space

alter table "LOCATION_ACTIVITY_DB"."WEBSERVICE_ACCESS_LOG" shrink space COMPACT


49 rows selected.










No comments:

Post a Comment