Thursday, June 10, 2010

RDBMS, Hyperion, PL/SQL, APEX, SQL Developer, PeopleSoft, Exadata, Flashback


RDBMS

Tom Kyte is putting the finishing touches on the second edition of his magnum opus, Expert Oracle Database Architecture.
You can preorder a copy at Amazon here.

Speaking of Oracle guruhood, Cary Milsap has an update on his blog about
Filter Early

The title reminds me of the old Chicago voting motto: Vote early and vote often.

__________________________

New release out:

Oracle Database Patch Set 10.2.0.5 has been released on the following platforms:

· Oracle Solaris x86-64 (64-bit) and SPARC (64-bit)

· HP-UX Itanium

· IBM AIX on POWER Systems

All are available for download from My Oracle Support (patch 8202632) as well as edelivery.oracle.com.

Next up will be Windows...stay tuned

Hyperion

Just one item this week. Over at Glenn Schwartzberg's Essbase Blog Glenn has a moment of revelation about exports:
Data Export, why I never thought of it

PL/SQL

Eddie Awad has a good article on
Please Request a Reasonable Conversion, including some drill-down links at the bottom for further research.

APEX

David Peake let's us know that
APEX 4.0 comes to http://apex.oracle.com

Also in the realm of APEX is this article from the APEX Development blog:
APEX 3.2 Quick Picks Updated.

Book Review: SQL Developer

Olaf Heimburger's Blog has a brief but useful
review of the book Oracle SQL Developer 2.1.

PeopleSoft

We frequently link to posts at Jim's PeopleSoft Journal. Since he has a new book out, I'm sure it's worth taking a look at:
PeoplesTools Tip Book

Flashback – Careful about Storage

A customer recently encountered problems with running out of space for Flashback Database logs (though it took a while to determine that was the problem). Here are a few interesting links that popped up when I was researching the problem:

http://dba-blog.blogspot.com/2006/05/flashback-database-feature.html

and this one is excellent, and comes from Jonathan Lewis, one of the key gurus of the Oak Table Net performance group:

http://jonathanlewis.wordpress.com/2010/04/14/analysing-statspack-12/

and a spot in the docs:

http://download-west.oracle.com/docs/cd/B12037_01/server.101/b10734/rcmflash.htm


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.