All Things Oracle

End to End Metrics: Building a performance bridge between the Developer and the DBA

Lasse Jenssen on 16 May 2013 with 0 comments

 Weds May 29th, 2013  Central Europe: 17:00 UK: 16:00 East USA: 11.00 Central USA: 10.00 Pacific USA: 08.00 Register now End-to-end metrics bridge the gap between the developer and the DBA, the Developer and Oracle, and the DBA and the application. Most applications today are n-tiers using a connection pool on the application tier, which makes them very hard to trace. With a little… Continue Reading →

Built-in Performance Monitoring in Oracle and SQL Server

Jonathan Lewis on 16 May 2013 with 0 comments

 Weds May 22nd, 2013  Central Europe: 17:00 UK: 16:00 East USA: 11.00 Central USA: 10.00 Pacific USA: 08.00 Register now While the primary focus of both Oracle and SQL Server is on relational database management, there are a number of tools that come with each software package that are focused around monitoring and investigating the performance of the servers. These monitoring tools vary wildly… 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 8 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 →

Hacking the Oracle Cloud

Morten Egan on 22 April 2013 with 2 comments

 Weds June 5th, 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, Morten Egan will take a look at how to overcome some of the limitations of the Oracle Cloud – including how to stretch your storage to its full potential. Can we circumvent the communication limits, since we do not have sqlnet,… Continue Reading →

Analyzing and Troubleshooting Oracle Parallel Execution

Randolf Geist on 17 April 2013 with 4 comments

  Watch video Oracle parallel execution, a feature of the Enterprise Edition, allows you to automatically distribute the processing of a SQL statement execution among multiple worker processes. This requires additional effort when analyzing and troubleshooting such parallel executions, since it adds complexity that is simply not there with normal serial execution where only a single process is involved. This webinar will… 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 →

Console Wrapper 1.0.4

Martin Giffy DSouza on 11 April 2013 with 0 comments

Console Wrapper 1.0.4 is officially out. You can download it from the project page: https://code.google.com/p/js-console-wrapper/ The only change for this release was to resolve an IE 9/10 issue which I previous blogged about. If you’re using any of the ClariFit plugins you may want to update the $console_wrapper.js file that’s included with each plugin. I’ll be sure to include the update file for each of… 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 →