Home -> Usenet -> comp.databases.oracle -> Re: Fragmentation in Oracle

Re: Fragmentation in Oracle

From: Dave S. <dsingh_at_tgtsolutions.com>
Date: 1997/11/08
Message-ID: <643acd$r76$1_at_tor-nn1.netcom.ca>#1/1 








As DBA's we deal with what you call 'atypical' code. We must be aware of how
Oracle handles storage items.



Believe me Tom, this is not atypical, I have seen on almost all installs
that I have worked on, specially if the code was developed by numerous
developers.



Further, if the delete is part of the transaction, AND, the code is to
rollback the transaction, then this is the only way to deal with this, I
mean, if the process is suppose to delete from the table and insert into the
same table, some developers may want to rollback the ALL transactions that
are involved.  They may not be deleting / inserting 30,000 rows and as a
result, the size of the rollback space used may not be critical.



Please, let's end this item,  I think Doug's input explains this to my
complete satisfaction. Thanks Doug.



Regards and thanks to all.



Dave
Received on Sat Nov 08 1997 - 00:00:00 CET












Original text of this message