Search

OakieTags

Who's online

There are currently 0 users and 38 guests online.

Recent comments

Affiliations

September 2012

Just attended this

Just attended this session here at Oracle Openworld:

Flexible Design and Modeling: Planning for Constant Change

Gwen Shapira - Senior Consultant, Pythian

Robyn Sands - Principal Member of Technical Staff, Oracle
Which was expressing the same message as the Helsinki Declaration does:

Create API's in the database layer and do not let outside software layers access tables directly.

It

Multiple Adverts

Just a couple of announcements:

1. I had the message already a couple of days added to the "Upcoming Public Appearances" sidebar on the right hand side of this page, now the official home page is available and registration open for the "CBO Days" at Trivadis 11th and 12th December in Zurich.

Join Mohamed Zait (Manager of the Query Optimizer Group at Oracle), Maria Colgan (Senior Principal Product Manager at Oracle), Jonathan Lewis, Jože Senegačnik, Christian Antognini and myself for two days fully focused on the Cost-Based Optimizer. You will not only learn about the history and present, but also the future of this very important Oracle Database component.

2. Oracle University is going to organize my one day master class "Mastering Parallel Execution" from December on.

Openworld has commenced…

The ACE director briefings are over and Oracle Open World has kicked into full swing.  The scale of the event is staggering and its a challenge just finding sessions to go to.  This is not due to insufficient sessions – just the challenge of sifting through 100+ concurrent sessions, spread across multiple locations and timeslots…

Maintaining Optimizer Statistics on PeopleSoft on Oracle 11g

I have been considering how to collect optimizer statistics for a PeopleSoft system running on an Oracle 11g database.  Despite 11g being several years old, most of my current customers are still using 10g, though some are looking at the upgrade to 11g.  I believe a slightly different approach is required.

In 2009, I wrote a series of blog postings on the subject of collecting statistics.  However these were all based on Oracle 10g.  I proposed a PL/SQL package that would use meta-data in a database table to determine how to collect statistics on a table, or deliberate supress collection of statistics.

Maintaining Optimizer Statistics on PeopleSoft on Oracle 11g

I have been considering how to collect optimizer statistics for a PeopleSoft system running on an Oracle 11g database.  Despite 11g being several years old, most of my current customers are still using 10g, though some are looking at the upgrade to 11g.  I believe a slightly different approach is required.

In 2009, I wrote a series of blog postings on the subject of collecting statistics.  However these were all based on Oracle 10g.  I proposed a PL/SQL package that would use meta-data in a database table to determine how to collect statistics on a table, or deliberate supress collection of statistics.

OOW12: Beginning Performance Tuning

Thank you very much for coming to my session "Beginning Performance Tuning" on the #IOUG track at #OOW12 Oracle Open World 2012. It makes the day for any speaker to see the room filled to capacity even at 9 AM on a Sunday morning. Much, much appreciated.

Here are the slides and the scripts I used in the demos. Please feel free to reuse the slides and scripts for for any purpose. All I ask is to give due credit to me. I imply no warranty and support for the materials. Use your discretion while using.

Repairman Jack : Fatal Error

Fatal Error is the fourteenth book in the Repairman Jack series by F. Paul Wilson.

The Septimus Order, the Dormentalists and the Kickers all combine to try and bring down the internet, hoping the resulting chaos will further their cause of killing The Lady and letting The Otherness take over our reality.

As with the previous episode, we are just progressing the story line, getting us another step closer to the possible end of the world…

Cheers

Tim…

Oracle OpenWorld 2012 : Day Minus 1

After another night with little sleep, Saturday was a chance to recover. I had no formal plans for the morning. I registered for OOW, then went out for breakfast with Marcelle, who then had to shoot to MySQL Connect.

From there I went back to my room for a little rest, then it was out to take Connor McDonald‘s advice and get a $15 T-Mobile SIM to get 7 day data access from my hotel room. Much cheaper than the hotel internet!

During the day I managed to hassle Marcus Eisele, Simon Haslam and Jakko Landlust about WebLogic stuff. It’s the classic case of “The more you know, the more you realise you don’t know”. Perhaps I should stop asking questions, so I can convince myself I’m a WebLogic God!

Oracle OpenWorld 2012 : Day Minus 2

Day 2 of the ACE Director briefing went pretty much to plan. My recent adventures in WebLogic meant I had to pay special attention to a few areas I would normally let wash over me. :) I also learned a few things about the WebLogic roadmap that made me kick myself for some of the recent decisions I had made. I guess that’s what happens when you get forced into a position of doing a role you have no background in. I confess I’m a WebLogic noob! :)

Thanks for Victoria and Lillian for organising the ACED briefing again. It’s good to get face time with the movers and shakers in the Oracle tech world…

Fusion apps

When it comes to hardware, the Fusion Apps installation guide is surprisingly non-committal:

4.2.1 Hardware Requirements

Consult an Oracle Fusion Applications sizing-certified representative to obtain specific, customized system hardware requirements

Some googling suggests that Fusion Apps is going plonk the following on your system:

- several databases
- many many WebLogic servers

and the general consensus seems to be minimum 128G RAM

Oh….my….goodness :-)