Oracle Performance tuning 1 to 1 session

Oracle Performance tuning 1 to 1 session @ FUTUREPOINT

Oracle Performance Tuning
SQL tuning
Query Optimizer and Execution plan
Index suggestions
Query structure change
Hints
Tkprof analysis
DBMS Profiler
Various index scans vs Table scan

Automatics SQL Tuning
Automatic tuning optimizer
Statistics analysis
Sql Profiling
SQL tuning advisor

Report analysis
AWR
ADDM
ASH

Oracle enterprise Manager (OEM)
DB Health check
Performance monitoring
Running above reports

Instance Tuning
Memory tuning
Automatic memory management
Wait events

Segment tuning
Index rebuilding
Segment move/shrink operations
Segment advisor

Partition and Compression
Partition types and benfits
OLTP compression
LOB compression with secure files

Real Time cases
Tuning query in given time period
Troubleshooting ongoing query issues
Archival Process
Partition Purge
Separating report data using goldengate


Drop a mail [email protected] we will get in touch with u

call 91 9247765590