ACE Profile

Full Name

ACE Associate

Job Role Sr technology Architect

Company Cognizant technology Solutions

Country United States

Top Expertise Database Performance Management

Focus Area Database

About Dhritiman

Dhritiman has 18+ years of experience in IT industry, among which 15 years in Oracle database administration. He is an Oracle certified professional in 9i and 10g.

Exadata certified specialist
ITIL V3 certified
Specialties: Oracle database administration(9i/10g/11g/12c/19c)
PL/SQL
Shell scripting
Perl scripting
Python scripting

Expertises Database Performance Management Advanced Compression Active Data Guard (ADG) OEM Tuning Pack Exadata Database Machine Automatic Storage Management (ASM)

Home Page https://exploreora.blogspot.com/

Cloud Customer Connect https://community.oracle.com/mosc/profile/discussions/DDeb

Links

Latest Contributions

#SELECTION#

#ICON_HTML#

How to use Apex and oracle database 23ai for efficient similarity search

Oct 02, 2025 - Article (in 3rd party publication) -

AI Vector Search

#ACTIONS#
#SELECTION#

#ICON_HTML#

Migrate database from X8-2 TO X11-2 hardware

Sep 29, 2025 - Blog post -

Active Data Guard (ADG)

#ACTIONS#
#SELECTION#

#ICON_HTML#

Vector similarity search using Oracle Database 23 ai and apex 24.2

Aug 20, 2025 - Blog post -

AI Vector Search

#ACTIONS#
#SELECTION#

#ICON_HTML#

How to utilize oratop efficiently

Aug 08, 2025 - Blog post -

Autonomous Health Framework (AHF)

#ACTIONS#
#SELECTION#

#ICON_HTML#

How to tune query which is accessing CLOB column

Aug 01, 2025 - Blog post -

SQL Tuning Advisor

#ACTIONS#
#SELECTION#

#ICON_HTML#

Optimizing ASM storage growth with ACFS snapshot

Jul 07, 2025 - Article (in 3rd party publication) -

Oracle ACFS

#ACTIONS#
#SELECTION#

#ICON_HTML#

When SQL plan baseline is not used

Jun 20, 2025 - Blog post -

SQL Performance

#ACTIONS#
#SELECTION#

#ICON_HTML#

How to test SQL execution manually using bind variables

Jun 15, 2025 - Blog post -

SQL Performance

#ACTIONS#
#SELECTION#

#ICON_HTML#

Rman backup based duplication without target and recovery catalog db connection

Jun 07, 2025 - Blog post -

Backup and Recovery

#ACTIONS#
#SELECTION#

#ICON_HTML#

Storage optimization using acfs

Apr 23, 2025 - Blog post -

Oracle ACFS

#ACTIONS#
#SELECTION#

#ICON_HTML#

How to create standby database using OEM

Apr 17, 2025 - Blog post -

Data Guard

#ACTIONS#
#SELECTION#

#ICON_HTML#

Explore alternate archivelog location

Apr 14, 2025 - Blog post -

Archive Storage

#ACTIONS#
#SELECTION#

#ICON_HTML#

Manual snap database creation

Apr 08, 2025 - Blog post -

Oracle ACFS

#ACTIONS#
#SELECTION#

#ICON_HTML#

How to run SQL tuning advisor when SQL is aged out of cursor cache

Apr 05, 2025 - Blog post -

SQL Tuning Advisor

#ACTIONS#
#SELECTION#

#ICON_HTML#

Importance of bind variable in SQL code

Apr 03, 2025 - Blog post -

Adaptive Execution Plans

#ACTIONS#

1 - 15

ACE

Top Level Details

About Dhritiman

Latest Contributions