[askdba] Re: Insert is taking a lot of time
- From: drumil narayan <drumilnarayan@xxxxxxxxx>
- To: askdba@xxxxxxxxxxxxx
- Date: Wed, 8 Oct 2008 16:50:20 +0530 (IST)
It was a simple insert using curosr, usually it takes 15-20 minutes I think
that is still more time.
This time it took nearly 50 minutes to complete..there was no load at that time.
the datase is in RAC..and this is why I want to go in some deep..
thanks
----- Original Message ----
From: Abraham Kurian <kurian24@xxxxxxxxx>
To: askdba@xxxxxxxxxxxxx
Sent: Tuesday, 7 October, 2008 5:28:53 PM
Subject: [askdba] Re: Insert is taking a lot of time
v$session_wait , what does it say ?
are you using sqlldr for this operation .. or a direct path insert ?
On Tue, Oct 7, 2008 at 4:54 PM, drumil narayan <drumilnarayan@xxxxxxxxx> wrote:
hi there are nearly 4 million rows to be inserted into a table, user saying it
has inserted only half in past 45 minutes, from where should i start...
kindly help...
________________________________
Unlimited freedom, unlimited storage. Get it now
Unlimited freedom, unlimited storage. Get it now, on
http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/
Other related posts:
