NetComrade wrote:
> I've read the book, and understand the functionality and importance.
> See my point below tough.
>
> On Tue, 02 Dec 2003 13:29:54 -0500, Phil Kaufman
> <philk_at_dbcsmartsfotware.com> wrote:
>
>
>>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
>>
>
> .......
> We use Oracle 8.1.7.4 on Solaris 2.7 boxes
> remove NSPAM to email
Excuse me ... but you don't have a point. Oracle can not and will
not function as you wish it to. Well actually it can with some
unsupported parameters in the init.ora. But it will also crash and
burn in quite short order.
--
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)
Received on Tue Dec 02 2003 - 16:15:34 CST
