Search

OakieTags

Who's online

There are currently 0 users and 39 guests online.

Recent comments

Affiliations

Uncategorized

AWR thoughts

It’s been a week since my last posting – so I thought I’d better contribute something to the community before my name gets lost in the mists of time.

I don’t have an article ready for publication, but some extracts from an AWR report appeared on the OTN database forum a few days ago, and I’ve made a few comments on what we’ve been given so far (with a warning that I might not have time to follow up on any further feedback). I tried to write my comments in a way that modelled the way I scanned (or would have scanned) through the reporting – noting things that caught my attention, listing some of the guesses and assumptions I made as I went along.  I hope it gives some indication of a pattern of thinking when dealing with a previously unseen AWR report.

 

 

Number one bottleneck in IT ?

#000000;">“Any improvement not made at the constraint is an illusion.” – Gene Kim paraphrasing “The Theory of Constraints”

What is the constraint in IT?

The constraints in IT are

  1. Provisioning environments for development
  2. Setting up test and QA environments
  3. Architecting development to facilitate easy changes in code
  4. Development speed
  5. Product management  input

Meaning, until the first constraint is eliminated it is pointless and even potentially counter productive to tune the following constraint.

The first constraint for most organizations to tackle is thus the speed and agility with which they can provision environments for development.

It’s about : Data Supply Chain

#222222;">There have been a number of questions coming my way about Delphix versus snapshot technologies. The capabilities of Delphix can be differentiated from snapshot technologies through the following hierarchy:

#222222;">Screen Shot 2014-06-24 at 6.57.54 AM

If I can’t picture it, I can’t understand it

#000000;">
#000000;">“If I can’t picture it, I can’t understand it.” – Albert Einstein

#000000;">
#000000;">Along the same lines

#000000;">“It is impossible to even think without a mental picture.” – Aristotle:

Oracle EM 12c ASH Analytics

#555555;">

#555555;">Was emailing with my esteemed college John Beresniewicz at Oracle in the OEM group. John and I worked together on OEM 10g and thank goodness he is still there as he is generally behind any good quantitative visualizations you might see in the product. Here is one cool example he sent me:#2970a6;" href="http://dboptimizer.com/wp-content/uploads/2011/10/UserIOloadMap_small.png">

Compliance, Reporting & Dodd Frank

What is one of the most daunting issues in IT departments now?  What kind of database issue can end people up in orange jump suits and yet how to avoid clearly avoid issues is unclear. Regulatory compliance.  Regulatory compliance is driving many Fortune 1000 and world wide corporations IT departments over the edge of their abilities. With regulatory compliance, how much data do you have to keep, how long do you have to keep it, how fast do you have to be able to access it and what technology do you use to maintain it?

Fortune 1000 companies in order to meet compliance demands typically  must collect, model and report on data from multiple systems systems, in multiple sites

Oracle EM errors after 11gR2 install

#555555;">Had a machine running the default database from the Oracle 11.2.0.3 installer. This instance was called o1123.
I then created a second database by hand (with #2970a6;" href="https://github.com/khailey/swingbenchsh/blob/master/shell_scripts/crdb.sh">crdb.sh for #2970a6;" href="http://www.dominicgiles.com/swingbench.html">swingbench and #2970a6;" href="http://www.pythian.com/blog/my-slob-io-testing-index/">slob tests) instead of dbca (maybe that was a mistake) and then I wanted to acccess OEM. The second instance was called SOE60G ( a 60GB swingbench dataset database)

#555555;">First tried to start up dbconsole:

Version controlled databases and data

To drive revenue and growth, companies are constantly improving existing applications or creating new ones. This ongoing application development depends upon provisioning environments for developers and QA teams. Once they are up and running in these environments, code development calls for the efficient change management and later deployment of changes.  The slower and more costly provisioning and managing the development environments becomes, the more delays and bugs there will be in the applications, and the less revenue the business will generate.

 

Problem

Code management has become straightforward with the use of source control tools such as Git, SVN, and Perforce. Provisioning development environments has been made more efficient by Chef, Puppet, and Jenkins.

Financial close pressures and performance

How long does your financial close take? How long would you like it to take? How much access do your internal business analysts have to the the financial data?

We’ve worked with a number of companies and taken their financial close down from weeks to a couple of days by using data virtualization and the Delphix appliance.  Using Delphix and data virtualization we’ve also thrown the constraints off of limited access to financial data allowing business analysts 24×7 access even in the days ramping up to quarter ends.

Problems we see

Oracle EM : connect to database broken

#555555;">OEM just seems to have too many brittle esoteric configuration files and process dependencies. Ideally I just want to connect with system/password and go. Is that too simple to ask for?

#555555;">Today I tried out OEM and got the general broken page:

#555555;">#2970a6;" href="http://dboptimizer.com/wp-content/uploads/2011/11/errors_sysman_password.png">

#555555;">And my first reaction was just to give up and move on, but then I noticed the error message sounded some what simple:

#555555;">ORA-28001: the password has expired (DBD ERROR: OCISessionBegin)

#555555;">Hmm, maybe this *is* easily fixable. Well guess again. Luckily someone has well documented the fix