First page Back Continue Last page Graphics
Architecture: Processes Workshop
Notes:
Architecture: Processes Workshop
Hands-on Exercises
Connect to your instance with your DBA-level user.
What background processes are active on your server? If you are using a UNIX (or Linux) server, use both an operating system command and a SQL statement to list active processes.
What is the maximum number of archive processes that can be started on your instance?
Written Exercises
What process will write dirty blocks back to a database file when a checkpoint occurs?
What process will parse and execute SQL statements on behalf of a user?
What process will, when a COMMIT is issued, write the redo log buffer contents to the redo log file?