Inserts slowing down on OLTP systems

2001-05-07 Thread Vikas Kawatra
Anyone have ideas on why OLTP database inserts would slow down by 100% from levels 15 days ago ? We alreay checked hit ratios in shared pool , checked for any storage issues etc thanks vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET: [EMAIL

RE: Inserts slowing down on OLTP systems

2001-05-07 Thread Rajaram
Multiple recipients of list ORACLE-L Subject: Inserts slowing down on OLTP systems Anyone have ideas on why OLTP database inserts would slow down by 100% from levels 15 days ago ? We alreay checked hit ratios in shared pool , checked for any storage issues etc thanks vikas -- Please see

Re: Inserts slowing down on OLTP systems

2001-05-08 Thread Rachel Carmichael
each time.. this can have a major impact on performance. Rachel >From: Vikas Kawatra <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Inserts slowing down on OLTP systems >Date: Mon, 07 May 2001 16

RE: Inserts slowing down on OLTP systems

2001-05-08 Thread Vikas Kawatra
>From: Vikas Kawatra <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Inserts slowing down on OLTP systems >Date: Mon, 07 May 2001 16:55:28 -0800 > >Anyone have ideas on why OLTP database inserts w

RE: Inserts slowing down on OLTP systems

2001-05-08 Thread Rachel Carmichael
RACLE-L <[EMAIL PROTECTED]> >Subject: RE: Inserts slowing down on OLTP systems >Date: Tue, 08 May 2001 09:52:15 -0800 > >What specific events should I look for in these tables ! - atleast the imp >ones - >And What's a block split ? > >vikas > >-Original Message

RE: Inserts slowing down on OLTP systems

2001-05-08 Thread John Kanagaraj
anges, then you should consider rebuilding the index. Hth, John Kanagaraj Oracle Applications DBA Hitach Data Systems, Santa Clara Work : (408) 970 7002 >-Original Message----- >From: Vikas Kawatra [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, May 08, 2001 10:52 AM >To: Multiple rec

Re: Inserts slowing down on OLTP systems

2001-05-08 Thread Jared Still
As Rachel already said, don't bother with hit ratios. They are in fact nearly useless for any kind of tuning. For a good ( but verbose ) paper on the subject, goto www.hotsos.com Jared On Monday 07 May 2001 17:55, Vikas Kawatra wrote: > Anyone have ideas on why OLTP database inserts would sl

Re: Inserts slowing down on OLTP systems

2001-05-09 Thread Saumyajit Mandal
In OLTP system if there are too many indexes defined on tables, insert slows down. As volume of data goes up, the system shows even worse performance. if you can reduce total no of indexes probably it will help...actually this is a trade off. Thanks, Saumyajit > > On Monday 07 May 2001

Re: Inserts slowing down on OLTP systems

2001-05-09 Thread Saumyajit Mandal
In OLTP system if there are too many indexes defined on tables, insert slows down. As volume of data goes up, the system shows even worse performance. if you can reduce total no of indexes probably it will help...actually this is a trade off. Thanks, Saumyajit --- Jared Still <[EMAIL PRO

RE: Inserts slowing down on OLTP systems

2001-05-09 Thread Mohan, Ross
ECTED]] || Sent: Tuesday, May 08, 2001 3:31 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: Inserts slowing down on OLTP systems || || || Hi Vikas, || || In simple words, a block split happens when an INSERT needs || to add an entry || into a leaf block and finds it full, requiri