Here is an excerpt of the Oracle June 2013 Newsletter, different global experts share their knowledge and enthusiam on Oracle functional and technical topics:
Primary Keys Guarantee Uniqueness? Think Again!
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".
Practical Cutover Tips for Your Enterprise Project
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.
Java EE 7 is Final!
Thoughtful summary of insights and pointers from ACE Director Markus Eisele regarding Java EE7. Find a list of articles from Markus about the Java EE 7 launch here.
Additional posts by Markus:
- Java SE 7 Update 25 - Release-Notes explained
- GlassFish 4 brings Java EE 7
- Interview with German iJUG e.V. (JUG Umbrella) in Java Magazine (Free subscription required to Access article)
Health Check of Oracle eBusiness Inventory by using the Inventory Analyzer
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.
Capture Workload using Database Replay in 11g
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.
Common Causes Resulting in ORA-01115 ErrorACE Director Syed Jaffar Hussein provides a list of common causes of an 'ORA-01115ORA-01115: IO error reading block from file (block # ).
He also shares a learning experience about how to rejoin a node to a 2 node cluster on a Windows Platform.
Deploy Agent In Enterprise Manager 12c
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.
Part 3 – Getting started with Statistics for Oracle Data Science Projects
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.
Why is Flashback Slow?
In this paper written by Oracle ACE Chris Lawson, it explains some interesting phenomenon regarding flashback queries.
TIMESTAMP WITH TIME ZONE Aggregation
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.
More to SQL Joins than Meets the Eye
Oracle ACE Kyle Hailey discusses in his post surprising visualizations of SQL Joins that can be more complex than you think. He also discusses a new feature in DBaaS: OEM Snap Clone.
Oracle 12c RAC On your laptop, Step by Step Guide" or "Back to School Again
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.
Dude, Where is my Redo?
This blog entry written by ACE Director Riyaj Shamsudeen discusses a method to identify the objects inducing higher amount of redo. Separately, he disscusses Clusterware startup details here.
Lessons from Fusion HCM Implementations
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.