What is RAC?RAC stands for Real Application cluster. It is a clustering solution from Oracle Corporation that ensures high availability of databases by providing instance…
View More Oracle RAC interview Questions
Category: Oracle
Oracle
What is the difference between RPO and RTO ?
Predicting a future disaster is nearly impossible, but fortunately, preparing for one and deciding your organizationโs aftermath is getting easier. Their abbreviated names are very…
View More What is the difference between RPO and RTO ?
Oracle Database Architecture
Oracle Database employs a client-server architecture, with the database server and client connections running in separate processes. The server process manages data and resources, and…
View More Oracle Database Architecture
How to install Oracle Database 19c on CentOS 8
Environment Specification: We have provisioned a minimally installed CentOS 8 virtual machine with following specifications. CPU – 3.4 Ghz (2 cores) Memory – 8 GB Storage – 80 GB Operating…
View More How to install Oracle Database 19c on CentOS 8
Oracle Memory Management
Memory management involves maintaining optimal sizes for the Oracle instance memory structures as demands on the database change. Initialization parameter settings determine how SGA and…
View More Oracle Memory Management
Oracle RMAN vs Export?
RMAN and export both backup tables, and they both support flashback database, but there are some important differences: Data Pump Export (expdp)ย – The export utility…
View More Oracle RMAN vs Export?
Asynchronous IO for file System using FILESYSTEMIO_OPTIONS
We noticed that on one of our servers oracle trc files accumulated too much. it started piling up after we increased /dev/shm and sga. In trace…
View More Asynchronous IO for file System using FILESYSTEMIO_OPTIONS
Using the Oracle 11GR2 database flash cache
Oracle just released a patch which allows you to use the database flash cache on Oracle Enterprise Linux even if you don’t have exadata storage. …
View More Using the Oracle 11GR2 database flash cache
Oracle Manageability Monitor Process (MMON) Background Process
Oracle Manageability Monitor Process (MMON) Background Process. Performs many tasks related to manageability, including taking Automatic Workload Repository snapshots and performing Automatic Database Diagnostic Monitor analysis…
View More Oracle Manageability Monitor Process (MMON) Background Process
What is the usecase of dev shm
/dev/shm is a temporary file storage filesystem (see tmpfs) that uses RAM for the storage. It can function as shared memory that facilitates IPC. It is a…
View More What is the usecase of dev shm