on 2012 Jun 25 1:51 PM
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
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
Request clarification before answering.
These 2 tables have Long RAW data type and the R3load needs to convert them during the export to a platform independent format before dumping into data files. This conversion is CPU intensive and hence it is always expected it is going to take a lot time.
You can do very little from your end to tune them .
1. You can split these tables and parallely export them using orderby file.
2. Use can use an application server with higher CPU power.
3. Utilize the CPU to the maximum extent ( as SAP application is already down) by increasing the number of R3load processes on the fly editing the export_monitor_cmd.properties and orderby files in the installation directory.
Regards
Ratnajit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi jairo & Ratnajit,
Thanks a lot for your valuable answers. Now I got the reason for this long export.
I will try the option of table splitting and do a test export again to find out whether we can reduce the downtime.
Thanks again.
Will get back in case of any issues.
Thanks and Regards,
Vimal
User | Count |
---|---|
79 | |
29 | |
9 | |
8 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.