12c Table/Column Enhancements:
- Identity columns (automatic primary key generation)
- VARCHAR2(32767) for LOB's (up from VARCHAR(4000).
Less than 4K is stored inline. More than 4K row lengths are stored out of
line (BFILE)
- Metadata only default of optional columns.
-
Invisible data columns Tips
-
ILM clause tips
12c SQL enhancements
- WITH clause enhancement to allow
function
- Booleans in SQL
-
max_sql_string_size Tips
- Row pattern matching (improved regex?)
-
Hybrid Histograms tips
-
adaptive execution plan tips
- improved optimizer statistics
12c RAC Enhancements
- RAC Transaction guard - evolution of TAF
-
Oracle12c de-support of RAC raw
volumes
-
12c Transaction Guard Tips
12c Storage Management Enhancements
-
Oracle Flex ASM: With this feature, database instances use
remote ASM instances.
- Oracle ASM
Disk Scrubbing: Checks for logical data corruptions and repair
them automatically.
-
alter database move
datafile <number> tips
- Interval-REF partitioning
- simultaneous operations on multiple partitions
- New Cascade option for TRUNCATE and EXCHANGE partition
- Oracle database file system (ODFS)
12c Instance Management:
-
What - if analysis for
server pool management
12c Security enhancements:
-
Enhancements to Policy-based Databases:
Actively utilizes different sized servers
12c Application Enhancements:
-
Application Continuity?
12c Installation & patching enhancements:
-
Oracle installer will run Fix-up scripts &
"root.sh" scripts across nodes. You don't have to run the
scripts manually on RAC nodes.
-
Multi-purpose Installation?
-
Standardized deployment and
patching:
Introducing GHS, rapid home provisioning and
gold images.
-
A new "ghctl" command for better patching
12c Utilities Enhancements:
-
expdp view_as_tables Tips
- Oracle
Utility Cluster
- New BBED commands
- The new 12c data pump will allow to turn off redo for the import
operation only.
-
Real-time ADDM
-
ADDM Report: SQL Commonality Index Tips
-
ASH Analytics
-
Pluggable Database Tips
12c Networking & connectivity
enhancements
-
Dynamic IP Management and name resolution
made easy
- IPv6 Based IP Addresses Support for
client connectivity