Re: Index Maintenance Vs Insert Response Time
From: Sidney Chen <huanshengchen_at_gmail.com>
Date: Wed, 8 Feb 2012 00:05:36 +0800
Message-ID: <CAM_ddu-xi9+WRGbzvOpWMCepLjirb7u8TYN5NmWQrAAeoSKj=A_at_mail.gmail.com>
Hi Antony,
Have you enabled entended sql trace to check the what's the major component of the current 6-7 minutes. Unless identifying what's responsible for the response time, we can only guess.
Date: Wed, 8 Feb 2012 00:05:36 +0800
Message-ID: <CAM_ddu-xi9+WRGbzvOpWMCepLjirb7u8TYN5NmWQrAAeoSKj=A_at_mail.gmail.com>
Hi Antony,
Have you enabled entended sql trace to check the what's the major component of the current 6-7 minutes. Unless identifying what's responsible for the response time, we can only guess.
what's the method to insert the rows, are inserted in a single insert...select... statment, in by inserting 45,000 times, in such a case, you may want to try the array insert method, the forall statment.
--
Regards
Sidney Chen
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 07 2012 - 10:05:36 CST