oracle tuning

We have a largely OLTP database driving a web site where I imagine discrete transactions would be a really big win. However there are occasional queries that do full table scans to generate reports or queries. Will enabling discrete transactions cause those queries to break completely? (with "snapshot too old")?

Or is there a strategy for dealing with this -- only using discrete transactions when no big queries are running, for example. And if I enable "discrete_transactions_enabled" is that all I need to do or do I have to change every sql call to make it a discrete transaction and fall back to normal transactions?

--
greg Received on Fri Nov 12 1999 - 14:00:53 CST