AIX Oracle tuning Posted on June 15, 2010, updated on October 9, 2014 by Yannick Jaquier AIX, Oracle Tuning   Table of contents Preamble Environment variables Maximum number of processes VMM tuning VMM background maxclient% maxperm% minperm... Read More

Since Oracle 11.2, Oracle provides ORION in the RDBMS binaries (in ${ORACLE_HOME}/bin). ORION – ORacle Input Output Numbers – is an I/O calibration tool allowing to simulating and testing I/O performances an Oracle database would be confronted with. ... Read More

https://docstore.mik.ua/orelly/bookshelfs.html   The Java Reference Library, version 1.3 The Java Enterprise CD Bookshelf, Version 1.0 The Perl CD Bookshelf, version 1.0 ... Read More

Do you Know These 5 Use of V$session View ?     V$session view is the base of all information related to current system status like which user, How many session, Which query and how long query is waiting etc. V$session is the first place when DBA s... Read More

List of 10 Must Know Oracle Database Parameters for Database Administrator     Database Parameters are environment variables for a database which can change database behavior according to value of the parameter. These are input values which are tak... Read More

What is OS Watcher Utility and How to use it for Database Troubleshooting ?     Oracle OS Watcher (OSWatcher) is a tool to help Remote DBA's to trouble shoot Database performance, Cluster reboot, node eviction, DB server reboot, DB instance Cr... Read More

How to Analyze or Read OS Watcher Output in three easy steps -- With Example ?     I assume, you have got Oracle OS Watcher (OSWatcher) logs and Database Administrator is facing slow database performance or System hang kind of situations. So, Next ... Read More

Top 4 Reasons for Node Reboot or Node Eviction in Real Application Cluster (RAC) Environment Remote DBA usually face Node Reboots or Node Evictions in Real Application Cluster Environment. Node Reboot is performed by CRS to maintain consistency in Cl... Read More