Optimizer, Hyperion, Clouds, MOS, I/O, APEX, EBS

Optimizer

The Oracle Optimizer team has an update from their experiences at OpenWorld on their blog here.

Hyperion

Tim Tow has a sobering posting on: One Good Reason to Stick with Supported Versions at his blog.

I've Seen Clouds from Both Sides Now...

The cloud concept is, well, cloudy, and it's hurting its reputation as the 'latest thing'. In fact, some would say that it is merely the latest fad, and the actual heart of the matter is the grid concept. There are several articles in the blogosphere and news that came out of the recent Sidekick debacle:

Defending the cloud over at ZDNet

Examining several aspects of the matter over at cnet, including a link to a statement by our very own Larry Ellison on clouds here.

Typical of the blog entries on this incident was this one over at the CircleID blog, which makes some good points about the underlying issue: Backups and restores.

To me it seems that there needs to be a more robust protocol for validating multiple backups on the cloud side of the equation. But the incident also comes back to some old fashioned, cliche-rich territory: Don't put all your eggs in one basket. What we need is a dispatcher service that copies out key items, like calendar entries and contacts, to several places and programs, and only notifies a user that an entry is confirmed when a minimum number of transactions are complete (similar to the behavior of some Oracle RDBMS features like DataGuard). In other words, it all comes back to basic transaction processing and due diligence on backup and recovery, things that DBAs deal with every day.

My Oracle Support

Have some feedback on MOS? Chris Warticki points to the spot for getting it to Oracle.

IOPS

Kevin Closson discusses the high end of storage and processing in this series: Sun Oracle Database Machine. The Million Oracle Database IOPS Machine or Marketing Hype? – Part I

APEX

David Peake has a link to an Updated Statement of Direction for APEX here.

EBS

At the Oracle E-Business Suite Technology blog this week:

OracleAS 10.1.3.5 Certified with E-Business Suite Release 12

E-Business Suite 12.1.2 Release Content Documents Now Available

Database 11gR1 11.1.0.7 Certified With EBS 12.1.1 on Windows Server 2003 (x64)

Secure Enterprise Search 10.1.8.4 Certified with E-Business Suite 11i

Interim Update #2: Certifying Windows 7 with Oracle E-Business Suite

Critical Patch Update for October 2009 Now Available

October CPU, Hyperion, Diagnosis, EBS, Morgan's Library

The October 2009 CPU is Out

This is another very important CPU to implement. Several high risk vulnerabilities are fixed in this CPU. Here's a good place to start working with it.

A word on one-off patching vs larger patchsets. Applying patches is rarely fun (ok, I admit it, it's never really fun, but I saw someone smile once while the files changes flew by on the screen). But it is good to recall that although one-off patches touch less code and thus seem to carry less risk, they lack the iterative testing that is done on larger collections of patches such as the CPU. Life is all about tradeoffs and compromises, so these factors are something to keep in mind.

Clouds of Hyperion

Sounds like poetry, albeit buzzword poetry. This posting at Tim Tow's blog looks to the future and a product to let you easily move things in and out of clouds.

Diagnosis

The metaphor of clinical concepts and IT continues at Edgewater Technologies blog with this post on diagnosis. I've always liked medical metaphors in IT, particularly in performance optimization. One of my favorite aphorisms from medical diagnostics applies very well to performance problems: If you hear hoof beats, think horses, not zebras. It's tempting to dig around in obscure internals and figure out some kind of latching linkages correlated to phases of the moon. But it's usually more productive to figure out what has changed and either improve it or change things back to the way they were before the problem.

EBS

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

Oracle Application Testing Suite 9.0 Supported with Oracle E-Business Suite

E-Business Suite Release 12.1.1 Certified on Windows Server 2008 (32-bit)

Using Oracle Application Server 10g with E-Business Suite (OpenWorld 2009 Recap)

Morgan's Library

Kevin Closson points out a great resource this week, Morgan's Library. I don't think we've blogged about it here before. And now we have.

PeopleSoft 9.1 and PeopleTools 8.50 Webcast

Join us on Wednesday, October 28, 2:00 PM EST for this special webcast: Introducing PeopleSoft Enterprise 9.1 and PeopleTools 8.50. We’ll cover:

• Newest capabilities demonstration
• Embedded Web 2.0 capabilities and industry-specific enhancements
• Robust Talent Management features and new Succession Planning solution
• Enhanced Financials Management
• Industry-specific applications for education and research, public sector, retail, and professional services.

Contributions by Angela Golla, Infogram Contributor

Oracle Support is pleased to announce the availability of the ComputerWorld Paper on My Oracle Support. This industry paper articulates why the proactive and personalized capabilities of My Oracle Support are having such an impact in the support industry. The paper covers multiple customer testimonials and an analyst perspective on why My Oracle Support is key to any support strategy. Read the article at:
http://www.computerworld.com/pdfs/a_oracle_stimulus2.pdf

Classic MetaLink Retires Nov 6: Essential My Oracle Support Customer Training Now Available

Contributions by Sherron Garnett, Infogram Contributor



Classic MetaLink Retires Nov 6: Essential My Oracle Support Customer Training Now Available



During the weekend of November 6–8, 2009, My Oracle Support, Oracle's next-generation customer support platform, will be upgraded and Classic MetaLink will be retired. Oracle is providing free training on My Oracle Support to help customers through this transition. Read more here here to learn about the training available.

EBS, APEX, Hyperion, Triage

EBS

The good folks from Oracle E-Business Suite Technology are out at OpenWorld this week, but still found time to post some valuable info on...OpenWorld 2009: E-Business Suite Technology Stack Certification Roadmap

APEX

The Application Express Listener Early Adopter is now available here.

Hyperion

Over at 'in 2 Hyperion' we have a posting on an Excel feature, custom lists, that many use and few know about, and how to combine it with Smartview: Compliment the Excel Add-In or SmartView with Excel Custom Lists.

Feel like bragging about how you have the biggest Essbase install in the cosmos? Well it has to be bigger than the one described here at Tim Tow's blog to qualify.

Are you a developer looking at Hyperion's complexities and wondering how all the pieces fit together, particularly Planning? This article from Rittman Mead Consulting is a good start toward clarity.

IT Philosophy: Triage and Queuing

I sense a resonance between these two postings, one, at Edgewater Technology's blog, speaks of project triage, a very high level concept, another, at The ORACLE-BASE Blog, goes down into the code to discuss queuing, another form of triage. Triage runs from the queing on the CPU all the way up to the user's daily calendar entries, it is a concept that should always be kept in mind when planning and building projects. It is also the most fundamental element of Oracle Support. Something is broken, or you don't know how to get the product to do what you need, you make an appointment with the doctor (file an SR) and the doctor (a combination of Oracle's internal workflow's interaction with the your profile and how you answer the questions when opening the SR and the actual support engineers) , sees you. Responses range from an unhurried process of preventive care (Sev 4) to rushing your DB to intensive care (Sev1). For Priority Service users you are near the front of the line as soon as you hit the submit button on the SR, and also have better ability to call in specialists if the problem is exotic, but the triage concept remains throughout. When is it time to think of triage? When the workflow gets out of whack. Wrong prioritization can lead to needless waste and damage. Increasing the priority of some tasks for politics or appearance' sake can cause harm, so can 'cry wolf' syndrome (i.e. if you always claim that any problem, even something minor, is a world-ending problem from hell). Artificially inflated priorities can wear out IT staff and waste money, ultimately slowing down the very project it was supposed to be expediting. Intelligent triage, though sometimes seeming harsh, will benefit your bottom line.

Contributions by Angela Golla, Infogram Contributor

Enterprise Architecture is always a hot topic. Learn more about it at Oracle's Enterprise Architecture Center:
http://www.oracle.com/technology/architect/entarch/index.html

Training Classes PeopleTools 8.50

Contributed by Linda Corniola, Infogram Contributor

Training PeopleTools 8.50

In case you were wondering, we are preparing lots of training classes for Tools 8.50. By Oracle Open World customers will be able to schedule themselves on the Oracle University website (oracle.com/education) for the following classes (Note that these classes are not available yet, names may change etc... ):

PeopleTools 1 rel. 8.50
PeopleTools 2 rel. 8.50
PeopleTools 1 & 2 Accelerated rel. 8.50
PeopleCode rel. 8.50
SQR for PeopleSoft rel. 8.50
Application Engine rel. 8.50
PeopleCode/SQR Accelerated training rel. 8.50
PeopleCode/Application Engine Accelerated

Secure Testimony

Contributions by Sherron Garnett, Infogram Contributor

Secure Testimony

Mary Ann Davidson is the Chief Security Officer of Oracle. She is responsible for securing development practices and security evaluations and assessments. She represents Oracle on the Board of Directors of the Information Technology Information Security Analysis Center (IT-ISAC), and has served on the U.S. Defense Science Board. Read her article Secure Testimony on advising the United States Congress about cybersecurity.

Performance, PeopleSoft, IT Philosophy, Links, Hyperion

Performance

Over at Alberto Dell'Era's blog we have the start of a series on the statistical density of "cardinality" in the CBO.

I wish I could say my math and logic skills were anywhere near close enough to keep up with Cary Milsap, former VP of Oracle for all things performance and originator of the Method R approach to optimization, but they're not. But I still advocate them in principle, if not personal practise, and so recommend this article on the Importance of Diagnosing Before Resolving at his blog.

PeopleSoft

Need to find how many concurrent users there are on PeopleSoft? Here's a handy script at ERP Associates' PeopleSoft Corner.

IT Philosophy

One of keys to solving complex IT problems, especially the tense situations when a key server is down and the fingers are pointing in flocks, is finding a likely cause. That search is often more difficult than it first appears. Let's say the database is down: Call Oracle, right? But what if you go through the steps and it turns out that the DB is fine, but someone wrote over a firewall configuration that didn't include its ports and ... kerfluey. These chains of causation can be lengthy and multifactorial. It is rare to have the opportunity to do full RCA on the matter. The main concern is usually getting the users reconnected, assigning blame, and moving along smartly. But I would ask you to keep the scientific approach always there. A majority of people nodding and saying: Yup, it's the application server, does not necessarily mean that it is the cause of the problem. Logic, not majority sentiment, should always prevail in IT troubleshooting. With that long and tedious preface, please read this item from the adhd ocd blog on nonsense correlations. And for another viewpoint on statistics and the manipulation thereof, have a look at Kosher Visualization over at the I'M JUST A SIMPLE DBA ON A COMPLEX PRODUCTION SYSTEM blog. Want to meet some of the bloggers you read here at the Infogram? Get together with them at Oracle Open World as described in this posting at the same blog, along with a batch of other links of interest.

RDBMS Links

A few handy links in this posting by Eddie Awad, all of interest to the DBA/Developer/Designer types out there. Oh, and 36,000 scripts. For those of you who really need something to do for the next ten years, test them out.

Not Oracle related, more like amusing psychology, but this link at Eddie's blog is fun too.

Hyperion

A good Hyperion posting recently over at Rittman Mead Consulting: Oracle Essbase 11.1.1.3 – Integration with Relational Sources and Applications.

Contributions by Linda Corniola, Infogram Contributor

PeopleSoft HCM 9.1 is GA

PeopleSoft HCM 9.1 is now generally available. Customers can start downloading it from the Electronic Product Delivery (EPD) site now. Physical shipment delivery will be available on October 1.

The upgrade scripts are usually available 6 - 8 weeks after GA. A great site to monitor is PeopleSoft HCM 9.1 Documentation Home Page on My Oracle Support Just log into My Oracle Support and search in knowledge for document ID 845867.1

Hyperion, EBS, AIA,, Forms, Performance

Hyperion

A handy posting today over at Tim Tow's Hyperion blog on Running Essbase on an Alternate Port.

EBS

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

Using Transportable Database 11gR1 with E-Business Suite

Database Vault 11.1.0.7 Certified for E-Business Suite on Windows Platforms

Firefox 3.5 Certified with E-Business Suite

AIA

Several valuable postings at the Official AIA Blog, including this one on AIA 2.0.1 and MLR # 18

Forms

Using Forms? There's a link to a webcast on Web cast with Oracle Forms Support Experts coming up on October 7th at OTN over at Grant's Blog.

Performance

Jonathan Lewis has been one of the leading lights of Oracle performance for as long as I've been involved in it. His blog is always worth a look. For instance this posting with links to forum posts on processes. Is it really a good idea to use the overkill approach and allocate lots of processes up front 'just in case'.