Search

Top 60 Oracle Blogs

Recent comments

Oakies Blog Aggregator

A Cloud over San Francisco for OpenWorld 2010

Oracle OpenWorld 2010 is just bursting with big cloud-related announcements this week.  As I prepare to present on the Amazon cloud at OOW2010 on Thursday (http://bit.ly/aSKdIQ), I thought I would highlight two of the biggest cloud-related announcements of the week.

Exalogic

We all know about Exadata, Oracle’s hardware-based storage-optimized RAC monster capable of over 1 million IOPS.  In his keynote, Larry Ellison announced Exalogic, an appliance that is meant to provide cloud-like private internal infrastructure.  Oriented towards  middleware, Exalogic’s marketing materials emphasize the elasticity of resources and promote middleware consolidation onto a small set of Exalogic nodes.

Certification for Oracle on Oracle VM-based Amazon Elastic Compute Cloud

Oracle and Amazon jointly announced this week that they will soon provide Oracle VM (OVM) based EC2 instances certified to run any Oracle software certified on traditional Oracle VM.  This includes Oracle Applications, Peoplesoft, Siebel and many other Oracle products. The issue of Oracle supportability and certification on EC2 has been a major sticking point for customers since EC2 and Oracle began collaborating over two years ago.  This announcement should allay some of the concerns regarding running Oracle on EC2.

Previously, Oracle supported only the database, middleware and Oracle Enterprise Manager on standard EC2 instances.

With this annoucement, the division of support responsibility remains the same. Oracle issues are handled by Oracle Support, and EC2 issues are handled by Amazon.

Related posts:

  1. Report from Oracle Openworld
  2. Oracle Certification vs Oracle Support
  3. Oracle E-Business Suite in the Amazon Cloud

Oracle Open World presentation uploaded… Optimizing Oracle Databases on SPARC Enterprise M-Series Servers.

As promised, I have attached the slide deck we used for our presentation at Oracle Open World.  A big thanks to Allan for asking me to help… glad to do it!

ID#: S315915
Title: Optimizing Oracle Databases on Sun SPARC Enterprise M-Series Servers
Track: Sun SPARC Servers
Date: 20-SEP-10
Time: 12:30 – 13:30
Venue: Moscone South
Room: Rm 270
Slides : oow2010_db_on_mseries.pdf

There are a bunch of OTN white papers that were produced to show how to run the Oracle stack best on Sun servers.  I will try to post an index soon but feel free to peruse the OTN site, there is lots of new content.

Filed under: Oracle Tagged: lgrpinfo, numa, Oracle, OTN, performance, sparc

UKOUG RAC&HA SIG September 2010

Just a quick one to announce that I’ll present at said event. Here’s the short synopsis of my talk:

Upgrading to Oracle Real Application Cluster 11.2

With the end of premier support in sight mid 2011 many business start looking at possible upgrade paths. With the majority of RAC systems deployed on Oracle 10g, there is a strong demand to upgrade these systems to 11.2. The presentation focuses on different upgrade paths, including Grid Infrastructure and the RDBMS. Alternative approaches to upgrading the software will be discussed as well. Experience from migrations performed at a large financial institution round the presentation up.

Oracle OpenWorld Day 2 Highlights

What a difference a good night’s sleep makes to one’s outlook on life !! Slept soundly until dawn for the first time since arriving to the US and boy, do I feel better for it. After a lazy morning, had a late breakfast at my favourite haunt, Louis Diner, for a breakfast that lasts me all day. The [...]

Oracle Closed World 1:30-2:30 Sept 20, 2010 I'll be speaking

I'll be speaking tomorrow at Oracle Closed World 1:30-2:30 at the Thirsty Bear, Sept 21, 2010


Database Performance Made Easy Through Graphics

Average Active Sessions (AAS) Formulas, Interpreting Load Charts and Visual SQL Tuning (VST)

Kyle begins his presentation with a discussion of the use of sample data to create Active Sessions History (ASH). But ASH is dense, multidimensional data, which makes it difficult to analyze. Fortunately, ASH can be simplified using a metric called Average Active Sessions (AAS). AAS shows the load on the database and allows you to drill down with precision and clarity into the cause of each bottleneck.

Most often, bottlenecks are caused by poor-performing SQL statements. For analyzing suboptimal SQL statements, Kyle will show you how to lay out the query graphically in a Visual SQL Tuning (VST) diagram. Through the VST, you’ll learn how to quickly visualize any coding errors in the query, discover flaws in the underlying database schema, and most importantly, find the best execution path through the query.

Oracle Closed World presentation links

Thanks to everybody who attended my OCW hacking session!
Sorry to guys who attended via webinar – I’ll do the session again in a few weeks, with audio from end to end hopefully! And I will get someone to assist me with monitoring the transmission quality and attendee questions etc.
Note that this stuff is mostly for hacking and fun – don’t use the undocumented stuff in production!
The links are below:

Oracle Closed World presentation links

Thanks to everybody who attended my OCW hacking session!
Sorry to guys who attended via webinar – I’ll do the session again in a few weeks, with audio from end to end hopefully! And I will get someone to assist me with monitoring the transmission quality and attendee questions etc.
Note that this stuff is mostly for hacking and fun – don’t use the undocumented stuff in production!
The links are below:

Oracle Closed World presentation links

Thanks to everybody who attended my OCW hacking session!

Sorry to guys who attended via webinar – I’ll do the session again in a few weeks, with audio from end to end hopefully! And I will get someone to assist me with monitoring the transmission quality and attendee questions etc.

Note that this stuff is mostly for hacking and fun – don’t use the undocumented stuff in production!

The links are below:

Download scripts & Tools:

Rlwrap links:

Diagnostic events:

X$TRACE
I haven’t written any articles on X$TRACE yet, but you can find some stuff from one of my very old presentations:

Or just type:

ALTER TRACING ENABLE “10704:4:ALL”

Where 10704 is the KST event number, 4 is the level and ALL means all Oracle PIDs (Oracle PIDs, not OSPID’s).


Share/Bookmark

Oracle Closed World presentation links

Thanks to everybody who attended my OCW hacking session!
Sorry to guys who attended via webinar – I’ll do the session again in a few weeks, with audio from end to end hopefully! And I will get someone to assist me with monitoring the transmission quality and attendee questions etc.
Note that this stuff is mostly for hacking and fun – don’t use the undocumented stuff in production!
The links are below:

Oracle Closed World presentation links

Thanks to everybody who attended my OCW hacking session!
Sorry to guys who attended via webinar – I’ll do the session again in a few weeks, with audio from end to end hopefully! And I will get someone to assist me with monitoring the transmission quality and attendee questions etc.
Note that this stuff is mostly for hacking and fun – don’t use the undocumented stuff in production!
The links are below: