Oracle DBA Performance Tuning Training at Futurepointtech

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

Courses Offerings

• Abinitio
• Android
• AIX Administration
• Business Analyst
• CCNA, CCNP Security, CCIE
• Citrix XenApp
• Cognos 10 BI & Tm1
• Crystal Reports
• Data Stage
• DB2 DBA
• Dot Net
• DAC
• Google Web Tool Kit
• Golden Gate
• Hadoop
• HTML 5
• IBM Websphere Commerce server Admin
• IBM Lotus Notes (Development)
• IBM Lotus Notes Domino Server Administration
• IBM Message Broker
• IBM MQ Series
• IBM Tivoli Access Manager
• IBM Web Sphere Application Server Administration (WAS)
• IBM WAS Portal server Development
• IBM Websphere Transformation extender (WTX 8.2)
• Informatica
• I Phone
• Java/J2EE
• J Query
• Java Apache Wicket
• MCITP
• MicroSoft .NET Technologies (VB.NET, C#, ASP.NET)
• Microstrategy

http://www.futurepointtech.com/oracle-performance-tuning-training.html
Drop a mail [email protected] we will get in touch with u