Forem

Vahid Yousefzadeh profile picture

Vahid Yousefzadeh

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

Restoring a Datafile Using Archivelogs

Restoring a Datafile Using Archivelogs

Comments
2 min read
Oracle AI Database 26ai — Managing AWR in Active Data Guard

Oracle AI Database 26ai — Managing AWR in Active Data Guard

1
Comments
3 min read
Generating AWR Reports in an Active Data Guard using RMF(12.2)

Generating AWR Reports in an Active Data Guard using RMF(12.2)

Comments
4 min read
Automatic Flashback (or PITR) Standby

Automatic Flashback (or PITR) Standby

Comments
12 min read
Oracle AI Database 26ai - SQL Domain

Oracle AI Database 26ai - SQL Domain

Comments
6 min read
Adding PDB Resources in Grid Infrastructure

Adding PDB Resources in Grid Infrastructure

Comments
2 min read
SESSION-LEVEL SEQUENCES

SESSION-LEVEL SEQUENCES

Comments
1 min read
A Brief Review of Interval Partitioning

A Brief Review of Interval Partitioning

Comments
6 min read
What’s New in Oracle AI Database 26ai? Exploring 50+ Major New Features

What’s New in Oracle AI Database 26ai? Exploring 50+ Major New Features

1
Comments 1
5 min read
Oracle AI Database 26ai — Wide Tables

Oracle AI Database 26ai — Wide Tables

Comments
1 min read
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 AI Database 26ai

Reducing Unified Audit Trail Size in Oracle AI Database 26ai

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(26ai, 19.28)

SQL Diagnostic Report(26ai, 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 26ai,19c — RMAN Progress Status Report

Oracle Database 26ai,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 AI Database 26ai(23.9) — GROUP BY ALL

Oracle AI Database 26ai(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 AI Database 26ai (23.9) — Introducing Non-Positional INSERT INTO SET Clause

Oracle AI Database 26ai (23.9) — Introducing Non-Positional INSERT INTO SET Clause

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

Four Oracle AI Database 26ai Enhancements Now Available in Oracle 19c (19.28)

Comments
1 min read
Oracle AI Database 26ai: Using IF [NOT] EXISTS Clause When Creating or Dropping an Object

Oracle AI Database 26ai: 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 AI Database 26ai — error_message_details Parameter for Displaying Error Details

Oracle AI Database 26ai — 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 AI Database 26ai — Identifying Data Dictionary Inconsistencies with DBMS_DICTIONARY_CHECK

Oracle AI Database 26ai — 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 AI Database 26ai — Transport Tablespace over Network

Oracle AI Database 26ai — Transport Tablespace over Network

Comments
3 min read
loading...