Yin Dog wrote: > Thanks Ronald! I can't agree more! > > Possible reason for the slowness here is that > the table itself is too big (with millions of records). > It will eat up cache space on the database server which > was allocated for DML operation for all databases on this > server.
more likely is that it's eating up rollback and getting io waits. > > So, my recommended solution is two steps: > 1. do a batch deletion instead of whole. e.g. delete 5,000 > rows one time, then loop through the delete function. > 2. ask your DBA to allocate more cache space. e.g. from 100M > to 150M throwing more space at the cache is not the way to solve the problem. better to ask the DBA to look at the wait states and see where the bottleneck is, then tune to relieve it. -- -- Bill "Shrek" Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] ------------------------------------------------------------------------ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ------------------------------------------------------------------------ IBM: Ideas Bring Money
