using sequneces with no cache? On 8/11/08, A Ebadi <ebadi01@xxxxxxxxx> wrote: > We are seeing lots of "row cache lock" waits in the DB during a long running > insert and the performance is really poor on this insert. Any suggestions > on what to look for? We have not come up with much from Metlink/Oracle > Support/Google yet. > > Environment: 3-node Oracle RAC (10.2.0.3.0 on Solaris 10 w/ ASM). > > Thanks, > Abdul > > > -- Anjo Kolk Owner and Founder OraPerf Projects tel: +31-577-712000 mob: +31-6-55340888 -- //www.freelists.org/webpage/oracle-l