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...
oracle
Data Dictionary Internals_en 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...
English Oracle Tablespace Local Management: How to Create and Choose
Introduction (100–160 chars)In oracle 19c, creating a tablespace with local management automates extent management and s...
Database Design_en Oracle OS Authentication: Configuration Steps and Practical Points
Published: Nov 18, 2024 / Updated: Aug 30, 2025Oracle Database provides two authentication methods: database authenticat...
English Oracle TNS_ADMIN: Proper Usage and Configuration Steps [Linux/19c]
Introduction (Summary)When you want to centrally manage Oracle connection settings, use the TNS_ADMIN environment variab...
English Oracle DBMS_PRIVILEGE_CAPTURE: Introduction to Privilege Analysis
To operate Oracle Database securely, it is important to grant users only the minimum required privileges. Leaving unnece...
Oracle Basics_en Oracle Database Profile Configuration Guide
IntroductionThe basics of account administration are to assign an appropriate profile to each oracle user and standardiz...
English Oracle Database 19c User Creation and Management
In this article, we will walk through how to create and manage a user in an oracle database, specifically assuming a non...
ADR_en Complete Guide to the Oracle Database Alert Log
The alert log is Oracle’s chronological record of instance health and incidents. If you can read the alert log fast, you...
Bronze_en Oracle SQL INSERT … SELECT: Practical Techniques in 19c
IntroductionWhen you need to move or transform a large volume of data in one go, insert select is a go-to technique. Thi...