| sql loader stuck [message #128470] |
Mon, 18 July 2005 15:05  |
yjin
Messages: 8
Registered: July 2005
|
Junior Member |
|
|
I am in the middle of executing sql loader. Then it is just stuck there. Log file is 0kb. It shows record count reaches to around 10000.
I have no idea while it stops there.
Any suggestion would be appreciated!
|
|
|
|
|
|
|
|
| Re: sql loader stuck [message #128565 is a reply to message #128470] |
Tue, 19 July 2005 07:40  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
How do you know that the record count reached 10000 if the log file is empty? Did you do a select from the table? Conventional path load?
Is the rest of your db performance ok, other people can still log in and run things, including dml?
When you check the processes running on your server, is sqlldr still running? Using full cpu or just sitting there idle?
Sometimes I've seen you have to return to the session that you are running and hit return. But that isn't an oracle thing, more a session connection thing.
And you are presumably on a patched up version?
|
|
|
|
| Re: sql loader stuck [message #128582 is a reply to message #128565] |
Tue, 19 July 2005 10:13 |
yjin
Messages: 8
Registered: July 2005
|
Junior Member |
|
|
I used sql loader from command prompt. Loading data by direct path. The process is stuck and message in command prompt window is "Commit point reached - logical record count 13163". I tried the enter key and no response.
Trying to use dml in SQL scratchpad and it is hanging there forever.
|
|
|
|
| Re: sql loader stuck [message #128587 is a reply to message #128470] |
Tue, 19 July 2005 10:37 |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
|
Hmm, I'm just throwing out things to check, but when you dml against another table, not involved in load, how is that? Is your tablespace or tempfile full? How are your redo logs and archving, are you waiting on them? And I thought commit point reached was for conventional path not direct path but I'm rusty. How many total records in your file to load? Anything in alert log? 13 thousand records should fly by very quickly.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
