1 / 13

Database Architecture

Database Architecture. Transaction Processing Query Processing Optimization. Samuel S. Conn , Asst. professor. Transaction Processing. SMON. PMON. SGA. SQL. Redo Log Buffer. Database Buffer Cache. Shared Pool. DBWR. CKPT. LGWR. ARCH. Control Files. Redo Logs. Datafiles.

sharne
Download Presentation

Database Architecture

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database Architecture • Transaction Processing • Query Processing • Optimization Samuel S. Conn, Asst. professor

  2. Transaction Processing SMON PMON SGA SQL Redo Log Buffer Database Buffer Cache Shared Pool DBWR CKPT LGWR ARCH Control Files Redo Logs Datafiles

  3. Transaction Processing SMON PMON SGA Redo Log Buffer Database Buffer Cache Shared Pool DBWR CKPT LGWR ARCH Control Files Redo Logs Datafiles

  4. Transaction Processing SMON PMON SGA Redo Log Buffer Database Buffer Cache Shared Pool DBWR CKPT LGWR ARCH Control Files Redo Logs Datafiles

  5. Transaction Processing SMON PMON SGA Redo Log Buffer Database Buffer Cache Shared Pool DBWR CKPT LGWR ARCH Control Files Redo Logs Datafiles

  6. Transaction Processing SMON PMON SGA Redo Log Buffer Database Buffer Cache Shared Pool DBWR CKPT LGWR ARCH Control Files Redo Logs Datafiles

  7. Transaction Processing SMON PMON SGA Redo Log Buffer Database Buffer Cache Shared Pool DBWR CKPT LGWR ARCH Control Files Redo Logs Datafiles

  8. Transaction Processing SMON PMON SGA Redo Log Buffer Database Buffer Cache Shared Pool DBWR CKPT LGWR ARCH Control Files Redo Logs Datafiles

  9. Transaction Processing SMON PMON SGA Redo Log Buffer Database Buffer Cache Shared Pool DBWR CKPT LGWR ARCH Control Files Redo Logs Datafiles

  10. Query Processing SMON PMON Optimizer code SGA SQL Redo Log Buffer Database Buffer Cache Shared Pool DBWR CKPT LGWR ARCH Control Files Redo Logs Datafiles

  11. Query Processing SMON PMON Query Plan Execution SGA Redo Log Buffer Database Buffer Cache Shared Pool DBWR CKPT LGWR ARCH Control Files Redo Logs Datafiles

  12. Query Processing SMON PMON SGA Redo Log Buffer Database Buffer Cache Shared Pool DBWR CKPT LGWR ARCH Control Files Redo Logs Datafiles

  13. Optimization SMON PMON Optimizer Code RBO CBO SGA Redo Log Buffer Database Buffer Cache Shared Pool DBWR CKPT LGWR ARCH Control Files Redo Logs Datafiles

More Related