• About Me
  • Contact
  • Linux
  • Oracle
Wadhah DAOUEHI
Wadhah DAOUEHI
Oracle and Linux blog
LinkedIn YouTube Twitter
  Menu
Skip to content
  • About Me
  • Contact
  • Linux
  • Oracle
LinkedIn YouTube Twitter
LinkedIn YouTube Twitter

Author Archives: Wadhah DAOUEHI

« Older posts
Newer posts »

Recommended UNDO Tablespace Size in Oracle 19c Using the Undo Advisor (SQL Only)

By Wadhah DAOUEHI | August 13, 2025 - 1:37 pm |March 1, 2026 Oracle 19c, Oracle Database
Leave a comment

When you change UNDO_RETENTION in Oracle Database 19c, you must ensure that your UNDO tablespace … Read More →

Understanding UNDO Configuration and RETENTION GUARANTEE in Oracle 19c

By Wadhah DAOUEHI | August 8, 2025 - 1:28 pm |March 1, 2026 Oracle 19c, Oracle Database
1 Comment

Managing UNDO correctly in Oracle Database 19c is critical for transaction consistency, read consistency, flashback … Read More →

Materialized View Log in Oracle 19c (ON COMMIT)

By Wadhah DAOUEHI | August 4, 2025 - 11:21 pm |February 26, 2026 Oracle 19c, Oracle Database
Leave a comment

In Oracle Database 19c, REFRESH FAST ON COMMIT allows a Materialized View (MV) to be … Read More →

Materialized View Log in Oracle 19c (ON DEMAND)

By Wadhah DAOUEHI | August 2, 2025 - 10:51 pm |February 25, 2026 Oracle 19c, Oracle Database
Leave a comment

In Oracle Database 19c, a Materialized View Log (MV Log) is a database object that … Read More →

Reinitializing the Same Password After Expiration in Oracle 19c

By Wadhah DAOUEHI | July 31, 2025 - 7:26 am |February 25, 2026 Oracle 19c, Oracle Database
Leave a comment

In Oracle Database 19c, when a user account (for example SYSTEM) becomes EXPIRED, the password … Read More →

Switching Session User in Oracle Database

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

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 →

‹1234›»
  • Oracle ACE Pro


  • Oracle Certified Expert




  • Oracle Cloud Infrastructure


  • MySQL: Administrator Certified Professional


  • PostgreSQL: Certified Associate


  • Recent Posts

    • Oracle 19c – SQL Access Path: ROWID Scan
    • Oracle 19c – SQL Access Path: Full Table Scan
    • OS_AUTHENT_PREFIX External Authentication in Oracle Database 19c
    • Oracle 19c Flashback Technology (7/7): Data Archives
    • Oracle 19c Flashback Technology (6/7): Flashback Database/PDB
    • Oracle 19c Flashback Technology (5/7): TRANSACTION
    • Oracle 19c Flashback Technology (4/7): Table
    • Oracle 19c Flashback Technology (3/7): Drop Table
    • Oracle 19c Flashback Technology (2/7): Versions Query
    • Oracle 19c Flashback Technology (1/7): Query
    • Recommended UNDO Tablespace Size in Oracle 19c Using the Undo Advisor (SQL Only)
    • Understanding UNDO Configuration and RETENTION GUARANTEE in Oracle 19c
    • Materialized View Log in Oracle 19c (ON COMMIT)
    • Materialized View Log in Oracle 19c (ON DEMAND)
    • Reinitializing the Same Password After Expiration in Oracle 19c
    • 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 Database 19c: Shared Server mode
    • SYS.DBMS_BACKUP_RESTORE & SYS.DBMS_RCVMAN RMAN
    • Oracle 19c: pdb_storage_clause
    • NGINST-64051: Invalid Central Inventory location “null”.
    • 23ai: Create table if not exists
Wadhah DAOUEHI | Powered by Mantra & WordPress.
LinkedIn YouTube Twitter