DEV Community

Vahid Yousefzadeh profile picture

Vahid Yousefzadeh

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

Joined Joined on  Email address vahidusefzadeh@gmail.com Personal website https://yousefzadeh-db.blogspot.com/
Oracle AI Database 26ai(23.26.4): Mixing SELECT * with Other Columns and Expressions
vahidusefzadeh profile

Oracle AI Database 26ai(23.26.4): Mixing SELECT * with Other Columns and Expressions

#oracle #database #26ai #ai
2
Comments 2
2 min read

Want to connect with Vahid Yousefzadeh?

Create an account to connect with Vahid Yousefzadeh. You can also sign in below to proceed if you already have an account.

Create Account
Already have an account? Sign in
23% Faster Autovacuum with Parallel Workers in PostgreSQL 19
vahidusefzadeh profile

23% Faster Autovacuum with Parallel Workers in PostgreSQL 19

#postgres #autovacuum #parallel #performance
Comments
5 min read
Calculating WAL Generation for DML Operations in PostgreSQL
vahidusefzadeh profile

Calculating WAL Generation for DML Operations in PostgreSQL

#postgres #wal #dml #ai
1
Comments 1
3 min read
Prevent Accidental Duplicate Rows with JOIN TO ONE in Oracle AI Database 26ai
vahidusefzadeh profile

Prevent Accidental Duplicate Rows with JOIN TO ONE in Oracle AI Database 26ai

#oracle #ai #database #26ai
Comments
4 min read
Verifying PostgreSQL Backups Using pg_verifybackup
vahidusefzadeh profile

Verifying PostgreSQL Backups Using pg_verifybackup

#postgres #backup #database #ai
Comments 1
3 min read
PostgreSQL 19: Online Table Reorganization with REPACK (Similar to Oracle DBMS_REDEFINITION)
vahidusefzadeh profile

PostgreSQL 19: Online Table Reorganization with REPACK (Similar to Oracle DBMS_REDEFINITION)

#oracle #postgres #linux #devops
Comments
6 min read
Nested WITH Clause in Oracle AI Database 26ai(23.26.2)
vahidusefzadeh profile

Nested WITH Clause in Oracle AI Database 26ai(23.26.2)

#ai #programming #oracle #26ai
Comments 1
3 min read
Duplicating a PDB into Another CDB
vahidusefzadeh profile

Duplicating a PDB into Another CDB

#oracle #database #ai #webdev
Comments
5 min read
Oracle AI Database 26ai(23.26.3) - Controlling PDB Redo Generation with REDO_GENERATION_KBPS_MAX
vahidusefzadeh profile

Oracle AI Database 26ai(23.26.3) - Controlling PDB Redo Generation with REDO_GENERATION_KBPS_MAX

#oracle #ai #database #linux
Comments
2 min read
PostgreSQL Table Bloat and Defragmentation: Autovacuum vs VACUUM vs VACUUM FULL
vahidusefzadeh profile

PostgreSQL Table Bloat and Defragmentation: Autovacuum vs VACUUM vs VACUUM FULL

#postgres #vacuum #autovacuum #database
Comments 1
8 min read
Migrating PostgreSQL 14 to 18 Using pg_dumpall
vahidusefzadeh profile

Migrating PostgreSQL 14 to 18 Using pg_dumpall

#postgres #oracle #database #ai
Comments
8 min read
Oracle Deep Data Security: Data Grants
vahidusefzadeh profile

Oracle Deep Data Security: Data Grants

#ai #webdev #programming #oracle
Comments
9 min read
PDB switchover
vahidusefzadeh profile

PDB switchover

#oracle #database #ai #webdev
Comments
6 min read
Oracle Deep Data Security in Oracle AI Database 26ai: End Users and Data Roles
vahidusefzadeh profile

Oracle Deep Data Security in Oracle AI Database 26ai: End Users and Data Roles

#oracle #ai #database #26ai
Comments 1
6 min read
PostgreSQL vs Oracle: When Higher Cost Means Better Performance
vahidusefzadeh profile

PostgreSQL vs Oracle: When Higher Cost Means Better Performance

#oracle #postgres #linux #ai
1
Comments
7 min read
Auto Redo Prioritization in Oracle AI Database 23.26.3: A Practical Test with OLTP and Batch Workloads
vahidusefzadeh profile

Auto Redo Prioritization in Oracle AI Database 23.26.3: A Practical Test with OLTP and Batch Workloads

#26ai #oracle #linux #ai
1
Comments
5 min read
Installing Oracle AI Database 26ai on Oracle Linux 10
vahidusefzadeh profile

Installing Oracle AI Database 26ai on Oracle Linux 10

#26ai #oracle #oel10 #linux
Comments
12 min read
Incremental Backup Using pg_basebackup in PostgreSQL 18
vahidusefzadeh profile

Incremental Backup Using pg_basebackup in PostgreSQL 18

#postgres #database #linux #ai
1
Comments
7 min read
Point-in-Time Recovery (PITR) with pg_basebackup in PostgreSQL 18
vahidusefzadeh profile

Point-in-Time Recovery (PITR) with pg_basebackup in PostgreSQL 18

#postgres #pitr #pgbasebackup #database
Comments
6 min read
Oracle 26ai- Installing Oracle Grid Infrastructure for a Standalone Server Using the Command-Line Interface
vahidusefzadeh profile

Oracle 26ai- Installing Oracle Grid Infrastructure for a Standalone Server Using the Command-Line Interface

#oracle #liux #26ai #ai
1
Comments
4 min read
Oracle AI Database 26ai(23.26.2)— DML Redirection for Data Guard per Pluggable Database
vahidusefzadeh profile

Oracle AI Database 26ai(23.26.2)— DML Redirection for Data Guard per Pluggable Database

#oracle #ai #devops #linux
1
Comments
2 min read
Automatic Standby PDB Instantiation and Standby Redo Log Creation in Oracle AI Database 26ai(23.26.2)
vahidusefzadeh profile

Automatic Standby PDB Instantiation and Standby Redo Log Creation in Oracle AI Database 26ai(23.26.2)

#oracle #ai #database #linux
1
Comments
4 min read
Oracle 26ai(23.26.2): WAIT and NOWAIT Support for DELETE, UPDATE, INSERT, and MERGE Statements
vahidusefzadeh profile

Oracle 26ai(23.26.2): WAIT and NOWAIT Support for DELETE, UPDATE, INSERT, and MERGE Statements

#oracle #devops #linux #ai
1
Comments
3 min read
Oracle 26ai — Enhancements to Data Dictionary Views for Partitioning
vahidusefzadeh profile

Oracle 26ai — Enhancements to Data Dictionary Views for Partitioning

#oracle #database #ai #devops
Comments
1 min read
Restoring a PDB Backup into a New CDB
vahidusefzadeh profile

Restoring a PDB Backup into a New CDB

#oracle #database #ai #sql
Comments
5 min read
Oracle Data Guard 26ai: Restricting Switchover and Failover Targets with PrimaryDatabaseCandidates
vahidusefzadeh profile

Oracle Data Guard 26ai: Restricting Switchover and Failover Targets with PrimaryDatabaseCandidates

#26ai #oracle #database #linux
1
Comments
2 min read
26ai- Using Tags in Oracle Data Guard Broker
vahidusefzadeh profile

26ai- Using Tags in Oracle Data Guard Broker

#ai #webdev #oracle #26ai
1
Comments
1 min read
Automatic temp file creation on the standby - Oracle AI Database 26ai
vahidusefzadeh profile

Automatic temp file creation on the standby - Oracle AI Database 26ai

#oracle #26ai #ai #programming
4
Comments
2 min read
Managing Alert Log Size in Oracle AI Database 26ai
vahidusefzadeh profile

Managing Alert Log Size in Oracle AI Database 26ai

#oracle #26ai #database #webdev
2
Comments
2 min read
Excluding LOB Columns Data in Data Pump
vahidusefzadeh profile

Excluding LOB Columns Data in Data Pump

#oracle #data #linux #devops
2
Comments
2 min read
Restoring a Datafile Using Archivelogs
vahidusefzadeh profile

Restoring a Datafile Using Archivelogs

#oracle #database #webdev #programming
Comments
2 min read
Oracle AI Database 26ai — Managing AWR in Active Data Guard
vahidusefzadeh profile

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

#26ai #oracle #database #webdev
3
Comments
3 min read
Generating AWR Reports in an Active Data Guard using RMF(12.2)
vahidusefzadeh profile

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

#oracle #database #linux #sql
Comments
4 min read
Automatic Flashback (or PITR) Standby
vahidusefzadeh profile

Automatic Flashback (or PITR) Standby

#oracle #database #linux #sql
Comments
12 min read
Oracle AI Database 26ai - SQL Domain
vahidusefzadeh profile

Oracle AI Database 26ai - SQL Domain

#oracle #26ai #database #ai
Comments
6 min read
Adding PDB Resources in Grid Infrastructure
vahidusefzadeh profile

Adding PDB Resources in Grid Infrastructure

#oracle #linux #database #sql
Comments
2 min read
SESSION-LEVEL SEQUENCES
vahidusefzadeh profile

SESSION-LEVEL SEQUENCES

#database #sql #tutorial
Comments
1 min read
A Brief Review of Interval Partitioning
vahidusefzadeh profile

A Brief Review of Interval Partitioning

#oracle #linux #database #sql
Comments
6 min read
What’s New in Oracle AI Database 26ai? Exploring 50+ Major New Features
vahidusefzadeh profile

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

#oracle #database #ai #linux
3
Comments 1
5 min read
Oracle AI Database 26ai — Wide Tables
vahidusefzadeh profile

Oracle AI Database 26ai — Wide Tables

#oracle26ai #ai #database #programming
Comments
1 min read
Oracle AI Database 26ai— Automatic Transaction Rollback (Priority Transactions with high, medium and low priority)
vahidusefzadeh profile

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

#oracle26ai #database #devops #linux
Comments
3 min read
Oracle AI Database 26ai — Dictionary Protection
vahidusefzadeh profile

Oracle AI Database 26ai — Dictionary Protection

#devops #linux #database #oracle26ai
1
Comments
4 min read
FAR SYNC Data Guard
vahidusefzadeh profile

FAR SYNC Data Guard

#oracle #devops #linux #database
Comments
3 min read
Mandatory Profile in Oracle Database
vahidusefzadeh profile

Mandatory Profile in Oracle Database

#oracle #linux #database #sql
Comments
3 min read
Restoring a Lost Datafile from Standby Using RMAN
vahidusefzadeh profile

Restoring a Lost Datafile from Standby Using RMAN

#oracle #devops #linux #database
1
Comments
1 min read
Rolling Back Online Table Redefinition
vahidusefzadeh profile

Rolling Back Online Table Redefinition

#oracle #devops #linux #sql
Comments
2 min read
The dml_lock_timeout Parameter in the DBMS_REDEFINITION Package
vahidusefzadeh profile

The dml_lock_timeout Parameter in the DBMS_REDEFINITION Package

#oracle #devops #linux #database
Comments
1 min read
Oracle AI Database 26ai: Bind Variable Support in Materialized View Query Rewrite
vahidusefzadeh profile

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

#oracle26ai #devops #linux #data
Comments
4 min read
PDB Recovery Isolation
vahidusefzadeh profile

PDB Recovery Isolation

#oracle #linux #devops #database
Comments
6 min read
DBMS_JOB and DBMS_SCHEDULER Integration in Oracle 19c
vahidusefzadeh profile

DBMS_JOB and DBMS_SCHEDULER Integration in Oracle 19c

#oracle #devops #linux #database
Comments
4 min read
Oracle AI Database 26ai: RESETTABLE Clause
vahidusefzadeh profile

Oracle AI Database 26ai: RESETTABLE Clause

#oracle26ai #data #linux #devops
Comments
2 min read
Oracle 21c — Using Result Cache in Standby
vahidusefzadeh profile

Oracle 21c — Using Result Cache in Standby

#oracle #21c #oracle21c #database
Comments
2 min read
Oracle AI Database 26ai: Filtering Analytic Function Results with the QUALIFY Clause
vahidusefzadeh profile

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

#oracle26ai #26ai #devops #database
Comments
1 min read
Installing Oracle AI Database 26ai Free on Oracle Linux 9
vahidusefzadeh profile

Installing Oracle AI Database 26ai Free on Oracle Linux 9

#oracle26ai #data #devops #linux
1
Comments
5 min read
Oracle 21c — Removal of IGNORECASE and SEC_CASE_SENSITIVE_LOGON Parameters
vahidusefzadeh profile

Oracle 21c — Removal of IGNORECASE and SEC_CASE_SENSITIVE_LOGON Parameters

#devops #oracle #database #linux
Comments
2 min read
Expression-Based Parameter Value Feature in Oracle 21c
vahidusefzadeh profile

Expression-Based Parameter Value Feature in Oracle 21c

#devops #oracle #linux #database
Comments
1 min read
Oracle vs PostgreSQL: How Undo Tablespace and MVCC Handle Updates and Deletes
vahidusefzadeh profile

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

#oracle #devops #postgres #database
Comments
7 min read
Sequence Dynamic Cache Resizing in Oracle 21c and 19.10
vahidusefzadeh profile

Sequence Dynamic Cache Resizing in Oracle 21c and 19.10

#oracle #devops #linux #sql
Comments
3 min read
A Note on Taking Backups from Standby
vahidusefzadeh profile

A Note on Taking Backups from Standby

#devops #oracle #linux #database
Comments
2 min read
Buffer Busy Wait and Read by Other Session in Oracle
vahidusefzadeh profile

Buffer Busy Wait and Read by Other Session in Oracle

#oracle #linux #database #sql
Comments
4 min read
loading...