Oracle Tidbits – November 2015

“Oracle *daily* TidBits” (#oratidbit) published at https://www.facebook.com/oraclenotes on weekdays in November 2015. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use… Publish Date TidBit 2-Nov #oratidbit … Read more

NoCOUG Journal – November 2015

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: … Read more

MOS Tools for Proactive DBA!

As a DBA, you must be familiar with the various tools provided by My Oracle Support (MOS) for diagnostics and health check. Here are few every DBA must be familiar with, which will help you when everyone else in the organization is jumping on you to resolve a failure or troubleshoot a performance issue. 1513912.2 … Read more

Oracle Tidbits – October 2015 #oratidbit

“Oracle *daily* TidBits” (#oratidbit) published at https://www.facebook.com/oraclenotes on weekdays in October 2015. There were no tidbits during the week of OOW15. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of … Read more

Invisible Columns in Oracle Database 12c

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 … Read more

Critical Background Processes in Oracle Database 12c

There are several background processes running when you start Oracle Database 12c instance. Here is an example from one of the 12.1.0.2 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 … Read more

East Coast Oracle Conference 2015

East Coast Oracle Conference was fun and filled with very good sessions and speakers. I had the opportunity to attend several wonderful sessions and present two sessions. Data Pump: Tricks, Tips and Techniques Getting Started with Oracle Multitenant Administration The presentations are uploaded to East Coast Oracle Conference site and you may download from there. … Read more

Bundle Patch or PSU on Windows

Well, honestly, have forgotten working on Windows platform administering Oracle databases. Recently, installed Oracle Database 12c on Windows and wanted to apply the latest PSU. Could not find the PSU, but found the BP (Bundled Patch) – hoped it the same and included more than a PSU! Had some challenges installing… did not remember to run … Read more