Tuning Oracle PGA for Indexing
Dramatically decrease index creation times! Increase Data Pump performance when index creation is too slow! In this 9-minute tutorial Oracle Certified Master DBA teaches you how to tune the PGA to decrease index creation time - by half in John’s demonstration!
Presenter: John Watson, SkillBuilders Certified Master Oracle DBA
Get the scripts and slides on the tutorial web page:
https://skillbuilders.com/course/how-...
Contents of this video:
00:00 - Understanding Index Generation and the PGA
02:42 - The Problem with Automatic PGA Management: _pga_max_size
04:14 - The Solution: Manual PGA Management for the Session
06:51 - The Solution Demonstration: Enable Manual PGA Management
08:19 - Summary to Tuning Oracle PGA for Indexing
Attend instructor-led online class with this instructor, Oracle Certified Master John Watson of SkillBuilders! https://skillbuilders.com/course/orac...
Hire John for Oracle DBA Services...for more info visit: https://skillbuilders.com/database-ad...
About Skillbuilders:
SkillBuilders, 25 years of success stories for Oracle Database Administration, APEX Development, APEX Hosting on AWS and Training.
Subscribe to our Channel and see hundreds of SkillBuilders Free Tutorials or watch on web site:
https://skillbuilders.com/free-tutori...