How the SMON process is used to write into LOG files? - oracle
Next Page »
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.
Next Page »
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
Oracle Composite Data-types
Oracle Data Types
Oracle DCL TCL
Oracle DML Commands
Oracle Error Handling
Oracle Functions, Procedures, Packages
Oracle Import export
Oracle Sub Queries
Oracle Backup Recovery
Oracle 11g dba
Oracle Large objects
Oracle Transaction Processing
Oracle database Tuning
Oracle Stored Procedure