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
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.
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…
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.
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.
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.
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…
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!
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…
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
Recent comments
3 years 21 hours ago
3 years 12 weeks ago
3 years 16 weeks ago
3 years 17 weeks ago
3 years 21 weeks ago
3 years 43 weeks ago
4 years 11 weeks ago
4 years 41 weeks ago
5 years 25 weeks ago
5 years 25 weeks ago