03:55

01 04 Performance Tuning Principles

02:14

0609 Demo 1 Managing Data Consistency

01:05

0611 Summary

05:49

0610 Demo 2 Taking Charge of Data Concurrency

01:16

0511 Summary

05:27

0510 Demo 2 Building Jobs With SQL Developer

01:34

0413 Resource Manager in a Multitenant Environment

05:59

0414 Demo 3 Creating a Resource Plan

01:14

0411 Consumer Group Mapping Rules

01:38

0415 Summary

00:56

0412 Managing Resource Consumer Groups

00:18

0410 Built In Consumer Groups

05:31

11 04 Committing Data too Frequently

06:21

11 02 Separating Transactional and Reporting Databases

03:00

11 05 ORMs and Abstraction From the Database

03:15

11 03 Loading too Much Data

03:09

11 01 Module Introduction

02:09

10 04 Session Information

01:32

10 08 Statements Conducting Full Scan Operations

04:40

10 07 Finding the Worst Performing Statements

06:20

10 02 Required Permissions

01:16

10 06 What Statements are Running Right Now

01:16

10 05 Session Resource Usage

00:51

10 03 Introduction to Queries

02:57

02 04 Buffer Cache

01:59

02 07 Oracle Architecture Wrap Up

02:25

02 06 Program Global Area

02:14

02 05 Shared Pool

10:04

02 08 Performance Metrics

05:56

02 09 Performance Tuning and Database Size

01:28

11 06 ORMs and the n+1 Selects Issue

00:49

10 09 Retrieving Execution Plans

04:06

11 07 Summary

03:37

02 10 Building Effective Performance Test Databases

10:00

02 11 Performance Tuning Database use Scenarios

02:15

10 10 Monitoring Index Usage

03:00

10 11 Monitoring Hard Parsing and SQL Using Literal Values

02:47

10 12 Table Information

00:53

10 13 Index Information

01:20

10 14 Summary

06:11

10 01 Motivation for Performance Monitoring

02:27

09 13 Data Type Conversion in the Where Clause

02:39

09 10 Using a Like Clause and a Leading Wildcard

01:30

09 09 Index not Selective Enough

02:50

09 12 Function in the Where Clause

06:54

09 02 What Should I Index

02:48

09 14 Outdated Database Statistics

01:02

09 07 Why isnt Oracle Using My Index

01:11

09 15 Summary

01:14

09 01 Introduction

01:29

09 08 Missing Leading Edge of Index

01:50

09 05 Similar Indexes

04:40

09 03 Indexing Costs and Overhead

04:18

09 04 Demo Indexing Overhead

03:06

09 11 Like Clauses and Index Selectivity

04:27

09 06 Monitoring Index Usage

04:04

08 09 Demo Invisible Indexes

01:33

08 10 Summary

03:12

08 06 Demo Function Based Indexes Selective Indexing

06:30

08 07 Index Compression