This may not come up very often, but for some reason, an administrator might have to reconfigure an EM12c environment to NOT use load balancers.
This could be due to:1. Hardware Issue on the Load Balancers 2. Mis-configured Load Balancers 3. Re-allocation of Load Balancer hardware for other purposes.
Come along in your wearables best and share your wearables experiences, meet the UX team and friends, see some cool innovation, and find out how to do more with wearables using Oracle technology. You can also your hands on some (more...)
This book took me much longer to write than I initially anticipated - and to be fair, that's the reason for staying quiet at the blog. I just didn't have time/energy to write everywhere :-) Although, it was fun writing - (more...)
A recent question on the OTN database forum raised the topic of returning free space in a tablespace to the operating system by rebuilding objects to fill the gaps near the start of files and leave the empty space at the ends of files so that the files could be resized downwards.
Oracle introduces centos2ol.sh script that can convert CentOS 5 and 6 systems to Oracle Linux. After that run "yum upgrade" again.
[root@test-centos ~]# uname -r
A lot has been written about the transactions, boundaries, threads etc in the Oracle SOA Suite. Clemens has written this piece years ago which explains the basics.I recently had a ‘disagreement’ with the SOA threadpool when I was using a parallel flow in a synchronous BPEL process.
The requirement was to guard the execution time of this BPEL process to a predefined maximum amount of seconds. The environment is as such that tweaking the (more...)
I will be in San Francisco a little early this year and as I’m not longer an ACE Director, it’s to attend the IOUC, (International Oracle User Conference) at Redwood Shores on Sept. 25th and 26th. I’ll be representing RMOUG for the two day event that has representatives from user groups from all over the world. Our lovely host, Mary Lou Dopart and her team, will ensure we have another great (more...)
Yet again the monster that is Oracle Open World is about to take over San Francisco. I won’t be making it this year, but considering we had something like 60,000 attendees last year I’d hate to see what the numbers are gonna be this year!
To try and make it a little easier for you to find all the Private Cloud and Lifecycle Management with EM12c material, here are the ones I know about. If (more...)
In the many years that I work with the Oracle SOA Suite and its Database Adapter, I never really had the pleasure of encountering the setObject errors.
Normally when you screw up the IN parameters in your call to the Database Adapter you’d get those java struct “cannot convert STRING to NUMERIC” errors. However, the following message
BINDING.JCA-11808 Set object error. Error binding the value of parameter P_SOMEINPUT. An error occurred when binding the (more...)
Despite the title, this is actually a technical post about Oracle, disk I/O and Exadata & Oracle In-Memory Database Option performance. Read on :)
If a car dealer tells you that this fancy new car on display goes 10 times (or 100 or 1000) faster than any of your previous ones, then either the salesman is lying or this new car is doing something radically different from all the old ones. You don’t just get orders of magnitude (more...)
I started looking into In-Memory on RAC this week. Data can be distributed across RAC nodes in a couple of different ways. The default is to spread it across the available nodes in the cluster. So if you had a 2 node cluster, roughly 50% of the data in your table or partition would be loaded into the column store in each of the 2 instances.
SYS@dw1> alter table kso.skew inmemory; (more...)
Simple requirement – I’ve got a CLOB (e.g. after exporting an application from Apex from the command line) that I want to examine, and I’m running my script on my local client so I can’t use UTL_FILE to write it to a file. I just want to spit it out to DBMS_OUTPUT.
Strangely enough I couldn’t find a suitable working example on the web for how to do this, so wrote my own version. (more...)
On the Maximum Availability Architecture website, there’s a paper on <awful term alert>Best Practices</awful term alert> for Database Consolidation. It’s a great paper, as you’d expect from the MAA guys (well, apart from that awful term alert I had to add! ). Since database consolidation is an area I work in a lot, I thought I’d start looking at implementing as much of their recommendations as I could in Enterprise Manager, which of course is (more...)
In the (good) old days there was only one optimizer and plans were developed based on the precedence of the rules. For some reason I have always thought there were 11 rules but looking at the manual it tells me there are 15 rules
Nowadays the vast majority of databases will be using the CBO and gathering statistics either by using the overnight maintenance functions or manually gathering as required. I suppose there is always (more...)
Before we start - a couple of disclaimers:
* It is my personal list of favorite resources, so all of the following statements (more...)
This post looks like I am jumping on the bandwagon of IT orchestration like a lot of people are doing. Maybe I should say ‘except for (die hard) Oracle DBA’s’. Or maybe not, it up to you to decide.
Most people who are interested in IT in general will have noticed IT orchestration has gotten attention, especially in the form of Puppet and/or Chef. I _think_ IT orchestration has gotten important with the rise of (more...)