[askdba] Re: Insert is taking a lot of time

  • From: "Abraham Kurian" <kurian24@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Wed, 8 Oct 2008 21:26:18 +0530

can you get a SQL trace of the session ? post tkprof if possible

Thanks

On Wed, Oct 8, 2008 at 4:50 PM, drumil narayan <drumilnarayan@xxxxxxxxx>wrote:

> 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<http://in.rd.yahoo.com/tagline_mail_2/*http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/>
>>
>
>
> ------------------------------
> Add more friends to your messenger and enjoy! Invite them 
> now.<http://in.rd.yahoo.com/tagline_messenger_6/*http://messenger.yahoo.com/invite/>
>

Other related posts: