Re: import hangs database

From: Vitaliy Mogilevskiy <vit100gain_at_earthlink.net>
Date: Tue, 04 May 1999 15:50:08 -0700
Message-ID: <372F79A0.A62E6435@earthlink.net>

First look at your altert log:
%ORACLE_HOME%\rdbms80\trace\orclALRT.LOG it'll tell you a lot about your problems. Second try increasing size of your redo log files, you are probably at the default, which is too small to run big imports. Third when you do an import increase BUFFER parameter: imp80 system/manager file=<YOUR_FILE>.dmp buffer=200000 commit=y full=y ignore=y log=imp.log

Good luck!

+--------------------------------------------------------------------------+
| Vitaliy Mogilevskiy
| Senior Consultant
| CORE Technology Group, Inc.
| E-mail:    vit100gain_at_earthlink.net
| Fax :      (707) 516-2163
| Web Page:  http://home.earthlink.net/~vit100gain/index.html

|            *** Free DBA Script Library at my Web Page ***
|

| "Never wrestle a pig - you both get dirty and the pig likes it..." | "If the only tool you have is a hammer, everything looks like a nail..."

+--------------------------------------------------------------------------+

Peter Rexer wrote:

> I'm a relatively inexperienced database admin.
>
> I'm importing a fairly large file (290M) into an Oracle 8.0.5 instance.
> Whenever i try to import it, I get a certain portion thru the process, and
> then my import hangs, keeping a lock on the table that it last was trying to
> load. If I go in with a sqlplus session and try to query the table I get:
>
> ORA-00054: resource busy and acquire with NOWAIT specified
>
> This seems to hang the database in a couple consistant spots during the load,
> depending on whether I clear out the tablespace before the import or not. So
> if I start with a clean database, then I hang when loading table 7, if I don't
> clean it out, I hang while loading table 12. I tried just re-running it ad-
> nauseum, but i think table 14 is too large, and it never gets done.
>
> I've been stopping the hang by doing a shutdown abort, as I don't really know
> how to get rid of the problem any other way.
>
> So two things: Where do I look to try to figure out what is going wrong with
> the import, it seems like I should be able to tell the database to do some
> logging, and how can I release the table lock without bouncing the DB?
>
> I've looked at space, and since this is on a 45G RAID drive, I don't think
> that's the problem. I don't have autoarchive on, but i've looked around and
> don't know where the redo-logs are written to, so potentially I'm swamping
> them?
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue May 04 1999 - 17:50:08 CDT