D78846GC30 Oracle Database 12c R2 Administration Workshop

Please download to get full document.

View again

of 6
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Information Report
Category:

Documents

Published:

Views: 404 | Pages: 6

Extension: PDF | Download: 12

Share
Related documents
Description
The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide you with a firm foundation in administration of an Oracle Database. In this course you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle Database in an effective and efficient manner. This course covers both Database as a Cloud Service and the on-premises Oracle Database.
Tags
Transcript
  Oracle University |Contact Us: 800-260-690 Oracle Database 12c R2: Administration Workshop Ed 3 Duration: 5 Days What you will learn The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide you with a firm foundation inadministration of an Oracle Database. In this course you will gain a conceptual understanding of Oracle Databasearchitecture and learn how to manage an Oracle Database in an effective and efficient manner. This course covers bothDatabase as a Cloud Service and the on-premises Oracle Database.Learn To:Manage an Oracle Database instance.Configure the Oracle Network environment.Create and manage storage structures.Manage and move data.Create and manage users.Monitor the database and manage performance.Create and manage Database as a Cloud Service database deployments.Benefits To YouYou will benefit from this course as you learn detailed information on the architecture of an Oracle Database instanceand database, enabling you to effectively manage your database resources. You learn how to create database storagestructures appropriate for the business applications supported by your database. In addition you learn how to createusers and administer database security to meet your business requirements. Basic information on backup and recoverytechniques is presented in this course.To provide an acceptable response time to users and manage resources effectively, you learn how to monitor yourdatabase and manage performance. Audience Data Warehouse AdministratorDatabase AdministratorsDatabase DesignersSupport EngineerTechnical Administrator Related Training Copyright © 2013, Oracle. All rights reserved.Page 1  Required Prerequisites  A working knowledge of SQL and PL/SQL packages is very helpful in the course. Suggested Prerequisites  Basic knowledge of Linux operating system Course Objectives Back up, restore, and patch DBCS database deploymentsDescribe the DBaaS and on-premises Oracle Database architecturesManage database instancesManage UNDO dataMove data between databasesImplement basic backup and recovery proceduresMonitor and tune database performanceTune SQL to improve performanceManage resources with Oracle Database Resource ManagerCreate pluggable databases (PDBs)Configure the Oracle network environmentAdminister user security and implement auditingCreate and manage tablespacesManage storage spaceRegister databases and manage performance with Enterprise Manager Cloud ControlCreate and manage Database as a Cloud Service (DBCS) database deployments Course TopicsGetting Started Course Objectives Exploring Oracle Database Architecture Introducing Oracle DatabaseRelation Database Models Copyright © 2013, Oracle. All rights reserved.Page 2  Oracle SQL and PL/SQLOracle Database Server ArchitectureConnecting to Oracle DatabasesOracle Database ToolsOracle-Supplied User AccountsQuerying the Oracle Data Dictionary Managing Database Instances Initialization Parameter FilesStarting Up Oracle DatabasesShutting Down Oracle DatabasesOpening and Closing PDBsWorking with the Automatic Diagnostic Repository (ADR)Querying Dynamic Performance Views Creating PDBs Methods and Tools to Create PDBsCreating PDBs from Seed with SQL*PlusCloning PDBs with SQL*PlusUnplugging and Pluggin In PDBs with SQL*PlusDropping PDBs with SQL*Plus Configuring the Oracle Network Environment Oracle Net ServicesHow Listeners WorkConfiguring Listeners for Dynamic Service RegistrationConfiguring Listeners for Static Service RegistrationConfiguring Local Naming for ConnectionsTesting Oracle Net Connectivity with tnspingConfiguring Communidation Between DatabasesDedicated Versus Shared Server Configurations Administering User Security Creating UsersGranting PrivilegesCreating and Granting RolesRevoking Privileges and RolesCreating and Assigning ProfilesAuthenticating UsersAssigning Quotas to UsersApplying the Principal of Least Privilege Creating and Managing Tablespaces How Table Data is StoredCreating Tablespaces in SQL*PlusAltering and Dropping Tablespaces in SQL*PlusViewing Tablespace Information in SQL*PlusImplementing Oracle Managed FilesMoving and Renaming Online Data Files in SQL*Plus Managing Storage Space Oracle Database Space Management Features Copyright © 2013, Oracle. All rights reserved.Page 3  Block Space ManagementRow Chaining and MigrationFree Space Management Within SegmentsTypes of SegmentsAllocating ExtentsUnderstanding Deferred Segment CreationSpace-Saving Features Managing UNDO Data Undo Data: OverviewTransactions and Undo DataStoring Undo InformationComparing Undo Data and Redo DataManaging UndoLocal Undo Mode Versus Shared Undo ModeConfiguring Undo RetensionCategories of Undo Moving Data Moving Data: General ArchitectureOracle Data Pump: OverviewOracle Data Pump: BenefitsData Pump Export and Import ClientsData Pump Utility: Interfaces and ModesData Pump Import: TransformationsSQL*Loader OverviewLoading Methods Backup and Recovery Concepts DBA ResponsibilitiesCategories of FailureUnderstanding Instance RecoveryUnderstanding Types of BackupsComparing Complete and Incomplete RecoveryOracle Data Protection SolutionsFlashback Technology Monitoring and Tuning Database Performance Managing Performance ActivitiesPerformance Planning ConsiderationsDatabase MaintenanceAutomatic Workload Repository (AWR)Automatic Database Diagnostic MonitorPerformance MonitoringPerformance Tuning MethodologyDatabase Server Statistics and Metrics SQL Tuning SQL Tuning ProcessOracle OptimizerOptimizer StatisticsSQL Plan Directives Copyright © 2013, Oracle. All rights reserved.Page 4
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks