Oracle Performance settings
Posted on 2001-08-21
I have a question that I hope you can help me with.
I work as a server admin for a Pharmaceutical Company. They want us to observe the performance of a particular server they are having problems with. I don't have any experience with Oracle so I am not sure what the best route to take is.
The server is a Compaq PL 3000, Dual 333 MHZ CPU, 256 MB RAM, 3 Logical Hard Drive volumes (1st. Operating System, 2nd. Swap and 3rd. Data) and running Windows NT 4.0 SP5a and Oracle 7.
What is the best configuration and monitoring I can do for this box? They want us to monitor the utilization of the server for period of an hour or two. I would like to know how is the best way to setup this box in terms of Memory, Swap, CPU tasks and general setup of Oracle software. Any advice/help would be greatly appreciated.