[HPADM] ORACLE 8.1.7 imp very slow

From: Paul.Soltermann@vonroll-isola.com
Date: Tue Feb 10 2004 - 10:11:12 EST

Next message: Gosselin, Mark: "[HPADM] Not enough colors..."
Previous message: Thomas Northup: "[HPADM] Kernel parameter names and suggested values"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Hello admins,

Recently we updated our System from HP-UX 10.20,32bit/ORACLE 7.3.3 32bit to
HP-UX 11.00,64bit/ORACLE 8.1.7 32bit on a HP D370 Server. This is the
highest possible release allowed by the main application which is also
compatible with our hp rp5470 server.

The ORACLE import from RP5470 to D370 takes 25% more time then it
previously took, and we need to do this every night.

We also increased FS blocksize to 4096 and init.ora parameter
db_block_size to 8192.

We moved the buffer-parameter from imp to buffer=16384.

Any ideas ?

--
             ---> Please post QUESTIONS and SUMMARIES only!! <---
        To subscribe/unsubscribe to this list, contact majordomo@dutchworks.nl
       Name: hpux-admin@dutchworks.nl     Owner: owner-hpux-admin@dutchworks.nl
 
 Archives:  ftp.dutchworks.nl:/pub/digests/hpux-admin       (FTP, browse only)
            http://www.dutchworks.nl/htbin/hpsysadmin   (Web, browse & search)

Next message: Gosselin, Mark: "[HPADM] Not enough colors..."
Previous message: Thomas Northup: "[HPADM] Kernel parameter names and suggested values"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

This archive was generated by hypermail 2.1.7 : Sat Apr 12 2008 - 11:02:38 EDT