Extract from the Oracle June 2013 Newsletter - Various Global Experts share their Knowledge
Here is an excerpt of the Oracle June 2013 Newsletter, different global experts share their knowledge and enthusiam on Oracle functional and technical topics:
ACE Director Arup Nanda provides a great explanation and examples of primary keys and table constraints. And, if you ever wondered about Big Data and what exactly it means, you'll want to read Arup's post "Demystifying Big Data for Oracle Professionals".
Provided by Oracle ACE Alex Antonatos are tips and tricks on the critical last 6 weeks before going live in the areas of testing, data conversion, training and cutover validation.
Additional posts by Markus:
In this post written by Oracle ACE Kashif Manzoor, he covers the use of Inventory Analyzer tool to evaluate Inventory setup, patch levels, runtime tables, profiles, settings, and configurations with recommendations. This script delivered by eBusiness suite for quick health checkup of most common Inventory issues usually facing by different customers.
Satishbabu Gunukula, Oracle ACE, talks about how to simulate actual production load for performance as well as functionality test and how to adopt changes quickly in an easy and cost effective way. Read more here.
MySQL Plugin for New Relic
The popular SaaS Monitoring product New Relic has added support for monitoring of existing data store products. ACE Director Ronald Bradford has written the open source MySQL plugin that gives developers additional insights to monitoring the entire stack.
He also shares a learning experience about how to rejoin a node to a 2 node cluster on a Windows Platform.
Enterprise Manager 12c provides very useful tools for all DBA and developers. In this post written by Oracle ACE Osama Mustafa, he explains how to deploy agent in EM 12c to monitor or host a database.
ACE Director Brendan Tierney shares part 3 on getting started with Statistics for Oracle Data Science projects which provides a summary of the other statistical functions that exist in the database.
Brendan also blogs about The DBMS_PREDICTIVE_ANALYTICS package & Predict procedure and The DBMS_PREDICTIVE_ANALYTICS package & Explain procedure
Productivity Tips for using SQL Developer Data Modeler (SDDM)Kent Graziano, ACE Director, has two recent tips on his blog for SQL Developer Data Modeler. The 1st tip is free: Oracle SQL Developer Data Modeler . And another free tip for SQL Developer Data Modeler (and a Challenge) .
WebLogic on the Virtualized Oracle Database Appliance X3-2ACE Director Simon Haslam is currently working on a proof of concept for running Fusion Middleware, along with RAC, on an ODA and is writing a series of blog posts describing his findings: #1 Planning , #2 Unboxing, with more to follow over the next month. Middleware types may also like this post, and debate, around Admin Server location.
In this paper written by Oracle ACE Chris Lawson, it explains some interesting phenomenon regarding flashback queries.
Check out the interesting observations and discussions in ACE Director Randolf Geists post about how the Oracle database treats the TIMESTAMP WITH TIMEZONE datatype when performing aggregation.
To get you up to speed with Oracle RAC 12c and let you focus on the important stuff (e.g. features research), ACE Director Yury Velikanov provides detailed step by step installation instructions.
At this years OHUG conference Oracle ACE Tim Warner had the opportunity to hear from some organizations who have been through the Fusion HCM implementation process. He shares some those experiences in his latest post.