Database Performance Tuning Steps Oracle Performance Tuning

Channel Avatar
Comment
X
Share
Database Performance Tuning Steps Oracle Performance Tuning
Database Performance Tuning Steps Oracle Performance Tuning
Database #tuning aims to maximize use of system resources to perform work as efficiently and rapidly as possible. Most systems are designed to manage their use of system resources, but there is still much room to improve their efficiency by customizing their settings and #configuration for the #database and the #DBMS.

00:00 Performance issue in database
00:35 Business Logic
06:23 Data Design
07:48 Application design
10:38 Change Database structure (Indexes)
11:30 Tuning the SQL
11:55 What do mean by effective SQL
16:58 Access Path-Change the indexes
22:39 Instance tuning (RAM)
24:58 Tune the I/O-Physical storage
30:04 Tune resources-Locks
31:31 Tune the server

Website: https://www.dbagenesis.com/
Facebook: https://www.facebook.com/dbagenesis/
Instagram: https://www.instagram.com/dbagenesis/
Twitter: https://twitter.com/DbaGenesis

Take the opportunity to connect and share this video with your friends and family if you find it useful.

Read Also

Leave a Reply

Your email address will not be published. Required fields are marked *