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
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
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
>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
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
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
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
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
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
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
10 matches
Mail list logo