From the course: Oracle Database 12c: Administration
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Server processes - Oracle Database Tutorial
From the course: Oracle Database 12c: Administration
Server processes
- [Instructor] Are you with me so far? Great. Now, let's divert our attention to the final piece of the Oracle puzzle. The last of the three major components, making up the Oracle database architecture. These are the Oracle SPs, or, in their full name, server processes. Their purpose, simple. Oracle starts up server processes to handle the requests of client processes connected to the Oracle database. A client process, which is basically a fancy name to call a user session that is connected to the database, always communicates through a server process. Server processes are created on behalf of a session that initiated the connection to the Oracle database. These server processes performs one or more of the following tasks. The first role of the server processes is to pass and execute SQL statements issued by the connecting session. So when a user issues a select statement, the server process is responsible for making sure the select statement is syntactually correct and find the best…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.