Live, Rapid Dev Guided by Kscope12 Attendees

All Things Oracle on 17 May 2012 with 0 comments

Attendees to this year’s ODTUG Kscope conference will have the opportunity to get involved in a live software development experience on the Red Gate exhibition stand (stand no. 424 – 425). Attendees will provide input to go from zero to first prototype in 3 days through a series of rapid development sessions live on the stand. Monday’s feedback is Tuesday’s… Continue Reading →

Introduction to Oracle Flashback Technology (Part 1: Application Developers)

David Njoku on 16 May 2012 with 0 comments

Imagine, if you will, that someone invented time travel. What would you do with it? Nip back into the past and fix that error you made? And maybe you’d want to do something about that silly, ill-advised haircut you had when you were 17. Well, the good news is that, in a manner of speaking, time travel has been invented…. Continue Reading →

Auto Restart Enterprise Manager Cloud Control Agent 12c

Wissem El Khlifi on 10 May 2012 with 0 comments

Introduction: Oracle Restart is a component added to the 11gR2 in order to improve the high availability of different database resources. Database instances, listeners are resources that can be automatically restarted after a hardware or software failure or whenever the server host restarts. These components can be easily added to the Oracle Restart using the crsctl add command. In this… Continue Reading →

Oracle Heap Tables or SQL Server Clustered Indexes? Jonathan Lewis and Grant Fritchey Live Debate

Jonathan Lewis on 30 April 2012 with 0 comments

This webinar is being broadcast by Red Gate on 7 June 2012. Oracle and SQL Server may both share a common language, but certain things are handled quite differently. Jonathan Lewis (OakTable Network, Oracle Ace Director) is used to seeing heap tables (almost) everywhere, but Grant Fritchey (Microsoft SQL Server MVP) is used to seeing clustered indexes (almost) everywhere. But… Continue Reading →

Oracle Server Room Door Puzzle

All Things Oracle on 27 April 2012 with 8 comments

Here at Red Gate we have installed an extra security measure to help prevent unauthorised access to our Oracle server room. Our server room has no windows, the air vents on the wall are for the air conditioning units and the room (or any light in the room) cannot be seen through them, and the door is solid steel. A… Continue Reading →

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 →

Free eBook: Expert Oracle Database Architecture

All Things Oracle on 23 April 2012 with 0 comments

Download your FREE eBook Expert Oracle Database Architecture (Apress Media) provides a one-stop resource containing deep wisdom on the design, development and administration of Oracle applications, written by one of the world’s foremost Oracle experts, Thomas Kyte. This fully revised second edition covers the developments up to Oracle Database 11g. Each feature is taught in a proof-by-example manner, not only… 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 →

An Introduction to 11.2 RAC Server Pools

Aman Sharma on 18 April 2012 with 7 comments

Oracle RAC is designed to cater for Oracle specific applications and also non-oracle applications. These applications, both Oracle and non-Oracle, when deployed on RAC, are termed as resources and Oracle RAC can manage both kinds of resources on the clusterware stack. Examples of both oracle and non-oracle resources are: database instance, database services, xclock, Apache etc. The traditional way to… 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 →