Saturday, September 7, 2013

Oracle OpenWorld 2013 Schedule

The annual Oracle OpenWorld global technology conference being held in San Francisco, CA is almost upon us. It kicks off September 22 with user group symposiums and runs until September 26. I was lucky enough to be chosen as speaker again this year. I say lucky because I believe there are much better speakers with more interesting topics that should've been accepted over mine. Whatever the reason, I'm happy and I'm looking forward to meeting up with old friends and networking with some of the best technologists and speakers in the world.
I will be participating in quite a few activities - mostly on Sunday. Here a few sessions that I'm scheduled to either present or be a panelist in.

Session ID: UGF9774
Session Title: Oracle RAC SIG Meeting: Expert Panel
Venue / Room: Moscone West - 3004
Date and Time: 9/22/13, 15:30 - 16:30

Session ID: UGF9794
Session Title: Managing Oracle Enterprise Manager Cloud Control 12c with Oracle Clusterware
Venue / Room: Moscone West - 3005
Date and Time: 9/22/13, 10:30 - 11:30

Session ID: UGF9801
Session Title: DBA Expert Panel
Venue / Room: Moscone West - 3014
Date and Time: 9/22/13, 13:00 - 14:00

Session ID: GEN9592
Session Title: General Session: Oracle Enterprise Manager 12c—Accelerating Your Journey to Self-Service IT
Venue / Room: Moscone South - 103
Date and Time: 9/24/13, 12:00 - 13:00


Session ID: CON7752
Session Title: Oracle Enterprise Manager Cloud Control 12c: Top 10 Features for DBAs
Venue / Room: Moscone South - 102
Date and Time: 9/26/13, 15:30 - 16:30

RAC Attack
Moscone South in the OTN Lounge - Tuesday, September 24th and Wednesday, September 25th from 10 am – 2 pm.
See here for more info.

I also plan on attending some OakTableWorld sessions which showcases the top talents in the Oracle community. Lots of technical deep dives - without the fluff.
My tentative schedule is also available here.

Bloggers meetup is also an OpenWorld networking/social staple.

Finally, there are a number of stay-in-shape activities being planned. Admittedly I've not been in any sort of good physical shape lately and have adopted a more or less sedentary mode -(aside from doing activities with my kids). But maybe this will  motivate me to get back in shape. We'll see :).

Oracle Enterprise Manager Cloud Control 12c and Database As A Service (DBaaS)

The information technology industry has been a tremendous growth in Cloud delivery models for IT services in the past couple of years. More recently, the PaaS service model including Database-as-as-Service (DBaaS) has been gaining traction rapidly. Amazon's RDS public DBaaaS service supports Oracle, MySQL and SQL Server and enable rapid development lifecycles by giving end-users the ability to provision databases on demand in a very short period.

Security and control are two drawbacks seen in public cloud environments. How can this be overcome while delivering the same level of rapid provisioning, elasticity and multi-tenancy for databases? Oracle Enterprise Manager Cloud Control 12c provides a complete lifecycle management framework for databases - from provisioning to patching. The Database Cloud plug-in enables DBaaS for users on premise without the drawbacks of public clouds. If developers want copies of schemas then the Schema-as-a-Service sub-model can enable them to self-provision these schemas in pre-defined databases without waiting hours or days for DBAs. Likewise, for QA testing, complete databases can be spun up from RMAN, DBCA templates or storage snapshots in a matter of mins-hours. Oracle Database 12c provides a multi-tenant architecture via "pluggable databases". Coupled together - these two can provide benefits such as rapid, self-provisioning via DBaaS/SchaaS even without a Cloud service model.

In this series I will explore how Oracle Enterprise Manager Cloud Control 12c provides DBaaS and how Oracle Database 12c Multi-tenant architecture makes it all come together.

EM12c Partition Maintenance and Stats

In previous versions of Oracle Enterprise Manager you would call the EMD_MAINTENANCE package to execute certain maintenance tasks such as partition maintenance and statistics gathering.
EMD_MAINTENANCE.ANALYZE_EMD_SCHEMA
EMD_MAINTENANCE.PARTITION_MAINTENANCE

In OEM12c these procedures are replaced by:
EMD_MAINTENANCE.GATHER_SYSMAN_STATS
EMD_MAINTENANCE.DAILY_MAINTENANCE

The daily_maintenance procedure actually calls gc_interval_partitions and gathers stats on Saturday. Not quite sure why that was hardcoded but I guess they figured that monitoring was least likely to be impacted on that day. If the OEM DBMS jobs are down you can also submit them by logging in the to the repository database as SYSMAN and execute the package:

Begin
     emd_maintenance.submit_em_dbms_jobs();
End;
/

Note that these procedures are automatically run through scheduled jobs once the job_queueue_ processes parameter is set to a value greater than 0.