Re: oracle 8.0.6 and rule-based optimizer

david spaisman wrote:

> 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:
>
> 1) 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

Talk to management about bringing in an independent consultant to evaluate the cost to the organization of keeping this pathetic dinosaur or moving to something supported by Oracle in the current millenium. It will likely never get any better than it currently is. And an upgrade to the operating system could make it substantially worse.

If they won't listen ... polish up your resume and get out while you still have marketable skills.

If you need references to an independent consultant in your area you can contact me off-line.

Daniel Morgan Received on Mon Feb 24 2003 - 01:46:41 CST