Not able to understand the reason for long export of SAP Tables

320 Views

Hi,

I recently did a export of CRM 7.0 System of about 600 GB of DB size. It took nearly 10 hours for a table CRMORDERCONT to be exported and DBTABLOG of about 4 hours to be exported. Entries in CRMORDERCONT is around 3 lakhs records and DBTABLOG is around 13 crore records.

I ran update statistics and tunned the Oracle parameter.

CRMORDERCONT.TSK file contains only the CRMORDERCONT Table and DBTABLOG.TSK contains DBTABLOG table only.

Size of table is

select SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024 "MB",MAX_SIZE/1024/1024 "MB" from dba_segments where SEGMENT_NAME='CONTENTDATA';

SEGMENT_NAME
--------------------------------------------------------------------------------
SEGMENT_TYPE MB MB
------------------ ---------- ----------
CRMORDERCONT
TABLE 1013.375 2048

SQL> select SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024 "MB",MAX_SIZE/1024/1024 "MB" from dba_segments where SEGMENT_NAME='DBTABLOG';

SEGMENT_NAME

--------------------------------------------------------------------------------

SEGMENT_TYPE MB MB

------------------ ---------- ----------

DBTABLOG

TABLE 45227.125 2048

Can anyone please help me to understand the reason for such a long duration of export of these tables ?

Thanks and Regards,

Vimal