Re: Oracle Performance on V240

See response in-line

>
> From what I've seen, the V240 is a solid workhorse. The config sounds
> reasonable, but ...
>
> a) I've found that performance concerns are addressed first by good
> application design (that it's not a simple cut 'n paste of a SQL Server
> application) and proper memory management.
>
> You don't mention the memory available.
>

8G

> b) With your config, it will be difficult to place the log files on a
> drive other than the binaries or the data. Log file performance is a
> crucial part of database performance. Log file protection is a crucial
> part of database recovery and longevity.
>

Thanks. Didnt think about this one. But generally, we'll cut the logs and back them up as often as possible. Would it be better to have the logs on the drive with the binaries or data?

> c) What version and edition of Oracle are you using? If you have 10g
> Enterprise, you can turn over monitoring and recommendations to the AWR
> and ADDM. If not, plan on monitoring and tweaking.
>

Oracle 9.2.06

> --
> Hans Forbrich
> Canada-wide Oracle training and consulting
> mailto: Fuzzy.GreyBeard_at_gmail.com
> *** Top posting guarantees I will not respond further ***
>
Received on Wed Nov 02 2005 - 12:56:15 CST