Month: September 2012

Full Portfolio of x86 Systems On Display at Oracle OpenWorld

Oracle x86 Server

This OpenWorld, Oracle’s x86 hardware team will have two hardware demos, showcasing the new X3 systems, as well as several other x86 solutions such as the ZFS Storage Appliance, Oracle Database Appliance and the Carrier Grade NETRA systems. These two demos are located in the South Hall in Oracle’s booth 1133 and Intel’s booth 1101. 

The Intel booth will feature additional demos including 3D demos of each server, a static architectural demo, the Oracle x86 Grand Prix video game and the Intel Theatre featuring several presentations by Intel’s partners.

Oracle’s Intel Theatre Schedule and Topics Include:
1. 10:30 a.m. – Engineered to Work Together: Oracle x86 Systems in the Data Center
2. 12:30 a.m. – The Oracle NoSQL Database on the Intel Platform.
3. 1:30 p.m. – Accelerate Your Path to Cloud with Oracle VM
4. 3:30 p.m. – Why Oracle Linux is the Best Linux for Your Intel Based Systems
5. 4:30 p.m. – Accelerate Your Path to Cloud with Oracle VM
1. 10:00 a.m. – Speed of thought” Analytics using In-Memory Analytics
2. 1:30 a.m. – A Storage Architecture for Big Data:  “It’s Not JUST Hadoop”
3. 2:00 a.m. – Oracle Optimized Solution for Enterprise Cloud Infrastructure.
4. 2:30 p.m. – Configuring Storage to Optimize Database Performance and Efficiency.
5. 3:30 p.m. – Total Cloud Control for Oracle’s x86 Systems
1. 10:00 a.m. – Big Data Analysis Using R-Programming Language
2. 11:30 a.m. – Extreme Performance Overview, The Oracle Exadata Database Machine
3. 1:30 p.m. – Oracle Times Ten In-Memory Database Overview

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 Tri…

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.

This seminar focuses on the building blocks of Parallel Execution: At the end of the day you should be able to really understand how Parallel Execution works, how to read Parallel Execution plans and in particular how to diagnose Parallel Execution issues like skewed data distribution using advanced tools like Real-Time SQL Monitoring and Active Session History.

So after this session you should have the knowledge to fully leverage the power of Parallel Query and Execution.

Ideally as a prerequisite you should already have a good understanding of serial SQL execution and how to read serial execution plans.

If you are interested, get in touch with Oracle University so that they can plan accordingly.

3. Just a short reminder that the DOAG organizes another Webinar about “Cost-Based Optimizer Basics” which is free for DOAG members and takes place at Friday, 12th October 11am

4. The next “DOAG News” will include a accompanying article about “Cost-Based Optimizer Basics”, where I provide a summary of the Webinar contents.

5. And last but not least, after OOW rush is over I expect OTN to publish a mini-series on “Parallel Execution” that gives more insights into contents of the master class mentioned above.

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.
I also recommended that statistics on tables created for use as temporary records in Application Engine programs should have their statistics deleted and locked  to prevent system-wide jobs refreshing their statistics. I proposed a package that collected statistics according to meta-data defined in a table.

IN 2011, Oracle published document 1322888.1 “pscbo_stats – Improving Statistics in Oracle RDBMS for PeopleSoft Enterprise”.  It takes a similar approach to my 10g package.  A PL/SQL package is used to collect statistics.  A number of tables control whether, when and how statistics are collected on each record.  Oracle’s package is also intended to be used to collect schema-wide statistics.

The psbo_stats package is a attempt to solve a genuine problem, and it has continued to evolve since its initial release.  However, I have a number of objections to it.

  • You are expected to replace the default automatic jobs that collect statistics with pscbo_stats, so it is a move away from standard default maintenance procedures.
  • pscbo_stats is still fundamentally a 10g solution. It does not use 11g table preferences.
  • It does use the Oracle automatic sample size in 11g if histograms are not to be collected.  Otherwise, it defaults to the previous behaviour of either using 100% sample size for when called by %UpdateStats with the ‘high’ sample size, or a variety of fixed sample sizes based on internal rules and the number of rows in the table.
  • The package contains a procedure that collects statistics on all objects in the schema that also refreshes statistics that are not stale but which have not been refreshed for a period of time determined by the size of the table. 
  • When it collects histograms it always sets the maximum bucket size of 254. This may not always be desirable for height balanced histograms.
  • There is no support for collecting aggregated or incremental statistics on partitioned objects.

I think that the 11g table preferences offer better control over collection of statistics.

Oracle considerably enhanced the delivered DBMS_STATS package in 11g.  It became possible to specify default values for parameters in the dbms_stats.gather_table_stats program for for each table.

The guiding principle in 11g, and one that is not specific to PeopleSoft, is that instead of calling dbms_stats.gather_table_stats with the desired parameters, we should set table preferences with the desired parameters and then just call dbms_stats without table specific parameters. We can then just leave the default database and schema-wide procedures get on with the job of collecting statistics.    

A document that describes the updated approach and the various scripts are available on the Go-Faste website at

CAVEAT: This document represents some experimental work that is in progress.  It has not been tested against a customer system, let alone been used in production. I would welcome any feedback, and the opportunity to work with someone on a PeopleSoft system on Oracle 11g.

Top 5 Sites and Activities in San Francisco to Experience During Oracle OpenWorld

While Oracle OpenWorld may provide solutions and information on topics like how to simplify your IT, the importance of cloud, and what types of storage may satisfy your enterprise needs, who is going to tell you more about San Francisco?

Here are some suggested sites and activities to experience after OpenWorld that aren’t too far from the Moscone Center. It is recommended to take a cab for the sake of time, but the 6 square miles that make up San Francisco will make for a quick trek to any of the following destinations:

  1. The Golden Gate Bridge

    An image often associated with San Francisco, this bridge is one of the most impressive in the world. Take a walk across it, or view it from nearby Crissy Field, it is a sight that floors even the most veteran of San Franciscans.
  2. The Ferry Building
    Ferry Building
    Located at the end of Market Street in the Embarcadero, the Ferry Building once served as a hub of water transport and trade. The building has a bay front view and an array of food choices and restaurants. It is easily accessible via the Muni, BART, trolley or by cab. It is a must-see in San Francisco, and not too far from the Moscone Center.
  3. Ride the Trolley to the Castro
    For only $2, you can get go back in history for a moment on the Trolley. Take the F-line from the Embarcadero and ride it all the way to the Castro district. During the ride, you will get an overview of the landscape and cultures that are prevalent in San Francisco, but be wary that some areas may beg for an open mind more than others.
  4. Golden Gate Park
    Golden Gate Park
    When you tire of the concrete jungle, the lucky part of being in San Francisco is that you can escape to a natural refuge, this park being one of the favorites. This park is known for its hiking trails, cultural attractions, monuments, lakes and gardens. It is one good reason to bring your sneakers to San Francisco, and is also a great place to picnic. Please be wary that it is easy to get lost, and it is advisable to bring a map (just in case) if you go.
  5. Haight Ashbury
    Haight Ashbury
    For a complete change of scenery, Haight Ashbury is known as one of the places hippies used to live and the location of “The Summer of Love.” It is now a more affluent neighborhood with boutique shops and the occasional drum circle. While it may be perceived as grungy in certain spots, it is one of the most photographed places in San Francisco and an integral part of San Franciscan history.

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 appreciate…

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 appreciate…

Day 1 of Oracle OpenWorld 2012 September 30

Howard Street in San Francisco is closed. The large Oracle tent is up! Attendees are arriving by the plane load at SFO. It can only mean one thing ….

That’s right!  Oracle OpenWorld officially starts today with the Oracle Users Forum. Ton’s of great technical sessions selected by the Oracle User Groups get under way this morning at 8 am (Doh!). And of course, Larry’s keynote is this evening 5:00 pm–7:00 pm, Moscone North. A must see, as he is bound to make some exciting announcements to get the show started!

Hope to see ya there!

OOW: So Much To Do

Just a quick blog post to say that I’m out in San Francisco for the 4th year running to attend Oracle OpenWorld, and as much as I can fit in of the other events that happen at the same time! There’s so much going on it can be pretty tricky to work out where the […]

TEL/電話+86 13764045638
QQ 47079569