[HPADM] ORACLE 8.1.7 imp very slow

Paul.Soltermann_at_vonroll-isola.com
Date: 02/10/04

  • Next message: Gosselin, Mark: "[HPADM] Not enough colors..." 
    To: hpux-admin@dutchworks.nl
Date: Tue, 10 Feb 2004 16:11:12 +0100

    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..."

    Relevant Pages

    • Re: IMP-00009: abnormal end of export file
      ... Ordinary file copy from a server inside my firewall ... Possibility of accidentally invoking exp rather than imp? ... most fantastic Oracle guru, but I am a software developer with several ... That sounds like user error on device, ...
      (comp.databases.oracle.server)
    • [HPADM] RE: Tentative SUMMARY: L Class and N Class memory
      ... Just as I suspected: the collective experience of the HP-UX admin mailing list had the right answer: The RAM removed from an N4000 server and installed in an L2000 server worked just fine. ... Subject: [HPADM] Tentative SUMMARY: L Class and N Class memory ... The general felling on the question of using N class server memory in an L class server is that it should work, ... To subscribe/unsubscribe to this list, ...
      (HP-UX-Admin)
    • [HPADM] Unable to reduce fs using fsadm
      ... OS: HP-UX 11.00 ... The server has the following installed: ... Am I missing something? ... To subscribe/unsubscribe to this list, ...
      (HP-UX-Admin)
    • tkinter + interrupts
      ... the problem is "start server" will loop infinitely and respond to requests. ... This message was sent using IMP, the Internet Messaging Program. ...
      (comp.lang.python)
    • [HPADM] Getting the data in seconds since epoch
      ... I want a simple command like 'date' to get the seconds since epoch on a ... HP-UX server. ... To subscribe/unsubscribe to this list, ...
      (HP-UX-Admin)