title: Is there a limit to how much work I can do in a single Oracle transaction?
body: <p>I have to update three tables in a single transaction.  I'm using Oracle Spatial intersecting against potentially hundreds of thousands of records.  To maintain cross-reference integrity, I really need to update three tables with large volumes of cross-references in a single transaction.</p>
  
  <p>Is there a measurable limit to how much I can do in a single transaction?  Are there pitfalls to cramming thousands of insert/update/delete operations in a single transaction?  For the pitfalls, are there any well-known patterns/practices for handling them?</p>