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 (more...)
I was looking into some new features of 12c and I didn’t need to dig deep, in order to figure out how does the “fetch first” feature work:
QL> set autotrace on
SQL> select ename from emp offset 5 rows fetch next 5 rows only;
Plan hash value: 3611411408
| Id | Operation | Name | Rows | Bytes | Cost (more...)
I haven’t even started on Sam Alapati’s OCP book but I realized today that Matthew Morris’s OCP 12c upgrade book has an outline of the Key DBA Skills section of the OCP exam and that is what I need most. I was two questions away on that section when I took the test the first time and I need to make sure I’m studying the right things. After I got back to the (more...)
Another wager lost to my daughter, this time an iPhone 5s.
Thank God she does not want the 6.
Learning the alphabets in school, A is for apple.
Earning straight A’s all the way through 8th grade.
Having dad pay for all the Apple toys – Priceless!
I think I’m done with the script for my Toastmaster’s talk: pdf
It’s Toastmaster’s talk 3 “Get to the Point” so I’m trying to do a 5-7 minute talk that focuses on how Oracle’s SQL optimizer sometimes chooses a slow plan. It’s tough to say anything meaningful in 7 minutes and I’m not using any kind of slides so I have to describe everything verbally.
But, it’s a topic I’m passionate about so I (more...)
I just finished working with a coworker on speeding up a PS/Query. It was running well in a development environment but not in production. I tried to find a simple hint or two to make production run like development but didn’t have any luck. Then I remembered that my script to get a query’s plan prints out a full set of outline hints like this:
Supporting an enterprise software system like Oracle WebCenter is no easy task. Technical complexities, customizations, and multiple versions make it difficult to resolve issues quickly and keep the system up and running. Without a dedicated and knowledgeable support team, WebCenter environments can suffer from system downtime, poor performance, and frustrated users.
Join Fishbowl Solutions for a webinar as they discuss their Oracle WebCenter technical support offerings. These offerings include specific technical services to support WebCenter (more...)
Here’s a quick list of several new EM CLI verbs and a few deprecated verbs in OEM 22.214.171.124:
New verb > modify_monitoring_agent
Deprecated > resyncAgent
Deprecated > get_signoff_status
New verb > grant_bipublisher_roles
New verb > revoke_bipublisher_roles
New verb > add_blackout_reason
New verb > add_chargeback_entity
New verb > assign_charge_plan
New verb > assign_cost_center
New verb > create_charge_entity_type
New verb > create_charge_item
New verb > delete_charge_item
New verb > export_charge_plans
New verb > export_custom_charge_items
I think I’ve run across a bug in 12c where v$sql_cs_statistics is not populated in 12c as it was in 126.96.36.199.
I’ve messed with adaptive cursor sharing using an example on Tim Hall’s web site: web example
I’ve tried to break it and change it in various ways to understand adaptive cursor sharing. I was using some 11g databases and on those systems the example results in output from v$sql_cs_statistics. (more...)
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 […]
Data lakes, like legacy storage arrays, are passive. They only hold data. Hadoop is an active reservoir, not a passive data lake. HDFS is a computational file system that can digest, filter and analyze any data in the reservoir, not just store it. HDFS is the only economically sustainable, computational file system in existence. Some […]
I was recently invited to speak about big data at the Rocky Mountain Oracle User's Group. I presentedto Oracle professionals who are faced with an onslaught of hype and mythology regarding Big Data in generaland Hadoop in particular. Most of the audience was familiar with the difficulty of attempting to engineer even Modest Data on […]
In the 1960s, Bank of America and IBM built one of the first credit card processing systems. Although those early mainframes processed just a fraction of the data compared to that of eBay or Amazon, the engineering was complex for the day. Once credit cards became popular, processing systems had to be built to handle […]
We have a Senior Oracle DBA position open on my team here in Tempe, Arizona.
Here is the link: url This link is for non-recruiters only.
We have a good team and would love to have someone join us.
I guess I should have waited around a bit longer before taking my 12c OCP upgrade exam. I purchased Kaplan’s Self Test software to prepare for the 12c OCP upgrade exam but it only included 50 questions and they only covered the first part of the OCP exam – the part I passed!
I noticed on the Self Test website that the test now includes 105 questions. So, I got the bright idea (more...)
Next up in the ‘hit list’ of topics on the way to specialisation is the Security Specialist. Fusion Security was designed with Role Based Access Control (RBAC) at its heart, allowing separation of duties for Sarbanes Oxley compliance easier to achieve, so that should make it easier to pick up, given my history of PeopleSoft. Let’s dive in …
There are a number of different role types in Fusion. My first impression is (more...)
If you speak german and you are interested in quality assurance for your ADF projects you should come and attend my presentation at DOAG Development on 06/04/2014 in Dusseldorf.
I will show you, how you can implement in the JDeveloper IDE and in Continous Integration server Jenkins:
- static code analysis with PMD, FindBugs and Checkstyle
- Commit tests with JUnit, Mockito and Powermock for Mockito
- Code coverage for commit tests with JaCoCo
- Acceptance tests with JUnit (more...)
Whether you already have or are planning to build an Oracle WebCenter-based intranet, extranet or customer portal, its overall success hinges on its time to market, ability to scale, and the presence of user productivity tools. Attend this webinar to see how Fishbowl’s Portal Solution Accelerator (PSA) can provide an extensible framework that bundles reusable templates and page layouts, standards-based portlets, and in-place security administration. Join us to discover how this framework can be applied (more...)
The majority of Enterprise Manager 12c Cloud Control agent installations are pretty straight forward, just do the usual checks, ensuring firewalls are open etc. and then deploy from the EM console. The Windows installations are not as straight forward these days, as the deployment method uses SSH connectivity which requires the installation and configuration of Cygwin as a