Quick Links

Oracle Documentation

 

Oracle Clusterware Control (CRSCTL) Utility Reference 19c

Oracle Database 12c: INTERACTIVE QUICK REFERENCE

Oracle Developer Community

Release Schedule of Current Database Releases (Doc ID 742060.1)

Diagnostic Tools Catalog (Doc ID 559339.1)

Autonomous Health Framework (AHF) – Including TFA and ORAchk/EXAChk (Doc ID 2550798.1)

Catalog: Oracle Toolbox: Diagnostic and Analyzer Scripts – Data Collectors – Health Checks – Tools – Utilities – SRDC – All Products – Database – Exadata – EBS – JDE – Fusion – Middleware – Siebel – Sun – Peoplesoft (Doc ID 1987483.2)

Autonomous Health Checks and Diagnostics

Maximum Availability Architecture Best Practices

Oracle MAA Reference Architectures

Introduction to Oracle Clusterware – Oracle Clusterware supports up to 100 nodes in a cluster on configurations running Oracle Database 10g release 2 (10.2) and later releases.

Managing Oracle Cluster Registry and Voting Files – Oracle 19c

Enabling Advanced Features of Oracle Net Services – Oracle 19c

Certified Virtualization and Partitioning Technologies for Oracle Database and RAC Product Releases

RAC Technologies Matrix for Linux Platforms

 

 

 

 

ASMLIB

 

ASM Inherently Performs Asynchronous I/O Regardless of filesystemio_options Parameter (Doc ID 751463.1)

How To Check if Asynchronous I/O is Working On Linux (Doc ID 237299.1)

Asynchonous I/O not reported in /proc/slabinfo KIOCB slabdata (Doc ID 413389.1)

Information Center: ASMLib (Doc ID 1624409.2)

How to Configure LUNs for ASM Disks using WWID, DM-Multipathing, and ASMLIB on RHEL 5/OL 5 and RHEL 6/OL 6 and RHEL7 (Doc ID 1365511.1)

ASMLib for RHEL6

Doing synchronous IO on ASM

ASMLIB Performance vs Udev

Why use Oracle ASM for Oracle databases

Performance and Scalability Considerations for ASM Disk Groups – 12.2

Altering Disk Groups – ASM Rebalance Oracle 19c

 

 

 

 

AWR and IOPS

 

Alejandro Vargas – Useful Scripts

Oracle AWR Reports: Understanding I/O Statistics

How to identify IOPS in AWR reports

How to get IOPS from AWR and Real-time

Oracle Database Load Testing Tools – Overview

 

 

 

 

Oracle RAC

Archive for the ‘STONITH’ Category – Kevin Closson

RAC: Frequently Asked Questions (RAC FAQ) (Doc ID 220970.1)

Avoiding Split Brain

Rebootless node fencing in Oracle RAC

http://ahfathi.blogspot.com/2014/02/oracle-rac-functions-of-io-fencing.html

Understanding Linux SCSI Reservation

What are SCSI Reservations and SCSI Persistent Reservations?

How to verify that the disk is iscsi3 persistent compliant

Multicast Requirements for Networks Used by Oracle Grid Infrastructure

Grid Infrastructure Redundant Interconnect and ora.cluster_interconnect.haip (Doc ID 1210883.1)

Grid Infrastructure Startup During Patching, Install or Upgrade May Fail Due to Multicasting Requirement (Doc ID 1212703.1)

How to Validate Network and Name Resolution Setup for the Clusterware and RAC (Doc ID 1054902.1)

The Basics of IPv4 Subnet and Oracle Clusterware (Doc ID 1386709.1)

 

 

 

 

Oracle RAC on Third-Party Clouds

 

Oracle RAC on Third-Party Clouds

Self-managed Oracle RAC on Amazon EC2

Oracle RAC on Amazon EC2

FlashGrid Enables Oracle RAC in AWS

https://en.wikipedia.org/wiki/Oracle_Database#Releases_and_versions

Network multicast support on Azure

How to enable broadcast and multicast support on Amazon (AWS) EC2

 

 

 

Oracle Articles

 

https://www.cyberciti.biz/files/linux-kernel/Documentation/filesystems/tmpfs.txt

http://blog.oracle48.nl/oracle-11g-amm-memory_target-memory_max_target-and-dev_shm/

https://www.kernel.org/doc/gorman/html/understand/understand015.html

https://fritshoogland.wordpress.com/2016/09/10/how-many-memory-is-truly-used-by-my-oracle-instance/

https://fritshoogland.wordpress.com/2014/11/28/physical-io-on-linux/

https://fritshoogland.wordpress.com/2012/12/15/throttling-io-with-linux/

How To Change The Priority Of Oracle Database Background Processes

Choosing the Right ASM Allocation Unit for a Virtualized Oracle Database

A look into oracle redo, part 7: adaptive log file sync – Frits

x$tables – adp-gmbh.com

Adaptive Log File Sync: Oracle, Please Don’t Do That Again

LGWR I/O is Simple, But Not LGWR Processing – Kevin Closson

Tuning Redo Log Buffer

Tuning ‘log file sync’ wait events – Riyaj

Oracle Linux Virtualization Manager

 

 

 

 

 

Oracle Bloggers

 

http://oracleracsig.org

http://asmsupportguy.blogspot.com

https://kevinclosson.net

https://bartsjerps.wordpress.com

http://canali.web.cern.ch/canali

http://www.oracle-base.com

http://blog.tanelpoder.com

http://ixora.com.au

http://oaktable.net

http://juliandyke.com

http://pythian.com

 

 

 

 

Linux Performance

 

Linux Load Averages: Solving the Mystery

USE Method: Linux Performance Checklist

The USE Method

Understand Linux Load Averages and Monitor Performance of Linux

Examining Load Average

Understanding CPU Steal Time – when should you be worried?

Steal Time Accounting

https://www.cyberciti.biz/files/linux-kernel/Documentation/

Little’s Law- An insight on the relation between latency and throughput

Deadline scheduler

Noop scheduler

Choosing an I/O Scheduler for 4 and the 2.6 Kernel

Improving Linux System Performance with I/O Scheduler Tuning

Queue sysfs files

Increasing the maximum I/O size in Linux

SC Storage Customer Notification: Linux Large IO Sizes Can Affect iSCSI Volume Availability

What is the suggested I/O scheduler to improve disk performance when using Red Hat Enterprise Linux with virtualization?

RHEL Configuring Tuning Profiles for Storage Performance

Using the Deadline IO Scheduler

Understanding the Deadline IO Scheduler

How to use the Noop IO Scheduler

What is the kernel parameters related to maximum size of physical I/O requests?

I/O Limits: block sizes, alignment and I/O hints

Default Maximum IO Size Change in Linux Kernel

How do I disable the irqbalance service in Red Hat Enterprise Linux?

Performance Tuning Guide Red Hat Enterprise Linux 7

RHEL 7 and Oracle 12c (Single Instance and RAC)

Pure Storage – Linux Recommended Settings

 

 

 

 

Linux fio

 

Inspecting disk IO performance with fio

fio(1) – Linux man page

Getting Started With Fio

https://www.binarylane.com.au/support/solutions/articles/1000055889-how-to-benchmark-disk-i-o

https://wiki.mikejung.biz/Benchmarking

 

 

 

 

Linux

 

Writing udev rules

https://www.kernel.org/doc/Documentation/admin-guide/kernel-parameters.txt

3D XPoint Memory

 

 

 

 

NTP

 

NTP Server – Stratum Levels Explained

Stratum Levels & NTP Explained | Welcome to the ‘Stratumopshere’

 

 

 

 

Persistent Memory

 

NVME nvme-get-feature

NVDIMM and the Linux Kernel

Configuring and Using Persistent Memory in RHEL 7.3

Persistent Memory Programming

Direct Access for files (DAX)

LIBNVDIMM: Non-Volatile Devices

Persistent Memory Wiki

ndctl-create-namespace

https://www.mankier.com/1/ndctl-create-namespace

https://code.vmware.com/persistent-memory-initiative

mmap and DMA

An NVDIMM Primer (Part 1 of 2)

https://en.wikipedia.org/wiki/NVDIMM

DAX on BTT

Using Persistent Memory Devices with the Linux Device Mapper

Chapter 28. Persistent Memory: NVDIMMs

NVDIMM Enabling in SUSE Linux Enterprise 12, Service Pack 2

How to Emulate Persistent Memory Using Dynamic Random-access Memory (DRAM)

Persistent Memory  – Important

 

 

 

 

Virtual Storage Appliances

 

https://www.flackbox.com/list-vsa-virtual-storage-appliances-storage-simulators-san-nas-demos

 

 

 

 

 

Unix

 

http://bhami.com/rosetta.html

http://www.softpanorama.org/Commercial_unixes

http://www.unixguide.net

 

 

Solaris

 

http://www.sean.de/Solaris/soltune.html

Shall I use Zones or LDOMs?

Oracle Solaris Containers

 

 

 

AIX

 

Assigning the appropriate processor entitled capacity

AIX for System Administrators – Physical – Virtual – Logical CPUs

Understanding CPU on AIX Power SMT Systems

Processor utilization difference between IBM AIX and Linux on Power – apple to apple comparison

Understanding CPU utilization on AIX

How to Use rPerfs for Workload Migration and Server Consolidation

Sockets, Cores, Virtual CPU, Logical CPU, Hyper-Threading: What is a CPU nowadays? – Oracle AWR AIX

 

 

Veritas

 

http://cuddletech.com/veritas/index.html

http://www.vxideas.org

 

 

EMC

 

http://powerlink.emc.com

https://community.emc.com/community/connect/everything_oracle

http://clariionblogs.blogspot.com

http://virtualgeek.typepad.com/virtual_geek/celerra-vsa-howto/

Dell EMC Workload Profile Assessment for Oracle AWR Report / StatsPack Gathering Procedures Instructions

 

 

NETAPP

 

http://www.netapp.com/us

https://communities.netapp.com/community/netapp-blogs/storage_nuts_n_bolts

NetApp From the Ground Up – A Beginner’s Guide – Index

Netapp Blog

http://storagegaga.com/

 

 

HDS

 

http://blogs.hds.com/hu

 

 

Pure Storage

 

http://vaughnstewart.com/

 

 

SNIA

 

http://www.snia.org