The annual two day AUSOUG conference in Perth is well underway, and so far, its been a wonderfully successful event. In particular, we Australians are notorious for not really getting into the networking thing, so conferences often have a lot of ‘awkward silences’ when sessions are not on, and we are meant to be (god forbid) *talking* to each other :-)
But this year has been different. Lots of banter, lots of discussion. Also, the (more...)
This blog post was written by Matt Rudd, Enterprise Support Team Lead at Fishbowl Solutions. Matt has participated in multiple WebCenter 11g upgrades during his time with Fishbowl, and recently developed a solution for an issue he ran into frequently while performing upgrades.
With the release of the ADF Content UI for WebCenter Content, it has become clear that the long-term road map for folder-based storage within WebCenter Content is based on enterprise libraries. The (more...)
I strive to keep the number non-technical posts on this blog to the minimum. However, there are days when a non-technical post has to be written. This is one of such days.
Oracle Corporation, concerned about legal and ethical issues, not only provides to its employees a document entitled Code of Ethics and Business Conduct, but also expects that every employee adheres with the standards that the document sets. For the purpose of (more...)
Its not immediately obvious the significance of this query…but trust me…you’ll love it :-)
SQL> select table_name, column_name from dba_tab_cols
2 where column_name like '%_VC' escape ''
3 and owner = 'SYS'
4 order by 1,2;
I’ll be at #ECO14 today in Raleigh,NC. Catch me in person to get a copy of #CloneAttack. I’ll also be at #DOAG14 in Nuremberg Nov 18-20 running an official #CloneAttack along side of #RacAttack and #RepAttack. Will also be at #BGOUG in Sofia Bulgaria Nov 14-16.
For online #CloneAttack info read on:
We are starting a limited publicly accessible download of a trial version of Delphix and lab.
If interested connect with me on linkedin (more...)
We still have a position open on our Oracle database team here in Tempe, Arizona. Here is the link with an updated job description: url
We have a great team and would love to have a new member to join us.
OOW 2014 was the best so far for me and a whirl wind. After not having a presentation accepted since I left Oracle 10 years ago, I got not only a presentation accepted but 3 presentations accepted. Woohoo! Two of my presentations are available on youtube at
On top of that with the awesome support of the Oaktable, Delphix, Pythian and Enkitec , I was able to secure a (more...)
Saw an interesting post related to work I am doing locking in plans and finding plans that have changed: Carlos Sierra post on queries with changing performance.
Our DBA team uses versions of my sqlstat.sql script to find queries whose elapsed time change and we use a script from Carlos Sierra’s SQLT collection to force the execution plan back to an efficient plan that the optimizer choose in the past. Carlos Sierra’s new (more...)
Scrum: The Art of Doing Twice the Work in Half the Time by Jeff Sutherland
My rating: 5 of 5 stars
An inspiring book from one of the original creators of Scrum. Full of anecdotes about how Scrum saved projects and can be used outside the software industry. Its main purpose is to motivate you to get started using Scrum, but it does contain enough methodology to actually allow you to use the methodology. It (more...)
“Oracle *daily* TidBits” published at https://www.facebook.com/oraclenotes on all weekdays in October 2014. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use… Publish Date TidBit 6-Oct The […]
Sometimes I get excited over simple things. Today, I learned something new, something about human behaviors.
Basically, there are 4 quadrants for human behaviors.
If one does not understand the other person’s behavior, then communication can be very difficult.
To find more about human behaviors, read The DISC Model of Human Behavior – A Quick Overview.
Which quadrant are you in, versus your manager?
The Manage Cloud Control | Agents page was always useful but for quickly identifying EM agent status. Prior to Release 4 this page had static icons indicating problems with specific agents. The page contained no hints about why the agents were in trouble, I’d highlight the broken agent’s row and then push the Unblock icon. There was 50-50 chance that the agent was actually blocked but, as often as not, Resecuring the agent would fix the issue. Haphazard? (more...)
This blog is currently being redirected to the following URL : BLOG.MORENO-CAMPOS.COM Please replace ocpdba.wordpress.com with the above mentioned.Filed under: Uncategorized
Your applications contain 20-30% dead code that is never executed. Not just commented-out code that programmers have left in “just in case”, but routines never called, branches never executed and screens never displayed.
The cost of software maintenance depends on the size of the code base, but systems with dead code are more expensive to maintain. This is because every time a developer comes across a dead piece of code, he becomes unsure: “I wonder (more...)
by Craig Martin
So from my last post Brendan Furey pointed out one minor detail.. that my code was seriously flawed. It only returned the results from one of the criteria found. Picky, picky :) So this is my last effort.. Back up to 12 buffers, but still works when you change the parameters:
select /*+ ordered index_ffs(j job_id_pk) use_nl(jh) use_nl(e) use_nl(e2) use_nl(e3) use_nl(d) use_nl(l) */ distinct l.location_id, l.city
left outer (more...)
My Oracle OpenWorld presentation “Mastering Oracle ADF Bindings: Advanced Techniques” is now available for download from the OpenWorld web site. In this presentation, I talk about
- Reading the Bindings tab
- Bindings in the ADF lifecycle
- Working programmatically with bindings
- Getting the binding from a component
- Working with dynamic bindings
- Creating a binding programmatically
If you are interested in creating bindings programmatically, you should read Eugene Fedorenko’s blog post on this. He also makes (more...)
After we upgraded our OMS environment we realized that our Harvester wasn’t uploading data to MOS anymore. Of course, you say, you just replaced your former ORACLE_HOME with a new home for 126.96.36.199.
1. Download p5567658_120030_Linux-x86-64.zip or the latest OCM installer for your environment. You’ll find a tab for downloading OCM on your front page in MOS. While you are there you should also download the Quick Start guide.
2. Unzip (more...)
I’m super looking forward to next weeks DevOps Enterprise Summit in San Francisco. You might ask “Why?!” since I’m a database guy and not a DevOps guy. I can understand that reaction.
I don’t know about you, but when I hear the term DevOps I have to roll my eyes and think “oh, the latest greatest tech industry buzzword.” So why would I as a DBA care about DevOps? With DevOps, as with (more...)
This article describes how to standardize your JDeveloper Installation as requested in Planning & Getting Started – Team, Skills and Development Environments. It is part of the ADF Architecture Practice lessons and describes the installation with examples for windows.
In this version the Oracle Universal Installer allows the silent installation of JDeveloper. All what you need is the installer file for your platform (e.g. jdev_suite_121300_win64.exe) and a response file. You (more...)