Thursday, May 20, 2010

DataGuard, EBS, Performance, SQL Editing Tool, Support Policies, PeopleSoft


TCP socket size is not something most people dwell on a lot. Well, according to Alejandro Vargas' Blog, it can be an important factor for high throughput DataGuard systems: How to Calculate TCP Socket Buffer Sizes for Data Guard Environments


This week at the Oracle E-Business Suite Technology blog:

Hierarchies in EBS

Hierarchies in RDBMS queries is one of those subjects that make junior developers (and even some fairly senior ones) wish they had taken that opportunity to work in their family business instead of dealing with the code. Oracle is constantly working to make it easier to generate hierarchies from relational tables, and here is another aspect pointed out by Laurent Schneider:


Alberto Dell'Era offers a very useful looking tool for tracing sessions: Xtrace: an Oracle session trace browser – exec flow

Jonathan Lewis has some answers on the question he posed at his lates Quiz Night in this posting about improving efficiency by changing a two table join into a three table join here: double trouble.

At Charles Hooper's Oracle Notes there is a good in-depth discussion of the pluses and minuses of cartesian joins. Cartesian joins tend to scare people, who want to keep them where they belong, between the covers of a relational database theory book. But it turns out there are circumstances where they can improve performance. Read about it here.

SQL Editing Tool

Tanel Poder has a posting on a very handy looking tool for editing and command history in tools like SQL*Plus at the Unix command line: Flexible Sqlplus command line history with RLWRAP

Support Policies

Oracle Tech Support Polices and Lifetime Support brochures have been updated to reflect the extension to 9.2 Extended Support

Tech Support Polices (
For customers with current support contracts for Oracle9i Database Release 9.2 on the following platforms: Solaris SPARC (64 bit), Linux x86 (32 bit). IBM AIX, HP-UX Itanium, HP-UX PA-RISC, HP Tru64 UNIX, Microsoft Windows (32 bit), IBM z/OS on System z, and IBM Linux on System z, Limited Extended Support will be available from July 2010 through July 2012. During this period, you will receive Severity 1 fixes only. Critical Patch Updates (“CPUs”) will not be made available during this period.

Lifetime Support Brochure (
For Oracle Database 9.2 a limited bug fix service will be available from Aug 2010 until July 2012. For details please refer to the Technical
Support Policies.

10.2 Fee Waivers
One final point due to the late porting of 11g on z/Linux we’re extending the fee waiver period for 10gR2 ES for an extra year for z/Linux customers

For customers with current support contracts running Oracle Database 10gR2 for z/Linux, the Extended Support Waiver Period has been
extended for one year. Extended Support will be waived from August 2010 – July 2012.


PeopleSoft users should have already received an email on this, but just in case you missed this:

URGENT: PeopleTools 8.50 Upgrade Issue! Datetime not converted to Timestamp

What are we announcing?

We need to bring to your attention a recent discovery for customers who have upgraded to 8.50 PeopleTools on a pre-9.1 PeopleSoft Application on an Oracle database platform.

It is critical that you review the solution attached to this email (also available in My Oracle Support, Document ID 1094003.1), if you're planning to move to production with this configuration.

If you are currently in production with this configuration, we ask that you immediately log a Service Request with Oracle Global Support and a Support Engineer will consult with you on next steps. When logging this SR, please use the following as the Problem Summary to facilitate a timely response: "Datetime not converted to Timestamp [ID 1094003.1]".

Thank you for your quick attention to this matter. Please contact the Oracle Support team to provide assistance with any concerns you may have with your current implementation.

- Regards,

PeopleTools Install and Upgrade Team, Global Customer Support.

No comments:

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.