| 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: Performance tuning
Trace the slower procedure. Hit the 10046 paper on www.hotsos.com to see
how.
This sounds like maybe 'buffer busy wait' waits on the index are causing contention among the procedures. But you need to prove whether it is (and which block it is, if my guess is right) before you can take the right corrective action on the first try.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic, Dec 9-11 Honolulu - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas - Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas
-----Original Message-----
Sent: Wednesday, November 06, 2002 10:38 PM
To: Multiple recipients of list ORACLE-L
I have a table in my application . This table gets all inserts during
one procedure and select during other . Now if I make an index on this
then the first procedure gets slow and if i drop the index then the
second procedure gets very slow.
Is there some solution to get out of this problem
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: dilmohan
INET: dilmohan_at_delhi.tcs.co.in
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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: Cary Millsap
INET: cary.millsap_at_hotsos.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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 Thu Nov 07 2002 - 00:43:27 CST
 |
 |