oracle 8.0.6 and rule-based optimizer

From: david spaisman <davedba._at_earthlink.net>
Date: Mon, 24 Feb 2003 04:55:57 GMT
Message-ID: <3E59D15D.E0395DD2@earthlink.net>

Hello:

I just was given responsibility for an application(ERP) that is written in microfocus cobol and runs on Oracle 8.0.6. The application must run on an rule-based optimiser according to the vendor.

I realize now tht my tuning possibiklites will be greatly limited becuase of rule-based leaves me with few tuning chocices.

I have some questiosn:

Cn I still use hints?

2)are there any other problems I should be aware of?

The application deadlocks at least twice a week because of slects with updates written by the vendor in their code(I checked he laert log). Any recommendatiuons around this?

David Spaisman Received on Sun Feb 23 2003 - 22:55:57 CST