How the SMON process is used to write into LOG files? - oracle
How the SMON process is used to write into LOG files?The Shared Global Area is where SMON process runs. Once the redo log buffer is full then SMON with the help of LOGWRITER (LGWR) writes into the log files.
|
Oracle trigger vs. stored procedureDifference between trigger and stored procedure - Procedure runs only when one call them manually whereas a trigger runs when there is any activity (insert,update,delete) on table on which the trigger is written...