Re: Best setup, given the resources....

oracle_man wrote:
> All,
>
> My client has purchased 2 AIX p5xx boxes, 4 processors, 8GB ram, and
> 4x50GB raw disk, and 2x8GB cooked file system, and minimal internal
> disk(internal disk for OS only).
>
> The software: Oracle 10.2 STANDARD Edition (sorry for yelling).
>
> I am soliciting best configs given my resources.
>
> I propose using the 4x50GB raw for ASM disk groups. Should I create 1
> big group, or 4 groups. I also plan to backup to flash recovery area,
> block change tracking, etc...
>
> The 2x8GB cooked files are for binaries and dump.
>
> Any suggestions are appreciated.

It depends.

It depends on many factors that you didn't mention and they all relate to the SLA. Without knowing that no help is possible.

Is it a single-user DSS system used once a month to create a sales report or the 300,000 simultaneous connections 7x24 of Amazon.com?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org