dbverify in nohup
Suffering from corruption in your database, it is nearly just as challenging as in real life… read more →
delete large number of records with intermediate commits
Have to delete a large number of records and running out of undo tablespace ‘ORA-30036: unable to extend segment by 8 in undo tablespace ‘UNDO’? Script below does a delete with intermediate commits ever ‘x’ records. read more →
,