IBM DB2 Database Administration

IBM DB2 is a Relational Database developed and owned by IBM. DB2 database is available for multiple platforms including Linux, UNIX, and Windows (LUW). DB2 is available as database software with multiple models or editions.

Read More

New Oracle 19c features for database administrators

The OracleĀ® Database version 19c introduced a slew of new and improved features.

Read More

Use the Oracle Database refreshable clone featureā€”Part Two: Demonstration

Part one of the series provides an introduction to OracleĀ® refreshable clones, including when and why to use them. In this post, I demonstrate how to set up, configure, maintain, and drop a refreshable clone pluggable database (PDB) in Oracle 18c.

Read More

Use the Oracle Database refreshable clone featureā€”Part One: Introduction

The OracleĀ® Database 18c for Enterprise Edition on Cloud bundles engineered systems (Exadata) with many new and improved features. Release 18c improves the refreshable clone feature from the 12c release 2 by adding a quick switchover or failover facility. You can also create a snapshot carousel to clone or replicate pluggable databases (PDBs) in a multitenant environment.

Read More

Troubleshooting hung Oracle databases and sessions with Real-Time ADDM

OracleĀ® Enterprise Manager (OEM) 12c and 13c includes many performance analysis tools, including a support tool, called OEM Real-Time Automatic Database Diagnostic Monitor (Real-Time ADDM), for the Oracle DBA to use for troubleshooting or tuning real-time, ongoing performance issues. This blog shares knowledge about practical use of Real-Time ADDM to identify and survive an emergency due to any type of database health problems, such as 100% session, process utilization, or exceeding the predefined critical limits setup for input/output (I/O), memory, or interconnect limits. In such cases, Real-Time ADDM is a very handy tool, and provides the capability to do deeper real-time and realistic ADDM analysis of database health, so let’s compare RADDM vs. ADDM.

Read More