Pythian has openings for MySQL and MS SQL Server DBAs in each of our offices in Ottawa, Canada; Boston, USA; Dubai, UAE; and Hyderabad, India. If you are a MySQL and/or SQL Server DBA and would like to evaluate this opportunity, please send us your résumé with an introductory paragraph to hr@pythian.com.
« DBMS_SCHEDULER and Implicit commits
RMAN Recipes: Switch Oracle Logs Automatically with ARCHIVE_LAG_TARGET »

Pythian Goodies: Oracle Parallel Basics

By Christo Kutrovsky — February 27th, 2007 at 11:14 am
Posted in Group Blog Posts • Oracle • Pythian Goodies

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


Online Videos by Veoh.com

P.S.: I love the moment that the thumbnail captured.

These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Google
  • del.icio.us
  • Facebook
  • bodytext
  • Technorati
  • TwitThis
  • Reddit

You can follow any responses to this post through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

3 Responses to “Pythian Goodies: Oracle Parallel Basics”

  1. Don Seiler Says:
    February 28th, 2007 at 2:24 pm

    Great video!

    Is it just me, or does the video lag behind the audio further and further as the presentation goes on?

  2. Christo Kutrovsky Says:
    February 28th, 2007 at 2:46 pm

    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.

  3. Log Buffer #34: a Carnival of the Vanities for DBAs Says:
    January 31st, 2008 at 4:00 pm

    […] Pythian’s Christo Kutrovsky published the latest Pythian Goody, this one, a video of Doug Burns on Oracle Parallel Basics. […]

Leave a Reply

Filling out the following captcha not only allows us to cut down on automated blogspam but also helps digitize books. Please feel free to send comments on this approach directly to Paul at vallee@pythian.com.

NOTE: After submitting your comment, verify that it is added to the blog. New comments will be marked as "waiting for moderation" (we only moderate for spam). If the level of spam is as low as we hope, we will bypass this step.