Re: HELP - Oracle Schema Import problem

On Jul 27, 3:15 am, DA Morgan <damor..._at_psoug.org> wrote:
> Johne_uk wrote:
> > Hi,
>
> > I have 2 identical Solaris servers (freshly installed v490 - dual CPU
> > 8GB RAM). The OS (Solaris 10) were both installed to an agreed spec by
> > 2 diff consultants (all disk mirrored and striped).
>
> > I created identical 9208 DB instances on both servers (using identical
> > scripts with only diff being SID names).
>
> > I then imported a schema dump (from another db server) on server 1.
> > This took about 3 hrs.
>
> > However, despite an idential setup the second server took up to 3
> > times longer than the first to import the same export dump (except
> > this dump was sourced from a Linux db whereas the first was from
> > another solaris instance)
>
> > Im not an expert DBA and in the morning need to start troublesheeting
> > this performance bottleneck. Could the linux sourced export be the
> > reason for it being being slower on server 2. No logs etc were
> > generated whilst importing.
>
> > If I rule out using a linux derived export dump AND verify there are
> > no i/o issues with the Solaris server how would you suggest I proceed
> > to identify the bottelneck on server 2.
>
> > Apologies for the simplistic explanation (there are reasons for using
> > the Linux export) but I'd appreciate any pointers on how to start
> > solving this as I'm currently stuck in a hotel room and cant get my
> > hands on the system until the morning.
>
> > Thanks in advance
> > John
>
> Check endian values.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -
>
> - Show quoted text -

It is a little unclear in the OP but there were two different export files. Are both export files from the same source? If not, or if the schema exported was different then the import time difference could be just due to the difference in the quantity of data being imported.

Other things to check:
Verify that the OS kernal parameters set are the same

Verify that the file systems are of the same type and were mounted using the same options

Verify that the import parameters especially buffer= were set the same

NLS, that is, character set conversion might be responsible for some time difference but I would not expect this large of a difference.

HTH -- Mark D Powell -- Received on Fri Jul 27 2007 - 07:45:01 CDT