Re: Index Maintenance Vs Insert Response Time
From: Antony Raj <ca_raj_at_yahoo.com>
Date: Tue, 7 Feb 2012 08:17:01 -0800 (PST)
Message-ID: <1328631421.27424.YahooMailNeo_at_web36808.mail.mud.yahoo.com>
Hi
It's an Insert .... select.
The select part is spending exactly the same amount of time(13 secs) from the extended trace.
Rows Operation
0 LOAD TABLE CONVENTIONAL (crC1112 pr4448 pw=0 time11385671 us) 43,564 FILTER (crB7284 prD8 pw=0 time572425 us)
Thanks
From: Sidney Chen <huanshengchen_at_gmail.com> To: ca_raj_at_yahoo.com
Cc: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> Sent: Tuesday, February 7, 2012 11:05 AM Subject: Re: Index Maintenance Vs Insert Response Time
Date: Tue, 7 Feb 2012 08:17:01 -0800 (PST)
Message-ID: <1328631421.27424.YahooMailNeo_at_web36808.mail.mud.yahoo.com>
Hi
It's an Insert .... select.
The select part is spending exactly the same amount of time(13 secs) from the extended trace.
Rows Operation
0 LOAD TABLE CONVENTIONAL (crC1112 pr4448 pw=0 time11385671 us) 43,564 FILTER (crB7284 prD8 pw=0 time572425 us)
Thanks
From: Sidney Chen <huanshengchen_at_gmail.com> To: ca_raj_at_yahoo.com
Cc: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> Sent: Tuesday, February 7, 2012 11:05 AM Subject: Re: Index Maintenance Vs Insert Response Time
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 -- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 07 2012 - 10:17:01 CST