[askdba] Re: Insert is taking a lot of time
- From: "Abraham Kurian" <kurian24@xxxxxxxxx>
- To: askdba@xxxxxxxxxxxxx
- Date: Tue, 7 Oct 2008 17:28:53 +0530
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/>
>
Other related posts: