EXCEPTIONAL TRAINING COURSES FOR IT PROFESSIONALS
LONDON UK | ONSITE | ONLINE
Memory, Process and Disk Structure, Disk Structure, Parameter File, Control File, Data Files, Redo Log Files, Password File, Logical / Physical Structures, Segments, Extents, Blocks, Memory Structure, Shared Pool, Buffer Cache, Redo Log Buffer, Process Structure, User and Shadow Processes, Database Writer, Log Writer, System Monitor, Process Monitor, Archiver, Processing a query, Processing an Update, Processing a transaction.
Planning to Tune, What is to be tuned?, What is needed?, What is the tuning target?, How to achieve your goals.
Tools Overview, Oracle Enterprise Manager, OEM Packs, Alert Log, Trace Files, Static Dictionary Tables, Dynamic Performance Views, UTLBSTAT/UTLESTAT, Statspack, Advisor Central, awrrpt reports,addmrpt
Table and Index Statistics, System Statistics, Statistics Gathering Mechanisms, DBMS_STATS Package, DBMS_STATS Procedures, System Statistics Procedures, Executing System Stats Procedures, Dictionary Statistics Procedures
Shared Pool Tuning, Cache Tuning, Redo Log Buffer Tuning, Automating Memory Settings, Parameters settings, Dynamic Memory Management.
Data Files, Processes and Data Files, Data File Tuning Goals, Optimise disk I/O by tablespaces, Using Tablespaces Effectively, Separate busy tables from each other, Tablespace Types, Extent Management, Segment Space Management, Setting Up ASSM, Checking Tablespace Usage, Plan UNDO/ROLLBACK tablespace usage, Redo Log File Tuning Goals, Checkpoints.
Rollback Segments v Automatic Undo Management.
Block Tuning Guidelines, Tablespace types, Dynamic extent allocation, Database Block Sizing, Block Packing Factor, Chaining and Migration, High Water Mark, Space Recovery Mechanisms, Index Reorganisation, Index Reorganisation Views.
ASM Automatic Storage Management, Architecture, Setting Parameters, Configuring ASM.
Sorting Overview, Sorting Mechanisms, Sort Operations, Sort Tuning Goals, Measuring Sorts, Oracle Latches, Investigating Latches, Latch Issue Resolution, Locking Overview, Lock Types, Locking Issues, Locking Diagnostics, Resolving Locking Issues.
See why people choose JBI
03/10/2017: Traditionally Cyber security has been associated mainly with penetrating networks and infrastructure. Now a more subtle level of attack needs...
05/10/2017: Back in March 2014, the Angular team dropped a bomb by announcing Angular 2 and everyone started yelling. Instead of an evolutionary step forward,...
05/10/2017: MVC The Model View Controller (MVC) architectural pattern has a long history (together with its variants) and has been used in many languages...
12/10/2017: The Graduate Programme provided a gateway into technology within investment banking. Graduates (Computer Science, Engineering, Maths, Physics...
13/10/2017: This organisation needed their Supply Chain department to get fully involved with Microsoft’s Power BI reporting product as soon as possible....
07/10/2017: This client had previously utilised third parties to develop and deliver its customer facing products and services. A strategy change required...
Call our Tech Team : 0800 028 6400 request info
Bring a JBI course to your office
and train a whole team onsite
0800 028 6400 or request quote
Get in touch
0800 028 6400
Our inspiring and up-to-date courses gain exceptional feedback
"great tips help reduce build times"
"we got access to exclusive content"
"Short course meant less time off"
"what an inspiring trainer !"
"colleagues at 2 sites joined via web"
"I passed my exam the next day"