[askdba] Re: Insert is taking a lot of time
- From: ntareen@xxxxxxxxx
- To: askdba@xxxxxxxxxxxxx
- Date: Wed, 8 Oct 2008 18:31:36 +0000
Why not just rebvuild the indexes and give it a try
Tareen
Sent via BlackBerry by AT&T
-----Original Message-----
From: "Abraham Kurian" <kurian24@xxxxxxxxx>
Date: Wed, 8 Oct 2008 21:26:18
To: <askdba@xxxxxxxxxxxxx>
Subject: [askdba] Re: Insert is taking a lot of time
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:
