AWR/statspack_en What is Oracle AWR? From Performance Analysis Basics to Report Generation and Utilization
During the operation of an Oracle Database, have you ever encountered performance issues such as "the system response su...
sql
AWR/statspack_en Data Dictionary Internals_en What is the Oracle GV$ View? Differences from V$ Views and Utilization in RAC Environments
In the operations management and performance analysis of Oracle Database, leveraging dynamic performance views such as V...
Data Dictionary Internals_en What Are Oracle Wait Events? How to Read v$session and v$system_event with Practical Examples
To monitor the operational status of Oracle, we utilize dynamic performance views that disclose memory-based statistical...
English Oracle Memory Architecture Fundamentals and Tuning Strategies to Maximize Performance
When considering Oracle Database performance, memory design is extremely important.When an appropriate amount of memory ...
English Fundamental Knowledge of Oracle Performance Tuning and 5 Steps for Efficiency
Have you ever encountered critical issues while operating an Oracle Database, such as "a specific process is slow" or "t...
Oracle Master Gold Active Database Duplication (Active Duplicate): Procedures and Key Points
Oracle RMAN features an "Active Database Duplication (Active Duplicate)" function that allows you to duplicate a databas...
English Oracle Read-Only ORACLE_HOME: Architecture and Activation
As a feature designed to significantly improve operational management efficiency and enhance security for Oracle Databas...
English How to Duplicate a Database Based on Backups (duplicate database)
Duplicating an Oracle database is an extremely useful feature for development, verification, and testing purposes. In th...
Datapump_en Practical Steps to Extract Transportable Tablespaces with RMAN and Import via SQL Script
— Smart Migration using Automatically Generated Scripts instead of Data Pump —Oracle's Transportable Tablespace (TTS) is...
Datapump_en Comprehensive Guide to Transportable Tablespaces (TTS) via Data Pump and RMAN
When migrating massive amounts of data—ranging from several GBs to multiple TBs—between Oracle databases, standard expdp...
English Procedures for Executing Flashback Database Using a Guaranteed Restore Point
When updating a system or applying large-scale data patches, the anxiety of "what if it fails?" is always present. In su...
English Flashback Database: Construction Procedures and Operational Secrets
One of the most powerful "insurance policies" in operating Oracle Database is Flashback Database. When a user accidental...
English Oracle Flashback Drop: The “Magic Command” to Rescue Deleted Tables from the Recycle Bin
In Oracle Database operations, one of the most heart-stopping moments is realizing you have accidentally executed a DROP...
English Undo Specific Changes: Oracle Flashback Transaction Techniques
When you accidentally commit an incorrect update in Oracle Database, using "Flashback Table" to revert an entire table c...
English Rewinding Time with SCN! A Guide to Using Oracle FLASHBACK TABLE
When operating an Oracle Database, you may encounter a situation where you accidentally delete important records and com...
English What is Oracle Flashback Data Archive? The Definitive Guide to History Management
Have you ever needed to "verify specific data from several years ago" or "track deleted records" in Oracle Database? Typ...
English What is Oracle Flashback Transaction Query?
When you perform an erroneous update or deletion in an Oracle Database, there are times when you want to accurately iden...
English Oracle Flashback Version Query
When operating an Oracle Database, there are times when you want to track the history of "when, by which transaction, an...
English Oracle Flashback Query (Specifying SCN vs. Timestamp)
When operating an Oracle Database, you often encounter situations where you need to "immediately check data before an up...
English What is Oracle Flashback Technology?
— The Savior from Human Error: Explaining Oracle's Powerful Rewind Feature —Oracle Database is equipped with a magical f...