Enquire

Submit your enquiry for Oracle 12c New Feature for DBA

Please enter valid question or comment

Please select a category

No matching category found.

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Pradeep

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Share

course photo

Oracle 12c New Feature for DBA

Online Instructor led Course

Platform: meetingplace

10,000

No Reviews Yet
3 Interested

About the Course


In the Oracle Database 12c: New Features for Administrators course, you’ll learn about the new and enhanced features of Oracle Database 12c. Expert instructors will teach you how these features increase security, manageability and performance.

Topics Covered

Enterprise Manager and Other Tools
Enterprise Manager (EM) Cloud Control home page
Enterprise Manager Express home page versus Enterprise Manager Database Control
SQL Developer with new functionalities
OUI, DBCA

Basics of Multitenant Container Database (CDB)
Benefits of the multitenant architecture
Differences between the root container and pluggable database containers
Structure of the root
Structure of Pluggable Database (PDB)
CDB_xxx and DBA_xxx views
Impacts in Security, Data Guard, Oracle GoldenGate, Oracle Streams, XStream, and Scheduler

Configuring and Creating CDB and PDBs
Tools: DBCA and SQL*Plus
Configuration and creation of CDB
Exploring the Structure (CDB_xxx views and EM)
Tools used: SQL Developer, DBCA and SQL*Plus
Create a new PDB from PDB$SEED
Create a PDB from a non-CDB
Clone a PDB into the same CDB or into another CDB using DB links
Plug in an unplugged PDB

Managing CDB and PDBs
Connect to CDB as administrator
Connect to a PDB using a service name
Start up a CDB
Open / Close a PDB (SQL*Plus, srvctl, EM)
Open / Close all PDBs
Shut down a CDB
Triggers ON PLUGGABLE DATABASE
Change PDB state

Managing Tablespaces, Common and Local Users, Privileges and Roles
Create permanent tablespaces in the root and PDBs
Manage common and local schemas and users in the root and PDBs
Manage system and object privileges to common and local grantees granted "commonly" or "locally"
Manage common and local roles granted "commonly" or "locally"

Managing Backup / Recovery / Flashback and Migration
Backup a whole CDB
Backup a PDB
Recover CDB from redo log files, control files, undo datafiles loss
Recover PDB from PDB datafiles loss
Flashback at CDB level

Online Datafile Move and Automatic Data Optimization
Data classification in 12c : tablespace, group, object, row levels
Configure heat map
Automatic movement and compression
Compression levels and types
Policy declaration: simple declarative SQL extension
Customized automated action execution with user-defined function
Execution in scheduled maintenance windows and by MMON
Customized schedule with DBMS_ILM package

In-Database Archiving
Challenges of old data in tables and 11g solutions
In-database archiving new solutions
Use ROW ARCHIVAL clause to enable row lifecycle state for applications
Set ROW ARCHIVAL VISIBILITY for session level visibility control
Use predicate on ORA_ARCHIVE_STATE column
Temporal Validity versus Temporal History (Transaction Time of FDA)
New clause of CREATE / ALTER TABLE to set a Temporal Validity: PERIOD FOR
New SQL temporal data type

Auditing Enhancements
Review of 11g R2 audit trail implementation
Overview of the Unified Audit Trail
Enabling the Unified Audit Trail
Creating a separate tablespace for the unified audit trail
Granting the AUDIT_ADMIN role to a user for audit trail configuration and management
Configuring the Unified Audit Trail to set a tolerance level for loss of audit records
Creating audit policies

Who should attend

Oracle DBAs

Pre-requisites

Oracle DBA

What you need to bring

N/A

Key Takeaways

N/a
Content
Reviews
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

cash back100% Money Back Guarentee

About the Trainer


14 years of experience in Database Administration. Oracle 11g Certified,Exadata Certified, GoldenGate certified, RAC expert.
Seats Left-

Students Interested 3

Course Id: 18063