The simple example of recursive subquery factoring.

Maybe, recursive subquery factoring was used in few cases only. But in that case, recursive subquery factoring provides very convenient way to handle each node.

For example, there is a diagram like below and we want calculate the ela(psed time) to current node. Without the recursive subquery factoring, we shoud use sys_connect_by_path and user define function.

I finished the installation for oracle RAC 11.2.0.3 using Oracle Virtual Box.

I finished the installation for oracle RAC 11.2.0.3 on Oracle Enterpise Linux 5 using Oracle Virtual Box. Actually, it’s hard work to install RAC. But, with Tomasz’s blog, we can install RAC very easily.

Actually, I’ve never seen such a detailed, kind and perfect installation guide. And, For installation, we need a few RPMs that was shown below.

sysstat-7.0.2-12.el5.x86_64.rpm
unixODBC-2.2.11-10.el5.i386.rpm
unixODBC-devel-2.2.11-10.el5.i386.rpm
unixODBC-libs-2.2.11-10.el5.i386.rpm
libaio-devel-0.3.106-5.i386.rpm
oracleasm-2.6.18-348.el5-2.0.5-1.el5.i686.rpm
oracleasmlib-2.0.4-1.el5.i386.rpm
oracleasm-support-2.1.8-1.el5.i386.rpm