| import hangs [message #450888] |
Sat, 10 April 2010 04:13  |
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 #450896 is a reply to message #450895] |
Sat, 10 April 2010 08:18  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
