New Mandatory Background Processes In Oracle Database 12cR2-: Mandatory background processes are present in all typical database configurations. These processes run by default in a read/write database instance started with a minimally configured initialization parameter file. BWnn (Database Writer Processes) Cleanup Main Process (CLMN) Cleanup Helper Processes (CLNN) LGnn (Log Read more…
Oracle Processes Read/Write from/in (Datafile/Redo Log File/Archive Log File/Control File) In Oracle Database 5 Background Processes will Read/Write from Datafile Redo Log File Archive Log File Control File & these 5 Background Processes are-: CKPT DBWN LGWR ARCn SERVER PROCESS 1-CKPT -: Read/Write from/in Data File Headers. Read/Write from/in Control Read more…
ORA-00845: MEMORY_TARGET not supported on this system When I was opening 12cR2 database after installation I get a ORA-00845 error. Because I am using Automatic Memory Management (AMM) feature & If Shared Memory file system (shmfs) is not big enough to accommodate memory_target and memory_max_target. Then i will get this Read more…
According to the U.S. Department of Labor’s Bureau of Labor Statistics, Employment of database administrators (DBAs) is projected to grow 11 percent from 2016 to 2026, faster than the average for all occupations. Growth in this occupation will be driven by the increased data needs of companies in all sectors Read more…