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

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Wed, 12 Oct 2005 16:37:22 -0400
Message-ID: <AA29A27627F842409E1D18FB19CDCF2705366C14@AABO-EXCHANGE02.bos.il.pqe>

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
 

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

Received on Wed Oct 12 2005 - 15:41:50 CDT