Steps to optimize and tune an Oracle database

Identify the current state of the system

• Model of the system server

• CPU the speed and quantity of

• Memory size

• I/O Equipment Situation

• Network status

• Number of system users and number of concurrent users

• Current system CPU usage, Memory utilization

• currently I/O the state of the system (average read-write response time, I/O wait time, etc.)

So how do you get the information you need? For the model of the system server, the speed of the CPU, and the amount and memory size, this is very easy to know. The following are descriptions of how I/O devices, network conditions, number of system users, number of concurrent users, current system CPU usage, memory usage, current I/O system status (average read and write response time, I/O wait time) are obtained in the window System and Linux operating system.

• Linux operating System Information view command
• 
  

Steps to optimize and tune an Oracle database