Wadhah DAOUEHI | Wadhah DAOUEHI

Switching Session User in Oracle Database

By Wadhah DAOUEHI | July 29, 2025 - 2:50 pm |February 24, 2026 Oracle Database

In Oracle Database, session identity and schema context are important concepts for security, auditing, and … Read More →

Monitoring the Oracle Fast Recovery Area (FRA)

By Wadhah DAOUEHI | July 24, 2025 - 1:17 pm |February 24, 2026 Oracle Database, SQL

Leave a comment

1. Objective The objective of monitoring the Fast Recovery Area (FRA) in Oracle is to: … Read More →

Database 19c Vault: OWNER/Manager privileges !

By Wadhah DAOUEHI | March 15, 2025 - 11:54 am |May 3, 2025 Linux

Leave a comment

In Oracle Database 19c, after enabling Database Vault (DV), two key roles are assigned during … Read More →

Enabling the Database Vault (Initialisation parameters)

By Wadhah DAOUEHI | March 3, 2025 - 11:32 am |May 3, 2025 Linux

Leave a comment

To enable Oracle Database Vault, specific initialization parameters must be set, and configuration steps must … Read More →

[FATAL] [DBT-09352] Error in validating dbv_owner credentials.

By Wadhah DAOUEHI | March 2, 2025 - 11:07 am |May 3, 2025 Linux

Leave a comment

While enabling Oracle database VAULT with the tool dbca, and after creating a dedicated Oracle … Read More →

Oracle 19c: Convert Table to range partition online

By Wadhah DAOUEHI | February 22, 2025 - 4:11 pm |April 14, 2025 Linux

Leave a comment

Partitioning allows tables, indexes, and index-organized tables to be subdivided into smaller pieces, enabling these … Read More →

Oracle 19c: Automatic List-Partitioned Table (2/2)

By Wadhah DAOUEHI | October 16, 2024 - 9:45 am |October 16, 2024 Oracle 19c

Leave a comment

In the previous article, from the beginning we have created a new Automatic List partitioning … Read More →

Oracle 19c: Automatic List-Partitioned Table (1/2)

By Wadhah DAOUEHI | October 13, 2024 - 9:24 am |October 16, 2024 Oracle 19c

Leave a comment

The automatic list partitioning method enables list partition creation on demand. An auto-list partitioned table … Read More →

Oracle 19c: Interval Partitioning (2/2)

By Wadhah DAOUEHI | October 6, 2024 - 1:23 pm |October 14, 2024 Oracle 19c

Leave a comment

In the previous article, from the beginning we have created a new interval partitioning table, … Read More →

Oracle 19c: Interval Partitioning (1/2)

By Wadhah DAOUEHI | September 14, 2024 - 12:55 pm |October 14, 2024 Oracle 19c

Leave a comment

Interval partitioning can be used for almost every table that is range partitioned and uses … Read More →

Author Archives: Wadhah DAOUEHI

Switching Session User in Oracle Database

Monitoring the Oracle Fast Recovery Area (FRA)

Database 19c Vault: OWNER/Manager privileges !

Enabling the Database Vault (Initialisation parameters)

[FATAL] [DBT-09352] Error in validating dbv_owner credentials.

Oracle 19c: Convert Table to range partition online

Oracle 19c: Automatic List-Partitioned Table (2/2)

Oracle 19c: Automatic List-Partitioned Table (1/2)

Oracle 19c: Interval Partitioning (2/2)

Oracle 19c: Interval Partitioning (1/2)

Oracle ACE Pro

Oracle Certified Expert

Oracle Cloud Infrastructure

MySQL: Administrator Certified Professional

PostgreSQL: Certified Associate

Recent Posts