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:[EMAIL PROTECTED]]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
