OMG … only a few weeks to go … Oracle Open World 2015 in San Francisco is coming closer and closer …
And this year will be really tough as we have a reduced number of people there – but more work to do as in previous years. 3 talks (2 for Upgrade, 1 for Data Pump), 4 labs (all in Nikko Hotel 15min walking distance from Moscone Center) – plus a good number of customer meetings already lined up. Plus the chance to meet so many great people … and not to forget the Data Warehouse Global Leaders event at the Oracle HQ.
I have that strange feeling that I will be VERY tired when I’ll board the plane on Friday night heading back to Germany … 😉
Focus On Upgrades/Migrations
As the fantastic application we are using for the OOW content catalog doesn’t allow me to link directly to a session Roy has built a Focus On document to guide you to some important talks around Upgrades and Migrations at OOW2015.for your convenience:
Talks
| Session ID
|
Title
|
Start Time
|
Room |
| CON6777 | Upgrade and Migrate to Oracle Database 12c: Live and Uncensored!Many customers now have database environments numbering in the hundreds or even thousands. This session addresses the challenge of maintaining technical currency of such an environment while also containing upgrade and migration costs at a reasonable level. Learn from Oracle Database upgrade experts about product features, options, tools, techniques, and services that can help you maintain control of your database environment. You will also see examples of how real customers are successfully meeting this challenge today. . . |
October 26 at 13:30h |
Moscone South—102 |
| CON8375 | How to Upgrade Hundreds or Thousands of Databases in a Reasonable Amount of TimeMany customers now have database environments numbering in the hundreds or even thousands. This session addresses the challenge of maintaining technical currency of such an environment while also containing upgrade and migration costs at a reasonable level. Learn from Oracle Database upgrade experts about product features, options, tools, techniques, and services that can help you maintain control of your database environment. You will also see examples of how real customers are successfully meeting this challenge today. . . |
October 28 at 12:15h |
Moscone South—102 |
| CON8376 | Deep Dive: More Oracle Data Pump Performance Tips and TricksThe Oracle Data Pump development team is back with even more performance tips and tricks for DBAs! In this session, learn about Oracle Data Pump features, parameters, and patches—some added since the first patch set of Oracle Database 12c 12.1.0.2—that will improve performance and decrease overhead for Oracle Data Pump projects. Whether you are an Oracle Data Pump novice or already an expert, you are sure to learn something new in this session that will help you maximize the throughput of your export and import operations. . . |
October 29 at 9:30h |
Moscone South—305 |
| HOL10348 | Upgrade, Migrate, and Consolidate to Oracle Database 12c [HOL10438]
The Oracle Data Pump development team is back with even more performance tips and tricks for DBAs! In this session, learn about Oracle Data Pump features, parameters, and patches—some added since the first patch set of Oracle Database 12c 12.1.0.2—that will improve performance and decrease overhead for Oracle Data Pump projects. Whether you are an Oracle Data Pump novice or already an expert, you are sure to learn something new in this session that will help you maximize the throughput of your export and import operations. |
Oct 26 at 11:00h Oct 27 at 11:45h Oct 28 at 13:15h Oct 29 at 12:30h |
Hotel Nikko – Golden Gate |
Hope to see you at OOW 2015!
–Mike
Mike – Any idea, that TomKyte will join us in this OOW ?
I don’t think so – see here:
http://www.oracle.com/technetwork/issue-archive/2015/15-sep/last-asktom-2650480.html
Mike
Yes, I know (read) that. so I put this question. every year we enjoy Tomkyte’s Keynote and his Top N style (Top 11 things about 11g, Top 12 things about 12c and five things about sql/plsql/performance) presentation. Miss you Tom !
Believe me, we all miss Tom a lot.
But he worked so entirely hard the past years, spending tons of time in airplanes, taxis, airports, trains, taxis, airports … at some point you need to take some time off and see what is life all about.
Thanks
Mike
Mike,
https://blogs.oracle.com/UPGRADE/entry/incremental_statistics_collection_improved_in
<quote>
Tom explained yesterday that in Oracle Database 12c Incremental Statistics Collection has gotten a few excellent extensions making it more efficient:
Smaller footprint on disk for synopses compared to previous releases
Incremental stats with partition exchange operations
Ability to define a stale percentage for existing partitions
</quote>
By any chance do you have the test scripts / benchmarking results that Tom used for this "Smaller footprint comparision with previous releases" ? can you share that?
There’s no benchmark script available to test this. We know it simply from changes in the code. You could of course verify the footprint in disk in
SYS.WRI$_OPTSTAT_SYNOPSIS_HEAD$
SYS.WRI$_OPTSTAT_SYNOPSIS$
and compare 11g and 12.1.0.2 to each other – then you’ll see a significant difference.
Cheers
Mike
CON8376, CON6777 ,CON8375 ,HOL10348
Mike,
For those who missed OOW like me.
do we have any chance in near future to get access to the above presentation?
Thanks
Please see the Slides Download Center to your right – you’ll find all of them titled "OOW 2015 …"
Cheers
Mike