Oracle SQL Performance Tuning from Scratch | 2B480895342E11C47CC8C3F83CF55F6CB660067C

Oracle SQL Performance Tuning from Scratch

Name	Oracle SQL Performance Tuning from Scratch	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	1.6 GB
Total Files	154
Hash	2B480895342E11C47CC8C3F83CF55F6CB660067C

/4. Bind Variables/
5. Sample Application to Compare Approaches.mp4	53.6 MB
1. Introduction.mp4	8.0 MB
1. Introduction.srt	2.4 KB
2. The Shared SQL Area.mp4	34.8 MB
2. The Shared SQL Area.srt	12.3 KB
3. Contention and Latch Waits.mp4	45.4 MB
3. Contention and Latch Waits.srt	14.8 KB
4. Matching SQL Statements.mp4	34.1 MB
4. Matching SQL Statements.srt	9.7 KB
5. Sample Application to Compare Approaches.srt	10.2 KB
6. Evaluation of Impacts of Bind Variables.mp4	22.8 MB
6. Evaluation of Impacts of Bind Variables.srt	6.0 KB
/
Visit Coursedrive.org.url	0.1 KB
ReadMe.txt	0.2 KB
/Oracle SQL Performance Tuning from Scratch/
ReadMe.txt	0.2 KB
Visit Coursedrive.org.url	0.1 KB
/1. Introduction/
1. Introduction.mp4	10.5 MB
1. Introduction.srt	4.0 KB
2. How Performance Tuning is not Magic.mp4	25.6 MB
2. How Performance Tuning is not Magic.srt	9.5 KB
3. Performance Tuning Approach.mp4	13.1 MB
3. Performance Tuning Approach.srt	5.2 KB
4. Sample Database.mp4	33.2 MB
4. Sample Database.srt	7.1 KB
/.../2. Architecture of Oracle/
1. Introduction.mp4	3.3 MB
1. Introduction.srt	2.0 KB
2. System Scalability.mp4	14.1 MB
2. System Scalability.srt	5.5 KB
3. Architecture Overview.mp4	27.2 MB
3. Architecture Overview.srt	6.6 KB
4. Buffer Cache.mp4	11.9 MB
4. Buffer Cache.srt	4.3 KB
5. Shared Pool.mp4	6.9 MB
5. Shared Pool.srt	3.4 KB
6. PGA(Program Global Area).mp4	8.0 MB
6. PGA(Program Global Area).srt	3.7 KB
7. Performance Metrics.mp4	32.9 MB
7. Performance Metrics.srt	15.4 KB
8. Performanace Tuning.mp4	13.1 MB
8. Performanace Tuning.srt	5.2 KB
9. Building Effective Performance.mp4	11.7 MB
9. Building Effective Performance.srt	5.3 KB
10. Performance Tuning Database use.mp4	39.7 MB
10. Performance Tuning Database use.srt	15.4 KB
/.../3. Connection and Connection Pools/
1. Introduction.mp4	19.3 MB
1. Introduction.srt	7.7 KB
2. Demo Connecting With and Without Connection Pools.mp4	15.4 MB
2. Demo Connecting With and Without Connection Pools.srt	3.9 KB
3. Using a Connection Pool in .NET.mp4	15.9 MB
3. Using a Connection Pool in .NET.srt	5.2 KB
4. Using a Connection Pool in Java.mp4	18.5 MB
4. Using a Connection Pool in Java.srt	5.3 KB
5. Blocking Connection.mp4	36.1 MB
5. Blocking Connection.srt	7.2 KB
/.../5. Statement Level Performance Tuning/
1. What is an Execution Plan.mp4	19.4 MB
1. What is an Execution Plan.srt	6.3 KB
2. Getting an Execution Plan.mp4	20.5 MB
2. Getting an Execution Plan.srt	4.5 KB
3. What Does an Execution Plan Contain.mp4	28.4 MB
3. What Does an Execution Plan Contain.srt	4.7 KB
4. Reading an Execution Plan.mp4	36.5 MB
4. Reading an Execution Plan.srt	6.7 KB
5. Analyzing an Execution Plan.mp4	21.1 MB
5. Analyzing an Execution Plan.srt	3.8 KB
6. Autotrace Introduction.mp4	11.7 MB
6. Autotrace Introduction.srt	6.7 KB
7. Autotrace Example in SQL Developer.mp4	35.1 MB
7. Autotrace Example in SQL Developer.srt	6.6 KB
8. Autotrace Example in SQLPlus.mp4	32.5 MB
8. Autotrace Example in SQLPlus.srt	5.5 KB
9. Data Size and Execution Plans.mp4	21.5 MB
9. Data Size and Execution Plans.srt	7.1 KB
/.../6. Execution Plans in Depth/
1. Introduction.mp4	4.6 MB
1. Introduction.srt	1.7 KB
2. Table Access Operations.mp4	30.6 MB
2. Table Access Operations.srt	11.9 KB
3. Demo Table Access Operations.mp4	33.7 MB
3. Demo Table Access Operations.srt	8.5 KB
4. Index Lookup Operations.mp4	29.9 MB
4. Index Lookup Operations.srt	8.3 KB
5. Demo Index Lookup Operations.mp4	35.4 MB
5. Demo Index Lookup Operations.srt	7.4 KB
6. Index Full Scan Operations.mp4	10.4 MB
6. Index Full Scan Operations.srt	5.1 KB
7. Join Operations.mp4	31.9 MB
7. Join Operations.srt	12.4 KB
8. Tuning SQL Statements.mp4	30.5 MB
8. Tuning SQL Statements.srt	13.8 KB
/7. Indexing Essentials/
1. Why Indexing Matters.mp4	18.3 MB
1. Why Indexing Matters.srt	9.3 KB
2. B-Tree Indexes.mp4	24.4 MB
2. B-Tree Indexes.srt	7.1 KB
3. Bitmap Indexes.mp4	25.9 MB
3. Bitmap Indexes.srt	9.9 KB
4. Index Column Order Matters.mp4	18.9 MB
4. Index Column Order Matters.srt	7.1 KB
5. Demo Index Column Order.mp4	25.5 MB
5. Demo Index Column Order.srt	5.3 KB
6. Index Skip Scan Operations.mp4	10.7 MB
6. Index Skip Scan Operations.srt	4.8 KB
7. Index Selectivity.mp4	32.5 MB
7. Index Selectivity.srt	12.5 KB
8. Selectivity for Composite Indexes.mp4	9.9 MB
8. Selectivity for Composite Indexes.srt	4.8 KB
9. Determining Index Column Order.mp4	8.3 MB
9. Determining Index Column Order.srt	4.5 KB
10. Demo Index Selectivity.mp4	25.7 MB
10. Demo Index Selectivity.srt	7.1 KB
/.../8. Advanced Indexing Techniques/
1. Module Outline.mp4	3.1 MB
1. Module Outline.srt	2.2 KB
2. Covering Indexes.mp4	39.5 MB
2. Covering Indexes.srt	11.2 KB
3. Function Based Indexes Introduction.mp4	27.3 MB
3. Function Based Indexes Introduction.srt	11.3 KB
4. Demo - Function Based Indexes Case Insensitive Search.mp4	26.6 MB
4. Demo - Function Based Indexes Case Insensitive Search.srt	5.5 KB
5. Selective Row Indexing With Function Based Indexes.mp4	24.7 MB
5. Selective Row Indexing With Function Based Indexes.srt	9.1 KB
6. Demo - Function Based Indexes Selective Indexing.mp4	19.4 MB
6. Demo - Function Based Indexes Selective Indexing.srt	3.9 KB
7. Index Compression.mp4	49.1 MB
7. Index Compression.srt	18.5 KB
8. Invisible Indexes.mp4	11.3 MB
8. Invisible Indexes.srt	4.8 KB
9. Demo Invisible Indexes.mp4	24.9 MB
9. Demo Invisible Indexes.srt	5.8 KB
/.../9. Application Indexing Practices/
1. Introduction.mp4	2.6 MB
1. Introduction.srt	1.6 KB
2. What Should I Index.mp4	21.3 MB
2. What Should I Index.srt	10.7 KB
3. Indexing Costs and Overhead.mp4	15.6 MB
3. Indexing Costs and Overhead.srt	7.0 KB
4. Demo Indexing Overhead.mp4	27.4 MB
4. Demo Indexing Overhead.srt	6.1 KB
5. Similar Indexes.mp4	6.7 MB
5. Similar Indexes.srt	2.6 KB
6. Monitoring Index Usage.mp4	20.3 MB
6. Monitoring Index Usage.srt	6.5 KB
7. Why isn't Oracle Using My Index.mp4	4.0 MB
7. Why isn't Oracle Using My Index.srt	1.5 KB
8. Missing Leading Edge of Index.mp4	6.6 MB
8. Missing Leading Edge of Index.srt	2.2 KB
9. Index not Selective Enough.mp4	5.7 MB
9. Index not Selective Enough.srt	2.2 KB
10. Using a Like Clause and a Leading Wildcard.mp4	9.1 MB
10. Using a Like Clause and a Leading Wildcard.srt	4.0 KB
11. Like Clauses and Index Selectivity.mp4	12.7 MB
11. Like Clauses and Index Selectivity.srt	4.5 KB
12. Function in the Where Clause.mp4	10.3 MB
12. Function in the Where Clause.srt	4.0 KB
13. Data Type Conversion in the Where Clause.mp4	10.5 MB
13. Data Type Conversion in the Where Clause.srt	3.5 KB
14. Outdated Database Statistics.mp4	11.4 MB
14. Outdated Database Statistics.srt	4.1 KB
Total files 154