RE: [SPAM] EXP taking forever....

From: laura pena <lizzpenaorclgrp_at_yahoo.com>
Date: Fri, 14 Oct 2005 08:32:14 -0700 (PDT)
Message-ID: <20051014153214.91416.qmail@web35011.mail.mud.yahoo.com>

Do you have listener up and running? Try using via tns connection ie system/<password>@tnsNameConnection

• "Bobak, Mark" <Mark.Bobak_at_il.proquest.com> wrote:

> Use SQL*Plus to connect to the instance. Identify
> the exp
> process/session. What's it doing? Is it burning
> CPU and spinning? Is
> is waiting on I/O? What does v$session_wait tell
> you about it?
>
> -Mark
>
> ________________________________
>
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
> Bryan Wells
> Sent: Wednesday, October 12, 2005 4:23 PM
> To: Oracle-L
> Subject: [SPAM] EXP taking forever....
> Importance: Low
>
>
> Guru's... I praise ye! slap me silly with thy
> knowledge!
>
> I have an export taking over 4 hours. I started it
> around 10AM MST.
> this is a relatively small 8.1.7.4 database on
> Solaris 8. I have pasted
> my parfile and where the hangup is occuring, but not
> sure what i am
> doing wrong?
>
> The call from script:
> exp system/0racl3
> parfile=/oracle_scripts/oraexport.ora;
>
> The parfile:
> #!/bin/ksh
> #
> #

>
FILE=/share/oraback/${V_HOSTNM}/${DATE}${V_HOSTNM}_full_exp.dmp >
LOG=/share/oraback/${V_HOSTNM}/${DATE}${V_HOSTNM}_full_exp.log
> FULL=Y
> STATISTICS=NONE
>
> The hanging output:
> . about to export DBSNMP's tables via Conventional
> Path ...
> . exporting referential integrity constraints
> . exporting synonyms
> . exporting views
> . exporting stored procedures
> . exporting operators
> . exporting indextypes
> . exporting bitmap, functional and extensible
> indexes
> . exporting posttables actions
> . exporting triggers
> . exporting snapshots
> . exporting snapshot logs
> . exporting job queues
> . exporting refresh groups and children
> . exporting dimensions
> . exporting post-schema procedural objects and
> actions
> . exporting user history table
> . exporting default and system auditing options
> . exporting statistics
>
>
                         

---

Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Oct 14 2005 - 10:38:26 CDT