Classified Sense

Ref: CS121010
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
• MicroSoft Business Intelligence
• OBIEE 11 g
• ODI ( Oracle Data Integrator)
• Oracle ATG
• Oracle APPS – HRMS
• Oracle APPS – SCM
• Oracle APPS - Manufacturing
• Oracle APPS – Financial
• Oracle APPS – Technical
• Oracle APPS – Project Accounting
• Oracle BI Apps
• Oracle BI Publisher
• Oracle DBA 11g
• Oracle RAC , Data Guard , Performance Tuning,
• Oracle Fusion SOA
• Oracle SQL , PL SQL
• People Soft
• PHP
• Perl Scripting
• Qlikview
• RUBY Cucumber
• SAP SD , BO , FICO , BI / BW , APO , BPC, BASIS , SRM , MM, ISOil
• SAS
• Sales Force CRM
• SharePoint Server 2010
• Shell Scripting
• Siebel CRM , EAI, E-Scripting
• SQL Server DBA
• Springs and Hibernate
• Storage Area Network ( SAN)
• Tableau
• Tera Data
• Testing Tools - QTP, QC, Load Runner, Selenium, ISTQB, RFT
• TIBCO BW, BE, TIBCO I Process
• Tivoli Access Manager & Identity Manager
• Unix Administration
• VMWare
• WCF, WPF, LINQ, AJAX, SILVER LIGHT
• Webservices , SOAP , REST ( JAVA)
• Windows 2012 server

www.futurepointtech.com/oracle-performance-tuning-training.html
Drop a mail info@futurepointtech.com we will get in touch with u

More details: Oracle DBA Performance Tuning Training Course
On Social:/FuturePointTech/FuturePoint Technologies/futurepoint-technologies/FuturePoint Technologies/+FuturePointTechHyderabad