Re: Raise Performance Dual PPRO Server under NT, how?

Start by performing a full analysis of your system *before* you change anything.

1. Analyse the execution plans for the sql your reports issue. Tune the sql.
2. Monitor the Oracle enviroment whilst your report is running. Tune as necessary, being careful you don't skew your entire system around just this report.
3. Do point 2, but this time for your OS (UNIX, NT, etc.)

The above isn't your solution, it's just where you should start. Come back with some hard data if you run into any particular problems.

MotoX.

Michael Menzel wrote in message <6r6ufs$7gs$1_at_news00.btx.dtag.de>...
>Hello Oracel-User,
>
>i have performance problems by using
>Sales-reports with my ora-db under nt.
>One report runs over 1,5 hours.
>
>Its an 200-ppro-dual machine with 256 MB!
>
>What can i do?
>
>
>Thanks Mikel
Received on Wed Aug 19 1998 - 07:53:48 CDT