Step by step screenshots showing the installation of Virtual box and configuring pre-built Oracle Database 126.96.36.199 (including in-memory option). A quick way to get started on Oracle Database 12c. This is a very easy setup, though many do not know how easy it is to get started and playing with Oracle Database 12c on Linux […]
Happy New Year! Upgraded 188.8.131.52 Grid Infrastructure to 184.108.40.206 and applied the Oct 2014 PSU. Had an error during rootupgrade.sh as well, due to the ASM spfile being on disk instead of on ASM diskgroup (MOS Note: Upgrading ASM Failed With ORA-32002: cannot create SPFILE – Doc ID 1912581.1). The install & upgrade steps documented […]
The READ privilege is new in Oracle Database 12c 220.127.116.11. Why do we need a READ privilege when there is SELECT privilege? Well, the SELECT privilege includes few more privilege than a pure read-only privilege! With the SELECT privilege, in addition to reading (or “selecting” from) the table, you are also able to do LOCK […]
Changing The Number Of Oracle Database 12c Log Writers
In an Oracle Database 12c instance you will likely see multiple log writer (LGWR) background processes. When you first start the Oracle instance you will likely see a parent and two redo workers. This is a very big deal and something many of us have been waiting for - for many years!
While I'm excited about the change, if I can't control the number of LGWRs (more...)
Off May Not Be Totally Off: Is Oracle In-Memory Database 12c (18.104.22.168.0) Faster?
Most Oracle 12c installations will NOT be using the awesome Oracle Database in-memory features available starting in version 22.214.171.124.0. This experiment is about the performance impact of upgrading to 12c but disabling the in-memory features.
Every experiment I have performed comparing buffer processing rates, clearly shows any version of 12c performs better than 11g. (more...)