Data Dictionary Internals_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...
Data Dictionary Internals_en

Preventing Oracle Block Corruption: Configuring DB_BLOCK_CHECKSUM and DB_BLOCK_CHECKING

In Oracle Database, physical or logical corruption of data blocks can trigger errors such as ORA-01578, leading to sever...
Data Dictionary Internals_en

Oracle Move Data Files: Safe Procedures and Examples [Linux/19c]

When reorganizing storage or cleaning up directories in your Oracle environment, knowing how to move data files safely i...
Data Dictionary Internals_en

Oracle Tablespace View Complete Guide: Verify Usage Correctly with DBA_* / V$*

This article explains how to correctly verify the usage and size of tablespaces in Oracle and how to expand capacity whe...