Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: MASSIVE degradation of insert using sequence ID's via JDBC on 9i?

Re: MASSIVE degradation of insert using sequence ID's via JDBC on 9i?

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Thu, 30 Jun 2005 21:13:08 +1000
Message-ID: <42c3d3bf$0$8651$5a62ac22@per-qv1-newsreader-01.iinet.net.au> 





bugbear apparently said,on my timestamp of 29/06/2005 11:55 PM:



> the log file sync event count is very similar, but where 10g is doing 

> each flush

> in 0.000242, 9i takes a rather leisurely 0.113205.




Interesting.  Next step for any help here is:
dump all configured init.ora parameters in 9i,
same for 10g if you can, then plonk them here.


-- 
Cheers
Nuno Souto
in sunny Sydney, Australia
wizofoz2k_at_yahoo.com.au.nospam


Received on Thu Jun 30 2005 - 06:13:08 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US