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
• 
  

How to optimize the Oracle database?

.. In fact, the requirements for each project are different, and the solutions are certainly different.
I/O, cpu, and memory are actually part of database optimization. The simplest way is to find the bottleneck.
If it is a bottleneck, the shortest board should be stretched, just like a bucket.

Because the database itself cannot be absolutely perfect, it can only be said that in the current demand, the current resource situation as much as possible to do the best.
If you really want to say the essence, it is just a random response.

Pay more attention to Top 5 events, try to eliminate waiting events, reduce physical reads, and reduce hard parsing...

Oracle Database optimization tutorial

I posted an optimized video sharing in the dba post bar. This is not a connection. You can paste it and see it on my Baidu online disk.