Re: Any way to disable UNDO (rollback) with temporary tables?

From: Phil Kaufman <philk_at_dbcsmartsfotware.com>
Date: Tue, 02 Dec 2003 13:29:54 -0500
Message-ID: <L46dnaOc49q-R1GiRVn-uA@golden.net>

If I may quote the Oracle guru himself, Thomas Kyte, in his book expert one-on-one Oracle in a chapter called Redo and Rollback:

"The most important things to take away from this chapter are the importance of redo and rollback, and the fact that they are not overhead - they are in fact integral components of the database, they are necessary and mandatory."

Pick up a copy of the book, give a read, and listen to what Thomas and Daniel here are trying to tell you. ;-)

NetComrade wrote:

> Possibly you're right.. But I just couldn't come up with a scenario
> where my temporary data would be need to recover any transaction.. If
> instance or session fails, data should just be discarded, as any data
> stored in temporary data is not used for anything but fetching it
> (e.g. it's not inserted in any 'real' tables).
> 
> The best solutions for us to to pass damn object arrays back to Pro*C,
> but Oracle just doesn't seem to be able to do it, or at least that's
> what they tell us.
> 
> On Tue, 02 Dec 2003 08:44:42 -0800, Daniel Morgan
> <damorgan_at_x.washington.edu> wrote:
> 
> 

>>NetComrade wrote:
>>
>>
>>>I kind of understand the reason behind storing undo for temporary
>>>tables, but in our case, I believe we just don't need it.
>>
>>You may well believe it but you are incorrect in that bleief.
>>
>>The entire structure of Oracle is based on an architecture that does.
>>Your belief that you don't is irrelevant to the underlying database engine.
>>
>>Whatever UNDO is doing ... it is undoubtedly not your problem. I would
>>suggest you concentrate on what is.
>>
>>--
>>Daniel Morgan
>>http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
>>http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
>>damorgan_at_x.washington.edu
>>(replace 'x' with a 'u' to reply)
>>

> 
> 
> .......
> We use Oracle 8.1.7.4 on Solaris 2.7 boxes
> remove NSPAM to email

Received on Tue Dec 02 2003 - 12:29:54 CST