• 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

Category Archives: 23ai

23ai: Create table if not exists

By Wadhah DAOUEHI | May 30, 2024 - 3:51 pm |May 30, 2024 23ai
Leave a comment

Within 23ai, we can create a table if not exist and we can ignore the … Read More →

23ai: Direct join with DELETE

By Wadhah DAOUEHI | May 30, 2024 - 1:54 pm |May 30, 2024 23ai, Oracle 19c
Leave a comment

As new features within the 23ai Oracle database, we can use the join in the … Read More →

23ai: Direct join with UPDATE

By Wadhah DAOUEHI | May 30, 2024 - 1:47 pm |May 30, 2024 23ai
Leave a comment

As new features within the 23ai Oracle database, we can use the join in the … Read More →

23ai: Having with alias

By Wadhah DAOUEHI | May 27, 2024 - 3:14 pm |May 30, 2024 23ai
Leave a comment

Within the Oracle database 23ai, we can use an alias in the HAVING clause, With … Read More →

Create FREE 23ai Database

By Wadhah DAOUEHI | May 26, 2024 - 10:37 pm |May 26, 2024 23ai
Leave a comment

After installation of the Oracle database 23ai RPM, we are going to create the FREE … Read More →

Oracle Database 23ai installation RPM

By Wadhah DAOUEHI | May 26, 2024 - 1:02 pm |May 26, 2024 23ai
1 Comment

My first installation of the new version of Oracle Database 23ai, for more details: oracle-23ai-now-generally-available … Read More →

23c: Database has been previously opened and closed

By Wadhah DAOUEHI | February 12, 2024 - 2:52 pm |May 30, 2024 23ai, Oracle 19c
Leave a comment

While the database is OPEN, we can close the database to the MOUNT status, and … Read More →

  • Oracle ACE Pro


  • Oracle Certified Expert




  • Oracle Cloud Infrastructure


  • MySQL: Administrator Certified Professional


  • PostgreSQL: Certified Associate


  • Recent Posts

    • 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
    • Oracle Database 19c Security Hardening – Part 8
    • Oracle Database 19c Security Hardening – Part 7
    • Oracle Database 19c Security Hardening – Part 6
    • Oracle Database 19c Security Hardening – Part 5
    • Oracle Database 19c Security Hardening – Part 4
    • Oracle Database 19c Security Hardening – Part 3
    • Oracle Database 19c Security Hardening – Part 2
    • Oracle Database 19c Security Hardening – Part 1
    • Oracle Database 19c: Transporting Tablespaces from a Non-CDB to a PDB
    • Oracle 19c Recovery Catalog: Installation and Configuration
    • Oracle RAC 19c: Change SCAN adresses
    • Oracle RAC 19c: Change VIPs adresses
    • Oracle ODA X9-2 (19c): Check networks status
    • Oracle ODA X9 (19c): Erase appliance Configuration
    • Oracle ODA X9 (19c): Create a Backup ACFS volume
    • Oracle ODA X9 (19c): Resize DB Home Storage
    • Oracle Database 19c: How to Verify Locked and Expired User Accounts
    • Oracle Database 19c: How to Verify DBA Accounts and Audit DBA Roles
    • Oracle 19c – SQL Access Path: Index Fast Full Scan
    • Oracle ASM : Monitor Disk Group Space Usage in 19c
    • Hourly Redo Activity Analysis Using V$LOG_HISTORY
    • Identify Where Database Time Is Spent (Wait Events + CPU)
    • Calculate Real Table Size (Including Indexes, LOBs and LOB indexes)
    • Oracle 19c: Index-Organized Table (IOT)
    • Oracle 19c – SQL Access Path: Index Skip Scan
    • Oracle 19c – SQL Access Path: Index Full Scan
Wadhah DAOUEHI | Powered by Mantra & WordPress.
LinkedIn YouTube Twitter