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.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
1
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
ALTER TABLE … MOVE ONLINE
vahidusefzadeh profile

ALTER TABLE … MOVE ONLINE

#oracle #linux #devops #database
Comments
1 min read
enq: TX — allocate ITL entry
vahidusefzadeh profile

enq: TX — allocate ITL entry

#oracle #devops #linux #database
Comments
9 min read
Hybrid Partition Table in Oracle 19c
vahidusefzadeh profile

Hybrid Partition Table in Oracle 19c

#oracle #devops #linux #database
Comments
3 min read
Reducing Unified Audit Trail Size in Oracle AI Database 26ai
vahidusefzadeh profile

Reducing Unified Audit Trail Size in Oracle AI Database 26ai

#oracle #dba #database #linux
Comments
3 min read
DataPump : Disabling the Use of Symbolic Links When Creating a Directory
vahidusefzadeh profile

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

#oracle #database #sql #linux
Comments
2 min read
Resolving Missing Log Gaps in Data Guard
vahidusefzadeh profile

Resolving Missing Log Gaps in Data Guard

#oracle #database #linux #rman
2
Comments
4 min read
Oracle 19c — Audit Only Top-Level SQL Statements
vahidusefzadeh profile

Oracle 19c — Audit Only Top-Level SQL Statements

#devops #oracle #database #linux
Comments
3 min read
Schema Only Accounts Feature in Oracle 18c and 19c
vahidusefzadeh profile

Schema Only Accounts Feature in Oracle 18c and 19c

#devops #oracle #linx #database
1
Comments
4 min read
loading...