Oracle Articles RSS Feed
AIX Oracle tuning
Viewed 43285 times since Tue, Jul 2, 2019
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
Simulating and testing I/O performances with ORION
Viewed 265 times since Wed, Jul 25, 2018
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
O’Reilly’s CD bookshelf
Viewed 4548 times since Wed, Jun 27, 2018
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 ?
Viewed 5165 times since Thu, Jun 21, 2018
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
Viewed 6042 times since Thu, Jun 21, 2018
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 ?
Viewed 2766 times since Thu, Jun 21, 2018
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 ?
Viewed 3063 times since Thu, Jun 21, 2018
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
Viewed 7445 times since Thu, Jun 21, 2018
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