My Oracle Support Banner

Master Note: Overview of Unix Resources (Doc ID 1498952.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Purpose

This note provides information about administering Oracle Database on UNIX-based operating systems. You must set Oracle Database environment variables, parameters, and user settings for Oracle Database to work.

Scope

Database performance is bounded by the system resources. Sometimes, poor database performance can be caused by faulty configuration of the instance and database. Sometimes, it can be caused by abnormal resource consumption by an Oracle transaction, user, or process.
Memory, CPU, and I/O are the three most common resources consumed by Oracle. We will discuss these resources, and list some of the commonly used tools that monitor them.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 Environment Variables
 1. Oracle Database Environment Variables
 2. UNIX Environment Variables
 Memory Requirements
 Configuring Swap Space
 Configuring Huge Pages
 Configuring Kernel Parameters
 Configuring Resource Limits
 CPU Utilization
 I/O Utilization
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.