OVMS: improving performance of import 10.2
edited Jan 10, 2014 9:28AM in Rdb on OpenVMS, IBM zSeries and Oracle on OpenVMS (MOSC) 2 commentsAnswered
The environment is OpenVMS 8.2 Alpha, Oracle 10.2.0.4 enterprise edition, db is not in archive mode.
Run a tablespace export on a 9.2.0.8 db; the job takes 2 hours 11 minutes.
The output file is 68 gigs.
Importing the data into a 10.2 db takes 9 hours 17 minutes. Nine hours seems excessive
The export and import are both run from DCL command procedures in batch mode. Both procedures have the following logicals defined:
define/job ora_beq_mbxbfq 32000
define/job ora_beq_mbxsiz 32000
define/job ora_file_deq 512
Thanks in advance for any suggestions for improving the performance of the import command
KC
Run a tablespace export on a 9.2.0.8 db; the job takes 2 hours 11 minutes.
The output file is 68 gigs.
Importing the data into a 10.2 db takes 9 hours 17 minutes. Nine hours seems excessive
The export and import are both run from DCL command procedures in batch mode. Both procedures have the following logicals defined:
define/job ora_beq_mbxbfq 32000
define/job ora_beq_mbxsiz 32000
define/job ora_file_deq 512
Thanks in advance for any suggestions for improving the performance of the import command
KC
0