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.
What are the types of Calculated columns available? - oracle
Types of Calculated columns - In forms there are 2 types of calculated columns 1. formula column 2.summary column...
Oracle trigger vs. stored procedure
Difference 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...
Row level and statement level trigger
Row level and statement level trigger - Row Level Trigger is fired each time row is affected by Insert, Update or Delete command...
Post your comment