Home » RDBMS Server » Server Utilities » import hangs (9.2.0.6)
import hangs [message #450888] Sat, 10 April 2010 04:13 Go to next message
ankush_chawla
Messages: 136
Registered: November 2006
Senior Member
I have initiated a full database import to replicate the database at the testing end .
A new database was created for the same purpose and we initated the import. The import went smothly for some time . A table of size more than 40 GB was imported in 12 hours . However it went stuck at a table (table_case) for more than 48 hours now. log shows
. . importing table "TABLE_CAM_PER_ROLE" 0 rows imported
. . importing table "TABLE_CASE"

The size of table is just 4 GB . There doesnot seem any bottleneck in the database . There are no activities running on the database. The alert log files shows no errors and log is switching every 20-30 minutes. We checked locks with below query
SQL> select * from v$lock where block=1;

no rows selected

. . importing table "TABLE_CAM_PER_ROLE" 0 rows imported
. . importing table "TABLE_CASE"


What are other areas we can look at . We have checked the sessions in toad and the number of gets are increasing for import but quite slowly .
please help
Re: import hangs [message #450895 is a reply to message #450888] Sat, 10 April 2010 08:07 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Quote:
log is switching every 20-30 minuteslog is switching every 20-30 minutes

Then Import running fine.

Could you please your import command?

Babu
Re: import hangs [message #450896 is a reply to message #450895] Sat, 10 April 2010 08:18 Go to previous message
ankush_chawla
Messages: 136
Registered: November 2006
Senior Member
import moved on.. i found waits for direct path write
(lob) and i increased pga and it went on ..
the table had a clob column.

let u knw if any other issues arises
Previous Topic: sql loader - how to ignore inserting duplicate records
Next Topic: Need to Import from 8i to 10gR2
Goto Forum:
  


Current Time: Sat Jul 31 05:59:21 CDT 2021