urgent. [message #65218] |
Fri, 18 June 2004 04:02 |
jeevan
Messages: 18 Registered: August 2001
|
Junior Member |
|
|
hi all!
one of my customer is dumping more than 2lacs records at time into a table. each record is having a average length of 37 bytes. it hangs up my database and am unable to do any thing with the database. Even i cant able to connect to the database under another user name also. I am trying to kill the session, but it hasnt been killed. It is difficult to restart the database each and every time when it hangs
example:
let us suppose there exist 250000 records in emp table
sql> insert into emp select * from emp where empno is not null;
or
sql> insert into emp select * from emp;
i increased the sharepool size and db buffers.
thanks in advance
jeevan
|
|
|