Table of Contents
- Title and Copyright Information
- Preface
-
Part I Basic Database Administration
-
1
Getting Started with Database Administration
- Changes in Oracle AI Database Release 26ai for Oracle AI Database Administrator's Guide
- Types of Oracle AI Database Users
-
Tasks of a Database Administrator
- Task 1: Evaluate the Database Server Hardware
- Task 2: Install the Oracle AI Database Software
- Task 3: Plan the Database
- Task 4: Create and Open the Database
- Task 5: Back Up the Database
- Task 6: Enroll System Users
- Task 7: Implement the Database Design
- Task 8: Back Up the Fully Functional Database
- Task 9: Tune Database Performance
- Task 10: Download and Install Release Updates and Release Update Revisions
- Task 11: Roll Out to Additional Hosts
- SQL Statements
- Identifying Your Oracle AI Database Software Release
- About Database Administrator Security and Privileges
- Database Administrator Authentication
-
Creating and Maintaining a Database Password File
- ORAPWD Syntax and Command Line Argument Descriptions
- Creating a Database Password File with ORAPWD
- Sharing and Disabling the 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
- Removing a Database Password File
- Data Utilities
-
2
Configuring Automatic Restart of an Oracle AI Database
-
About Oracle Restart
- Oracle Restart Overview
- 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
- Preparing to Run SRVCTL
- Obtaining Help for SRVCTL
- Adding Components to the Oracle Restart Configuration
- Removing Components from the Oracle Restart Configuration
- Disabling and Enabling Oracle Restart Management for a Component
- Viewing Component Status
- Viewing the Oracle Restart Configuration for a Component
- Modifying the Oracle Restart Configuration for a Component
- Managing Environment Variables in the Oracle Restart Configuration
- Creating and Deleting Database Services with SRVCTL
- Enabling FAN Events in an Oracle Restart Environment
- Automating the Failover of Connections Between Primary and Standby Databases
- Enabling Clients for Fast Connection Failover
- Starting and Stopping Components Managed by Oracle Restart
- Stopping and Restarting Oracle Restart for Maintenance Operations
-
SRVCTL Command Reference for Oracle Restart
- add
- config
- disable
- downgrade
- enable
- getenv
- modify
- remove
- setenv
- start
- status
- stop
- unsetenv
- update
- upgrade
- CRSCTL Command Reference
-
About Oracle Restart
-
3
Managing Processes
- About Dedicated and Shared Server Processes
- About Database Resident Connection Pooling
- About Proxy Resident Connection Pooling
- Configuring Oracle AI Database for Shared Server
-
Configuring Database Resident Connection Pooling
- Database Resident Connection Pooling Initialization Parameters
- Enabling Database Resident Connection Pooling
- Configuring the Connection Pool for Database Resident Connection Pooling
- Using Multi-Pool Database Resident Connection Pooling
- Data Dictionary Views for Database Resident Connection Pooling
- Determining the States of Connections in the Connection Pool
- About Oracle AI Database Background Processes
- Managing Prespawned Processes
- Managing Processes for Parallel SQL Execution
- Managing Processes for External Procedures
- Terminating Sessions
- Process and Session Data Dictionary Views
-
4
Managing Memory
- About Memory Management
- Memory Architecture Overview
- Using Unified Memory Management
- Using Automatic Memory Management
-
Configuring Memory Manually
- About Manual Memory Management
-
Using Automatic Shared Memory Management
- About Automatic Shared Memory Management
- Components and Granules in the SGA
- Setting Maximum SGA Size
- Setting SGA Target Size
- Enabling Automatic Shared Memory Management
- Setting Minimums for Automatically Sized SGA Components
- Dynamic Modification of SGA_TARGET
- Modifying Parameters for Automatically Sized Components
- Modifying Parameters for Manually Sized Components
-
Using Manual Shared Memory Management
- About Manual Shared Memory Management
- Enabling Manual Shared Memory Management
- Setting the Buffer Cache Initialization Parameters
- Specifying the Shared Pool Size
- Specifying the Large Pool Size
- Specifying the Java Pool Size
- Specifying the Streams Pool Size
- Specifying the Vector Pool Size
- Specifying Miscellaneous SGA Initialization Parameters
- Using Automatic PGA Memory Management
- Using Manual PGA Memory Management
- Configuring MGA Memory
- Using Force Full Database Caching Mode
- Configuring Database Smart Flash Cache
- Improving Query Response Time with the Server Result Cache
- Improving Query Performance with Oracle AI Database In-Memory
- Enabling High Performance Data Streaming with the Memoptimized Rowstore
- Memory Management Reference
- Configuring and Using True Cache
- 5 Managing Users and Securing the Database
-
6
Monitoring the Database
-
Monitoring Errors and Alerts
-
Monitoring Errors, Warnings and Notifications
with Attention Log, Alert Log, and Trace Files
- About Monitoring Errors, Warnings and Notifications with Attention Log, Alert Log, and Trace Files
- Controlling the Size of an Alert Log
- Controlling the Size of an Attention Log
- Controlling the Size of a Debug Log
- Controlling the Size of Trace Files
- Controlling When Oracle AI Database Writes to Trace Files
- Reading the Trace File for Shared Server Sessions
- Monitoring a Database with Server-Generated Alerts
- Monitoring Databases with the Observability Service
-
Monitoring Errors, Warnings and Notifications
with Attention Log, Alert Log, and Trace Files
- Monitoring Performance
- Monitoring Quarantined Objects
- Automatically Monitoring Schema Objects
-
Monitoring Errors and Alerts
-
7
Diagnosing and Resolving Problems
- About the Oracle AI Database Fault Diagnosability Infrastructure
-
About Investigating, Reporting, and Resolving a Problem
- Roadmap — Investigating, Reporting, and Resolving a Problem
- Task 1: View Critical Error Alerts in Cloud Control
- Task 2: View Problem Details
- Task 3: (Optional) Gather Additional Diagnostic Information
- Task 4: (Optional) Create a Service Request
- Task 5: Package and Upload Diagnostic Data to Oracle Support
- Task 6: Track the Service Request and Implement Any Repairs
-
Diagnosing Problems
- Identifying Problems Reactively
- Identifying Problems Proactively with Health Monitor
- Gathering Additional Diagnostic Data
- Creating Test Cases with SQL Test Case Builder
- Reporting Problems
-
Resolving Problems
- About Automatic Error Mitigation
-
Repairing SQL Failures with the SQL Repair Advisor
- About the SQL Repair Advisor
- Running the SQL Repair Advisor Using Cloud Control
- Running the SQL Repair Advisor Using the DBMS_SQLDIAG Package Subprograms
- Viewing, Disabling, or Removing a SQL Patch Using Cloud Control
- Disabling or Removing a SQL Patch Using DBMS_SQLDIAG Package Subprograms
- Exporting and Importing a Patch Using DBMS_SQLDIAG Package Subprograms
- Repairing Data Corruptions with the Data Recovery Advisor
-
Quarantine for Execution Plans for SQL Statements Consuming Excessive System Resources
- About Quarantine for Execution Plans for SQL Statements
- Creating a Quarantine Configuration for an Execution Plan of a SQL Statement
- Specifying Quarantine Thresholds in a Quarantine Configuration
- Enabling and Disabling a Quarantine Configuration
- Viewing the Details of a Quarantine Configuration
- Deleting a Quarantine Configuration
- Viewing the Details of Quarantined Execution Plans of SQL Statements
- Transferring Quarantine Configurations from One Database to Another Database
- Example: Quarantine for an Execution Plan of a SQL Statement Consuming Excessive System Resources
- Viewing Attention Log Information
- Diagnosis and Tracing in a PDB Using Package DBMS_USERDIAG
-
1
Getting Started with Database Administration
-
Part II Oracle AI Database Structure and Storage
- 8 Managing Control Files
-
9
Managing the Redo Log
- What Is the Redo Log?
- Planning the Redo Log
- Creating Redo Log Groups and Members
- Relocating and Renaming Redo Log Members
- Dropping Redo Log Groups and Members
- Forcing Log Switches
- Verifying Blocks in Redo Log Files
- Clearing a Redo Log File
- Reduction of Redo Generation for Direct Path Operations
- Redo Log Data Dictionary Views
-
10
Managing Archived Redo Log Files
- What Is the Archived Redo Log?
- Choosing Between NOARCHIVELOG and ARCHIVELOG Mode
- Controlling Archiving
- 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
-
11
Managing Tablespaces
- Guidelines for Managing Tablespaces
- Creating Tablespaces
- 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
- Creating a Read-Only Tablespace on a WORM Device
- Delaying the Opening of Data Files in Read-Only Tablespaces
- Using Read-Only Tablespaces on Object Storage
- Altering and Maintaining Tablespaces
- Renaming Tablespaces
- Dropping Tablespaces
-
Managing Lost Write Protection with Shadow Tablespaces
- About Shadow Lost Write Protection
- Creating Shadow Tablespaces for Shadow Lost Write Protection
- Enabling Shadow Lost Write Protection for a Database
- Enabling Shadow Lost Write Protection for Tablespaces and Data Files
- Disabling Shadow Lost Write Protection for a Database
- Removing or Suspending Shadow Lost Write Protection
- Dropping a Shadow Tablespace
- Managing 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
- Migrating the SYSTEM Tablespace to a Locally Managed Tablespace
- Viewing Information About Tablespaces
-
12
Managing Data Files and Temp Files
- Guidelines for Managing Data Files
- Creating Data Files and Adding Data Files to a Tablespace
- Changing Data File Size
- Altering Data File Availability
- Renaming and Relocating Data Files
- Dropping Data Files
- Verifying Data Blocks in Data Files
- Copying Files Using the Database Server
- Mapping Files to Physical Devices
- Data Files Data Dictionary Views
-
13
Transporting Data
-
About Transporting Data
- Purpose of Transporting Data
-
Transporting Data: Scenarios
- Scenarios for Full Transportable Export/import
-
Scenarios for Transportable Tablespaces or Transportable Tables
- Scenarios That Apply to Transportable Tablespaces or Transportable Tables
- Transporting and Attaching Partitions for Data Warehousing
- Publishing Structured Data on CDs
- Mounting the Same Tablespace Read-Only on Multiple Databases
- Archiving Historical Data
- Using Transportable Tablespaces to Perform TSPITR
- Copying or Moving Individual Tables
- Transporting Data Across Platforms
- General Limitations on Transporting Data
- Compatibility Considerations for Transporting Data
- Transporting Databases
- Transporting Tablespaces Between Databases
- Transporting Tables, Partitions, or Subpartitions Between Databases
- Converting Data Between Platforms
- Guidelines for Transferring Data Files
-
About Transporting Data
-
14
Managing Undo
- What Is Undo?
- Introduction to Automatic Undo Management
- Setting the Minimum Undo Retention Period
- Sizing a Fixed-Size Undo Tablespace
- Managing Undo Tablespaces
- Migrating to Automatic Undo Management
- Managing Temporary Undo
- Undo Space Data Dictionary Views
-
15
Using Oracle Managed Files
- About Oracle Managed Files
- Enabling the Creation and Use of 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
- Creating Temp Files for Temporary Tablespaces Using Oracle Managed Files
- Creating Control Files Using Oracle Managed Files
- Creating Redo Log Files Using Oracle Managed Files
- Creating Archived Logs Using Oracle Managed Files
- Operation of Oracle Managed Files
- Scenarios for Using Oracle Managed Files
- 16 Using Persistent Memory Database
-
Part III Schema Objects
-
17
Managing Schema Objects
- About Common and Local Objects
- About the Container for Schema Objects
- Creating Multiple Tables and Views in a Single Operation
- Analyzing Tables, Indexes, and Clusters
- Truncating Tables and Clusters
- Enabling and Disabling Triggers
- Managing Integrity Constraints
- Managing Assertions
- Renaming Schema Objects
- Managing Object Dependencies
- Managing Object Name Resolution
- Switching to a Different Schema
- Managing Editions
- Displaying Information About Schema Objects
-
18
Managing Space for Schema Objects
- Managing Tablespace Alerts
- Managing Resumable Space Allocation
-
Reclaiming Unused Space
- About Reclaimable Unused Space
- The Segment Advisor
- Shrinking Database Segments Online
- Deallocating Unused Space
- Dropping Unused Object Storage
- Understanding Space Usage of Data Types
- Displaying Information About Space Usage for Schema Objects
- Capacity Planning for Database Objects
-
19
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
- About Table Compression
- Examples Related to Table Compression
- Compression and Partitioned Tables
- Determining If a Table Is Compressed
- Determining Which Rows Are Compressed
- Changing the Compression Level
- Adding and Dropping Columns in Compressed Tables
- Exporting and Importing Hybrid Columnar Compression Tables
- Restoring a Hybrid Columnar Compression Table
- Notes and Restrictions for Compressed Tables
- Packing Compressed Tables
- 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 Data Use Case Domains
- 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
- Creating Tables
-
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
- 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
-
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
- Terminating Online Table Redefinition and Cleaning Up After Errors
- Online Redefinition of One or More Partitions
- Online Table Redefinition Examples
- 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
- About Creating Index-Organized Tables
- Example: Creating an Index-Organized Table
- Restrictions for Index-Organized Tables
- Creating Index-Organized Tables That Contain Object Types
- Choosing and Monitoring a Threshold Value
- Using the INCLUDING Clause
- Parallelizing Index-Organized Table Creation
- Using Prefix Compression
- 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
- 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
- Using SQL*Loader for External Tables with Partition Values in File Paths
- Managing Hybrid Partitioned Tables
-
Managing Immutable Tables
- About Immutable Tables
- Guidelines for Managing Immutable Tables
- Creating Immutable Tables
- Converting a Regular Table to an Immutable Table
- Altering Immutable Tables
- Adding and Dropping User Columns in Immutable Tables
- Creating Row Versions in Immutable Tables
- Deleting Rows from Immutable Tables
- Dropping Immutable Tables
- Immutable Tables Data Dictionary Views
-
Managing Blockchain Tables
- About Blockchain Tables
- Guidelines for Managing Blockchain Tables
- Creating Blockchain Tables
- Adding and Dropping User Columns in Blockchain Tables
- Creating Row Versions in Blockchain Tables
- Creating User Chains in Blockchain Tables
- Altering Blockchain Tables
- Adding Certificates Used to Sign Blockchain Table Rows
- Adding the Certificate of a Certificate Authority to the Database
- Deleting Certificates in Blockchain Tables
- Adding a User Signature to Blockchain Table Rows
- Allowing a Delegate to Sign Blockchain Table Rows
- Countersigning Blockchain Table Rows
- Validating Data in Blockchain Tables
- Verifying the Integrity of Blockchain Tables
- Deleting Rows from Blockchain Tables
- Dropping Blockchain Tables
- Setting the Table Retention Threshold
- Determining the Data Format for Row Content to Compute Row Hash
- Determining the Data Format to Compute Row Signature
- Displaying the Byte Values of Data in Blockchain Tables
- Creating a Regular Table with Blockchain History Log
- Blockchain Tables Data Dictionary Views
- Tables Data Dictionary Views
-
20
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
- Document the Purpose of Indexes with Schema Annotations
- 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
-
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 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
- Creating a Vector Index
- Altering Indexes
- Monitoring Space Use of Indexes
- Dropping Indexes
- Managing Automatic Indexes
- Indexes Data Dictionary Views
- 21 Managing Clusters
-
22
Managing Hash Clusters
- About Hash Clusters
- When to Use Hash Clusters
- Creating Different Types of Hash Clusters
- Altering Hash Clusters
- Dropping Hash Clusters
- Hash Clusters Data Dictionary Views
-
23
Managing Views, Sequences, and Synonyms
- Managing Views
- Managing Sequences
- Managing Synonyms
- Views, Synonyms, and Sequences Data Dictionary Views
-
24
Managing Data Use Case Domains
- About Data Use Case Domains
-
Guidelines for Managing Domains
- Specify the Type of Domain
- Consider Using Built-in Domains
- Consider Defining Strict Domain Columns
- Define Annotations on Domains
- Consider Multi-column Domains for Composite Values
- Consider Defining Display and Order Expressions
- Consider Using Enum Domains for Small Static Lists
- Consider Using Flex Domains for Values With Different Rules Per Type
- Consider Using JSON Schema Domains for JSON Data
- Creating Domains
- Using Domains
- Altering Domains
- Dropping Domains
- Evolving Domains
- Domains Data Dictionary Views
-
25
Repairing Corrupted Data
- Options for Repairing Data Block Corruption
- About the DBMS_REPAIR Package
- Using the DBMS_REPAIR Package
- DBMS_REPAIR Examples
-
17
Managing Schema Objects
-
Part IV Database Resource Management and Task Scheduling
- 26 Managing Automated Database Maintenance Tasks
-
27
Managing Resources with Oracle AI Database Resource Manager
-
About Oracle Database Resource Manager
- CDB and PDB Resource Management
- Purpose of Resource Management
- Consumer Groups, Plans, and Plan Directives
- User Interface for PDB Resource Management
- Enabling Oracle Database Resource Manager and Switching Plans
- Assigning Sessions to Resource Consumer Groups
-
Managing Resource Plans
-
Managing CDB Resource Plans
- Creating a CDB Resource Plan for Managing PDBs
- Creating a CDB Resource Plan for Managing PDBs: Scenario
- Creating a CDB Resource Plan with PDB Performance Profiles
- Creating a CDB Resource Plan for PDB Performance Profiles: Scenario
- Enabling a CDB Resource Plan
-
Modifying a CDB Resource Plan
- Updating a CDB Resource Plan
- Managing CDB Resource Plan Directives for a PDB
- Managing CDB Resource Plan Directives for a PDB Performance Profile
- Updating the Default Directive for PDBs in a CDB Resource Plan
- Updating the Default Directive for Maintenance Tasks in a CDB Resource Plan
- Deleting a CDB Resource Plan
- Disabling a CDB Resource Plan
- Viewing Information About Plans and Directives in a CDB
- Managing PDB Resource Plans
- Creating a Simple Resource Plan
- Creating an Advanced Resource Plan
-
Managing CDB Resource Plans
- Putting It All Together: Oracle Database Resource Manager Examples
- Managing Multiple Database Instances on a Single Server
- Maintaining Consumer Groups, Plans, and Directives
- Viewing Database Resource Manager Configuration and Status
- Interacting with Operating-System Resource Control
- Oracle Database Resource Manager Reference
- Operating System CPU Resource Management
-
About Oracle Database Resource Manager
-
28
Oracle Scheduler Concepts
- Overview of Oracle Scheduler
- Jobs and Supporting Scheduler Objects
- More About Jobs
- Scheduler Architecture
- Processes to Close a PDB
- Scheduler Support for Oracle Data Guard
-
29
Scheduling Jobs with Oracle Scheduler
- About Scheduler Objects and Their Naming
-
Creating, Running, and Managing Jobs
- Job Tasks and Their Procedures
-
Creating Jobs
- Overview of Creating Jobs
- Specifying Job Actions, Schedules, Programs, and Styles
- Specifying Scheduler Job Credentials
- Specifying Destinations
- Creating Multiple-Destination Jobs
- Setting Job Arguments
- Setting Additional Job Attributes
- Creating Detached Jobs
- Creating Multiple Jobs in a Single Transaction
- Techniques for External Jobs
- Altering Jobs
- Running Jobs
- Stopping Jobs
- Stopping External Jobs
- Stopping a Chain Job
- Dropping Jobs
- Dropping Running Jobs
- Dropping Multiple Jobs
- Disabling Jobs
- Enabling Jobs
- Copying Jobs
- Creating and Managing Programs to Define Jobs
- Creating and Managing Schedules to Define Jobs
-
Using Events to Start Jobs
- About Events
- Starting Jobs with Events Raised by Your Application
- Starting a Job When a File Arrives on a System
-
Creating and Managing Job Chains
- About Creating and Managing Job Chains
- Chain Tasks and Their Procedures
- Creating Chains
- Defining Chain Steps
- Adding Rules to a Chain
- Setting an Evaluation Interval for Chain Rules
- Enabling Chains
- Creating Jobs for Chains
- Dropping Chains
- Running Chains
- Dropping Chain Rules
- Disabling Chains
- Dropping Chain Steps
- Stopping Chains
- Stopping Individual Chain Steps
- Pausing Chains
- Skipping Chain Steps
- Running Part of a Chain
- Monitoring Running Chains
- Handling Stalled Chains
- Using Incompatibility Definitions
- Managing Job Resources
-
Prioritizing Jobs
- Managing Job Priorities with Job Classes
- Setting Relative Job Priorities Within a Job Class
- Managing Job Scheduling and Job Priorities with Windows
- Managing Job Scheduling and Job Priorities with Window Groups
- Allocating Resources Among Jobs Using Resource Manager
- Example of Resource Allocation for Jobs
- Monitoring Jobs
-
30
Administering Oracle Scheduler
- Configuring Oracle Scheduler
- Monitoring and Managing the Scheduler
- Import/Export and the Scheduler
- Troubleshooting the Scheduler
- Examples of Using the Scheduler
- Scheduler Reference
- 31 Managing Transactions
-
Part V Distributed Database Management
-
32
Distributed Database Concepts
- Distributed Database Architecture
-
Database Links
- What Are Database Links?
- What Are Shared Database Links?
- Why Use Database Links?
- Global Database Names in Database Links
- Global Name as a Loopback Database Link
- Names for Database Links
- Types of Database Links
- Users of Database Links
- Creation of Database Links: Examples
- Schema Objects and Database Links
- Database Link Restrictions
- Distributed Database Administration
- Transaction Processing in a Distributed System
- Distributed Database Application Development
- Character Set Support for Distributed Environments
-
33
Managing a Distributed Database
- Managing Global Names in a Distributed System
- Creating Database Links
- Using Shared Database Links
- Managing Database Links
- Viewing Information About Database Links
- Creating Location Transparency
- Managing Statement Transparency
- Managing a Distributed Database: Examples
-
34
Developing Applications for a Distributed Database System
- Managing the Distribution of Application Data
- Controlling Connections Established by Database Links
- Maintaining Referential Integrity in a Distributed System
- Tuning Distributed Queries
- Handling Errors in Remote Procedures
-
35
Distributed Transactions Concepts
- What Are Distributed Transactions?
- Session Trees for Distributed Transactions
- Two-Phase Commit Mechanism
- In-Doubt Transactions
-
Distributed Transaction Processing: Case Study
- About the Distributed Transaction Processing Case Study
- Stage 1: Client Application Issues DML Statements
- Stage 2: Oracle Database Determines Commit Point Site
- Stage 3: Global Coordinator Sends Prepare Response
- Stage 4: Commit Point Site Commits
- Stage 5: Commit Point Site Informs Global Coordinator of Commit
- Stage 6: Global and Local Coordinators Tell All Nodes to Commit
- Stage 7: Global Coordinator and Commit Point Site Complete the Commit
-
36
Managing Distributed Transactions
- Specifying the Commit Point Strength of a Node
- Naming Transactions
- Viewing Information About Distributed Transactions
- Deciding How to Handle In-Doubt Transactions
- Manually Overriding In-Doubt Transactions
- Purging Pending Rows from the Data Dictionary
- Manually Committing an In-Doubt Transaction: Example
- Data Access Failures Due to Locks
- Simulating Distributed Transaction Failure
- Managing Read Consistency
- Enhancing Distributed Transaction Security
-
32
Distributed Database Concepts
-
Part VI Managing Read-Only Materialized Views
-
37
Read-Only Materialized View Concepts
- Replication Databases
- Read-Only Materialized Views
- The Uses of Materialized Views
- Available Materialized Views
- Users and Privileges Related to Materialized Views
- Data Subsetting with Materialized Views
- Materialized View Refresh
- Refresh Groups
- Materialized View Log
- Materialized Views and User-Defined Data Types
- Materialized View Registration at a Master Database
- 38 Read-Only Materialized View Architecture
-
39
Planning for Read-Only Materialized Views
- Considerations for Master Tables
- Planning for Master Databases and Materialized View Databases
-
40
Creating and Managing Read-Only Materialized Views
- Creating Read-Only Materialized Views
- Creating Refresh Groups
- Refreshing Materialized Views
- Determining the Fast Refresh Capabilities of a Materialized View
- Adding a New Materialized View Database
- Monitoring Materialized View Logs
- Monitoring Materialized Views
- 41 Troubleshooting Problems with Read-Only Materialized Views
-
37
Read-Only Materialized View Concepts
- Appendices
- Index