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
10/02/2018: A leading Financial institution commissioned JBI to run a series of Agile/Scrum courses for various teams - inhouse. Pre-course consultation...
10/02/2018: Background The Development Team found itself having legacy modules developed in Ruby script. These modules would rapidly render dynamically changing...
06/02/2018: Originating from Facebook, React is a component based front-end library that allows you to build applications out of a tree of small, testable,...
12/10/2017: The Graduate Programme provided a gateway into technology within investment banking. Graduates (Computer Science, Engineering, Maths, Physics...
27/02/2018: Mariella has put together this short briefing on the bookmarks functionality in Power BI... "I love it!" she says.. Bookmarks has been available...
27/02/2018: Our world is changing; this is hardly anything new. New startups emerge consistently, almost on a daily basis, each claiming to have the latest...
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
Excellent feedback, consistently !
"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"