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.
The Oracle® Database version 19c introduced a slew of new and improved features.
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.
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.
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.