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
Tag: oracle
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
How much memory is truly used by my Oracle instance?
There are many posts about the amount of memory that is taken by the Oracle database executables and the database SGA and PGA. The reason…
View More How much memory is truly used by my Oracle instance?
How to trace SQL sessions to identify Oracle Database bottlenecks
Want your database to run faster? While common tuning techniques can prove quite helpful in resolving many performance issues, they donβt show the details of all the…
View More How to trace SQL sessions to identify Oracle Database bottlenecks
How to get access to download older Oracle versions?
In the Software Delivery Cloud (formerly known as eDelivery) you will find the following base releases of the Oracle database: And the other source for downloads is oracle.com.…
View More How to get access to download older Oracle versions?
Oracle COMPATIBLE VS OPTIMIZER_FEATURES_ENABLE
COMPATIBLE PARAMETER Understanding the COMPATIBLE Initialization ParameterIn Oracle Database 19c, when the COMPATIBLE initialization parameter is not set in your parameter file, the COMPATIBLE parameter…
View More Oracle COMPATIBLE VS OPTIMIZER_FEATURES_ENABLE