MGMTDB: Grid Infrastructure Management Repository
MGMTDB is new database instance which is used for storing Cluster Health Monitor (CHM) data. In 11g this was being stored in berkley database but starting Oracle database 12c it is…
Read Full RecipeTag: 12c
12c: Exporting Database Views as Tables
Starting Oracle Database 12c, you can export view to be imported as a table. There is no need to individually export each table, Data Pump will dump a table with…
Read Full Recipe
12c: Sqlplus Displays Last Login Time For Non – Sys Users
12c database has introduced a pretty nifty Security feature which allows you to check last login time for non-sys user. e.g If I connect to scott user as below, it…
Read Full Recipe
12c:Limiting PGA with pga_aggregate_limit
This is a interesting feature for Oracle DBA's. Till now there has been no way of limiting total PGA being used by oracle instance. _pga_max_size (hidden parameter) could be used to…
Read Full Recipe
12c:Specifying lock timeout for finish_redef_table
Oracle 12c database has introduced enhancement to DBMS_REDEFINITION for specifying a a lock timeout (in seconds) which will allow FINISH_REDEF_TABLE to acquire an exclusive lock for swapping the source and interim tables.If…
Read Full Recipe
Openfiler on Virtualbox and 12c Oracle Flex ASM
Last week Oracle released 12c database and Oracle blogosphere is bustling with lot of people posting details about new versions and setup. I too decided to take plunge and setup…
Read Full Recipe