Seamless cloning of an application stack is an outstanding goal. Seamless cloning of an application stack including the full production database, application server, and webserver in a few minutes with next to zero disk space used or configuration required is the best goal since Alexander Graham Bell decided he wanted a better way tell Mr. Watson to “come here.”
Happy New Year everyone. I wish you a prosperous 2015!
Time is passing by too fast. I had a dynamic 2014 with a couple of interesting projects. It’s not time to recap now but it is definitely time to refresh my blog.
This month we started to give our Oracle Tuning Workshop. And with a new workshop comes new questions. We advise to give to the optimizer the most accurate statsistics that we can have. That suggests that WORKLOAD statistics are better than NOWORKLOAD ones because they gather the average number of blocks read in multiblock read, rather than using default values.
There has been a lot of activity on https://github.com/oracle lately. Apparently a place to keep…
Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.
Just a quick reminder for those who are devoloping Apex multilingual applications:
Build options' state is propagated to translated applications at the time of seeding, so you need to be careful when changing the state of a build option in the primary language because you may end up
After having zero success finding employment after Delphix ended my employment in December, I wanted to reach out to fellow contacts in the business to offer my consultative services as a database and cloud product architect. I applied online to the usual job portals at Oracle, SAP, EMC and many other companies but alas my resume slid down the Taleo ATS blackhole. The one hiring manager at SAP wanted 20 decades of HANA experience and I told him that HANA has been out less than a few years. Hopefully I find work soon.
Disjunction (logical OR) is known to cause various performance problems, from extreme parse times (e.g. here) to sub-optimal plans. A common solution to such problems is getting rid of OR’s by “OR expansion” (i.e. rewrite via UNION ALL), although it doesn’t work in 100% cases. In this post, I will consider an example of an OR problem that can be solved differently.
Here is the setup: