Subscribe to Posts by Email

Subscriber Count

    696

Disclaimer

All information is offered in good faith and in the hope that it may be of use for educational purpose and for Database community purpose, but is not guaranteed to be correct, up to date or suitable for any particular purpose. db.geeksinsight.com accepts no liability in respect of this information or its use. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content and if notify any such I am happy to remove. Product and company names mentioned in this website may be the trademarks of their respective owners and published here for informational purpose only. This is my personal blog. The views expressed on these pages are mine and learnt from other blogs and bloggers and to enhance and support the DBA community and this web blog does not represent the thoughts, intentions, plans or strategies of my current employer nor the Oracle and its affiliates or any other companies. And this website does not offer or take profit for providing these content and this is purely non-profit and for educational purpose only. If you see any issues with Content and copy write issues, I am happy to remove if you notify me. Contact Geek DBA Team, via geeksinsights@gmail.com

Pages

12C – Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup

Thanks to my Colleague Jaipal to introduce me to this Metalink Note: Doc ID 2005729.1

In a 12c and higher environment, to migrate data between systems that have different endian formats, with the least amount of application down time.

The first step is to copy a full back up from the source to the destination. […]

12c Database : ASM Enhancements : FlexASM – Overview

Flex ASM is a new architecture in Oracle Cluster/Grid Infrastructure where you can reduce the foot print of ASM instances in the cluster. I.e you really do not need 4 ASM instances for 4 Nodes.

In addition to above, Flex ASM also alleviate the problem of RDBMS instance dependency on ASM instance. For instance, if […]

12c Database: New Features List 2

Few more collection of new features with in 12c database in continuation to my earlier post in this category

RMAN Enhancements:-

Recover or copy files from Standby databases Table level restoration i.e object level Incremental recovery more faster, many of the tasks removed

RAC Enhancements:-

TAF is extended to Transactions failover (insert/update/delete)

Dataguard Enhancements:-

Global […]

12c database: New features list

The below is Gathered from various sources and listed out here, thanks to all who shared those in their respective blogs, Optimizer Blog, Tim hall, Ask Tom etc.

Core Architecture Changes:- Container & Pluggable Databases –  New parameter PGA_AGGREGATE_LIMIT, to limit the pga memory utilization New role CDB Administrator has been introduced Multi threaded database […]

12c Database: Threaded executions ?

Oracle may introduce or leverage the multi threading architecture more.

In turns, Oracle may reduce the number of process that it actually use to minimum, One process on behalf of all the other dedicated processes will work and drastically reduces the number of processes.

There will be a new parameter for this could be […]