Oracle Database optimization and optimization steps

Oracle Database optimization and optimization steps

Identify the current status of the system

System server model

CPU speed and quantity

Memory size

I/O device status

Network Conditions

Number of system users and number of concurrent users

Current system CPU usage and memory usage

Current status of the I/O system (average read/write Response Time, I/O wait time, etc)

So how can we get the information we need above? It is easy to know the system server model, CPU speed, quantity, and memory size. In this case, the information about the I/O device, network conditions, number of system users, number of concurrent users, current system CPU usage, memory usage, and current I/O system status (average read/write Response time, I/O wait time) in the Windows and Linux operating systems.

Command for viewing Linux operating system information