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.
- 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
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.
Where do I start with Oracle if I want to be a DBA? written by Oracle ACE Kyle Hailey
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.
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.
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.
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.
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.
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 188.8.131.52.
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".
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.
Oracle ACE Asif Momen demonstrates how to connect to the Oracle Database even if background processes are k.illed