Webinar

Managing Oracle Schema Deployment for Teams

All Things Oracle on 29 November 2012 with 0 comments

This video is a follow up to the webinar broadcast by Red Gate on 28th November 2012. Please leave a response and ask questions at the bottom of the page. Watch video This webinar features a demonstration of Schema Compare for Oracle. You can download a free 14 day trial here: Download Schema Compare for Oracle. Summary James Murtagh will… Continue Reading →

Improving Development Processes for Database Teams

Dominic Delmolino on 22 November 2012 with 4 comments

This video is a follow up to the webinar broadcast by Red Gate on 14th November 2012. Please leave a response and ask questions at the bottom of the page. Watch video Summary The journey of a team-developed database, from initial development to successful deployment to production, involves many stages. Regardless of the specific development methodology employed (ITIL, Scrum, etc.)… Continue Reading →

Temporary Tables in Oracle and SQL Server

Jonathan Lewis on 15 October 2012 with 1 comments

This video is a follow up to the webinar broadcast by Red Gate on 13th September 2012. Please leave a response and ask questions at the bottom of the page. Watch video Summary Temporary tables are often used in applications for processes that are difficult to complete in a single pass. They are widely used in SQL Server development and… Continue Reading →

The Undiscovered Country: Useful Built-in Database Packages You’ve Never Heard About

Morten Egan on 14 September 2012 with 12 comments

This video and set of resources is a follow up to the webinar broadcast by Red Gate on 13th September 2012. Please see further down the page for a follow up to the Q+A. Watch video The video above is accompanied by the following downloadable scripts: 01_show_db_version.sql 02_show_dbms_assert.sql 03_show_parallel_execution.sql 04_show_utl_match.sql 05_show_dbms_alert.sql 06_show_utl_compress.sql 07_show_utl_inaddr.sql 08_show_owa_util.sql 09_show_apex_util.sql user_and_objects.sql Download all scripts (.zip)… Continue Reading →

Performance Tuning with ASH and AWR Data

Kellyn PotVin on 31 August 2012 with 19 comments

This video and set of resources is a follow up to the webinar broadcast by Red Gate on 30 August 2012. Watch video The video above is accompanied by the following downloadable resources: Presentation slides Scripts featured during the presentation (uploaded to dbakevlar.com) Summary Since their introduction with Oracle 10g, AWR and ASH data has offered the Database professional enhanced… Continue Reading →

Oracle Enterprise Manager Highlighted Questions and Extended Answers

Doug Burns on 10 August 2012 with 0 comments

Thanks to all those that attended the last Webinar organised by James Murtagh of Red Gate Software. It was very well attended and the feedback was all pretty good although, as I’ve said before, ASH Analytics presentations always seem to go down well and I suspect that says as much about the feature as it does about the presenter, if… Continue Reading →

Oracle Cost-Based Optimizer Advanced

Randolf Geist on 02 August 2012 with 2 comments

This video and set of resources is a follow up to the webinar broadcast by Red Gate on 01 August 2012. You may want to watch Oracle Cost-Based Optimizer Basics before you view this video Watch video The video above is accompanied by the following downloadable resources: Read me Presentation slides – PDF version Presentation slides – PowerPoint version concurrent_execution_inserts_check_results.sql… Continue Reading →

Free Webinar: Oracle Cost-Based Optimizer Advanced Session

Randolf Geist on 27 July 2012 with 2 comments

On Wednesday, 1st of August, I’ll be presenting another free webinar hosted by AllThingsOracle.com. Although it is called “Oracle Cost-Based Optimizer Advanced Session“, don’t be mislead by the title. It is not a truly “advanced” session, but rather I’ll try to delve into various topics that I could only mention briefly or had to omit completely during the first webinar on the Cost-Based Optimizer…. Continue Reading →

Falling in Love All Over Again: OEM 12c Performance Page Enhancements

Doug Burns on 10 July 2012 with 0 comments

Oracle Enterprise Manager 12c introduces the latest evolutionary stage of the Performance Pages demonstrated in the previous webinar. This session will demonstrate the new features such as ASH Analytics that make OEM more compelling and useful in more situations. A live Q+A session with Doug Burns will follow the presentation. Register now

How I Learned to Love Pictures: OEM Performance Page Fundamentals

Doug Burns on 26 June 2012 with 0 comments

The following video and set of resources are from the webinar broadcast by Red Gate on 03 July 2012. Watch video Key performance analysis and tuning principles apply regardless of the version of Oracle you’re using, but the Oracle 10g Diagnostics Pack instrumentation and related OEM Performance Pages built on these principles to offer a new, more visual, performance analysis… Continue Reading →