Oracle - 12c Architecture

1
Oracle -12C
2
Oracle-12c

• This course is ideal for Database Administrators
  of small to medium sized businesses. This Oracle
  Database 12c Fundamentals for Developers and
  System Administrators course helps you perform
  basic Oracle Database 12c administration tasks
  needed to keep the database operational.

3
Oracle 12C DBA Topics

• Relational Database Model and Installing Oracle
  database software (12c R1)
• Oracle Database Architecture
• Database storage
• Oracle Networking
• User Administration and Security
• Used Managed (Manual) Backup and Recovery
• RMAN Backup and Recovery
• Oracle database upgrades
• Oracle 12c New Features Multitenant Architecture
• Oracle Data Movement Utilities
• Oracle Database Performance Tuning

4
Oracle-12c Architecture
5
New features of oracle-12c
Pluggable Databases Through Database
Consolidation Oracle is doing every thing to
jump into the cloud bandwagon. With 12C, Oracle
is trying to address the problem of Multitenancy
through this feature. There is a radical change
and a major change in the core database
architecture through the introduction of
Container Databases also called CBD and Pluggable
Databases (PDB).
6

• Redaction Policy
• This is one of the top features in Oracle 12C.
  Data Redaction in simple terms means, masking of
  data. You can setup a Data Redaction policy, for
  example SSN field in a Employee table can be
  masked. This is called redaction.
• Top N Query and Fetch and offset Replacement to
  Rownum
• With the release of Oracle Database 12c, Oracle
  has introduced this new SQL syntax to simplify
  fetching the first few rows. The new sql syntax
  "Fetch First X Rows only" can be used
• Adaptive Query Optimization and Online Stats
  Gathering
• With this feature, it helps the optimizer to
  make runtime adjustments to execution plan which
  leads to better stats. For statements like CTAS
  (Create Table As Select) and IAS (Insert As
  Select), the stats is gathered online so that it
  is available immediately.

7

•  Restore a Table easily through RMAN
• Earlier if you had to restore a particular
  table, you had to do all sorts of things like
  restoring a table space and or do Export and
  Import. The new restore command in RMAN
  simplifies this task.
• Size Limit on Varchar2, NVarchar2, Raw Data Types
  increased
• The previous limit on these data types was 4K.
  In 12C, it has been increased to 32,767 bytes.
  Upto 4K, the data is stored inline. I am sure
  everyone will be happy with this small and cute
  enhancement.

8
Data base storage

• Overview
• Oracle Automatic Storage Management simplifies
  the relationship between database and storage to
  ensure the best I/O performance for database
  workloads while significantly reducing storage
  costs and complexity
• Oracle Partitioning enhances database
  manageability, performance, and availability for
  a wide variety of applications by allowing
  tables, indexes, and index-organized tables to be
  subdivided into smaller pieces and managed
  cost-effectively on different tiers of storage to
  improve access performance

9

• Oracle Advanced Compression helps businesses
  manage data growth more cost-effectively by
  automating data-management processes that
  maximize resource utilization with compression
  rates of 2-4x across all types of data and
  applications to save disk space and improve query
  performance
• Oracle Hybrid Columnar Compression differentiates
  Oracle Exadata Database Machine and Oracle SAN
  and NAS storage systems by reducing the size of
  data warehousing tables by 10x, and archive
  tables by 15x, improving performance and reducing
  storage costs for primary, standby, and backup
  databases

10

• Benefits
• Manage storage more efficiently
• Reduce overall storage costs
• Optimize storage performance
• Protect against data loss

11

• Oracle Virtual Networking
• Oracle Virtual Networking products virtualize
  your SAN and LAN infrastructure by defining
  connectivity in software, giving you the
  flexibility and agility you need for the cloud.
  By consolidating your SPARC and x86 systems into
  a single data center fabric, you can reduce
  infrastructure complexity by up to 70 and cut
  OPEX by up to 50.

12

• Ethernet Networking
• Oracle's Sun Ethernet line of networking
  solutions deliver Ethernet fabric and
  connectivity between Oracle's Sun servers,
  storage, and applications for the convergence and
  high performance required in the virtualized data
  center.

13

• InfiniBand Networking
• Oracle's InfiniBand network solutions deliver
  the application isolation and elasticity you need
  to consolidate and virtualize enterprise business
  applications and cloud computing infrastructures.

14

• Storage Networking
• For enterprise customers looking for superior
  I/O connectivity, Oracle's storage networking
  solutions offer some of the fastest, most
  cost-efficient host bus adapters, switches,
  directors, and routers on the market today.

15

• Backup and Recovery with RMAN
• As noted earlier, using RMAN gives you access to
  several data backup and recovery techniques and
  features not available at all with user-managed
  backup and recovery. The most noteworthy are
• Incremental backups, which provide more compact
  backups (storing only changed blocks) and faster
  data file media recovery (reducing the need to
  apply redo during data file media recovery)
• Block media recovery, in which a data file with
  only a small number of corrupt data blocks can be
  repaired without being taken offline or restored
  from backup

16

• Unused block compression, where RMAN can in some
  cases skip unused datafile blocks during backups
• Binary compression, which uses a compression
  mechanism integrated into the Oracle database
  server to reduce the size of backups
• Encrypted backups, which uses encryption
  capabilities integrated into the Oracle database
  to store backups in an encrypted format

17

• Files That RMAN Can Back Up
• RMAN can back up all database files needed for
  efficient recovery in the event of a failure.
  RMAN supports backing up the following types of
  files
• Data files, and image copies of data files
• Control files, and image copies of control files
• Archived redo logs
• The current server parameter file
• Backup pieces, containing other backups created
  by RMAN

18
Thank u Readers
For More Info Visit www.quontrasolutions.com