Explanations of Oracle Data Dictionary

Oracle stores the definition of data along with the data. This data definition meant the data about the data i.e. Information about the users, table, columns, concerns, and all objects created in the database. This information is stored in the form of a table which is called a data dictionary. The data dictionary is a … Read more

Write and Explain the various Oracle Processes

The various oracle processes are listed and explained below Log Writer Background Process (LGWR): This component writes the redo entries from redo log buffers when the user executes the commit statement or the buffer exceeds 1/3rd of the redo log buffers. Database Writer Background Process(DBWR): This component will write all the dirty blocks whenever checkpoints … Read more