How to Gather SQL Resource Consumption Metrics in Oracle

Karen Morton on 26 April 2012 with 4 comments

The following video and set of resources are from the webinar broadcast by Red Gate on 8 May 2012. The video above is accompanied by the following downloadable resources: Presentation slides (.pdf) Resource Consumption Metrics Examples (.txt) Workload Repository SQL Report (awrsqlrpt_1_16411_16412.html) SQL Monitoring Report (0-6x2sh0kvzac0t-2.html) ASH Report for BIUAT/biuat1 (ashrpt_1_0505_1117.html) Download all resources (.zip) SQL is utilized to return… Continue Reading →

Real Developers DO use Tools

Cary Millsap on 19 April 2012 with 0 comments

This video is a recording from the webinar broadcast by Red Gate on 24th January 2012. You may’ve heard the idea that real developers don’t need tools, and the mark of a good developer is someone who can hand-code everything. But there are certain tasks where it doesn’t make sense to disregard using tools. In particular, critical tasks that need… Continue Reading →

Migrating Oracle Single Instance to RAC

Syed Jaffer Hussain on 17 April 2012 with 0 comments

This video is a recording from the webinar broadcast by Red Gate on 29th March 2012. Oracle Database administrators have to cope with numerous challenges when migrating an existing non-cluster environment to a cluster environment. One of the most significant challenges a DBA faces is to migrate/convert an existing single instance to RAC. Oracle provides several easy methods to carry… Continue Reading →

Oracle Cost-Based Optimizer Basics

Randolf Geist on 10 April 2012 with 0 comments

This video and set of resources is a follow up to the webinar broadcast by Red Gate on 11 Apr 2012. The video above is accompanied by the following downloadable resources: Read me Presentation slides – PDF version Presentation slides – PowerPoint version Screenshots – Demo 1 (.pdf) Screenshots – Demo 2 (.pdf) Screenshots – Demo 3 (.pdf) optimizer_basics_inter_table_clustering_testcase.sql optimizer_basics_join_cardinality_testcase.sql… Continue Reading →

Building Apex Plugins 101

Martin Giffy DSouza on 28 March 2012 with 0 comments

Martin Giffy D’Souza has created some of the most popular plug-ins available on the APEX plug-in community page. He has learned a lot about the architecture and what it takes to make a robust plug-in. In this video, Martin will help get you started with creating your first APEX plug-in. He will also provide you with some tips and useful… Continue Reading →

Security in the Database is more than Just Granting Access

Michelle Malcher on 06 March 2012 with 2 comments

Michelle Malcher (Oracle Ace Director and a representative on the Oracle Security Customer Advisor Council for the Independent Oracle User Group) presents practical ways to look at security and implementing standards and procedures around the database environment to account for the security outside of the users, including secured environments for regulations and compliance. Oracle 11g provides transparent data encryption at… Continue Reading →

Upgrading to Oracle 11gR2

Syed Jaffer Hussain on 05 March 2012 with 0 comments

It has been a common practice and relatively a tough task for almost every individual Oracle DBA to decide whether to proceed or not with the upgrade whenever Oracle releases new version. The core objective of this presentation is to share my experience of upgrading 4 Cluster environments with nearly 200 databases to Oracle 11gR2. The presentation is best suited… Continue Reading →

Applied Rapid Development Techniques for Database Engineers

Dominic Delmolino on 31 January 2012 with 2 comments

This article is based on the webinar delivered on 22 Nov 2011. You can read the full article below including the Q+A or: Download a PDF version Watch a video recording: Applied Rapid Development Techniques for Database Engineers In this article, Dominic Delmolino describes his experience in implementing a rapid refactoring and professional schema management process using standard software development… Continue Reading →

My Case for Agile Development, Cary Millsap

Cary Millsap on 17 August 2011 with 2 comments

Cary Millsap (Oracle Ace Director, co-founder of the OakTable) explains how the principles of the Agile Manifesto have defined his most commercially and technically successful projects (specifically, the implementation of the Agile Manifesto called Extreme Programming (XP), as explained by Kent Beck). Watch a full video recording of the session, including the Q+A. Visit the Red Gate website for more… Continue Reading →

APEX for Mobile Development, Peter Raganitsch Webinar Video

Peter Raganitsch on 17 August 2011 with 2 comments

Going mobile is a hot topic: everyone has a smartphone and wants to access their business data with it. In this webinar, broadcast live on July 2011, Peter Raganitsch demonstrated how he created a mobile APEX Demo Showcase with standard APEX components like Templates, Plugins, Reports, Lists and Forms. Watch a full video recording of the session, including the Q+A…. Continue Reading →