We are looking at our db performance (10gR2 on Win 2003 SP2) and am wondering what setting would give the better performance for the db. The server is only hosting the oracle backend for BMC Remedy 7.1p6. Its a DL580 with 8GB ram.
The factors I'm looking at at the OS level is:
- Paging: system managed or
- Processor scheduling: Programs or Background services
- Memory usage: Programs or System cache
- File paging: Custom and size, System managed, None