• 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
« Older posts

Oracle 19c: Index-Organized Table (IOT)

By Wadhah DAOUEHI | November 9, 2025 - 7:05 pm |March 9, 2026 Oracle 19c, Oracle Database
Leave a comment

In Oracle Database 19c, tables are typically stored as heap-organized tables, where data rows are … Read More →

Oracle 19c – SQL Access Path: Index Skip Scan

By Wadhah DAOUEHI | November 1, 2025 - 6:44 pm |March 9, 2026 Oracle 19c, Oracle Database, SQL
Leave a comment

In Oracle Database 19c, the Cost-Based Optimizer (CBO) selects the best method to retrieve rows … Read More →

Oracle 19c – SQL Access Path: Index Full Scan

By Wadhah DAOUEHI | October 23, 2025 - 5:30 pm |March 8, 2026 Oracle 19c, Oracle Database, SQL
Leave a comment

In Oracle Database 19c, the Cost-Based Optimizer (CBO) selects the most efficient method to retrieve … Read More →

Oracle 19c – SQL Access Path: Index Range Scan

By Wadhah DAOUEHI | October 15, 2025 - 5:08 pm |March 8, 2026 Oracle 19c, Oracle Database, SQL
Leave a comment

In Oracle Database 19c, the Cost-Based Optimizer (CBO) determines the most efficient way to retrieve … Read More →

Oracle 19c – SQL Access Path: Index Unique Scan

By Wadhah DAOUEHI | October 8, 2025 - 4:48 pm |March 8, 2026 Oracle 19c, SQL
Leave a comment

In Oracle Database 19c, the Cost-Based Optimizer (CBO) selects the most efficient method to retrieve … Read More →

Oracle 19c – SQL Access Path: ROWID Scan

By Wadhah DAOUEHI | October 1, 2025 - 3:32 pm |March 8, 2026 Oracle 19c, Oracle Database, SQL
Leave a comment

In Oracle Database 19c, the Oracle Optimizer determines the best method to retrieve data from … Read More →

Oracle 19c – SQL Access Path: Full Table Scan

By Wadhah DAOUEHI | September 27, 2025 - 3:13 pm |March 8, 2026 Oracle Database, SQL
Leave a comment

In Oracle Database 19c, when executing a SQL query, the Oracle Optimizer determines the most … Read More →

OS_AUTHENT_PREFIX External Authentication in Oracle Database 19c

By Wadhah DAOUEHI | September 14, 2025 - 10:40 pm |March 2, 2026 Linux, Oracle 19c, Oracle Database
Leave a comment

Let’s make an extenal authentification example, so the operating system authentication (OS authentication) allows users … Read More →

Oracle 19c Flashback Technology (7/7): Data Archives

By Wadhah DAOUEHI | September 10, 2025 - 7:04 pm |March 2, 2026 Oracle 19c, Oracle Database
Leave a comment

In Oracle Database 19c, Flashback Data Archive (FDA) — also known as Total Recall — … Read More →

Oracle 19c Flashback Technology (6/7): Flashback Database/PDB

By Wadhah DAOUEHI | September 3, 2025 - 6:11 pm |March 1, 2026 Oracle 19c, Oracle Database
Leave a comment

In Oracle Database 19c, Flashback Database allows you to rewind your database to a previous … Read More →

123›»
  • Oracle ACE Pro


  • Oracle Certified Expert




  • Oracle Cloud Infrastructure


  • MySQL: Administrator Certified Professional


  • PostgreSQL: Certified Associate


  • Recent Posts

    • Oracle 19c: Index-Organized Table (IOT)
    • Oracle 19c – SQL Access Path: Index Skip Scan
    • Oracle 19c – SQL Access Path: Index Full Scan
    • Oracle 19c – SQL Access Path: Index Range Scan
    • Oracle 19c – SQL Access Path: Index Unique Scan
    • 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)
Wadhah DAOUEHI | Powered by Mantra & WordPress.
LinkedIn YouTube Twitter