RE :

If by '32,000' you mean something like '32,767' I would suspect arrays indexed by signed short (two-byte) integers trying to go past the limit. I presume that your interface is trying to loop an index too far, that there is an attempt at catching the exception and that you are entering a never-ending while loop somewhere (ready to bet that the process still consumes a lot of CPU). Don't think that the problem is on the Oracle side (it would tell you, anyway).

-- 
Regards,

  Stephane Faroult
  email: sfaroult_at_oriolecorp.com 
  Oriole Corporation
  Voice:  +44  (0) 7050-696-269 
  Fax:    +44  (0) 7050-696-449 
  Performance Tools & Free Scripts
------------------------------------------------------------------
http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs
------------------------------------------------------------------


> 

> 

> Hi All

> 

> I have a problem with inserting records into a table. I am inserting into a

> table through an interface. After each insert its committing.But after 32000

> records the interface hangs.What could be the possible reason something

> related to extents of table or otherwise.

> 

> 

> Kindest Regards

> Priyanka

> pdeswal_at_velos.ssind.com