Home » RDBMS Server » Performance Tuning » urgent.
urgent. [message #65218] Fri, 18 June 2004 04:02
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


  let us suppose there exist 250000 records in emp table

sql>  insert into emp select * from emp where empno is not null;


sql> insert into emp select * from emp;

i increased the sharepool size and db buffers.

thanks in advance


Previous Topic: Oracle 8.1.6 performance on NT4
Next Topic: How to identify the top 10 long running queries in oracle
Goto Forum:

Current Time: Sun Mar 03 02:23:19 CST 2024