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: memory
Find Top Running Processes by Memory and CPU Usage
1. top command The top command gives real-time information about the running processes as well as a summary of system information. It displays uptime, load averages, CPU…
View More Find Top Running Processes by Memory and CPU Usage
How to troubleshoot high memory usage in linux
There are situations where your server shows unintended behaviors like a slow response from websites, failures with services, inability to start applications, server crashes etc.…
View More How to troubleshoot high memory usage in linux
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
How to Increase MEMORY_TARGET
Before you can increase memory in oracle database, you must first understand four oracle memory parameters which govern the instance. SGA_TARGET and SGA_MAX_SIZE MEMORY_TARGET and…
View More How to Increase MEMORY_TARGET