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.

Database configuration and logging

Database configuration and logging - 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

Database configuration and logging

“

- [Instructor] Along with physical and logical architecture, there are secondary directories and file structures used for configuration, connectivity and logging. It's important to know what these are and how to use them properly. For each database, there is a parameter file with configuration information referred to as a server parameter file, a.k.a. spfile. The text version of the file is referred to as an initialization parameter file, also known as a pfile, and both contain critical configuration parameters about how the database instance is configured. In RAC, each database node will have its own spfile. Parameter information can be attained inside the database by querying the v$parameter view or from using the show parameter command. It can be really helpful, if you know how to look at the v$parameter data dictionary view, as it can offer you a lot of information. So we're going to query right now. I'm in my SQL Plus screen, just from my command line, just like I always like to…

Contents