Thursday, February 28, 2013

Oracle Priority Service Infogram, 28-FEB-2013


From the Alexey Ragozin blog: Remote code execution in Java made trivial.



From the ORACLE DIAGNOSTICIAN: Efficiency-based SQL tuning.

At Kevin Closson's Blog: Platforms, Databases and Storage Platform, Database and Storage Topics Blog: Using Linux Perf(1) To Analyze Database Processes – Part I.

Several bloggers and residents of the tweetosphere noted this posting by Carlos Sierra at Oracle SQL Tuning Tools and Tips: About TKPROF, Trace Analyzer and Method-R Profiler.



Kyle's Blog on WebCenter Content fills us in on: Conversions in WebCenter Content.


Oracle's Identity Management blog is letting everyone know about an interesting conference coming later this year for those in the healthcare industry: See you at HIMSS 2013?

Also from Identity Management comes this posting on User Management for Databases (UM4DB).


Data Mining

Stepping right in to the middle of a series over at Brendan Tierney - Oracle & Data Mining Blog, here is a link to Clustering in Oracle Data Miner–Part 3. We leave it as an exercise to the reader to track back to part 1.


And over at CONFESSIONS OF A SOFTWARE DEVELOPER, BPM: how to time out synchronous calls to external services?


At Ora-600, a detective tale of recovering from an error. I would add one caveat: When in doubt, take it to Support. If you open an SR and follow the process you know you are going to stay in the warm and fuzzy realm of being supported. But it's an impressive read: Recover from unusable dictionary indexes in 10g using 11g.


Good note links to keep in a little box on the wall that says 'in case of debacle, break glass'. Database downgrade - MOS useful notes, from Jaffar's Oracle blog.

Book Review

Monday, February 25, 2013

Contributions by Angela Golla, Infogram Deputy Editor

Check out the new Support videos that focus on Oracle E-Business Suite, JD Edwards, and PeopleSoft. These videos not only walk through the latest enhancements, but also highlight Oracle's ongoing commitment.
• (JD Edwards and Oracle Premier Support) -

• (EBS and Oracle Premier Support) -

• (PeopleSoft and Oracle Premier Support) -

Visit My Oracle Support Note:432.1 to learn more about upgrading to the latest versions of JD Edwards, EBS and PeopleSoft products.

Thursday, February 21, 2013

Oracle Priority Service Infogram for 22-FEB-2013


RDBMS Performance

The Oracle at Delphix talks about Oracle I/O latency monitoring.

Also at Delphix, an answer to the plaintive cry we've all heard: Why does my full table scan take 10x longer today ?!

From the master of taking Oracle binaries apart and seeing where all the gears mesh, TANEL PODER'S BLOG: IT & MOBILE FOR GEEKS AND PROS: Peeking into Linux kernel-land using /proc filesystem for quick’n'dirty troubleshooting.


Have you checked out some of the PeopleSoft Advisor Webcasts lately?

And from Linda Harmon-Corniola:

Check out the PeopleTools 8.53 documentation on our newly redesigned Hosted PeopleSoft Online Help (PeopleBooks) Site.

And also:

Tech Updates are posted on a regular basis. Announcements may contain news about new certifications, end of support or third party retirement notices as well as any other platform related information.


A couple of goodies lately from Essbase Labs:




From the WebLogic Partner Community EMEA blog: ExaLogic new material.

Oracle Support

Chris Warticki's Blog - Oracle Support reminds us to take an occasional look at upcoming Customer Resource: Events.


At OTN, a nice technical article: Sysadmins Rejoice! OVM 3.2.1 Includes a Full-Featured CLI. Of course I included it mainly for the references to Monty Python.


Oracle WebCenter Alerts lets us know about an upcoming event: Product Support Webcast for Existing Customers: Framework Folders for WebCenter Content 11g.

Blog of Note

Ms Yin-Jen Su recommends keeping a link established to the Oracle Security Inside Out newsletter. Sagely advice, in this age of hack and counter-hack.


Better life through robots, Java and a Myriad of Toys! at The Java Source.

...And Finally

Have a Kindle and Amazon Prime? You can borrow books, lots of them, but only one at a time and one a month. Here's how to find the goods, at lifehacker: How to View the Entire Free Kindle Lending Library from Your Browser.

Monday, February 18, 2013

Contributions by Angela Golla, Infogram Deputy Editor

Oracle Newsletters
Oracle has a wealth of online magazines and newsletters to keep you informed.  You can subscribe to them here

Support specific newsletters are a vailable at Note:222.1.

Wednesday, February 13, 2013

Oracle Priority Service Infogram for 13-FEB-2013

Big Data


A good article on the 8.5.3 PeopleTools release from the Oracle PeopleSoft Technology blog recommended by Linda Corniola: Oracle and PeopleSoft Development Announce the General Availability of PeopleTools 8.53.


At the Oracle Scratchpad, Jonathan Lewis discusses a string of useful and entertaining acronyms: STS, OFE and SPM.




At Oracle DBA – Tips and Techniques, GoldenGate Integrated Capture Mode.


The Momen Blog discusses: Bug: ORA-00979: not a GROUP BY expression.


An announcement from the Oracle Business Intelligence Blog: OBIEE Bundle Patch Available.


From the always excellent Andrejus Baranovskis's Blog: ADF BC - Scrolling To The Last Row.

Waveset, OIM

A roadmap of the changes from Sun Identity Manager to OIM: migration Oracle Waveset OW, earlier Sun Identity Manager) to Oracle Identity Manager at Online Apps DBA.


Book Reviews and Announcements

The WebLogic 12c Book is Finally Here at the Oracle Fusion Middleware blog.

At the The PeopleSoft Tipster Blog: Jim Marion's new book.

Monday, February 11, 2013

Contributions by Angela Golla, Deputy Infogram Editor

E-Business Suite Resources
Steven Chan has a great E-Business Suite Blog.  Check it out at: For those of you preparing to upgrade to E-Business Suite Release 12, the following notes have a wealth of information:  Note:1406960.1, Note:1322667.1 and Note:380482.1.    

Wednesday, February 6, 2013

Oracle Priority Service Infogram for 06-FEB-2013

Data Warehouse

Lots and lots of data, one letter 'R'. From The Data Warehouse Insider: Parallel R: Quick Ways Model More.


Over at Technet, how to Track Down a Memory Leak.



Over at Martin Giffy D'Souza on Oracle APEX, Embedding Files within APEX: WORKSPACE_IMAGES vs APP_IMAGES.

RDBMS Performance

We all know the benefits of replacing SQL literals with bind variables, but how do you speed things up if you've already got a bunch of them in the code? Pythian makes a suggestion: regexp_replace: Auto-translate SQL literals to bind vars.

ITIL and the DBA

ITIL is one of the key elements of understanding how Oracle Support does its job, and a major element of any modern IT shop. Here's an article on it from the DBA's perspective at Jobacle (sounds like a labor-related icicle, eh?): What does a DBA really do – in ITIL terms ?



At Integrate, Harmonize, Orchestrate with Oracle Solutions, Capture Application Events using Oracle Goldengate.


Oracle Java SE Critical Patch Update for February 2013

The Oracle Java SE Critical Patch Update for February 2013 was released on February 1st, 2013. The original Critical Patch Update for Java SE was scheduled on February 19th , but Oracle decided to accelerate the release of this Critical Patch Update because active exploitation “in the wild” of one of the vulnerabilities affecting the Java Runtime Environment (JRE) in desktop browsers, was addressed with this Critical Patch Update. Oracle strongly recommends applying the patches as soon as possible.

The Critical Patch Update Advisory is the starting point for relevant information. It includes a list of products affected, pointers to obtain the patches, a summary of the security vulnerabilities, and links to other important documents.

Also, it is essential to review the Critical Patch Update supporting documentation referenced in the Advisory before applying patches, as this is where you can find important pertinent information.

The Critical Patch Update Advisories are available at the following location:

Oracle Technology Network:

Oracle Java SE Critical Patch Update for February 2013:

Oracle Technology Network:

The next three scheduled dates for Oracle Java SE Critical Patch Updates are:
  • 18 June 2013
  • 15 October 2013
  • 14 January 2014
Oracle Security Alerts

Tuesday, February 5, 2013

Contributions by Angela Golla, Infogram Deputy Editor

Improve Issue-to-Resolution-Time with Demo It To Oracle (DITO)

If you are having problems arranging an OWC with Support to see your problem or issue, DITO (Demo It To Oracle) can help you.  DITO uses CamStudio, a third party desktop recording software that is able to record all screen and audio activity on your computer into standard AVI video files and uses its built-in SWF (Streaming Flash Video) Producer to turn those AVIs into smaller, bandwidth-friendly streaming flash videos.

The idea of DITO is that you can demonstrate your issue for Oracle Support just like you do on an Oracle Web Conference; however, you can do this offline at your convenience without having to arrange for the presence of a support engineer.  You can make the recordings available to Oracle Support by uploading them to your SR in My Oracle Support.

This tool will record the reproducing steps from the customer that will allow Support or Development see what happens without setting up an OWC.
For complete instructions on how to use DITO, please refer to "Ditto It To Oracle" (DITO) CamStudio Help (Doc ID 11.1)

Official, Youbetcha Legalese

This blog is provided for information purposes only and the contents hereof are subject to change without notice. This blog contains links to articles, sites, blogs, that are created by entities other than Oracle. These links may contain advice, information, and opinion that is incorrect or untested. This blog, links, and other materials contained or referenced in this blog are not warranted to be error-free, nor are they subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this blog, links and other materials contained or referenced in this blog, and no contractual obligations are formed either directly or indirectly by this blog, link or other materials. This blog may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission. The opinions and recommendations contained in this blog(including links) do not represent the position of Oracle Corporation.

Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.