[root@mytest01 ~]# fdisk -l (more...)
|Larry Ellison 1978|
While I admit I'm far removed from the reality of the situation, I find it a little amusing how it's been deemed as a 'shake up' when a few paragraphs before he's quoted as saying this (referring to new co-CEOs)
“I am going to continue to do what I have been doing (more...)
At Oracle OpenWorld 2014, the company will roll out its new Database Cloud Service — a new multi-tenant database-as-a-service offering that will let customers migrate their existing apps and databases to the cloud “with the push of a button,” said Ellison. Data will be compressed ten to one and encrypted for secure and efficient transfer to the cloud, with no reprogramming. “Every single Oracle feature — even our latest high-speed in-memory processing — is included in (more...)
In case you hadn’t noticed it, partitioning has finally reached clusters in 12c – specifically 22.214.171.124. They’re limited to hash clusters with range partitioning, but it may be enough to encourage more people to use the technology. Here’s a simple example of the syntax:
create cluster pt_hash_cluster ( id number(8,0), d_date date, small_vc varchar2(8), padding varchar2(100) ) -- single table hashkeys 10000 hash is id size 700 partition by range (d_date) ( partition (more...)
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...)