Home » RDBMS Server » Performance Tuning » urgent.
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

 
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