Oracle started releasing OVJM component of DB PSU in October 2014, and recommend applying OVJM PSU along with (or after) DB PSU. I will demo applying DB PSU, and OVJM PSU on 220.127.116.11 database. Use this opportunity to introduce you to Queryable Patch Inventory (DBMS_QOPATCH), where you can query OPatch information directly from the database. […]
Another edition of NoCOUG journal came out. In this issue, for the Many Things Oracle column, I introduce the new background processes in DB 12c and few SQL Developer tidbits… Read here… This is fifth installment of Many Things Oracle column in NoCOUG journal. The past articles are: NoCOUG Journal 2015 AUG: Trace File Analyzer [Magazine] NoCOUG Journal 2015 MAY: […]
In May 2014, the following #oratidbit relating to invisible columns were tweeted. In #DB12c, you can make a column in table as INVISIBLE. When you make it invisible, the COL# column in COL$ dictionary is updated to 0, thus is not included in the “SELECT *” or “INSERT INTO VALUES”, unless specifically selected. When you […]
There are several background processes running when you start Oracle Database 12c instance. Here is an example from one of the 18.104.22.168 instances. ora_acms_bt9prod1 ora_lreg_bt9prod1 ora_p00w_bt9prod1 ora_aqpc_bt9prod1 ora_m000_bt9prod1 ora_p00x_bt9prod1 ora_asmb_bt9prod1 ora_mark_bt9prod1 ora_p00y_bt9prod1 ora_cjq0_bt9prod1 ora_mman_bt9prod1 ora_p00z_bt9prod1 ora_ckpt_bt9prod1 ora_mmnl_bt9prod1 ora_ping_bt9prod1 ora_dbrm_bt9prod1 ora_mmon_bt9prod1 ora_pmon_bt9prod1 ora_dbw0_bt9prod1 ora_o000_bt9prod1 ora_ppa6_bt9prod1 ora_dbw1_bt9prod1 ora_p000_bt9prod1 ora_ppa7_bt9prod1 ora_dbw2_bt9prod1 ora_p001_bt9prod1 ora_psp0_bt9prod1 ora_dbw3_bt9prod1 ora_p002_bt9prod1 ora_pxmn_bt9prod1 ora_dbw4_bt9prod1 […]
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 (22.214.171.124.0) Faster?
Most Oracle 12c installations will NOT be using the awesome Oracle Database in-memory features available starting in version 126.96.36.199.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...)