Good Luck at Collaborate ’06

Posted in: Technical Track

Just a quick note to wish good luck to Pythian DBAs Christo Kutrosky and Babette Turner-Underwood who are presenting at Collaborate ’06 today and tomorrow.

These are two outstanding presenters with deep technical knowledge reinforced with day-to-day use of the technology and I would encourage anyone to attend. If you attended the presentation, by all means post any feedback here!

Here are their schedules if you would like to attend:

1. Title: Postgres for the Oracle DBA
Speaker: Turner-Underwood, Babette
Expertise: Intermediate
Focus Area: Architecture & Infrastructure
Date: Tuesday, Apr 25, 2006
Time: 1:45 PM – 2:45 PM
Venue/Room: Gaylord Opryland Resort – Canal C
Paper Num: 216
Abstract: Postgres is a popular database for supporting Web sites. But, how does it really compare to Oracle? In this session, we will look at why Postgres has become so popular and why some people are moving their databases to Postgres. After giving a general introduction to Postgres, we will compare the features, strengths and weaknesses of the two database systems. The attendee will leave with an appreciation of the similarities and the differences between Oracle and Postgres and how to manage a Postgres database. The presentation will conclude with a case study of moving a client off of Oracle and onto Postgres. The planning involved, difficulties encountered, tricks discovered and lessons learned will be presented. 
2. Title: Oracle 10g Data Pump 101
Speaker: Turner-Underwood, Babette
Expertise: Intermediate
Focus Area: Architecture & Infrastructure
Date: Wednesday, Apr 26, 2006
Time: 9:15 AM – 10:15 AM
Venue/Room: Gaylord Opryland Resort – Canal C
Paper Num: 207
Abstract: Little enhancements were made to the boring but useful utilities exp / imp and sql*loader. For years we lived with the basic utlties and wrote our own wrapper scripts to provide more robust features. All of that now changes with Oracle Data Pump. Oracle has finally provided us with a standard tool to do what we always needed. 
3. Title: Working with Automatic PGA
Speaker: Kutrovsky, Christo
Expertise: All
Focus Area: DBA
Date: Wednesday, Apr 26, 2006
Time: 1:30 PM – 2:30 PM
Venue/Room: Gaylord Opryland Resort – Bayou A
Paper Num: 432
Abstract: This all levels presentation uncovers the secrets of Oracle PGA memory management. It shows how to maximize memory usage by tweaking undocumented Oracle parameters and explains how they will affect query response time. It covers, in detail, how different settings change the behaviors of sorts and some obscure hash joins behaviors.The presentation demonstrates how changing the necessary parameters will allow a server with 32G of RAM to use more then 8G of PGA memory to satisfy a single serial SQL statement.

“Working with Automatic PGA” had a great success and received excellent audience feedback in the February 2005 session of the Ottawa Oracle User Group. It has been recognized as one of the most useful presentations on the topic by some of the famous Oracle names.



Want to talk with an expert? Schedule a call with our team to get the conversation started.

About the Author

As Pythian’s Chief Executive Officer, Paul leads this center of excellence for expert, outsourced technical services for companies whose systems are directly tied to revenue growth and business success. His passion and foresight for using data and technology to drive business success has helped Pythian become a high-growth global company with over 400 employees and offices in North America, Europe, and Asia. Paul, who started his career as a data scientist, founded Pythian when he was 25 years old. In addition to driving the business, Paul is a vocal proponent of diversity in the workplace, human rights, and economic empowerment. He supports his commitment through Pythian’s hiring and retention practices, his role as board member for the Basic Income Canada Network, and as a supporter of women in technology.

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *