TorBT - Torrents and Magnet Links Search Engine
[pluralsight.com] Oracle Performance Tuning for Developers
- Date: 2022-06-01
- Size: 877 MB
- Files: 104
File Name
Size
01. Why Performance Tuning Matters/01_01-Introduction.mp4
5.2 MB
01. Why Performance Tuning Matters/01_02-Performance Tuning is Not Magic.mp4
11 MB
01. Why Performance Tuning Matters/01_03-Performance Tuning Approach.mp4
6.0 MB
01. Why Performance Tuning Matters/01_04-Performance Tuning Principles.mp4
7.3 MB
01. Why Performance Tuning Matters/01_05-Sample Database.mp4
15 MB
02. Oracle Architecture and Performance Basics/02_01-Introduction.mp4
2.2 MB
02. Oracle Architecture and Performance Basics/02_02-System Scalability.mp4
6.5 MB
02. Oracle Architecture and Performance Basics/02_03-Oracle Architecture Overview.mp4
11 MB
02. Oracle Architecture and Performance Basics/02_04-Buffer Cache.mp4
5.0 MB
02. Oracle Architecture and Performance Basics/02_05-Shared Pool.mp4
3.4 MB
02. Oracle Architecture and Performance Basics/02_06-Program Global Area.mp4
3.7 MB
02. Oracle Architecture and Performance Basics/02_07-Oracle Architecture Wrap Up.mp4
2.8 MB
02. Oracle Architecture and Performance Basics/02_08-Performance Metrics.mp4
16 MB
02. Oracle Architecture and Performance Basics/02_09-Performance Tuning and Database Size.mp4
9.5 MB
02. Oracle Architecture and Performance Basics/02_10-Building Effective Performance Test Databases.mp4
5.8 MB
02. Oracle Architecture and Performance Basics/02_11-Performance Tuning Database use Scenarios.mp4
18 MB
03. Connections and Connection Pools/03_01-Introduction.mp4
8.7 MB
03. Connections and Connection Pools/03_02-Demo - Connecting With and Without Connection Pools.mp4
6.8 MB
03. Connections and Connection Pools/03_03-Using a Connection Pool in .NET.mp4
6.7 MB
03. Connections and Connection Pools/03_04-Using a Connection Pool in Java.mp4
7.5 MB
03. Connections and Connection Pools/03_05-Connection Pool Best Practices.mp4
12 MB
03. Connections and Connection Pools/03_06-Demo - Blocking Connections.mp4
15 MB
03. Connections and Connection Pools/03_07-Summary.mp4
4.3 MB
04. Bind Variables/04_01-Introduction.mp4
3.5 MB
04. Bind Variables/04_02-The Shared SQL Area.mp4
15 MB
04. Bind Variables/04_03-Contention and Latch Waits.mp4
19 MB
04. Bind Variables/04_04-Matching SQL Statements.mp4
36 MB
04. Bind Variables/04_05-Using Bind Variables in Applications.mp4
24 MB
04. Bind Variables/04_06-Sample Application to Compare Approaches.mp4
24 MB
04. Bind Variables/04_07-Evaluation of Impacts of Bind Variables.mp4
8.5 MB
05. Statement Level Performance Tuning/05_01-What is an Execution Plan.mp4
9.5 MB
05. Statement Level Performance Tuning/05_02-Getting an Execution Plan.mp4
8.1 MB
05. Statement Level Performance Tuning/05_03-What Does an Execution Plan Contain.mp4
15 MB
05. Statement Level Performance Tuning/05_04-Reading an Execution Plan.mp4
13 MB
05. Statement Level Performance Tuning/05_05-Analyzing an Execution Plan.mp4
7.9 MB
05. Statement Level Performance Tuning/05_06-Autotrace Introduction.mp4
6.2 MB
05. Statement Level Performance Tuning/05_07-Autotrace Example in SQL Developer.mp4
13 MB
05. Statement Level Performance Tuning/05_08-Autotrace Example in SQL Plus.mp4
16 MB
05. Statement Level Performance Tuning/05_09-Data Size and Execution Plans.mp4
9.2 MB
05. Statement Level Performance Tuning/05_10-Summary.mp4
1.4 MB
06. Execution Plans in Depth/06_01-Introduction.mp4
2.5 MB
06. Execution Plans in Depth/06_02-Table Access Operations.mp4
14 MB
06. Execution Plans in Depth/06_03-Demo - Table Access Operations.mp4
13 MB
06. Execution Plans in Depth/06_04-Index Lookup Operations.mp4
16 MB
06. Execution Plans in Depth/06_05-Demo - Index Lookup Operations.mp4
11 MB
06. Execution Plans in Depth/06_06-Index Full Scan Operations.mp4
5.0 MB
06. Execution Plans in Depth/06_07-Join Operations.mp4
15 MB
06. Execution Plans in Depth/06_08-Tuning SQL Statements.mp4
14 MB
07. Indexing Essentials/07_01-Why Indexing Matters.mp4
9.5 MB
07. Indexing Essentials/07_02-B-Tree Indexes.mp4
9.3 MB
07. Indexing Essentials/07_03-Bitmap Indexes.mp4
11 MB
07. Indexing Essentials/07_04-Index Column Order Matters.mp4
8.1 MB
07. Indexing Essentials/07_05-Demo - Index Column Order.mp4
10 MB
07. Indexing Essentials/07_06-Index Skip Scan Operations.mp4
5.0 MB
07. Indexing Essentials/07_07-Index Selectivity.mp4
14 MB
07. Indexing Essentials/07_08-Selectivity for Composite Indexes.mp4
4.8 MB
07. Indexing Essentials/07_09-Demo - Index Selectivity.mp4
10 MB
07. Indexing Essentials/07_10-Determining Index Column Order.mp4
4.2 MB
08. Advanced Indexing Techniques/08_01-Module Outline.mp4
2.2 MB
08. Advanced Indexing Techniques/08_02-Covering Indexes.mp4
17 MB
08. Advanced Indexing Techniques/08_03-Function Based Indexes Introduction.mp4
12 MB
08. Advanced Indexing Techniques/08_04-Demo - Function Based Indexes. Case Insensitive Search.mp4
10 MB
08. Advanced Indexing Techniques/08_05-Selective Row Indexing With Function Based Indexes.mp4
10 MB
08. Advanced Indexing Techniques/08_06-Demo - Function Based Indexes. Selective Indexing.mp4
7.5 MB
08. Advanced Indexing Techniques/08_07-Index Compression.mp4
11 MB
08. Advanced Indexing Techniques/08_08-Invisible Indexes.mp4
5.1 MB
08. Advanced Indexing Techniques/08_09-Demo - Invisible Indexes.mp4
9.7 MB
08. Advanced Indexing Techniques/08_10-Summary.mp4
2.5 MB
09. Application Indexing Practices/09_01-Introduction.mp4
1.8 MB
09. Application Indexing Practices/09_02-What Should I Index.mp4
10 MB
09. Application Indexing Practices/09_03-Indexing Costs and Overhead.mp4
7.3 MB
09. Application Indexing Practices/09_04-Demo - Indexing Overhead.mp4
11 MB
09. Application Indexing Practices/09_05-Similar Indexes.mp4
3.1 MB
09. Application Indexing Practices/09_06-Monitoring Index Usage.mp4
8.5 MB
09. Application Indexing Practices/09_07-Why isnt Oracle Using My Index.mp4
1.8 MB
09. Application Indexing Practices/09_08-Missing Leading Edge of Index.mp4
2.8 MB
09. Application Indexing Practices/09_09-Index not Selective Enough.mp4
2.6 MB
09. Application Indexing Practices/09_10-Using a Like Clause and a Leading Wildcard.mp4
4.2 MB
09. Application Indexing Practices/09_11-Like Clauses and Index Selectivity.mp4
5.3 MB
09. Application Indexing Practices/09_12-Function in the Where Clause.mp4
4.7 MB
09. Application Indexing Practices/09_13-Data Type Conversion in the Where Clause.mp4
4.5 MB
09. Application Indexing Practices/09_14-Outdated Database Statistics.mp4
5.0 MB
09. Application Indexing Practices/09_15-Summary.mp4
1.9 MB
10. Monitoring Oracle Applications/10_01-Motivation for Performance Monitoring.mp4
11 MB
10. Monitoring Oracle Applications/10_02-Required Permissions.mp4
9.8 MB
10. Monitoring Oracle Applications/10_03-Introduction to Queries.mp4
1.0 MB
10. Monitoring Oracle Applications/10_04-Session Information.mp4
3.6 MB
10. Monitoring Oracle Applications/10_05-Session Resource Usage.mp4
2.6 MB
10. Monitoring Oracle Applications/10_06-What Statements are Running Right Now.mp4
2.9 MB
10. Monitoring Oracle Applications/10_07-Finding the Worst Performing Statements.mp4
9.4 MB
10. Monitoring Oracle Applications/10_08-Statements Conducting Full Scan Operations.mp4
3.4 MB
10. Monitoring Oracle Applications/10_09-Retrieving Execution Plans.mp4
1.2 MB
10. Monitoring Oracle Applications/10_10-Monitoring Index Usage.mp4
4.4 MB
10. Monitoring Oracle Applications/10_11-Monitoring Hard Parsing and SQL Using Literal Values.mp4
5.6 MB
10. Monitoring Oracle Applications/10_12-Table Information.mp4
5.0 MB
10. Monitoring Oracle Applications/10_13-Index Information.mp4
1.8 MB
10. Monitoring Oracle Applications/10_14-Summary.mp4
2.1 MB
11. Pitfalls and Practices/11_01-Module Introduction.mp4
5.2 MB
11. Pitfalls and Practices/11_02-Separating Transactional and Reporting Databases.mp4
14 MB
11. Pitfalls and Practices/11_03-Loading too Much Data.mp4
7.6 MB
11. Pitfalls and Practices/11_04-Committing Data too Frequently.mp4
16 MB
11. Pitfalls and Practices/11_05-ORMs and Abstraction From the Database.mp4
4.8 MB
11. Pitfalls and Practices/11_06-ORMs and the n+1 Selects Issue.mp4
2.1 MB
11. Pitfalls and Practices/11_07-Summary.mp4
7.0 MB