Re: Slow Oracle Export???

On 2 Sep 1996 16:56:15 GMT, Vijay Vardhineni 604-1835 <vvardh01> wrote:

>This is a multi-part message in MIME format.
>
>---------------------------------18226177316864634261530709459
>Content-Transfer-Encoding: 7bit
>Content-Type: text/plain; charset=us-ascii
>
>You may want to use Single Task Export. You can find more info
>on Single-task Export on Oracle7 Administrator's Reference for
>UNIX (Version 7.3), Page 3-20, Tuning Oracle7 for UNIX, Tip -
>34. For Version 7.2 also you have the Single-task Export
>feature available. Following lines are from Oracle7
>Administrator's Reference for UNIX (Release 7.3).
>
>Tip 34: USE SINGLE-TASK LINKING FOR LARGE EXPORTS/IMPORTS
>
>Suggestion: The Potential Performance benefit you follow this
>recommendation is 0-15 percent.
>
>If you need to transfer large amounts of data between the user
>and Oracle 7 (for example export/import), it is efficient to
>use single-task architecture. To make single-task import
>(impst) and export (expst) executables, use the oracle.mk
>program, which can be found in the $ORACLE_HOME/rdbms/lib
>directory.
>
>Attention: Linking Oracle executables as a single-task allows
>a user process to directly access the entire SGA. In
>addition, running single-task requires more memory because the
>oracle executable text is no longer shared between the
>front-end and background processes.
>
>----END OF TIP
>
>
>Vijay Vardhineni
>Oracle DBA, EDS
>Plano, TX
>
>---------------------------------18226177316864634261530709459
>Content-Transfer-Encoding: quoted-printable
>Content-Type: text/plain
>
>From: akm_at_wizvax.net
>Reply-To: akm_at_wizvax.net
>Newsgroups: comp.databases.oracle
>Subject: Slow Oracle Export???
>Date: 26 Aug 96 12:25:53 GMT
>Organization: Deja News Usenet Posting Service
>Message-ID: <841062088.17745_at_dejanews.com>
>
>I'm running Oracle 7.2 on an HP9000. An export on a 1.5 GB table is taking about 7 hours. I've tried a bunch of different values f=
>or exp, but it doesn't seem to make a difference. We are using a fast cybernetics CY-8505 tape drive. Anyone have any suggestions?=
>

AH HA! You're running the export to TAPE! Possibly the slowest mass storage device known to man. Export the data to disk first. It'll be a whole lot faster and your export dump file will not be even close to the full 1.5GB in the table.

>
>Thanks.
>-----------------------------------------------------------------------
>This article was posted to Usenet via the Posting Service at Deja News:
> http://www.dejanews.com/ [Search, Post, and Read Usenet News!]
>
>---------------------------------18226177316864634261530709459--
Received on Sat Sep 07 1996 - 00:00:00 CEST