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 →

Uncategorized

 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 →

Database Administration, Database Development, Webinar

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 →

12c, APEX, Database Development

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 →

All Things Oracle Full Articles, APEX, Application Development, Oracle Cloud, Oracle Database, PL/SQL

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 →

11g, All Things Oracle Full Articles, Database Administration, Oracle Database, RAC

 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 →

Database Administration, Database Development, Oracle Cloud, Troubleshooting, Webinar

  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 →

Database Development, Oracle Database, Performance Tuning, Troubleshooting, Webinar

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 →

Database Administration, Oracle Database, Troubleshooting, Webinar

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 →

Application Development

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 →

Application Development, Database Administration, Database Development, Oracle Database, PL/SQL, Uncategorized