Pythian Goodies: Oracle Parallel Basics
Feb 27, 2007 / By Christo Kutrovsky
As Doug Burns already mentioned, here’s another video from the Pythian Goodies project.
As usual, the Goodies are intended to be debates, so please post any questions or follow-ups with the relevant time-index from the video.
Featuring Doug himself, he discusses Parallel Basics. This video is a good introduction to using Oracle Parallel features and most importantly, what problems you may have with it. Topics discussed:
- Basic Parallel Execution (PX) architecture
- Degree of Parallelism and number of slaves
- Instance configuration for parallel operation
- Hints for Parallelism
- Common problems
- Dictionary queries for monitoring parallel operations
P.S.: I love the moment that the thumbnail captured.
Great video!
Is it just me, or does the video lag behind the audio further and further as the presentation goes on?
Don,
It’s not you, it is lagging behind. In the begining it’s not lagging, but as it’s progressing the lags becomes more appereant.
I will have to play with the settings to see what’s causing that.
Pingback: Log Buffer #34: a Carnival of the Vanities for DBAs