Re: re-indexing per statement or per row?

In article <3cb16302$0$238$ed9e5944_at_reading.news.pipex.net>, "Niall says...
>
>"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message
>news:3CB09D26.3AF2_at_yahoo.com...
>> Thomas Kyte wrote:
><snip>
>> > o the cost of an 18gig disk drive that you just buy -- hook up to the
>> > system and use for that one update and then throw away (yes, just
>throw it
>> > away) is typically less then what you have to pay someone to develop
>and test
>> > the procedural code......
><snip>
>> And just to reinforce Tom's point - from a shopping web site
>>
>> (IDE) disk 160G £205
>> (SCSI) disk 36.9GB £258.50
>>
>> You don't get a lot of developer time for £250
>
>Food for thought this whole discussion. On the whole I don't like throwing
>hardware at problems which this approach *could* be viewed as On the other
>hand there is an argument that you are just buying an 'appropriate' level of
>hardware for the task.
>

Exactly -- I made the somewhat "exaggerated" statement about buying the disk, throwing them out just to make a point.

I don't know how many times people have just blantantly refused to size various structures properly for what they are doing all because they "don't think it should take that much".

That's just not the right approach. You size UNDO and REDO based on your workloads, not based on what "feels good". The argument that "disk is an expense, we must be cautious in our purchase of it" just doesn't work. Compared to the level of effort you will spend over the life of your system working around NOT having sufficient disk allocated to these important structures -- the disk is almost FREE.

While 9i gives us resumable statements, partially fixing the problem -- I just wonder how many millions of hours have be wasted by people doing something and having temp or rollback blow out "because they don't feel it should take that much".

It is penny wise, pound foolish to skimp in this area.

>
>--
>Niall Litchfield
>Oracle DBA
>Audit Commission UK
>*****************************************
>Please include version and platform
>and SQL where applicable
>It makes life easier and increases the
>likelihood of a good answer
>
>******************************************
>
>
>

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp