| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Inserts slowing down on OLTP systems
What specific events should I look for in these tables ! - atleast the imp
ones -
And What's a block split ?
vikas
-----Original Message-----
Sent: Tuesday, May 08, 2001 6:32 AM
To: Multiple recipients of list ORACLE-L
instead of checking hit ratios, try looking at wait events in v$session_event, v$system_event and v$session_wait.
also -- how many indexes are on these tables? How much data is in the tables? If the indexes are doing constant block splits on the insert you are
basically rebuilding the index each time.. this can have a major impact on performance.
Rachel
>From: Vikas Kawatra <VKawatra_at_innoventry.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Inserts slowing down on OLTP systems
>Date: Mon, 07 May 2001 16:55:28 -0800
>
>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: VKawatra_at_innoventry.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: carmichr_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET: VKawatra_at_innoventry.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue May 08 2001 - 11:52:28 CDT
 |
 |