Search

OakieTags

Who's online

There are currently 0 users and 32 guests online.

Recent comments

Affiliations

Uncategorized

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

Oracle’s SQL Tuning pack, part III

#555555;">How does the STA work in 11gR2 with the query from “Oracle’s SQL Tuning Pack – part II″ ?

#555555;">In Part II, the STA in 10g proposed a new profile for the query but that profile actually caused the query to run slower. Quetion is, in 11gR2 does the STA do better?

#555555;">Below I ran the query load, identied the query, submitted to STA and STA spent 30 minutes burning CPU trying to tune the query and finally ended with an error that a better plan could not be found.

Oracle’s SQL Tuning pack, part II

#555555;">

Hadoop as a Cloud

The idea of clouds “meeting" big data or big data "living in" clouds isn’t simply marketing hype. Because big data followed so closely on the trend of cloud computing, both customers and vendors still struggle to understand the differences from their enterprise-centric perspectives. Everyone assumes that Hadoop can work in conventional clouds as easily as […]