Oracle DBA Syllabus:
1. Basic Oracle Database Administration
Type of Oracle database users: The types of users and their roles and responsibilities depend on the database site. Database Administrators, security officers, Network Administrators, Application developers, Application Administrators, Database users.
Tasks of a Database Administrator: Evaluate the Database Server Hardware, Install the Oracle Database Software, Plan the Database, Create and Open the Database, Back Up the Database, Enroll System Users, Implement the Database Design, Back Up the Fully Functional Database, Tune Database Performance.
2. Oracle SQL Statements, Identifying Software Release, Administrator Security and Privileges
The primary means of communicating with Oracle Database,submitting SQL statements,
Submitting Commands and SQL to the Database, Syntax of the SQL*Plus CONNECT Command,
Identifying Oracle Database Software Release: About Oracle Database Release Numbers, Checking Current Release Number, About Database Administrator Security and Privileges, About Administrative User Accounts: SYS, SYSTEM, SYSBACKUP, SYSDG, SYSKM, and SYSRAC. The DBA Role.
3. Oracle Database Administrator Authentication
DBA special operations, shutting down or starting up a database, Administrative Privileges: SYSDBA, SYSOPER, SYSBACKUP, SYSDG, SYSKM, SYSRAC. Operations Authorized by Administrative Privileges, Authentication Methods for Database Administrators: Nonsecure Remote Connections, Local Connections and Secure Remote Connections, Using Password File Authentication: Preparing to Use Password File Authentication, Connecting Using Password File Authentication.
4. Creating and Maintaining a Database Password File Oracle DBA
Creating and Maintaining a Database Password File: Keeping Administrator Passwords Synchronized with the Data Dictionary, Adding Users to a Database Password File, Granting and Revoking Administrative Privileges, Viewing Database Password File Members, Granting and Revoking Administrative Privileges.
5. Creating and Configuring an Oracle Database
Creating a Database with DBCA: Planning for Database Creation, Selecting a Character Set.
Creating a Database with the CREATE DATABASE Statement: Specify an Instance Identifier, Required Environment Variables Are Set, Database Administrator Authentication Method, Create the Initialization Parameter File, Create an Instance, Connect to the Instance, Create a Server Parameter File, Start the Instance, Issue the CREATE DATABASE Statement, Create Additional Table spaces.
6. Specifying Initialization Parameters in Oracle DBA
Sample Initialization Parameter File, Text Initialization Parameter File Format, Determining the Global Database Name, DB_NAME Initialization Parameter, DB_DOMAIN Initialization Parameter, Specifying a Fast Recovery Area, Specifying Control Files, Specifying Database Block Sizes, DB_BLOCK_SIZE Initialization Parameter, Nonstandard Block Size
UNDO_MANAGEMENT Initialization Parameter, UNDO_TABLESPACE Initialization Parameter.
7. Initialization Parameters Using a Server Parameter File in Oracle DBA
Managing Initialization Parameters Using a Server Parameter File: What Is a Server Parameter File, Migrating to a Server Parameter File, Server Parameter File Default Names and Locations, Creating a Server Parameter File. SPFILE Initialization Parameter: Changing Initialization Parameter Values, Setting or Changing Initialization Parameter Values, Clearing Initialization Parameter Values ,Exporting the Server Parameter File, Recovering a Lost or Damaged Server Parameter File, Methods for Viewing Parameter Settings.
8. Managing Application Workloads with Oracle Database Services
A database service is a named representation of one or more database instances. Database Services: About Database Services, Database Services and Performance, Oracle Database Features That Use Database Services. Global Data Services, Database service data Dictionary views.
Considerations After Creating a Database: Database Security, Transparent Data Encryption, A Secure External Password Store.
9. Cloning a Database in Oracle DBA
Cloning a Database with CloneDB in a Non-multitenant Environment: About Cloning a Database with CloneDB, Cloning a Database with CloneDB After Cloning a Database with CloneDB.
Cloning a Database in a Multitenant Environment. Cloning a Database with Oracle Automatic Storage Management (Oracle ASM).
Dropping a Database,
Database Data Dictionary Views. Create database using administration assistant for windows.
10. Starting Up and Shutting Down in Oracle DBA 1
Starting Up a Database: About Database Startup Options, Specifying Initialization Parameters at Startup, Starting Up an Instance: About Starting Up an Instance: Starting an Instance, and Mounting and Opening a Database, Starting an Instance Without Mounting a Database, Starting an Instance and Mounting a Database, Restricting Access to an Instance at Startup, Forcing an Instance to Start, Starting an Instance, Mounting a Database, and Starting Complete Media Recovery, Automatic Database Startup at Operating System Start, Starting Remote Instances.
11. Starting Up and Shutting Down in Oracle DBA 2
Altering Database Availability: Mounting a Database to an Instance,
Opening a Closed Database,
Opening a Database in Read-Only Mode,
Restricting Access to an Open Database.
Shutting Down a Database: About Shutting Down the Database, Shutting Down with the Normal Mode, Shutting Down with the Immediate Mode, Shutting Down with the Transactional Mode, Shutting Down with the Abort Mode, Shutdown Timeout.
12. Quiescing a Database in Oracle DBA
Quiescing a Database: About Quiescing a Database, Placing a Database into a Quiesced State, Restoring the System to Normal Operation, Viewing the Quiesce State of an Instance.
Suspending and Resuming a Database.
Delaying Instance Abort.
13. Configuring Automatic Restart of an Oracle Database.
About Oracle Restart, About Startup Dependencies, About Starting and Stopping Components with Oracle Restart, About Starting and Stopping Oracle Restart, Oracle Restart Configuration, Oracle Restart Integration with Oracle Data Guard, Fast Application Notification with Oracle Restart.
Configuring Oracle Restart: About Configuring Oracle Restart.
14. Managing Processes in Oracle DBA
About Dedicated and Shared Server Processes: Dedicated Server Processes, Shared Server Processes. About Database Resident Connection Pooling: When To Use Database Resident Connection Pooling, Advantages, Comparing DRCP to Dedicated Server and Shared Server .About Proxy Resident Connection Pooling: When to Use Proxy Resident Connection Pooling, Advantages.
15. Shared server process in Oracle DBA 1
Configuring Oracle Database for Shared Server: Initialization Parameters for Shared Server, Memory Management for Shared Server, Enabling Shared Server: About Determining a Value for SHARED_SERVERS, Decreasing the Number of Shared Server Processes, Limiting the Number of Shared Server Processes, Protecting Shared Memory. Disabling Shared Server, Shared Server Data Dictionary Views.
16. Shared server process in Oracle DBA 2
Managing Processes for Parallel SQL Execution: About Parallel Execution Servers, Altering Parallel Execution for a Session, Disabling Parallel SQL Execution, Enabling Parallel SQL Execution, Forcing Parallel SQL Execution.
Managing Processes for External Procedures: About External Procedures, DBA Tasks to Enable External Procedure Calls, Terminating Sessions: About Terminating Sessions, Identifying Which Session to Terminate, Terminating an Active Session, Terminating an Inactive Session, Cancelling a SQL Statement in a Session. Process and Session Data Dictionary Views.
17. Managing Memory in Oracle DBA
About Memory Management, Memory Architecture Overview.
Using Automatic Memory Management: About Automatic Memory Management, Enabling Automatic Memory Management, Monitoring and Tuning Automatic Memory Management.
Configuring Memory Manually: About Manual Memory Management, Using Automatic Shared Memory Management, Using Manual Shared Memory Management, Using Automatic PGA Memory Management, Using Manual PGA Memory Management.
18. Using Force Full Database Caching Mode
About Force Full Database Caching Mode,
Before Enabling Force Full Database Caching Mode, Enabling Force Full Database Caching Mode, Disabling Force Full Database Caching Mode.
Improving Query Performance with Oracle Database In Memory.
Memory Management Data Dictionary Views.
19. ` Managing Users and Securing the Oracle Database
The Importance of Establishing a Security Policy for Your Database, Managing Users and Resources, User Privileges and Roles, Auditing Database Activity, Predefined User Accounts.
Monitoring the Database: Server-Generated Alerts Data Dictionary Views, Performance Monitoring Data Dictionary Views, Viewing ADR Locations with the V$DIAG_INFO View, Viewing Critical Errors with the V$DIAG_CRITICAL_ERROR View, Finding Trace Files
20 Oracle Database Structure and Storage
Managing Control Files: What Is a Control File, Guidelines for Control Files: Provide File Names for the Control Files, Multiplex Control Files on Different Disks, Back Up Control Files, Manage the Size of Control Files.
Creating Control Files: Creating Initial Control Files, Creating Additional Copies, Renaming, and Relocating Control Files, creating New Control Files.
Troubleshooting After Creating Control Files: Checking for Missing or Extra Files, Handling Errors During CREATE CONTROLFILE.
Backing Up Control Files, Recovering a Control File Using a Current Copy, Dropping Control Files, Control Files Data Dictionary Views
21. Managing the Redo Log in Oracle DBA
What is redo log: Redo Threads, Redo Log Contents, Active (Current) and Inactive Redo Log Files, Log Switches and Log Sequence Numbers.
Planning the Redo Log: Multiplexing Redo Log Files, Placing Redo Log Members on Different Disks, Planning the Size of Redo Log Files, Planning the Block Size of Redo Log Files, Choosing the Number of Redo Log Files, Controlling Archive Lag: Setting the ARCHIVE_LAG_TARGET Initialization Parameter, Factors Affecting the Setting of ARCHIVE_LAG_TARGET.
22. Creating Redo Log Groups and Members
Creating Redo Log Groups and Members: Creating Redo Log Groups, Creating Redo Log Members.
Relocating and Renaming Redo Log Members.
Dropping Redo Log Groups and Members: Dropping Log Groups, Dropping Redo Log Members.
Forcing Log Switches.
Verifying Blocks in Redo Log Files.
Clearing a Redo Log File.
Precedence of FORCE LOGGING Settings.
Redo Log Data Dictionary Views.
23. Managing Archived Redo Log Files in Oracle DBA
What Is the Archived Redo Log.
Choosing Between NOARCHIVELOG and ARCHIVELOG Mode: Running a Database in NOARCHIVELOG Mode, Running a Database in ARCHIVELOG Mode.
Controlling Archiving: Setting the Initial Database Archiving Mode, Changing the Database Archiving Mode, Performing Manual Archiving, Adjusting the Number of Archiver Processes.
Specifying Archive Destinations.
About Log Transmission Modes.
Managing Archive Destination Failure.
Controlling Trace Output Generated by the Archivelog Process
Viewing Information About the Archived Redo Log: Archived Redo Log Files Views
24. Managing Table spaces in Oracle DBA
Guidelines for Managing Tablespaces: Use Multiple Tablespaces, Assign Tablespace Quotas to Users.
Creating Tablespaces: About Creating Tablespaces, Locally Managed Tablespaces, Bigfile Tablespaces:create a bigfile tablespace,identifying. Tablespaces with Default Compression Attributes, Encrypted Tablespaces, Temporary Tablespaces, Temporary Tablespace Groups: Multiple Temporary Tablespaces: Using Tablespace Groups, Creating a Tablespace Group, Changing Members of a Tablespace Group, Assigning a Tablespace Group as the Default Temporary Tablespace.
25. Tablespaces in Oracle DBA
Consider Storing Tablespaces in the In-Memory Column Store.
Specifying Nonstandard Block Sizes for Tablespaces.
Controlling the Writing of Redo Records.
Altering Tablespace Availability.
Using Read-Only Tablespaces: About Read-Only Tablespaces, Making a Tablespace Read-Only, Making a Read-Only Tablespace Writable.
Altering and Maintaining Tablespaces: Increasing the Size of a Tablespace, Altering a Locally Managed Tablespace, Altering a Bigfile Tablespace, Altering a Locally Managed Temporary Tablespace, Shrinking a Locally Managed Temporary Tablespace.
Renaming Tablespaces. Dropping Tablespaces.
26. Managing the SYSAUX Tablespace
Managing the SYSAUX Tablespace: Monitoring Occupants of the SYSAUX Tablespace, Moving Occupants Out Of or Into the SYSAUX Tablespace, Controlling the Size of the SYSAUX Tablespace.
Correcting Problems with Locally Managed Tablespaces: Diagnosing and Repairing Locally Managed Tablespace Problems, Scenario 1: Fixing Bitmap When Allocated Blocks are Marked Free (No Overlap), Scenario 2: Dropping a Corrupted Segment, Scenario 3: Fixing Bitmap Where Overlap is Reported, Scenario 4: Correcting Media Corruption of Bitmap Blocks, Scenario 5: Migrating from a Dictionary-Managed to a Locally Managed Tablespace.
27. Migrating the SYSTEM Tablespace in Oracle DBA
Migrating the SYSTEM Tablespace to a Locally Managed Tablespace.
Viewing Information About Tablespaces: Tablespace Data Dictionary Views, Example 1: Listing Tablespaces and Default Storage Parameters, Example 2: Listing the Data Files and Associated Tablespaces of a Database, Example 3: Displaying Statistics for Free Space (Extents) of Each Tablespace.
28. Managing Data Files and Temp Files
Guidelines for Managing Data Files: About Data Files, Determine the Number of Data Files, Determine the Size of Data Files, Place Data Files Appropriately, Store Data Files Separate from Redo Log Files.
Creating Data Files and Adding Data Files to a Tablespace.
Changing Data File Size: Enabling and Disabling Automatic Extension for a Data File, Manually Resizing a Data File.
Altering Data File Availability: About Altering Data File Availability, Bringing Data Files Online or Taking Offline in ARCHIVELOG Mode, Taking Data Files Offline in NOARCHIVELOG Mode, Altering the Availability of All Data Files or Temp Files in a Tablespace.
29. Managing Data File in Oracle DBA
Renaming and Relocating Data Files: ONLINE DATAFILES AND OFFLINE DATAFILE, Renaming Offline Data Files in a Single Tablespace, Relocating Offline Data Files in a Single Tablespace, Renaming and Relocating Offline Data Files in Multiple Tablespaces.
Dropping Data Files.
Verifying Data Blocks in Data Files.
Mapping Files to Physical Devices: Copying Files Using the Database Server: Components of File Mapping, FMON, External Process (FMPUTL), Mapping Libraries, Mapping Structures, Example of Mapping Structures,
Obtaining Information from the File Mapping Views
Data Files Data Dictionary Views.
30. Transporting Data in Oracle DBA
Transporting and Attaching Partitions for Data Warehousing, Transporting Data Across Platforms, General Limitations on Transporting Data, Transporting Tablespaces Between Databases: Pick a Self-Contained Set of Tablespaces, Generate a Transportable Tablespace Set, Transport the Export Dump File, Transport the Tablespace Set, Restore Tablespaces to Read/Write Mode, Import the Tablespace Set.
Transporting Tables, Partitions, or Subpartitions Between Databases: Introduction to Transportable Tables, Limitations on Transportable Tables, Transporting Tables, Partitions, or Subpartitions Using an Export Dump File .,Transporting Tables, Partitions, or Subpartitions Over the Network.
Guidelines for Transferring Data Files.
31. Managing Undo in Oracle DBA
What Is Undo.
Introduction to Automatic Undo Management: Overview of Automatic Undo Management, The Undo Retention Period: About the Undo Retention Period, Automatic Tuning of Undo Retention, Retention Guarantee, Undo Retention Tuning and Alert Thresholds, Tracking the Tuned Undo Retention Period.
Setting the Minimum Undo Retention Period.
Sizing a Fixed-Size Undo Tablespace.
Managing Undo Tablespaces: Creating an Undo Tablespace, Altering an Undo Tablespace, Dropping an Undo Tablespace, Switching Undo Tablespaces, Establishing User Quotas for Undo Space, Managing Space Threshold Alerts for the Undo Tablespace.
Migrating to Automatic Undo Management.
Managing Temporary Undo: About Managing Temporary Undo, Enabling and Disabling Temporary Undo.
Undo Space Data Dictionary Views
32. Using Oracle Managed Files
About Oracle Managed Files: What Is Oracle Managed Files, Who Can Use Oracle Managed Files, What Is a Logical Volume Manager, What Is a File System, Benefits of Using Oracle Managed Files, Oracle Managed Files and Existing Functionality.
Enabling the Creation and Use of Oracle Managed Files: Initialization Parameters That Enable Oracle Managed Files, Setting the DB_CREATE_FILE_DEST Initialization Parameter, Setting the DB_RECOVERY_FILE_DEST Parameter, Setting the DB_CREATE_ONLINE_LOG_DEST_n Initialization Parameters.
33. Creating oracle managed files
Creating Oracle Managed Files: When Oracle Database Creates Oracle Managed Files, How Oracle Managed Files Are Named, Creating Oracle Managed Files at Database Creation:
Specifying Control Files at Database Creation, Specifying Redo Log Files at Database Creation, Specifying the SYSTEM and SYSAUX Tablespace Data Files at Database Creation, Specifying the Undo Tablespace Data File at Database Creation, Specifying the Default Temporary Tablespace Temp File at Database Creation, CREATE DATABASE Statement Using Oracle Managed Files: Examples.
Creating Data Files for Tablespaces Using Oracle Managed Files: About Creating Data Files for Tablespaces Using Oracle Managed Files, CREATE TABLESPACE: Examples, CREATE UNDO TABLESPACE: Example, ALTER TABLESPACE: Example.
34. Creating temp files, control files and redo log files using oracle managed files.
Creating Temp Files for Temporary Table spaces Using Oracle Managed Files: About Creating Temp Files for Temporary Tablespaces Using Oracle Managed Files, CREATE TEMPORARY TABLESPACE: Example, ALTER TABLESPACE... ADD TEMPFILE: Example.
Creating Control Files Using Oracle Managed Files: About Creating Control Files Using Oracle Managed Files, CREATE CONTROLFILE Using NORESETLOGS Keyword: Example, CREATE CONTROLFILE Using RESETLOGS Keyword: Example.
Creating Redo Log Files Using Oracle Managed Files: Using the ALTER DATABASE ADD LOGFILE Statement, Using the ALTER DATABASE OPEN RESETLOGS Statement.
Creating Archived Logs Using Oracle Managed Files.
35. Operation of Oracle Managed Files and Scenarios for Using Oracle Managed Files
Operation of Oracle Managed Files: Dropping Data Files and Temp Files, Dropping Redo Log Files, Renaming Files, Managing Standby Databases.
Scenarios for Using Oracle Managed Files: Scenario 1: Create and Manage a Database with Multiplexed Redo Logs, Scenario 2: Create and Manage a Database with Database and Fast Recovery Areas, Scenario 3: Adding Oracle Managed Files to an Existing Database.
36. Schema Objects in Oracle DBA
Managing Schema Objects: Creating Multiple Tables and Views in a Single Operation, Analyzing Tables, Indexes, and Clusters: About Analyzing Tables, Indexes, and Clusters, Using DBMS_STATS to Collect Table and Index Statistics, Validating Tables, Indexes, Clusters, and Materialized Views, Cross Validation of a Table and an Index with a Query, Listing Chained Rows of Tables and Clusters
: Creating a CHAINED_ROWS Table, Eliminating Migrated or Chained Rows in a Table.
Truncating Tables and Clusters: Using DELETE to Truncate a Table, Using DROP and CREATE to Truncate a Table, Using TRUNCATE.
37. Schema Objects: TRIGGERS AND INTEGRITY CONSTRAINTS in Oracle
Enabling and Disabling Triggers: About Enabling and Disabling Triggers, Enabling Triggers, Disabling Triggers.
Managing Integrity Constraints: Integrity Constraint States: About Integrity Constraint States, About Disabling Constraints, About Enabling Constraints, About the Enable Novalidate Constraint State, Efficient Use of Integrity Constraints: A Procedure.
Setting Integrity Constraints Upon Definition: Disabling Constraints Upon Definition, Enabling Constraints Upon Definition.
38. Schema Objects: managing integrity constraints, renaming schema objects
Modifying, Renaming, or Dropping Existing Integrity Constraints: Disabling and Enabling Constraints, Renaming Constraints, Dropping Constraints.
Deferring Constraint Checks: Set All Constraints Deferred, Check the Commit (Optional).
Reporting Constraint Exceptions, Viewing Constraint Information.
Renaming Schema Objects, Managing Object Dependencies: About Object Dependencies and Object Invalidation, Manually Recompiling Invalid Objects with DDL, Manually Recompiling Invalid Objects with PL/SQL Package Procedures.
39. Schema objects name resolution in Oracle DBA
Managing Object Name Resolution, Switching to a Different Schema, Managing Editions: Querying the Database Default Edition.
Displaying Information About Schema Objects: Using a PL/SQL Package to Display Information About Schema Objects, Schema Objects Data Dictionary Views.
Example 1: Displaying Schema Objects By Type
40. Managing Space for Schema Objects in Oracle DBA
Managing Tablespace Alerts: About Managing Tablespace Alerts, Setting Alert Thresholds ,Viewing Alerts, Limitations.
Managing Resumable Space Allocation: Resumable Space Allocation Overview, Enabling and Disabling Resumable Space Allocation, Using a LOGON Trigger to Set Default Resumable Mode, Detecting Suspended Statements, Operation-Suspended Alert, Resumable Space Allocation Example: Registering an AFTER SUSPEND Trigger.
Reclaiming Unused Space: About Reclaimable Unused Space, The Segment Advisor, Shrinking Database Segments Online, Deallocating Unused Space.
41. Space usage for schema object and capacity planning for database object. Dropping Unused Object Storage.
Understanding Space Usage of Data Types.
Displaying Information About Space Usage for Schema Objects: Using PL/SQL Packages to Display Information About Schema Object Space Usage, Schema Objects Space Usage Data Dictionary Views.
Example 1: Displaying Segment Information
Example 2: Displaying Extent Information
Example 3: Displaying the Free Space (Extents) in a Table space
Capacity Planning for Database Objects: Estimating the Space Use of a Table, Estimating the Space Use of an Index, Obtaining Object Growth Trends.
42. Managing tables in Oracle DBA
Managing Tables: About Tables, Guidelines for Managing Tables: Design Tables Before Creating Them, Specify the Type of Table to Create, Specify the Location of Each Table, Consider Parallelizing Table Creation, Consider Using NOLOGGING When Creating Tables, Consider Using Table Compression, Managing Table Compression Using Enterprise Manager Cloud Control, Consider Using Segment-Level and Row-Level Compression Tiering, Consider Using Attribute-Clustered Tables, Consider Using Zone Maps, Consider Storing Tables in the In-Memory Column Store, Consider Using Invisible Columns, Consider Encrypting Columns That Contain Sensitive Data, Understand Deferred Segment Creation , Materializing Segments, Estimate Table Size and Plan Accordingly, Restrictions to Consider When Creating Tables.
43. Creating and loading tables
Creating Tables: Example: Creating a Table, Creating a Temporary Table: Overview of Temporary Tables, Considerations When Creating Temporary Tables, Creating Global Temporary Tables, Creating Private Temporary Tables. Parallelizing Table Creation.
Loading Tables: Methods for Loading Tables, Improving INSERT Performance with Direct-Path INSERT, Using Conventional Inserts to Load Tables, Avoiding Bulk INSERT Failures with DML Error Logging.
44. Optimizing the performance of bulk updates.
Optimizing the Performance of Bulk Updates, Automatically Collecting Statistics on Tables, Altering Tables: Reasons for Using the ALTER TABLE Statement, Altering Physical Attributes of a Table, Moving a Table to a New Segment or Tablespace, Manually Allocating Storage for a Table, Modifying an Existing Column Definition, Adding Table Columns, Renaming Table Columns, Dropping Table Columns, Placing a Table in Read-Only Mode.
45. Redefining tables online in Oracle DBA
Redefining Tables Online: About Redefining Tables Online, Features of Online Table Redefinition, Privileges Required for the DBMS_REDEFINITION Package, Restrictions for Online Redefinition of Tables, Performing Online Redefinition with the REDEF_TABLE Procedure, Redefining Tables Online with Multiple Procedures in DBMS_REDEFINITION, Results of the Redefinition Process, Performing Intermediate Synchronization, Refreshing Dependent Materialized Views During Online Table Redefinition, Monitoring Online Table Redefinition Progress, Restarting Online Table Redefinition After a Failure, Rolling Back Online Table Redefinition, Aborting Online Table Redefinition and Cleaning Up After Errors, Online Redefinition of One or More Partitions, Online Table Redefinition Examples.
46. Manage Researching and Reversing Erroneous Table Changes
Researching and Reversing Erroneous Table Changes, Recovering Tables Using Oracle Flashback Table, Dropping Tables, Using Flashback Drop and Managing the Recycle Bin, Managing Index-Organized Tables: What Are Index-Organized Tables, Creating Index-Organized Tables, Maintaining Index-Organized Tables, Creating Secondary Indexes on Index-Organized Tables, Analyzing Index-Organized Tables, Using the ORDER BY Clause with Index-Organized Tables, Converting Index-Organized Tables to Regular Tables
47. Managing Partitioned and external Tables
Managing Partitioned Tables, Managing External Tables: About External Tables, Creating External Tables, Altering External Tables Preprocessing External Tables, Overriding Parameters for External Tables in a Query, Using Inline External Tables, Partitioning External Tables, Dropping External Tables, System and Object Privileges for External Tables.
, Managing Hybrid Partitioned Tables, Tables Data Dictionary Views.
48. Managing indexes in Oracle DBA
Managing Indexes: About Indexes, Guidelines for Managing Indexes: Create Indexes After Inserting Table Data, Index the Correct Tables and Columns, Order Index Columns for Performance, Limit the Number of Indexes for Each Table, Drop Indexes That Are No Longer Required, Indexes and Deferred Segment Creation, Estimate Index Size and Set Storage Parameters, Specify the Tablespace for Each Index, Consider Parallelizing Index Creation, Consider Creating Indexes with NOLOGGING, Understand When to Use Unusable or Invisible Indexes, Understand When to Create Multiple Indexes on the Same Set of Columns, Consider Costs and Benefits of Coalescing or Rebuilding Indexes, Consider Cost Before Disabling or Dropping Constraints, Consider Using the In-Memory Column Store to Reduce the Number of Indexes .
49. Creating indexes in Oracle DBA
Creating Indexes: Prerequisites for Creating Indexes, Creating an Index Explicitly, Creating a Unique Index Explicitly, Creating an Index Associated with a Constraint, Creating a Large Index, Creating an Index Online, Creating an Index Online, Creating a Function-Based Index, Creating a Compressed Index, Creating an Unusable Index, Creating an Invisible Index, Creating Multiple Indexes on the Same Set of Columns.
50. Altering Indexes in Oracle DBA
Altering Indexes: About Altering Indexes, Altering Storage Characteristics of an Index, Rebuilding an Existing Index, Making an Index Unusable, Making an Index Invisible or Visible, Renaming an Index, Monitoring Index Usage.
Monitoring Space Use of Indexes, Dropping Indexes,
Managing Auto Indexes: About Automatic Indexing, How Automatic Indexing Works, Configuring Automatic Indexing in an Oracle Database, Generating Automatic Indexing Reports, Views Containing the Automatic Indexing Information
Indexes Data Dictionary Views
51. Managing Clusters in Oracle DBA
Guidelines for Managing Clusters: Choose Appropriate Tables for the Cluster, Choose Appropriate Columns for the Cluster Key, Specify the Space Required by an Average Cluster Key and Its Associated Rows, Specify the Location of Each Cluster and Cluster Index Rows, Estimate Cluster Size and Set Storage Parameters.
Creating Clusters and Objects That Use Them: Creating Clusters, Creating Clustered Tables, Creating Cluster Indexes.
Altering Clusters and Objects That Use Them: Altering Clusters, Altering Clustered Tables, Altering Cluster Indexes.
Dropping Clusters and Objects That Use Them: Dropping Clusters, Dropping Clustered Tables, Dropping Cluster Indexes.
Clusters Data Dictionary Views.
52. Managing Hash Clusters About Hash Clusters.
When to Use Hash Clusters.
Creating Different Types of Hash Clusters: Creating Hash Clusters, Creating a Sorted Hash Cluster, Creating Single-Table Hash Clusters, Controlling Space Use Within a Hash Cluster, Estimating Size Required by Hash Clusters.
Altering Hash Clusters.
Dropping Hash Clusters.
Hash Clusters Data Dictionary Views.
53. Managing Views, Sequences, and Synonyms
Managing Views: About Views, Creating Views and Join Views, Replacing Views, Using Views in Queries, DML Statements and Join Views, Altering Views, Dropping Views.
Managing Sequences: About Sequences, Creating Sequences, Altering Sequences, Using Sequences, Dropping Sequences.
Managing Synonyms: About Synonyms, Creating Synonyms, Using Synonyms in DML Statements, Dropping Synonyms.
Views, Synonyms, and Sequences Data Dictionary Views.
54. Repairing Corrupted Data in Oracle DBA
Options for Repairing Data Block Corruption.
About the DBMS_REPAIR Package: DBMS_REPAIR Procedures, Limitations and Restrictions for DBMS_REPAIR Procedures.
Using the DBMS_REPAIR Package: Task 1: Detect and Report Corruptions, Task 2: Evaluate the Costs and Benefits of Using DBMS_REPAIR, Task 3: Make Objects Usable, Task 4: Repair Corruptions and Rebuild Lost Data.
DBMS_REPAIR Examples: Examples: Building a Repair Table or Orphan Key Table, Example: Detecting Corruption, Example: Fixing Corrupt Blocks, Example: Finding Index Entries Pointing to Corrupt Data Blocks, Example: Skipping Corrupt Blocks.
* Each Session include:
Faculty training, Lab Practice, Lab Exercises and Portal based assignments.
* Sinet Education reserved the right to alter the course contents, offers, price, certificates etc.