Sweet! I just installed the software from the CD that came with Sam Alapati’s book related to the OCP 12c upgrade exam and found that it has questions related to the key DBA skills section of the test. Now I feel good about my test preparation materials. The first time I took the test I didn’t have this degree of guidance on what to study, especially on the key DBA skills section.
For many Oracle database patches there is an option to apply them “online”, i.e. without stopping the database and related services (listener, ASM etc.). This is very convenient when downtime is impossible or difficult to arrange. However, this convenience comes at a certain price, including some performance penalties. Such side effects of hot patching are not well understood, even by Oracle support engineers.
There is a MOS note 761111.1 where in addition to (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...)
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:
/*+ BEGIN_OUTLINE_DATA USE_HASH_AGGREGATION(@"SEL$E903463E") (more...)
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 126.96.36.199:
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
Fridays word is ultracrepidarianism: the habit of giving opinions or advice outside ones sphere of knowledge or competence.
Use: today I shall be wading through a sea of ultracrepidarianism, just like yesterday, but today I shall have a collective noun to use. And a few less opinions to give.
Filed under: Uncategorized
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...)
If you’re applying for permanent positions and not getting hired even though you have the skills the organizations asks for, consider whether you are proving your ability to learn new things.
I’m often talking to people who believe their 20 years of experience with technology X or Y should make them shoo-ins for a job. However, they are not getting hired.
The reason is that a modern organization can’t depend on the same skill being (more...)
The #enkitecworlddomination bus has a few new stops on the tour…
Today was a pretty big day at Enkitec – one that probably comes as a shock to many people. In case you haven’t heard, Enkitec has been acquired by Accenture, which still sounds a little weird, to be honest. I’ve pretty much spent my entire career working a small shop (well, everything is small compared to Accenture), and I’m sure that there will be a (more...)