Database SQL; Delete vs Truncate and segment size allocated
This article shows the differences between SQL commands delete and truncate in Oracle Database with … Read More
Oracle ACE Pro
-
Oracle Certified Expert
-
Oracle Cloud Infrastructure
-
MySQL: Administrator Certified Professional
-
PostgreSQL: Certified Associate
-
-
Recent Posts
- 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
- 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 !
