Extract from the Oracle June 2013 Newsletter - Various Global Experts share their Knowledge

on Tuesday, 16 July 2013. Posted in General - Misc. Tips, Blog

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:

 

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.

 

Comments (5)

  • Vinh Lam Sam

    Vinh Lam Sam

    16 July 2013 at 19:24 |
    Thank you for sharing, great information!
  • Mike Simms

    Mike Simms

    16 July 2013 at 20:49 |
    I just enjoyed the article on Oracle EBS Inventory and yours on Production Cutovers, i live in Perth Australia and a newbie with the Oracle products thank you for sharing all this welath of information.
  • Robert Batista

    Robert Batista

    17 July 2013 at 06:52 |
    Thank you for sharing it electronically, it provides a wealth of information
  • Michael Nathan

    Michael Nathan

    17 July 2013 at 09:40 |
    Thanks for sharing, this is a fantastic blog
  • Rajeev Patel

    Rajeev Patel

    20 July 2013 at 22:15 |
    Thank you for sharing, you rock, one of the articles helped me understand 12c.

Copyright 2014 Appsconsultant.com. All rights reserved.