{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Database Architecture Components

Database Architecture Components - Database Architecture...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Database Architecture Components User Processes: Starts when a tool is started Terminates when the user logs out Includes the UPI UPI generates calls to the Oracle server Server Processes: Runs on the same machine as the Oracle server Created when a user requests a connection Terminated when a user disconnects Uses the PGA Includes the OPI Returns status information and results Shared pool stores the most recently used data dictionary information DBWn- writes changed data from the database buffer cache to the data files LGWR- records changes that are registered in redo log bugger to redo log file SMON- instance recovery during instance startup PMON- process recovery when a user process fails, cleaning up cache CKPT- updating database status information Data files, redo log files, control files – Three types of files in a database Database related files: parameter file, password, archived redo log Processing a Query PARSE EXECUTE FETCH Shared pool : library cache and the data dictionary cache
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}