IT World

RDBMS, Unix and many more…

  • Home
  • About
  • Privacy

AIX

AIX Oracle tuning

Posted on June 15, 2010, updated on September 2, 2021 by Yannick Jaquier

Table of contents

  • Preamble
  • Environment variables
  • Maximum number of processes
  • VMM tuning
    • VMM background
    • maxclient%
    • maxperm%
    • minperm%
    • lru_file_repage
    • page_steal_method
  • Memory monitoring
  • LOCK_SGA
  • Large page memory
  • Asynchronous I/O
  • Concurrent I/O
  • Filesystems tuning
  • I/O monitoring
  • References

Continue reading

AIX, Oracle Tuning 12 Comments

AIX basic commands

Posted on June 3, 2010, updated on September 2, 2021 by Yannick Jaquier

Table of contents

  • AIX release
  • General hardware information
  • Process scheduler
  • General AIX performance tools
  • In depth tools
  • Trace based tools
  • Generic monitoring
  • Memory monitoring
  • I/O monitoring
  • Network monitoring
  • CPU monitoring
  • File system defragmentation
  • References

Continue reading

AIX Administration Leave a comment

Search

Certifications

Oracle Certified Master (OCM) Oracle Certified Professional (OCP) Oracle Certified Associate (OCA)
Microsoft Azure Fundamentals Microsoft Azure Solutions Architect Expert

Tags Cloud

11gR2 (9) 12cR1 (6) Active Session History (ASH) (2) Adaptive Cursor Sharing (ACS) (2) Administration (37) Ambari (1) Application Continuity (AC) (1) Automatic Data Optimization (ADO) (1) Automatic Diagnostic Repository (ADR) (1) Automatic Memory Management (AMM) (2) Automatic Segment Space Management (ASSM) (1) Automatic Shared Memory Management (ASMM) (4) Automatic Storage Management (ASM) (2) Automatic Workload Repository (AWR) (3) Backup (7) Benchmark (7) Bug (1) Cloud Control (2) cluster (1) Compression (3) Connection Manager (1) Container (3) Database Links (1) Database Resource Manager (DBRM) (3) Database Vault (2) Data Guard (7) Data Recovery Advisor (2) Data Redaction (1) Development (3) Directory Naming (3) Docker (4) Fast Application Notification (FAN) (1) Fast Connection Failover (FCF) (1) Fast Recovery Area (FRA) (1) Fine-Grained Access Control (FGAC) (1) Flashback (1) GATHER_STATS_JOB (1) GoldenGate (3) Grid Control (4) Grub (1) Health Monitor (2) Heat Map (1) High Availability (26) HP Integrity Virtual Machines (HPVM) (1) Huge Pages (2) Information Lifecycle Management (ILM) (1) InnoDB (2) Instance Caging (1) Machine Learning (1) Multi-Master Replication Manager (MMM) (1) Non-Uniform Memory Access (NUMA) (3) OpenStack (2) OpenView Performance Agent (OVPA) (1) Oracle Configuration Manager (OCM) (1) Oracle Label Security (OLS) (1) oradebug (1) Patch (2) PL/SQL (1) Privilege Analysis (1) Process Resource Management (PRM) (2) Program Global Area (PGA) (1) Real Application Clusters (RAC) (5) Real Application Testing (RAT) (1) Recovery (2) Redo Log (2) RMAN (5) Security (23) Segment Advisor (2) Single Client Access Name (SCAN) (1) Spark (1) SQL (26) SQL*Net (3) SQL*Plus (1) SQL Access Advisor (SAA) (2) SQL Monitoring (1) SQL Performance Analyzer (SPA) (1) SQL Plan Management (SPM) (1) SQL Profile (1) SQL Trace (1) SQL Tuning Advisor (STA) (5) SQL Tuning Set (STS) (1) Streams (3) System Global Area (SGA) (1) Tivoli Data Protection for Oracle (TDPO) (2) Tivoli Storage Manager (TSM) (1) Transaction Guard (TG) (1) Transparent Application Failover (TAF) (1) Transparent Data Encryption (TDE) (1) Tuning (44) Virtualization (2) Virtual Memory (2) Virtual Private Database (VPD) (2) VxDMP (1) VxFS (1) VxVM (1)

Categories

  • AIX (2)
  • Couchbase (2)
  • Hadoop (21)
  • HPUX (6)
  • Linux (28)
  • MariaDB (10)
  • mongoDB (1)
  • MySQL (24)
  • Oracle (137)
  • PostgreSQL (2)
  • Python (3)
  • SQL Server (3)

Recent Comments

  • Kubernetes on virtual machines hands-on – part 3 on Kubernetes on virtual machines hands-on – part 2
  • Yannick Jaquier on Fine-Grained Access Control (FGAC) hands-on
  • Mason on Fine-Grained Access Control (FGAC) hands-on
  • Kubernetes on virtual machines hands-on - part 2 on Kubernetes on virtual machines hands-on – part 1
  • Yannick Jaquier on GoldenGate for Big Data and Kafka Handlers hands-on – part 2

Blogroll

  • Ask Tom
  • Data Virtualizer
  • Exile on Keyboard St. (French)
  • Kevin Closson’s Oracle Blog
  • MySQL Performance Blog
  • Official Pythian Blog
  • Oracle Optimizer
  • Oracle Scratchpad
  • Richard Foote’s Oracle Blog
  • Tanel Poder's blog
  • The Oracle Instructor

Visitors

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
IT World Proudly powered by WordPress