• 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
Newer posts »

Hourly Redo Activity Analysis Using V$LOG_HISTORY

By Wadhah DAOUEHI | January 11, 2026 - 2:18 pm |May 31, 2026 Oracle 19c, Oracle Database
Leave a comment

Understanding redo generation patterns is essential for Oracle performance monitoring, backup planning, and Data Guard … Read More →

Identify Where Database Time Is Spent (Wait Events + CPU)

By Wadhah DAOUEHI | December 21, 2025 - 2:02 pm |May 31, 2026 Oracle 19c, Oracle Database
Leave a comment

One of the most important tasks for an Oracle DBA is understanding where database time … Read More →

Calculate Real Table Size (Including Indexes, LOBs and LOB indexes)

By Wadhah DAOUEHI | November 30, 2025 - 1:44 pm |May 31, 2026 Oracle Database, SQL
Leave a comment

In Oracle database (starting from 10g), a table’s real storage size is not limited to … Read More →

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 →

«‹45678›»

  • Oracle ACE Pro


  • Oracle Certified Expert




  • Oracle Cloud Infrastructure


  • MySQL: Administrator Certified Professional


  • PostgreSQL: Certified Associate


  • Recent Posts

    • Oracle RAC 19c Masterclass — Part 22: RAC Performance Troubleshooting: Cache Fusion, GC Waits, Hot Blocks & SQL
    • Oracle RAC 19c Masterclass — Part 21: Resource Manager, Instance Caging & Workload Control
    • Oracle RAC 19c Masterclass — Part 20: RAC Services & Workload Management: Designing RAC for Real Applications
    • Oracle RAC 19c Masterclass — Part 19: RAC Interconnect Deep Dive: Private Network, MTU, Redundancy & Troubleshooting
    • Oracle RAC 19c Masterclass — Part 18: Cache Fusion Deep Dive: GCS, GC Waits, Hot Blocks & Block Pinging
    • Oracle RAC 19c Masterclass — Part 17
    • Oracle RAC 19c Masterclass — Part 16
    • Oracle RAC 19c Masterclass — Part 15
    • Oracle RAC 19c Masterclass – Part 14
    • Oracle RAC 19c Masterclass — Part 13
    • Oracle RAC 19c Masterclass – Part 12
    • Oracle RAC 19c Masterclass – Part 11
    • Oracle RAC 19c Masterclass – Part 10
    • Oracle RAC 19c Masterclass – Part 9
    • Oracle RAC 19c Masterclass – Part 8
    • Oracle RAC 19c Masterclass – Part 7
    • Oracle RAC 19c Masterclass – Part 6
    • Oracle RAC 19c Masterclass – Part 5
    • Oracle RAC 19c Masterclass – Part 4
    • Oracle RAC 19c Masterclass – Part 3
    • Oracle RAC 19c Masterclass – Part 2
    • Oracle RAC 19c Masterclass – Part 1
    • Oracle Database 19c Security Hardening – Part 16
    • Oracle Database 19c Security Hardening – Part 15
    • Oracle Database 19c Security Hardening – Part 14
    • Oracle Database 19c Security Hardening – Part 13
    • Oracle Database 19c Security Hardening – Part 12
    • Oracle Database 19c Security Hardening – Part 11
    • Oracle Database 19c Security Hardening – Part 10
    • Oracle Database 19c Security Hardening – Part 9
Wadhah DAOUEHI | Powered by Mantra & WordPress.
LinkedIn YouTube Twitter