WGU D330 study guide
WGU D330 study guide
Study online at https://quizlet.com/_hkn154
1. Oracle Instance A combination of Oracle memory structures (SGA/PGA) and back-
ground processes that allow database access.
2. Oracle database A collection of physical files, like datafiles, control files, and redo logs,
that store Oracle data.
3. Tablespace A logical storage unit within the database that contains data files.
4. Datafile A physical file on disk that stores data for a tablespace.
5. Redo log Files that store a record of all changes made to the database
6. Control File A critical file that contains metadata about the database structure and
is needed to start the DB.
7. SGA (System Global Area) Shared memory used by all sessions; includes cache, buffers, and
pools.
8. PGA (Program Global Private memory area used by a server process for sort operations and
Area) session info.
9. Shared Pool Part of SGA that stores SQL and PL/SQL code for reuse.
10. Buffer Cache Stores recently accessed data blocks to reduce disk I/O.
11. Redo Log Buffer Temporarily holds redo data before it's written to redo logs. Stores
changes for recovery
12. Large Pool Optional SGA area used for backups, I/O, and parallel queries.
13. Java Pool Memory area in SGA to support Java execution.
14. Streams Pool SGA area used for Oracle Streams data replication.
15. DBWn (Database Writer) Writes dirty data blocks from the buffer cache to disk.
, WGU D330 study guide
WGU D330 study guide
Study online at https://quizlet.com/_hkn154
16. LGWR (Log Writer) Writes redo log buffer contents to the redo log files.
17. CKPT (Checkpoint) Signals DBWn to write data and updates file headers during check-
points.
18. SMON (System Monitor) Performs recovery during startup and cleans up temp segments.
19. PMON (Process Monitor) Cleans up resources from failed user sessions.
20. ARCn (Archiver) Archives redo logs when in ARCHIVELOG mode.
21. LREG (Listener Registra- Registers the instance with the listener for client connections.
tion)
22. Startup NOMOUNT Starts instance and allocates memory, but doesn't open control files.
Also starts background processes
23. Startup MOUNT Starts instance and reads control files, but doesn't open datafiles.
24. Startup OPEN Fully opens the database for use. Accesses datafiles for normal oper-
ations
25. Shutdown NORMAL Waits for all users to disconnect before shutting down.
26. Shutdown IMMEDIATE Rolls back transactions and shuts down without waiting.
27. Shutdown TRANSAC- Waits for active transactions to complete before shutting down.
TIONAL
28. Shutdown ABORT Forces immediate shutdown without cleanup.
29. SPFILE A binary initialization file that allows dynamic changes to parameters.
30. PFILE A text-based initialization file that must be edited manually and
restarted.
WGU D330 study guide
Study online at https://quizlet.com/_hkn154
1. Oracle Instance A combination of Oracle memory structures (SGA/PGA) and back-
ground processes that allow database access.
2. Oracle database A collection of physical files, like datafiles, control files, and redo logs,
that store Oracle data.
3. Tablespace A logical storage unit within the database that contains data files.
4. Datafile A physical file on disk that stores data for a tablespace.
5. Redo log Files that store a record of all changes made to the database
6. Control File A critical file that contains metadata about the database structure and
is needed to start the DB.
7. SGA (System Global Area) Shared memory used by all sessions; includes cache, buffers, and
pools.
8. PGA (Program Global Private memory area used by a server process for sort operations and
Area) session info.
9. Shared Pool Part of SGA that stores SQL and PL/SQL code for reuse.
10. Buffer Cache Stores recently accessed data blocks to reduce disk I/O.
11. Redo Log Buffer Temporarily holds redo data before it's written to redo logs. Stores
changes for recovery
12. Large Pool Optional SGA area used for backups, I/O, and parallel queries.
13. Java Pool Memory area in SGA to support Java execution.
14. Streams Pool SGA area used for Oracle Streams data replication.
15. DBWn (Database Writer) Writes dirty data blocks from the buffer cache to disk.
, WGU D330 study guide
WGU D330 study guide
Study online at https://quizlet.com/_hkn154
16. LGWR (Log Writer) Writes redo log buffer contents to the redo log files.
17. CKPT (Checkpoint) Signals DBWn to write data and updates file headers during check-
points.
18. SMON (System Monitor) Performs recovery during startup and cleans up temp segments.
19. PMON (Process Monitor) Cleans up resources from failed user sessions.
20. ARCn (Archiver) Archives redo logs when in ARCHIVELOG mode.
21. LREG (Listener Registra- Registers the instance with the listener for client connections.
tion)
22. Startup NOMOUNT Starts instance and allocates memory, but doesn't open control files.
Also starts background processes
23. Startup MOUNT Starts instance and reads control files, but doesn't open datafiles.
24. Startup OPEN Fully opens the database for use. Accesses datafiles for normal oper-
ations
25. Shutdown NORMAL Waits for all users to disconnect before shutting down.
26. Shutdown IMMEDIATE Rolls back transactions and shuts down without waiting.
27. Shutdown TRANSAC- Waits for active transactions to complete before shutting down.
TIONAL
28. Shutdown ABORT Forces immediate shutdown without cleanup.
29. SPFILE A binary initialization file that allows dynamic changes to parameters.
30. PFILE A text-based initialization file that must be edited manually and
restarted.
