Forem

Vahid Yousefzadeh profile picture

Vahid Yousefzadeh

I have been a DBA since 2011 and I work with Oracle technology...

Oracle AI Database 26ai— Automatic Transaction Rollback (Priority Transactions with high, medium and low priority)

Oracle AI Database 26ai— Automatic Transaction Rollback (Priority Transactions with high, medium and low priority)

Comments
3 min read
Oracle AI Database 26ai — Dictionary Protection

Oracle AI Database 26ai — Dictionary Protection

Comments
4 min read
FAR SYNC Data Guard

FAR SYNC Data Guard

Comments
3 min read
Mandatory Profile in Oracle Database

Mandatory Profile in Oracle Database

Comments
3 min read
Restoring a Lost Datafile from Standby Using RMAN

Restoring a Lost Datafile from Standby Using RMAN

1
Comments
1 min read
Rolling Back Online Table Redefinition

Rolling Back Online Table Redefinition

Comments
2 min read
The dml_lock_timeout Parameter in the DBMS_REDEFINITION Package

The dml_lock_timeout Parameter in the DBMS_REDEFINITION Package

Comments
1 min read
Oracle AI Database 26ai: Bind Variable Support in Materialized View Query Rewrite

Oracle AI Database 26ai: Bind Variable Support in Materialized View Query Rewrite

Comments
4 min read
PDB Recovery Isolation

PDB Recovery Isolation

Comments
6 min read
DBMS_JOB and DBMS_SCHEDULER Integration in Oracle 19c

DBMS_JOB and DBMS_SCHEDULER Integration in Oracle 19c

2
Comments
4 min read
Oracle AI Database 26ai: RESETTABLE Clause

Oracle AI Database 26ai: RESETTABLE Clause

Comments
2 min read
Oracle 21c — Using Result Cache in Standby

Oracle 21c — Using Result Cache in Standby

Comments
2 min read
Oracle AI Database 26ai: Filtering Analytic Function Results with the QUALIFY Clause

Oracle AI Database 26ai: Filtering Analytic Function Results with the QUALIFY Clause

Comments
1 min read
Installing Oracle AI Database 26ai Free on Oracle Linux 9

Installing Oracle AI Database 26ai Free on Oracle Linux 9

Comments
5 min read
Oracle 21c — Removal of IGNORECASE and SEC_CASE_SENSITIVE_LOGON Parameters

Oracle 21c — Removal of IGNORECASE and SEC_CASE_SENSITIVE_LOGON Parameters

Comments
2 min read
Expression-Based Parameter Value Feature in Oracle 21c

Expression-Based Parameter Value Feature in Oracle 21c

Comments
1 min read
Oracle vs PostgreSQL: How Undo Tablespace and MVCC Handle Updates and Deletes

Oracle vs PostgreSQL: How Undo Tablespace and MVCC Handle Updates and Deletes

Comments
7 min read
Sequence Dynamic Cache Resizing in Oracle 21c and 19.10

Sequence Dynamic Cache Resizing in Oracle 21c and 19.10

Comments
3 min read
A Note on Taking Backups from Standby

A Note on Taking Backups from Standby

Comments
2 min read
Buffer Busy Wait and Read by Other Session in Oracle

Buffer Busy Wait and Read by Other Session in Oracle

Comments
4 min read
ALTER TABLE … MOVE ONLINE

ALTER TABLE … MOVE ONLINE

Comments
1 min read
enq: TX — allocate ITL entry

enq: TX — allocate ITL entry

Comments
9 min read
Hybrid Partition Table in Oracle 19c

Hybrid Partition Table in Oracle 19c

Comments
3 min read
Reducing Unified Audit Trail Size in Oracle 23ai

Reducing Unified Audit Trail Size in Oracle 23ai

Comments
3 min read
DataPump : Disabling the Use of Symbolic Links When Creating a Directory

DataPump : Disabling the Use of Symbolic Links When Creating a Directory

Comments
2 min read
Resolving Missing Log Gaps in Data Guard

Resolving Missing Log Gaps in Data Guard

Comments
4 min read
Oracle 19c — Audit Only Top-Level SQL Statements

Oracle 19c — Audit Only Top-Level SQL Statements

Comments
3 min read
Schema Only Accounts Feature in Oracle 18c and 19c

Schema Only Accounts Feature in Oracle 18c and 19c

1
Comments
4 min read
DataGuard DML Redirection(Oracle 19c and 18c)

DataGuard DML Redirection(Oracle 19c and 18c)

Comments
3 min read
SQL Diagnostic Report(23ai, 19.28)

SQL Diagnostic Report(23ai, 19.28)

Comments
2 min read
Automatic Service Failback to Preferred Instance in Oracle RAC 19c

Automatic Service Failback to Preferred Instance in Oracle RAC 19c

Comments
3 min read
Oracle 21c — Setting Compression Attribute for Indexes During Import

Oracle 21c — Setting Compression Attribute for Indexes During Import

Comments
2 min read
Oracle Database 23ai,19c — RMAN Progress Status Report

Oracle Database 23ai,19c — RMAN Progress Status Report

Comments
3 min read
Creating Gold Image from existing installed software(GI HOME and Oracle HOME)

Creating Gold Image from existing installed software(GI HOME and Oracle HOME)

Comments
2 min read
Real-Time Statistics in Oracle 19c

Real-Time Statistics in Oracle 19c

Comments
3 min read
Enhancements to the FOR Loop in Oracle 21c

Enhancements to the FOR Loop in Oracle 21c

Comments
2 min read
Oracle 23ai(23.9) — GROUP BY ALL

Oracle 23ai(23.9) — GROUP BY ALL

Comments
2 min read
Oracle 21c — Auditing for All Editions of an Object

Oracle 21c — Auditing for All Editions of an Object

Comments
2 min read
Oracle 23ai (23.9) — Introducing Non-Positional INSERT INTO SET Clause

Oracle 23ai (23.9) — Introducing Non-Positional INSERT INTO SET Clause

Comments
3 min read
Four Oracle 23ai Enhancements Now Available in Oracle 19c (19.28)

Four Oracle 23ai Enhancements Now Available in Oracle 19c (19.28)

Comments
1 min read
23ai: Using IF [NOT] EXISTS Clause When Creating or Dropping an Object

23ai: Using IF [NOT] EXISTS Clause When Creating or Dropping an Object

Comments
2 min read
Oracle 21c — AutoUpgrade Enhancements for RAC

Oracle 21c — AutoUpgrade Enhancements for RAC

Comments
1 min read
No more ALTER USER RENAME under Oracle 19c

No more ALTER USER RENAME under Oracle 19c

Comments
2 min read
Oracle 23ai — error_message_details Parameter for Displaying Error Details

Oracle 23ai — error_message_details Parameter for Displaying Error Details

Comments
1 min read
ANY_VALUE Function in Oracle 21c

ANY_VALUE Function in Oracle 21c

Comments
1 min read
Oracle 19c — Generating Reports for Hints Usage (HINT_REPORT)

Oracle 19c — Generating Reports for Hints Usage (HINT_REPORT)

Comments
2 min read
Oracle 23ai — Identifying Data Dictionary Inconsistencies with DBMS_DICTIONARY_CHECK

Oracle 23ai — Identifying Data Dictionary Inconsistencies with DBMS_DICTIONARY_CHECK

Comments
7 min read
CHECKSUM Function in Oracle 21c

CHECKSUM Function in Oracle 21c

Comments
2 min read
Oracle 19c — Grid Infrastructure Upgrade in Dry-Run Mode

Oracle 19c — Grid Infrastructure Upgrade in Dry-Run Mode

1
Comments
2 min read
Oracle 23ai — Transport Tablespace over Network

Oracle 23ai — Transport Tablespace over Network

Comments
3 min read
Flashback Database Support for Shrink Datafile in Oracle 21c

Flashback Database Support for Shrink Datafile in Oracle 21c

Comments
1 min read
Oracle 23ai — ConnStr Tool

Oracle 23ai — ConnStr Tool

Comments
4 min read
Oracle 21c — Comparing Explain Plans Using the COMPARE_EXPLAIN Function

Oracle 21c — Comparing Explain Plans Using the COMPARE_EXPLAIN Function

Comments
2 min read
Oracle 23ai— The INMEMORY(ALL) and NO INMEMORY(ALL) Clauses

Oracle 23ai— The INMEMORY(ALL) and NO INMEMORY(ALL) Clauses

Comments
2 min read
Oracle 23ai — Applying Grid Infrastructure Patches via GUI(Zero-Downtime)

Oracle 23ai — Applying Grid Infrastructure Patches via GUI(Zero-Downtime)

Comments 1
4 min read
Oracle 23ai: Utilizing Memoptimized Rowstore Without Setting a Hint

Oracle 23ai: Utilizing Memoptimized Rowstore Without Setting a Hint

Comments 1
2 min read
Exporting AUDIT tables Using Oracle Data Pump

Exporting AUDIT tables Using Oracle Data Pump

Comments
2 min read
Storing AWR Snapshots Outside SYSAUX

Storing AWR Snapshots Outside SYSAUX

Comments 2
2 min read
Oracle 23ai — Storing Flashback Logs Outside FRA

Oracle 23ai — Storing Flashback Logs Outside FRA

Comments
2 min read
Oracle 21c – pdbTimezone Parameter in DBCA Command

Oracle 21c – pdbTimezone Parameter in DBCA Command

Comments 2
1 min read
loading...