Does the table you are deleting has any child table(s)? If yes, then are the foreign keys in the child table(s) indexed?
Guang -----Original Message----- Wolfgang Breitling Sent: Thursday, October 09, 2003 11:34 AM To: Multiple recipients of list ORACLE-L I was tempted to point to the /*+ _try_harder */ hint (revealed by Jonathan Lewis at this year's IOUG), but that won't be available until Oracle 10. Until then we have to use the old methods of identifying where the time is spent and figure out what can be done to eliminate as much of it as possible. I have seen deletes take a long time if the table was heavily indexed. Removing the indexes before the delete and rebuilding afterwards was the solution there. At 02:29 AM 10/9/2003, you wrote: >Hi List , > >Can you help me please , > >What are the database parameters that i have to increase or modify in >order to increase the speed of my ddl >statments ,i have a statment that delete a table with 40000 record but it >takes about nine hours to accomplish !!! > >Is their any parameters on the server that i have to check ??,Increase >rollback segment is not helpfull at all . >Iam running oracle 9.2.0.1.0 production . Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
