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.
Sincerely,
Bob Adase
Sorry to say, that your question is too general - it is not enough to answer your question even by pages. Because it is a big topic in Oracle.
Basically for performance tuning and consideration:
- you have to know the concept of SGA (memory) and how to tune the memory.
- you have to know the concept of sql parsing. this is important in creating an effecient sql command
- you have to know the architecture of oracle db - such as buffer log, data buffer, what process is associated with it etc.
thanks
wandi