Free cookie consent management tool by TermsFeed

IT World

RDBMS, Unix and many more…

  • Home
  • About
  • Privacy

Database Resource Manager (DBRM) to manage and prioritize resources

Posted on July 14, 2010, updated on May 2, 2018 by Yannick Jaquier

Table of contents

  • Preamble
  • Database resource manager configuration
  • Database resource manager testing
  • References

Continue reading

Oracle Database Resource Manager (DBRM), Tuning 1 Comment

PGA and SGA sizing

Posted on July 13, 2010, updated on January 26, 2016 by Yannick Jaquier

Table of contents

  • Preamble
  • PGA used by processes
  • How to increase PGA per process
  • References

Continue reading

Oracle Automatic Shared Memory Management (ASMM), Program Global Area (PGA), System Global Area (SGA) Leave a comment

HP Process Resource Manager (PRM)

Posted on July 2, 2010, updated on April 19, 2022 by Yannick Jaquier

Table of contents

  • Preamble
  • Configuration
  • CPU testing
  • Memory testing
    • Private memory
    • Shared memory
  • Disk testing
  • Useful commands
  • References

Continue reading

HPUX Process Resource Management (PRM), Tuning 3 Comments

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 October 16, 2023 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

LogMiner setup and investigation with Oracle 10g and above

Posted on June 2, 2010, updated on October 26, 2016 by Yannick Jaquier

Table of contents

  • Preamble
  • Instantiate LogMiner
  • How to get redo size
  • Redo log block size
  • References

Continue reading

Oracle Administration, Redo Log, SQL 2 Comments
  • Page 41 of 44
  • « First
  • ‹ Previous
  • 39
  • 40
  • 41(current)
  • 42
  • 43
  • Next ›
  • Last »

Search

Certifications

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

Tags Cloud

Active Session History (ASH) (2) Adaptive Cursor Sharing (ACS) (2) Administration (42) 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 SQL Plan Management (ASPM) (1) Automatic SQL Tuning Sets (ASTS) (1) 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 (4) Database Links (1) Database Migration Assistant for Unicode (DMU) (2) Database Resource Manager (DBRM) (3) Database Vault (2) Data Guard (9) Data Recovery Advisor (2) Data Redaction (1) DBMS_REDEFINITION (1) Development (12) Directory Naming (3) Docker (4) Edition-Based Redefinition (EBR) (1) Exadata (1) Fast Application Notification (FAN) (1) Fast Connection Failover (FCF) (1) Fast Recovery Area (FRA) (1) Fine-Grained Access Control (FGAC) (1) Flashback (1) Galera (3) GATHER_STATS_JOB (1) GoldenGate (6) Grid Control (4) Grub (1) Health Monitor (2) Heat Map (1) High Availability (35) HP Integrity Virtual Machines (HPVM) (1) Huge Pages (2) In-Memory (1) Information Lifecycle Management (ILM) (1) InnoDB (2) Instance Caging (1) JSON (1) Kafka (3) Machine Learning (1) Multi-Master Replication Manager (MMM) (1) Multitenant (5) 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) Polymorphic Table Functions (PTF) (1) Privilege Analysis (1) Process Resource Management (PRM) (2) Program Global Area (PGA) (1) Real Application Clusters (RAC) (5) Real Application Testing (RAT) (2) Recovery (2) Redo Log (2) Resource Governor (1) RMAN (5) Security (27) Segment Advisor (2) Single Client Access Name (SCAN) (1) Spark (1) SQL (36) SQL*Net (3) SQL*Plus (1) SQL Access Advisor (SAA) (2) SQL Monitoring (2) SQL Performance Analyzer (SPA) (1) SQL Plan Management (SPM) (2) 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) Transactional Event Queues (TxEventQ) (1) Transaction Guard (TG) (1) Transparent Application Continuity (TAC) (1) Transparent Application Failover (TAF) (1) Transparent Data Encryption (TDE) (1) Tuning (54) Virtualization (2) Virtual Memory (2) Virtual Private Database (VPD) (2) VxDMP (1) VxFS (1) VxVM (1)

Categories

  • AIX (2)
  • Couchbase (2)
  • Databricks (5)
  • Hadoop (21)
  • HPUX (6)
  • Linux (30)
  • MariaDB (20)
  • MongoDB (1)
  • MySQL (30)
  • Oracle (156)
  • PostgreSQL (8)
  • Python (3)
  • SQL Server (11)

Recent Comments

  • SQL Access Advisor and SQL Tuning Advisor in 11gR2 on SQL Access Advisor versus SQL Tuning Advisor
  • Adaptive Query Optimization in action on Cardinality feedback to automatically improve query plans
  • MySQL Utilities versus Master High Availability Manager (MHA) on MySQL Replication with Global Transaction Identifiers (GTID) hands-on
  • geek on SQL Server on Linux – Availability Groups – part 3
  • sai sumanth on SQL Server on Linux – Availability Groups – part 3

Blogroll

  • Ask Tom
  • Kevin Closson’s Oracle Blog
  • Official Pythian Blog
  • Oracle Optimizer
  • Oracle Scratchpad
  • Percona Database Performance Blog
  • Richard Foote’s Oracle Blog
  • Tanel Poder's blog

Visitors

Meta

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