Wednesday, April 15, 2009

Groovy, APEX, Optimizer, Nehalem, EBS & CPU, Model, Hyperion


Groovy APEX

Yes, it's a new language named Groovy. I suppose it was inevitable. The link to an Oracle whitepaper on this new language in JDeveloper is to be found here.

Also over at Grant's blog is a good list of factors when you are thinking about moving from Forms to APEX. I'd say go for it. I love APEX. But don't assume it's a push-button process. There is still plenty of room for the usual vicissitudes of computer development work.

Optimizer

The Inside the Oracle Optimizer has a good technical article (they have yet to produce a posting that is less than 100% technical) on Adaptive Cursor Sharing. Ah, that brings back memories of school...no, wait...that was Abusive Chalk Hoarding.

Nehalem

We blogged last week about Kevin Closson's posting on the unnerving speed of the new Nehalem processor. Well, in the realm of peer review, there is a posting this week on the Structured Data blog that link's to Kevin's posting and shows off some results that back it up.

EBS

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



Please note that first one: CPU for April 2009 now available. Starting with the advisory for the April 2009 CPU here at OTN. 

Here, courtesy of Keith Murphy of Oracle, is an availability matrix for the CPU:

Platform

11.1.0.7

11.1.0.6

10.2.0.4

10.2.0.3

10.1.0.5 

9.2.0.8 DV

9.2.0.8

Comments

Terminal Critical Patch Update

-

CPUJul2009

-

-

CPUJan2012

CPUJul2010

CPUJul2010

 

AIX 5L

8290478

8290402

8290506

NA

8290534

8290542

8290549

 

BS2000

NA

NA

8290506

NA

NA

NA

NA

 

BS2000-SX

NA

NA

8290506

NA

NA

NA

NA

 

HP Itanium

8290478

8290402

8290506

NA

8290534

NA

8290549

 

HP-UX

8290478

8290402

8290506

NA

8290534

8290542

8290549

 

IBM S/390 Linux

NA

NA

NA

NA

NA

NA

OR

 

IBM zLinux

NA

NA

8290506

NA

OR

NA

NA

 

IBM z/OS 390 (Server)

NA

NA

NA

21-APR-2009

OR

NA

OR

 

Linux Itanium

NA

NA

8290506

NA

OR

NA

8290549

 

Linux on POWER

NA

NA

8290506

NA

OR

NA

NA

 

Linux x86

8290478

8290402

8290506

NA

8290534

NA

8290549

 

Linux x86-64

8290478

8290402

8290506

NA

8290534

8290542

8290549

 

Mac OS

NA

NA

Planned

NA

OR

NA

NA

 

Solaris

NA

NA

NA

NA

NA

8290542

8290549

 

Solaris 64-Bit

8290478

8290402

8290506

NA

8290534

8290542

8290549

 

Solaris x86

NA

NA

8290506

NA

8290534

NA

NA

 

Solaris x86-64

NA

NA

8290506

NA

NA

NA

NA

 

Tru64

NA

NA

21-APR-2009

8290523

8290534

NA

8290549

 

VMS

NA

NA

8290506

NA

OR

NA

8290549

 

VMS Itanium

NA

NA

8290506

NA

NA

NA

NA

 

Windows 32-Bit

8343061

8333655

8307237

NA

8300356

NA

8300340

 

Windows 64-Bit

NA

NA

8333678

8288853

8300360

NA

8300346

 

Windows x86-64

8343070

8333657

8307238

NA

NA

NA

NA

 

  

Indexes

How small should you go? Can tables of a few blocks benefit from indexing? The typical DBA answer, as for everything, is: Well, it depends. Richard Foote, Dr. Index, tells us more about it.

Model Clause

Jonathan Lewis has a posting today over at his Oracle Scratchpad blog on the Model Clause. Give it a read.

Hyperion

Run Hyperion? Need to use it in something other than English? The Look Smarter Than You Are blog has good news: 

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.