Oracle Database

Topics in Database Version Control

Dominic Delmolino on 11 June 2013 with 0 comments

 Tues July 2nd, 2013  Central Europe: 17:00 UK: 16:00 East USA: 11.00 Central USA: 10.00 Pacific USA: 08.00 Register now In this webinar, database development expert Dominic Delmolino discusses some of the nuances of database version control in today’s distributed development environments. Topics will include the pros and cons of personal vs. centralized development databases and how Oracle 12c may enable the best of… Continue Reading →

Views

Patrick Barel on 05 June 2013 with 0 comments

Success always occurs in private and failure in full public view. – Unknown When working with views you have several options to hide some of the data. Of course there is the possibility not to select certain columns of data in the view. This way, the user of the view doesn’t even have to know this column even exists. You… Continue Reading →

Oracle Database Replay for your Workload Test

Satishbabu Gunukula on 30 May 2013 with 7 comments

Database replay was introduced in Oracle 11g R1, and it allows you to capture workloads on a Production system and replay them in your Development or test environments while maintaining the unique characteristics of the workload. This enables the user to test a variety of system changes such as hardware/software migration, operating system/ database upgrade, patches, database config changes etc…. Continue Reading →

Continuous Integration with Jenkins and Red Gate Oracle Tools

Neil Anderson on 28 May 2013 with 0 comments

 Weds June 19th, 2013  Central Europe: 17:00 UK: 16:00 East USA: 11.00 Central USA: 10.00 Pacific USA: 08.00 Register now Continuous integration is not just for application developers. Database code is still code, so the considerable benefits of continuous integration are also available to Oracle database developers. All you need are the right tools. This session will look at how to setup continuous integration… Continue Reading →

Oracle Database 12c and APEX

Dimitri Gielis on 16 May 2013 with 0 comments

The below content is based on a David Peake‘s presentation at OOW 2012 and APEX World 2013. As the Oracle Database 12c is not out yet at the time of writing, note that things might be different in the final product. The Oracle Database 12c is a major release in Oracle history, as it contains a complete redesign of the underlying architecture. Two… Continue Reading →

Developing your First Oracle Cloud Application

Morten Egan on 09 May 2013 with 5 comments

Prerequisites A local database, for development SQL Developer version 3.2.20.09.87 or higher (Download) Wallet Manager Getting started To get started, we first need an account on the Oracle cloud. So go to Oracle Cloud, login with your OTN account and request a trial period. You will need to enter a credit card for verification, but it will not get charged… Continue Reading →

RAC One Node

Aman Sharma on 25 April 2013 with 9 comments

In the past few years, technology has become a very important aspect of our lives. There isn’t any moment when we are not connected to or using technology and this is not to do some core geeky stuff but for the tasks which have become a part of our lives. Can you imagine a day when you are unable to connect to… Continue Reading →

Analyzing and Troubleshooting Oracle Parallel Execution

Randolf Geist on 17 April 2013 with 4 comments

  Watch video The video above is accompanied by the following resources: Analysing and Troubleshooting Parallel Execution presentation slides (.pdf) Further reading: Calculating Parameter Values for Parallelism Auto DOP and Concurrency Auto DOP and Queuing Parameter Settings Auto DOP and Parallel Statement Queuing Workload Management – Statement Queuing Workload Management – A Simple (but real) Example Parallel_degree_limit hierarchy – CPU,… Continue Reading →

Managing & Troubleshooting Cluster

Syed Jaffer Hussain on 15 April 2013 with 10 comments

In this webinar, Syed Jaffar Hussain (Oracle ACE Director and Oracle Magazine Editor’s choice award (2011) for ‘Technologist of the year, DBA’) explains how to manage and troubleshoot various clusterware issues. View the presentation slides Watch video You will learn: Grid Infrastructure (Clusterware) startup sequence, like how things getting started after a node reboot or cluster start-up How to understand… Continue Reading →

SQL’s MEDIAN Function

Jonathan Gennick on 09 April 2013 with 0 comments

Article #3 in my ongoing series covering SQL statistic functions in Oracle Database is now up. The topic is the median: MEDIAN: For When You Don’t Really Mean It Median is useful in typifying a data set when the data might be skewed, or in the presence of extreme outliers. For example, the U.S. Census Bureau reports median household income… Continue Reading →