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

DataGuard

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

EBS

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

TDE Tablespace Encryption 11.2.0.1 Certified with EBS 12

Interim Update #1: Microsoft Office 2010 and E-Business Suite

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:

CONNECT BY and Recursive CTE

connect by and recursive with (part 2)

Performance

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

http://blog.tanelpoder.com/2010/05/07/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 (http://www.oracle.com/support/collateral/oracle-technical-support-policies.pdf)
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 (http://www.oracle.com/support/library/brochure/lifetime-support-technology.pdf)
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

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.