database

Operating System Tuning for Oracle Database

This chapter describes how to tune Oracle Database. It contains the following sections: Importance of Tuning Operating System Tools Tuning Memory Management Tuning Disk I/O Monitoring Disk Performance System Global Area Tuning the Operating System Buffer Cache 1.1 Importance of Tuning Oracle Database is a highly optimizable software product. Frequent tuning optimizes system performance and …

Operating System Tuning for Oracle Database Read More »

Tunning AIX for Oracle Database

Memory and Paging Disk I/O Issues CPU Scheduling and Process Priorities Oracle Real Application Clusters Information Setting the AIXTHREAD_SCOPE Environment Variable Memory and Paging Memory contention occurs when processes require more memory than is available. To cope with the shortage, the system pages programs and data between memory and disks. Controlling Buffer-Cache Paging Activity Excessive …

Tunning AIX for Oracle Database Read More »

Oracle: How to Export / Import Database Schema

1. EXPORT: exp system@test owner=test123 file=d:oracleuser.dmp log=d:oracleuserdump.log rows=y statistics=none feedback=100 indexes=y consistent=y compress=n; (for individual tables=table1,table2,…..) 2. IMPORT: imp system@test fromuser=test123 touser=test123 file=d:oracleuser.dmp log=d:oracleuser11.log ignore=y rows=y indexes=y feedback=100;

Scroll to Top