One of new exciting features of Oracle 11g is the Real Application Testing (RAT). The RAT has two solutions – Database Replay and SQL Performance Analyzer (SPA) to address two different issues. Both have the same concept (capture then replay), but are scoped differently. Database Replay applies at database-level workload for all activities (exclusion is …
I just passed the 11g OCP upgrade after many excuses to postpone it. I have to admit I was nervous a little bit because the last Oracle exam I’ve taken was more than one year ago. I was struggling a little bit at first. I tend to read too quickly (= careless). So at the …
One of Oracle 11g’s new features is an ease of capturing the initialization parameter values currently in memory into a file. create pfile from memory; create spfile from memory; create pfile=’/tmp/cur_pfile.ora’ from memory; This comes in handy when you’d like to quickly verify changes especially after executing “alter system set” with scope=memory. It also lets …
I just have time to install Oracle Enterprise Linux (OLE) on VMWare. The first error I encountered after trying to login into the 11g (11.1.0.6) database is this – [oracle@oralnx1 ~]$ sqlplus / as sysdba sqlplus: error while loading shared libraries: /opt/oracle/product/11.1.0/db_1/lib/libnnz11.so: cannot restore segment prot after reloc: Permission denied. Well, I guess this is …
A new extended partition syntax can be used to designate a partition without knowing its name. The syntax must refer to a possible value for the partition. This syntax works for all cases when you have to reference a partition, whether it be range, list, interval, or hash. It supports all operations such as drop, …
Today I installed Oracle 11g (11.1.0.6) on my machine. I did not realize that Oracle APEX is a part of the standard database components. So after the 11g installation, I just follow simple steps (shown later below) for the post-installation. In order to access the APEX application, either the embedded PL/SQL gateway or Oracle HTTP …
