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

on Monday, 08 April 2013. Posted in General - Misc. Tips, Blog

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


Here is an excerpt of the Oracle March 2013 Newsletter, different global experts share their enthusiasm on Oracle functional, technical ideas and concepts:

- UKOUG Magazine Oracle Scene: Database Virtualization and Instant Cloning (p26) written by Oracle ACE Kyle Hailey

- Professional Software Development using Oracle Application Express written by Oracle ACE Rob van Wijk

- Dutch IT magazine: A seven part series on the OTN Yathra Tour 2013 and IT in India written by ACE Director Lucas Jellema (in Dutch)


MySQL Stored Routines Debugger & Debugging API: Sneak Peek II created by Oracle ACE Shlomi Noach

Blog Post: How to Implement Fusion Applications

Oracle ACE Alex Antonatos shares his knowledge on Oracle Fusion by answering questions and providing a visual diagram on the steps required to implement an instance of fusion applications.

He also provides a whiteboard animation video discussing Fusion Financial and HCM Apps benefits.

Blog Post: ADF, Oracle SQL and more posts by ACE Director Lucas Jellema

- ADF: (re-)Introducing Contextual Events in several simple steps

- Oracle SQL – Finding free adjacent seats in an airplane, using Subquery Factoring, Analytical Functions (LISTAGG and LEAD), Outer Join, PIVOT and good old INSTR

- Out of the box usage of ADF DVT Scheduling Gantt Chart to report Database Query Results using stacked bar charts per time period

- Oracle SQL – spotting combinations that occur and those that do not – demonstrating Analytical Functions, Outer Join and SubQuery Factoring

- Oracle SQL: Using subquery factoring in an INSERT statement

- How Oracle Database uses internal locks to make statement level constraint validation robust at the transaction level

Blog Post: When 'FREE' costs more in the long run: Why WebCenter often costs less then SharePoint - despite the stunning license price difference

Are you clear on the Great and the Ugly of WebCenter and SharePoint - enough to recommend one over the other for an enterprise-wide deployment? Feeling that your company has made a mistake by picking the wrong product? Or simply wondering "what if... ?" Check out this 2 page mini-whitepaper written by Oracle ACE Dmitri Khanine for some answers. It’s a quick read, that may shock and excite you.

Blog Post : Exadata Optimization Tips

Where do I start with Oracle if I want to be a DBA? written by Oracle ACE Kyle Hailey

Blog Post: Amazon EC2 - RDS quick comparison

Oracle ACE Marco Tusa provides a review of the real status about Amazon RDS in comparison with EC2.

Blog Post: Possible Data Corruption, ORA-600 on RAC Instances Shutdown

ACE Director Syed Jaffar Hussain discusses how a typical RAC instance shutdown sometimes can lead to data corruption and produces senescence of ORA-600 and what is the recommended RAC instance/database shutdown procedure to avoid the issue.

If you are planning a Database 11g upgrade with downgrade in mind, you will might find these tips provided by Syed helpful.

Blog Post: 5-Part Series on Oracle Clustering

ACE Director Brendan Tierney has published a series of 5 blog posts on how to do Clustering using the Oracle Data Miner Tool and how to do Clustering using the ODM SQL and PL/SQL functions. Part 1, 2, 3, 4, 5

Another post by Brendan will help determine whether you are a Type I or a Type II Data Scientist. Find out here.

Blog Post: Using Production Data for Testing

Daily DBA tasks, dealing with development environment and refresing using production data... is this a good idea? Production Data contains sensitive information and should not be shared with unauthorized people. Read this post, including data research on security, provided by Oracle ACE Osama Mustafa.

Blog Post: CBO 10053 Trace Files Series

A series of posts provided by ACE Director Doug Burns on what he thinks is the most important reason to use 10053 trace files.

Blog Post: Bash Script to Upload RMAN Backups via FTP

Oracle ACE Gokhan Atil shares a small bash script which calls an SQL script to queries RMAN backups and demonstrates some interesting methods such as handling arrays returned from SQLPLus.

Blog Post: Convert JSON to XML/SOAP (in Spanish)

A common occurance these days, Oracle ACE Rolando Carrasco provides a guide to converting JSON to XML/SOAP using Oracle Service Bus.

In a different post, he shares an introduction to Oracle ADF Mobile.

Blog Post: Debugging Data Pump session

While importing a dump file, it can sometimes be a long process. ACE Director, Kamran Agayev, shares his command solution he runs to import the dump file into the new database.

Blog Post: What is the Oracle Cloud Really?

If you ever wondered what is the big deal around Oracle Cloud Service, you'll want to read this post written by ACE Director Markus Eisele. He explains it well and also provides an example on how to use JAX-RS with Jersey on the Oracle Cloud Service

Another interesting post Markus shares is about Test driving Java API for Processing JSON with GlassFish 4.0.

Blog Post: Installing Oracle Business Transaction Monitoring

Oracle ACE Rob Zoeteweij created virtual Servers and describes the installation process of BTS in his latest post.

Rob continues to share his knowledge on EM 12c, this post describes how to setup Database as a Service using EM12c DB Plugin

Blog Post: Pseudo Cursors and Invisible SQL

Do you ever wonder why Oracle Enterprise Manager and AWR reports show the SQL text for some SQL IDs as not available? ACE Director Julian Dontcheff provides an explanation in his latest post.

Here's another good read by Julian on the definition of "The Oracle Platform Administrator".

Blog Post: Cost Free Joins

In this two-part post, ACE Director Randolf Geist first demonstrates an unexpected Nested Loop Join caused by an extreme data distribution. In the latter, he presents another case of an unexpected execution plan, this time about Merge Joins.

Blog Post: Oracle Background Process Killed

Oracle ACE Asif Momen demonstrates how to connect to the Oracle Database even if background processes are k.illed

Blog Post: Adding HINTS in ODI

Read this post written by Gurcan Orhan as he explains how to implement adding Oracle HINTS and Variable HINTS into ODI (static and dynamic).



Comments (4)

  • Michael Clark

    Michael Clark

    08 April 2013 at 00:55 |
    Thank you for sharing just what I was looking for, just bookmarked your site
  • Matt


    08 April 2013 at 01:51 |
    We are starting in 2 weeks, a global 3 month feasibility study to implement latest version of JDE or fusion are you available for a 3 month project in NY.
    • Alex Antonatos

      Alex Antonatos

      08 April 2013 at 22:12 |
      Hi Matt, I am currently unavailable i will send you an email of a consultant based in NY(to the emaill address you registered in the comment), I think he is available April 29th.
  • Naomi


    09 April 2013 at 07:07 |
    Exactly what I was looking for, the Internet was an amazing invention, thank you for sharing

ZOO Comment

Copyright 2018 Appsconsultant.com. All rights reserved.