Home » Infrastructure » Other Operating Systems » ORACLE Unload/Reloads very slow on MVS
ORACLE Unload/Reloads very slow on MVS [message #113888] Sat, 03 May 2003 19:02 Go to next message
raj patel
Messages: 15
Registered: October 2002
Junior Member
Hi again, my ORACLE DBA's are concerned that ORACLE database unload/reload's are very slow on the mainframe compared to some NT's systems.

The mainframe is a 9672-R56 and we have fast IBM ESS 2105 disk's.

I would be interested in users hints/tips please.

Thanks Raj.
Re: ORACLE Unload/Reloads very slow on MVS [message #113889 is a reply to message #113888] Sat, 03 May 2003 19:03 Go to previous message
Gia McNerney
Messages: 7
Registered: March 2001
Junior Member
: Hi again, my ORACLE DBA's are concerned that ORACLE database unload/reload's are very slow on the mainframe compared to some NT's systems.

: The mainframe is a 9672-R56 and we have fast IBM ESS 2105 disk's.

: I would be interested in users hints/tips please.

: Thanks Raj.

Hi Raj,

Hi,

This shouldn't be any slower. A few suggestions:

Specify the BUFFER parm to make it more efficient
Ensure the DCB information is specified for the export dataset.
Ask Operations to up the priority for your jobs.

When we specified the buffer with DCB info, our exports/imports were much quicker (imports are a direct result of the export file).

I'm assuming you are talking about export/import when stating unload and reload?

Gia
Previous Topic: Anybody using VIPA and ORACLE
Next Topic: Upgrade to 9i; anyone done this and any problems
Goto Forum:
  


Current Time: Thu Dec 18 04:35:38 CST 2014

Total time taken to generate the page: 0.10719 seconds