Hi,
We have a cgi that displays data from oracle tables.
The program has been running for several months perfectly.
Last week every time it started, it seemed to almost "freeze" the Oracle
server ,
it didn' t end the operation (many Select statements).
After several hours of work we removed the /*+ FIRST_ROWS */ hints from some of
the selects and the problem went down to 50% ( It woult be a long story to
tell all the details).
At last we recreated _all_ the indexes and the problem dissapeared,
everything was fine again.
Question: Should a "bad" index cause a problem like this and why?
If an index is "bad" how come Oracle doesn' t see it?
It is important for me to know that for I don' t want to run in this
problem again.
Thank you
Zsolt Csillag
Hungary
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Csillag Zsolt
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).
