Pluralsight - Oracle Performance Tuning for Developers - 2014

seeders: 12

leechers: 31

Download torrent

Added on January 18, 2015 by RocknBassin Other > Tutorials
Torrent verified.

Main

add to bookmarks

Pluralsight - Oracle Performance Tuning for Developers - 2014 (Size: 877.2 MB)

		01_01-Introduction.mp4	5.21 MB
		01_02-Performance Tuning is Not Magic.mp4	11.16 MB
		01_03-Performance Tuning Approach.mp4	5.97 MB
		01_04-Performance Tuning Principles.mp4	7.28 MB
		01_05-Sample Database.mp4	15.13 MB
		02_01-Introduction.mp4	2.24 MB
		02_02-System Scalability.mp4	6.51 MB
		02_03-Oracle Architecture Overview.mp4	10.62 MB
		02_04-Buffer Cache.mp4	4.99 MB
		02_05-Shared Pool.mp4	3.42 MB
		02_06-Program Global Area.mp4	3.74 MB
		02_07-Oracle Architecture Wrap Up.mp4	2.77 MB
		02_08-Performance Metrics.mp4	15.69 MB
		02_09-Performance Tuning and Database Size.mp4	9.48 MB
		02_10-Building Effective Performance Test Databases.mp4	5.77 MB
		02_11-Performance Tuning Database use Scenarios.mp4	17.77 MB
		03_01-Introduction.mp4	8.66 MB
		03_02-Demo - Connecting With and Without Connection Pools.mp4	6.79 MB
		03_03-Using a Connection Pool in .NET.mp4	6.75 MB
		03_04-Using a Connection Pool in Java.mp4	7.52 MB
		03_05-Connection Pool Best Practices.mp4	11.62 MB
		03_06-Demo - Blocking Connections.mp4	15.02 MB
		03_07-Summary.mp4	4.33 MB
		04_01-Introduction.mp4	3.51 MB
		04_02-The Shared SQL Area.mp4	14.74 MB
		04_03-Contention and Latch Waits.mp4	18.82 MB
		04_04-Matching SQL Statements.mp4	35.68 MB
		04_05-Using Bind Variables in Applications.mp4	23.76 MB
		04_06-Sample Application to Compare Approaches.mp4	24.05 MB
		04_07-Evaluation of Impacts of Bind Variables.mp4	8.48 MB
		05_01-What is an Execution Plan.mp4	9.49 MB
		05_02-Getting an Execution Plan.mp4	8.11 MB
		05_03-What Does an Execution Plan Contain.mp4	14.64 MB
		05_04-Reading an Execution Plan.mp4	13.4 MB
		05_05-Analyzing an Execution Plan.mp4	7.88 MB
		05_06-Autotrace Introduction.mp4	6.23 MB
		05_07-Autotrace Example in SQL Developer.mp4	13.22 MB
		05_08-Autotrace Example in SQL Plus.mp4	15.48 MB
		05_09-Data Size and Execution Plans.mp4	9.23 MB
		05_10-Summary.mp4	1.42 MB
		06_01-Introduction.mp4	2.48 MB
		06_02-Table Access Operations.mp4	13.63 MB
		06_03-Demo - Table Access Operations.mp4	13.36 MB
		06_04-Index Lookup Operations.mp4	15.67 MB
		06_05-Demo - Index Lookup Operations.mp4	11.22 MB
		06_06-Index Full Scan Operations.mp4	5 MB
		06_07-Join Operations.mp4	14.74 MB
		06_08-Tuning SQL Statements.mp4	14.54 MB
		07_01-Why Indexing Matters.mp4	9.49 MB
		07_02-B-Tree Indexes.mp4	9.27 MB
		07_03-Bitmap Indexes.mp4	10.97 MB
		07_04-Index Column Order Matters.mp4	8.15 MB
		07_05-Demo - Index Column Order.mp4	10.08 MB
		07_06-Index Skip Scan Operations.mp4	5 MB
		07_07-Index Selectivity.mp4	14.23 MB
		07_08-Selectivity for Composite Indexes.mp4	4.78 MB
		07_09-Demo - Index Selectivity.mp4	10.51 MB
		07_10-Determining Index Column Order.mp4	4.2 MB
		08_01-Module Outline.mp4	2.16 MB
		08_02-Covering Indexes.mp4	16.78 MB
		08_03-Function Based Indexes Introduction.mp4	12.52 MB
		08_04-Demo - Function Based Indexes. Case Insensitive Search.mp4	10.37 MB
		08_05-Selective Row Indexing With Function Based Indexes.mp4	10.52 MB
		08_06-Demo - Function Based Indexes. Selective Indexing.mp4	7.54 MB
		08_07-Index Compression.mp4	10.83 MB
		08_08-Invisible Indexes.mp4	5.06 MB
		08_09-Demo - Invisible Indexes.mp4	9.73 MB
		08_10-Summary.mp4	2.51 MB
		09_01-Introduction.mp4	1.79 MB
		09_02-What Should I Index.mp4	10.16 MB
		09_03-Indexing Costs and Overhead.mp4	7.29 MB
		09_04-Demo - Indexing Overhead.mp4	11.45 MB
		09_05-Similar Indexes.mp4	3.06 MB
		09_06-Monitoring Index Usage.mp4	8.48 MB
		09_07-Why isnt Oracle Using My Index.mp4	1.83 MB
		09_08-Missing Leading Edge of Index.mp4	2.8 MB
		09_09-Index not Selective Enough.mp4	2.57 MB
		09_10-Using a Like Clause and a Leading Wildcard.mp4	4.2 MB
		10_01-Motivation for Performance Monitoring.mp4	10.56 MB
		10_02-Required Permissions.mp4	9.77 MB
		10_03-Introduction to Queries.mp4	1.01 MB
		10_04-Session Information.mp4	3.63 MB
		10_05-Session Resource Usage.mp4	2.59 MB
		10_06-What Statements are Running Right Now.mp4	2.92 MB
		10_07-Finding the Worst Performing Statements.mp4	9.37 MB
		10_08-Statements Conducting Full Scan Operations.mp4	3.44 MB
		10_09-Retrieving Execution Plans.mp4	1.2 MB
		10_10-Monitoring Index Usage.mp4	4.43 MB
		11_01-Module Introduction.mp4	5.18 MB
		11_02-Separating Transactional and Reporting Databases.mp4	14.08 MB
		11_03-Loading too Much Data.mp4	7.63 MB
		11_04-Committing Data too Frequently.mp4	16.17 MB
		11_05-ORMs and Abstraction From the Database.mp4	4.79 MB
		11_06-ORMs and the n+1 Selects Issue.mp4	2.1 MB
		11_07-Summary.mp4	6.99 MB

Description

Year : 2014
Manufacturer : pluralsight
Author : David Berry
Duration : 7h 1m
Language : English
Format : MP4
Video : AVC, 1024x768, 4: 3, 15 fps, 111 Kbps
Audio : AAC, 123 Kbps, 2 channels, 44.1 KHz

This course introduces developers to the fundamental principles of performance tuning when using Oracle as their backend database. This course introduces developers to the basic principles of performance tuning using Oracle as the backend database.

01. Why Performance Tuning Matters 21:17
Introduction 2:50
Performance Tuning is Not Magic 6:00
Performance Tuning Approach 3:32
Performance Tuning Principles 3:54
Sample Database 4:59

02. Oracle Architecture and Performance Basics 48:51
Introduction 1:25
System Scalability 3:41
Oracle Architecture Overview 4:35
Buffer Cache 2:56
Shared Pool 2:13
Program Global Area 2:24
Oracle Architecture Wrap Up 1:58
Performance Metrics 10:03
Performance Tuning and Database Size 5:55
Building Effective Performance Test Databases 3:36
Performance Tuning Database use Scenarios 9:59

03. Connections and Connection Pools 28:15
Introduction 4:55
Demo: Connecting With and Without Connection Pools 2:47
Using a Connection Pool in .NET 3:26
Using a Connection Pool in Java 3:40
Connection Pool Best Practices 6:14
Demo: Blocking Connections 4:35
Summary 2:34

04. Bind Variables 43:02
Introduction 1:46
The Shared SQL Area 8:17
Contention and Latch Waits 10:07
Matching SQL Statements 6:13
Using Bind Variables in Applications 6:13
Sample Application to Compare Approaches 6:16
Evaluation of Impacts of Bind Variables 4:06

05. Statement Level Performance Tuning 34:45
What is an Execution Plan 4:28
Getting an Execution Plan 2:59
What Does an Execution Plan Contain? 2:54
Reading an Execution Plan 4:25
Analyzing an Execution Plan 2:29
Autotrace Introduction 4:10
Autotrace Example in SQL Developer 4:24
Autotrace Example in SQL*Plus 3:34
Data Size and Execution Plans 4:31
Summary 0:47

06. Execution Plans in Depth 46:19
Introduction 1:16
Table Access Operations 7:38
Demo: Table Access Operations 5:18
Index Lookup Operations 5:42
Demo: Index Lookup Operations 5:18
Index Full Scan Operations 3:26
Join Operations 8:33
Tuning SQL Statements 9:04

07. Indexing Essentials 48:38
Why Indexing Matters 6:19
B-Tree Indexes 4:54
Bitmap Indexes 6:42
Index Column Order Matters 4:52
Demo: Index Column Order 3:58
Index Skip Scan Operations 3:13
Index Selectivity 7:55
Selectivity for Composite Indexes 3:00
Demo: Index Selectivity 4:43
Determining Index Column Order 2:56

08. Advanced Indexing Techniques 46:22
Module Outline 1:42
Covering Indexes 7:55
Function Based Indexes Introduction 7:42
Demo - Function Based Indexes: Case Insensitive Search 4:03
Selective Row Indexing With Function Based Indexes 6:13
Demo - Function Based Indexes: Selective Indexing 3:11
Index Compression 6:29
Invisible Indexes 3:26
Demo: Invisible Indexes 4:03
Summary 1:32

09. Application Indexing Practices 42:16
Introduction 1:13
What Should I Index? 6:53
Indexing Costs and Overhead 4:39
Demo: Indexing Overhead 4:17
Similar Indexes 1:49
Monitoring Index Usage 4:26
Why isn't Oracle Using My Index? 1:01
Missing Leading Edge of Index 1:28
Index not Selective Enough 1:29
Using a Like Clause and a Leading Wildcard 2:38
Like Clauses and Index Selectivity 3:05
Function in the Where Clause 2:49
Data Type Conversion in the Where Clause 2:26
Outdated Database Statistics 2:47
Summary 1:10

10. Monitoring Oracle Applications 35:11
Motivation for Performance Monitoring 6:10
Required Permissions 6:19
Introduction to Queries 0:50
Session Information 2:08
Session Resource Usage 1:15
What Statements are Running Right Now? 1:15
Finding the Worst Performing Statements 4:38
Statements Conducting Full Scan Operations 1:31
Retrieving Execution Plans 0:48
Monitoring Index Usage 2:14
Monitoring Hard Parsing and SQL Using Literal Values 2:59
Table Information 2:46
Index Information 0:52
Summary 1:19

11. Pitfalls and Practices 26:45
Module Introduction 1:27
Separating Transactional and Reporting Databases 4:05
Loading too Much Data 3:08
Committing Data too Frequently 6:20
ORMs and Abstraction From the Database 3:14
ORMs and the n+1 Selects Issue 5:30
Summary 2:59

Sharing Widget

Download torrent

877.2 MB

seeders:12

leechers:31

Pluralsight - Oracle Performance Tuning for Developers - 2014