Skip to content
AskDba.org Weblog
  • Home
  • Forums
    • DBA – Wiki
    • Database Administration
    • Real Application Cluster
    • Automatic Storage Management
  • AWS
  • Azure
  • Oracle
    • 10g10g Articles
    • 11gLists 11gR1/R2 articles
    • 12c
  • Performance
  • About Us
Menu Close
  • Home
  • Forums
    • DBA – Wiki
    • Database Administration
    • Real Application Cluster
    • Automatic Storage Management
  • AWS
  • Azure
  • Oracle
    • 10g
    • 11g
    • 12c
  • Performance
  • About Us

12c

Home » 12c

MGMTDB: Grid Infrastructure Management Repository

  • Post author:Amit Bansal
  • Post published:23 July, 2013
  • Post category:12c
  • Post comments:3 Comments

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…

Continue ReadingMGMTDB: Grid Infrastructure Management Repository
Read more about the article 12c: Exporting Database Views as Tables

12c: Exporting Database Views as Tables

  • Post author:Amit Bansal
  • Post published:22 July, 2013
  • Post category:12c
  • Post comments:1 Comment

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…

Continue Reading12c: Exporting Database Views as Tables
Read more about the article 12c: Sqlplus Displays Last Login Time For Non – Sys Users

12c: Sqlplus Displays Last Login Time For Non – Sys Users

  • Post author:Amit Bansal
  • Post published:22 July, 2013
  • Post category:12c
  • Post comments:1 Comment

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…

Continue Reading12c: Sqlplus Displays Last Login Time For Non – Sys Users
Read more about the article 12c:Limiting PGA with pga_aggregate_limit

12c:Limiting PGA with pga_aggregate_limit

  • Post author:Amit Bansal
  • Post published:7 July, 2013
  • Post category:12c
  • Post comments:1 Comment

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…

Continue Reading12c:Limiting PGA with pga_aggregate_limit

12c:Specifying lock timeout for finish_redef_table

  • Post author:Amit Bansal
  • Post published:3 July, 2013
  • Post category:12c
  • Post comments:0 Comments

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…

Continue Reading12c:Specifying lock timeout for finish_redef_table

Openfiler on Virtualbox and 12c Oracle Flex ASM

  • Post author:Amit Bansal
  • Post published:2 July, 2013
  • Post category:12c
  • Post comments:0 Comments

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…

Continue ReadingOpenfiler on Virtualbox and 12c Oracle Flex ASM
Copyright - OceanWP Theme by OceanWP