Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to trap the row count from a Commit ?
Glad to see my Hard Work hasn't been wasted.
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:3fa26cff$0$254$ed9e5944_at_reading.news.pipex.net...
> why not just make your rollback segments the right size?
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission Uk
> "Richard Elliott" <richard.a.elliott_at_williams.com> wrote in message
> news:8c132b3c.0310310519.2963db99_at_posting.google.com...
> > I know the data is there somewhere. I'm running an update loop (5k
> > rows/commit) to avoid the rollback segment too small issue. It works
> > fine, but I have to do a count of the remaining rows to see if I need
> > to loop again. It would be much faster if I could just see if the
> > previous commit did 5k rows or not. How do I trap the "# of rows
> > affected" from the commit ?
> >
> > Thanks !
>
>
Received on Fri Oct 31 2003 - 09:31:56 CST