RE: can clustering help INSERTS ?

2002-10-27 Thread Rahul
t; > running.. > > > > there are no indexes on the tables > > > > > -- > > > From: Tim Gorman[SMTP:[EMAIL PROTECTED]] > > > Reply To: [EMAIL PROTECTED] > > > Sent: Friday, October 25, 2002 9:13 PM > > > To: Multiple recipients of list ORACLE-

RE: can clustering help INSERTS ?

2002-10-27 Thread Rahul
is view once every second Rahul > -- > From: Jared Still[SMTP:[EMAIL PROTECTED]] > Sent: Sunday, October 27, 2002 8:27 AM > To: [EMAIL PROTECTED]; Rahul > Subject: Re: can clustering help INSERTS ? > > > *no* waits? > > How is this

RE: can clustering help INSERTS ?

2002-10-27 Thread Rachel Carmichael
I believe Kevin gave that presentation at OpenWorld -- either last year or the year before. His paper is available for download on the TUSC site, as he works for TUSC. --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > Naveen - >He provided figures, and they are on the handout that is somewhere

Re: can clustering help INSERTS ?

2002-10-27 Thread Tim Gorman
of the > > > > insertion process, currently it takes around 9 hrs... the management > > wants > > > > to bring it > > > > down to 5-6 hrs...again.. i OD NOT see any wait events while the process > > is > > > > running.. > > > &

Re: can clustering help INSERTS ?

2002-10-27 Thread Mark J. Bobak
insertion process, currently it takes around 9 hrs... the management > wants > > > to bring it > > > down to 5-6 hrs...again.. i OD NOT see any wait events while the process > is > > > running.. > > > > > > there are no indexes on the tables > >

RE: can clustering help INSERTS ?

2002-10-27 Thread DENNIS WILLIAMS
Naveen - He provided figures, and they are on the handout that is somewhere in my office. Maybe I'll run across it someday, or even better, maybe he'll publish his results. Here are a few more details that I posted to this list earlier. Kevin Loney (author of Oracle DBA Handbook) has performe

Re: can clustering help INSERTS ?

2002-10-27 Thread Stephane Faroult
DENNIS WILLIAMS wrote: > > Stephane >You mentioned "each additional index costs about 2.5 times the cost of > inserting into a non-indexed table". I just wanted to point out that Kevin > Loney has done some performance tests involving the number of indexes. I > don't know if he has published t

Re: can clustering help INSERTS ?

2002-10-27 Thread Tim Gorman
it events while the process is > > running.. > > > > there are no indexes on the tables > > > > > -- > > > From: Tim Gorman[SMTP:[EMAIL PROTECTED]] > > > Reply To: [EMAIL PROTECTED] > > > Sent: Friday, October 25, 2002 9:13 PM

Re: can clustering help INSERTS ?

2002-10-26 Thread Jared Still
ess is > running.. > > there are no indexes on the tables > > > -- > > From: Tim Gorman[SMTP:[EMAIL PROTECTED]] > > Reply To: [EMAIL PROTECTED] > > Sent: Friday, October 25, 2002 9:13 PM > > To: Multiple recipients of

RE: can clustering help INSERTS ?

2002-10-26 Thread Naveen Nahata
:13 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Re: can clustering help INSERTS ? > > > > Rahul, > > > > It does no good to speculate; let's work with facts... > > > > What wait-events are occurring in the sessions running the INSERTs?

Re: can clustering help INSERTS ?

2002-10-26 Thread Tim Gorman
> > From: Tim Gorman[SMTP:[EMAIL PROTECTED]] > > Reply To: [EMAIL PROTECTED] > > Sent: Friday, October 25, 2002 9:13 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Re: can clustering help INSERTS ? > > > > Rahul, > > > > It does no

RE: can clustering help INSERTS ?

2002-10-26 Thread Naveen Nahata
Dennis, Did he publish any figures? I mean, it seems common-sense that adding the first index will hurt but adding 11th index to a table won't hurt that much. As stephane pointed out, cost of an index is 2.5 times more than the cost of insert in a non-indexed table. So assuming cost is 1, than

RE: can clustering help INSERTS ?

2002-10-25 Thread Rahul
ables > -- > From: Tim Gorman[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Friday, October 25, 2002 9:13 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: can clustering help INSERTS ? > > Rahul, > > I

RE: can clustering help INSERTS ?

2002-10-25 Thread DENNIS WILLIAMS
Stephane You mentioned "each additional index costs about 2.5 times the cost of inserting into a non-indexed table". I just wanted to point out that Kevin Loney has done some performance tests involving the number of indexes. I don't know if he has published these anywhere. In a nutshell, the re

Re: can clustering help INSERTS ?

2002-10-25 Thread Tim Gorman
Rahul, It does no good to speculate; let's work with facts... What wait-events are occurring in the sessions running the INSERTs? If you can locate the sessions in the V$SESSION view, then use the value in the column SID to locate associated rows in the V$SESSION_EVENT view, sorting by the cumu

Re: can clustering help INSERTS ?

2002-10-25 Thread Stephane Faroult
Rahul wrote: > > List, > i have two heavily inserted tables, the structures are same. > currently these tables reside on separate disks, can i increase the > performance > of inserts if i create these tables in a cluster ? as a cluster would force > the rows of both the tables > to be physically c

can clustering help INSERTS ?

2002-10-25 Thread Rahul
List, i have two heavily inserted tables, the structures are same. currently these tables reside on separate disks, can i increase the performance of inserts if i create these tables in a cluster ? as a cluster would force the rows of both the tables to be physically close on the disk ! regards