Re: Oracle - solving performance problem

On 7 Oct 2005 14:42:52 -0700, mark_sensfan_at_hotmail.com wrote:

>Anyone have any opinions on the best course of action? How should one
>handle this amount of data and maintain performance?

Actually you have forgotten three things

• You need to tune the application
• You need to tune the application
• You need to tune the application After you have done that
• you need to tune the application, because it is unscalable

If you can't tune the application because it is canned and bought you need to
- dump it
- sue the vendor or fire the developers

Hardware will never compensate for a badly written application. You obviously have one. A SGA of several Gigs is fully ridiculous.

--
Sybrand Bakker, Senior Oracle DBA