| 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
Hi,
Can u elaborate? What does the statement
"Inserts slow down by 100% from levels 15 days ago?" mean. I did not understand
especially the "levels" part of it.
Also, mention as to how you are doing the inserts.
Are the inserts done as select * from another_table?
or Using SQLLOADER?
or Pro*C
or anyother?
I want these details 'Cos - Each method of loading data has its own optimization technique.
Rajaram.
-----Original Message-----
From: Vikas Kawatra [SMTP:VKawatra_at_innoventry.com]
Sent: Monday, May 07, 2001 8:55 PM
To: 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 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).
NetZero Platinum
No Banner Ads and Unlimited Access
Sign Up Today - Only $9.95 per month!
http://www.netzero.net
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rajaram
INET: rajaram_k_at_netzero.net
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 Mon May 07 2001 - 21:42:16 CDT
 |
 |