IT World

RDBMS, Unix and many more…

  • Home
  • About
  • Privacy

SQL*Plus ARRAYSIZE

Posted on July 16, 2010, updated on May 27, 2019 by Yannick Jaquier

Table of contents

  • Preamble
  • Testing
    • ARRAYSIZE = 15
    • ARRAYSIZE = 200
    • Summary and conclusion
  • SQL*Net further configuration
  • References

Continue reading

Oracle SQL*Net, SQL*Plus 1 Comment

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 Leave a 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 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
  • Page 35 of 38
  • « First
  • ‹ Previous
  • 33
  • 34
  • 35(current)
  • 36
  • 37
  • Next ›
  • Last »

Search

Certifications

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

Categories

  • AIX (2)
  • Couchbase (2)
  • Hadoop (21)
  • HPUX (6)
  • Linux (29)
  • MariaDB (12)
  • mongoDB (1)
  • MySQL (24)
  • Oracle (138)
  • PostgreSQL (5)
  • Python (3)
  • SQL Server (7)

Recent Comments

  • Table and scalar SQL macros hands-on on Pipelined functions
  • R RAVEENDRA on Data Guard apply lag gap troubleshooting
  • Oracle OpenStack for Oracle Linux Release 2 in Virtualbox (1/2) on How to use Docker to create a MariaDB sandbox for testing
  • SQL Server on Linux – Log Shipping – part 4 on SQL Server on Linux – Failover Cluster Instances – part 2
  • vmckrish on Linux memory usage how to know what is used with basic commands

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