From the course: Complete Guide to Oracle Database 23ai: From Beginner to Advanced

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Instance tuning

Instance tuning - Oracle Database Tutorial

From the course: Complete Guide to Oracle Database 23ai: From Beginner to Advanced

Start my 1-month free trial Buy for my team

Instance tuning

“

- [Instructor] Every database has a unique instance that belongs to that CDB and PDB in Oracle 23c. The database instance provides specific values for everything from database block size, memory allocation, and parameter settings to best serve the database. But parameter values may not be most optimized and need to be adjusted. The values in the SPFILE created may have been copied from a database with a different use. The workload over time may have evolved, requiring changes to these values. The control file and the SPFILE will be the static location for the changes in instance tuning. Value changes can be done dynamically for many parameters, which means a change can be put into place immediately. But for some, they can only be made in memory and won't go into effect until after the database cycle is performed. A change can also be done for parameter values at the session or a database level or an update to the instance using the SPFILE is performed by an ALTER SYSTEM SET command. A…

Contents