Edit D:\rfid\database\database\doc\server.112\e10897\target.db
<?xml version="1.0" encoding="UTF-8"?> <div element="book" href="toc.htm" number="" targetptr=""> <ttl>Oracle® Database 2 Day DBA</ttl> <xreftext><cite>Oracle® Database 2 Day DBA</cite></xreftext> <div element="preface" href="preface.htm" number="" targetptr="ADMQS12116"> <ttl>Preface</ttl> <xreftext>“Preface”</xreftext> <div element="prefsect1" href="preface.htm" number="" targetptr="ADMQS12117"> <ttl>Audience</ttl> <xreftext>“Audience”</xreftext> </div> <div element="prefsect1" href="preface.htm" number="" targetptr="ADMQS12322"> <ttl>Documentation Accessibility</ttl> <xreftext>“Documentation Accessibility”</xreftext> <obj element="formalpara" href="preface.htm" number="" targetptr="ADMQS12323"> <ttl>Accessibility of Code Examples in Documentation</ttl> <xreftext>“Accessibility of Code Examples in Documentation”</xreftext> </obj> <obj element="formalpara" href="preface.htm" number="" targetptr="ADMQS12324"> <ttl>Accessibility of Links to External Web Sites in Documentation</ttl> <xreftext>“Accessibility of Links to External Web Sites in Documentation”</xreftext> </obj> <obj element="formalpara" href="preface.htm" number="" targetptr=""> <ttl>Access to Oracle Support for Hearing-Impaired Customers</ttl> <xreftext>“Access to Oracle Support for Hearing-Impaired Customers”</xreftext> </obj> </div> <div element="prefsect1" href="preface.htm" number="" targetptr="ADMQS12122"> <ttl>Related Documentation</ttl> <xreftext>“Related Documentation”</xreftext> </div> <div element="prefsect1" href="preface.htm" number="" targetptr="ADMQS12123"> <ttl>Conventions</ttl> <xreftext>“Conventions”</xreftext> </div> </div> <div element="chapter" href="intro.htm" number="1" targetptr="ADMQS001"> <ttl>Introduction</ttl> <xreftext>“Introduction”</xreftext> <div element="sect1" href="intro.htm" number="1.1" targetptr="ADMQS011"> <ttl>About This Guide</ttl> <xreftext>“About This Guide”</xreftext> <div element="sect2" href="intro.htm" number="1.1.1" targetptr="ADMQS0111"> <ttl>What This Guide Is Not</ttl> <xreftext>“What This Guide Is Not”</xreftext> </div> <div element="sect2" href="intro.htm" number="1.1.2" targetptr="ADMQS0112"> <ttl>How to Use This Guide with Related Material</ttl> <xreftext>“How to Use This Guide with Related Material”</xreftext> </div> </div> <div element="sect1" href="intro.htm" number="1.2" targetptr="ADMQS012"> <ttl>About Oracle Database</ttl> <xreftext>“About Oracle Database”</xreftext> </div> <div element="sect1" href="intro.htm" number="1.3" targetptr="ADMQS12032"> <ttl>Common Oracle DBA Tasks</ttl> <xreftext>“Common Oracle DBA Tasks”</xreftext> </div> <div element="sect1" href="intro.htm" number="1.4" targetptr="ADMQS013"> <ttl>Tools for Administering the Database</ttl> <xreftext>“Tools for Administering the Database”</xreftext> </div> </div> <div element="chapter" href="install.htm" number="2" targetptr="ADMQS002"> <ttl>Installing Oracle Database and Creating a Database</ttl> <xreftext>“Installing Oracle Database and Creating a Database”</xreftext> <div element="sect1" href="install.htm" number="2.1" targetptr="ADMQS021"> <ttl>Overview of Installing Oracle Database Software and Creating a Database</ttl> <xreftext>“Overview of Installing Oracle Database Software and Creating a Database”</xreftext> <div element="sect2" href="install.htm" number="2.1.1" targetptr="ADMQS0211"> <ttl>Checking Prerequisites</ttl> <xreftext>“Checking Prerequisites”</xreftext> </div> <div element="sect2" href="install.htm" number="2.1.2" targetptr="ADMQS0212"> <ttl>Deciding on Installation Choices</ttl> <xreftext>“Deciding on Installation Choices”</xreftext> <div element="sect3" href="install.htm" number="2.1.2.1" targetptr="CHDICDHE"> <ttl>Install Options</ttl> <xreftext>“Install Options”</xreftext> </div> <div element="sect3" href="install.htm" number="2.1.2.2" targetptr="CHDHAFJB"> <ttl>Installation Method</ttl> <xreftext>“Installation Method”</xreftext> </div> <div element="sect3" href="install.htm" number="2.1.2.3" targetptr="ADMQS02121"> <ttl>Installation Type</ttl> <xreftext>“Installation Type”</xreftext> </div> <div element="sect3" href="install.htm" number="2.1.2.4" targetptr="CHDIDDBB"> <ttl>Software Installation Directories</ttl> <xreftext>“Software Installation Directories”</xreftext> </div> <div element="sect3" href="install.htm" number="2.1.2.5" targetptr="CHDHAFHH"> <ttl>Database File Location</ttl> <xreftext>“Database File Location”</xreftext> </div> <div element="sect3" href="install.htm" number="2.1.2.6" targetptr="CHDCFBDE"> <ttl>Database Identifiers</ttl> <xreftext>“Database Identifiers”</xreftext> </div> <div element="sect3" href="install.htm" number="2.1.2.7" targetptr="ADMQS02122"> <ttl>About Advanced Installation</ttl> <xreftext>“About Advanced Installation”</xreftext> </div> </div> </div> <div element="sect1" href="install.htm" number="2.2" targetptr="ADMQS022"> <ttl>Installing Oracle Database Software</ttl> <xreftext>“Installing Oracle Database Software”</xreftext> <obj element="bridgehead" href="install.htm" number="" targetptr="ADMQS12124"> <ttl>To perform a basic installation:</ttl> <xreftext>“To perform a basic installation:”</xreftext> </obj> </div> <div element="sect1" href="install.htm" number="2.3" targetptr="ADMQS023"> <ttl>Creating and Managing a Database with DBCA</ttl> <xreftext>“Creating and Managing a Database with DBCA”</xreftext> <div element="sect2" href="install.htm" number="2.3.1" targetptr="ADMQS0231"> <ttl>Starting DBCA</ttl> <xreftext>“Starting DBCA”</xreftext> <obj element="bridgehead" href="install.htm" number="" targetptr="ADMQS12125"> <ttl>To start DBCA:</ttl> <xreftext>“To start DBCA:”</xreftext> </obj> </div> <div element="sect2" href="install.htm" number="2.3.2" targetptr="ADMQS0232"> <ttl>Creating a Database Using DBCA</ttl> <xreftext>“Creating a Database Using DBCA”</xreftext> <obj element="bridgehead" href="install.htm" number="" targetptr="ADMQS12126"> <ttl>To create a database using DBCA:</ttl> <xreftext>“To create a database using DBCA:”</xreftext> </obj> <div element="sect3" href="install.htm" number="2.3.2.1" targetptr="ADMQS02321"> <ttl>Step 2 - Database Templates</ttl> <xreftext>“Step 2 - Database Templates”</xreftext> </div> <div element="sect3" href="install.htm" number="2.3.2.2" targetptr="ADMQS02322"> <ttl>Step 3 - Database Identification</ttl> <xreftext>“Step 3 - Database Identification”</xreftext> </div> <div element="sect3" href="install.htm" number="2.3.2.3" targetptr="ADMQS02323"> <ttl>Step 4 - Management Options</ttl> <xreftext>“Step 4 - Management Options”</xreftext> </div> <div element="sect3" href="install.htm" number="2.3.2.4" targetptr="ADMQS02324"> <ttl>Step 5 - Database Credentials</ttl> <xreftext>“Step 5 - Database Credentials”</xreftext> </div> <div element="sect3" href="install.htm" number="2.3.2.5" targetptr="ADMQS02326"> <ttl>Step 6 - Database File Locations</ttl> <xreftext>“Step 6 - Database File Locations”</xreftext> </div> <div element="sect3" href="install.htm" number="2.3.2.6" targetptr="ADMQS02327"> <ttl>Step 7 - Recovery Configuration</ttl> <xreftext>“Step 7 - Recovery Configuration”</xreftext> </div> <div element="sect3" href="install.htm" number="2.3.2.7" targetptr="ADMQS02328"> <ttl>Step 8 - Database Content</ttl> <xreftext>“Step 8 - Database Content”</xreftext> </div> <div element="sect3" href="install.htm" number="2.3.2.8" targetptr="ADMQS02329"> <ttl>Step 9 - Initialization Parameters</ttl> <xreftext>“Step 9 - Initialization Parameters”</xreftext> <div element="sect4" href="install.htm" number="2.3.2.8.1" targetptr="ADMQS02332"> <ttl>Memory</ttl> <xreftext>“Memory”</xreftext> </div> <div element="sect4" href="install.htm" number="2.3.2.8.2" targetptr="ADMQS02333"> <ttl>Sizing</ttl> <xreftext>“Sizing”</xreftext> </div> <div element="sect4" href="install.htm" number="2.3.2.8.3" targetptr="ADMQS02334"> <ttl>Character Sets</ttl> <xreftext>“Character Sets”</xreftext> </div> <div element="sect4" href="install.htm" number="2.3.2.8.4" targetptr="ADMQS02335"> <ttl>Connection Mode</ttl> <xreftext>“Connection Mode”</xreftext> </div> </div> <div element="sect3" href="install.htm" number="2.3.2.9" targetptr="ADMQS02336"> <ttl>Step 10 - Database Storage</ttl> <xreftext>“Step 10 - Database Storage”</xreftext> </div> <div element="sect3" href="install.htm" number="2.3.2.10" targetptr="ADMQS02337"> <ttl>Step 11 - Creation Options</ttl> <xreftext>“Step 11 - Creation Options”</xreftext> </div> </div> <div element="sect2" href="install.htm" number="2.3.3" targetptr="ADMQS0233"> <ttl>Changing the Configuration of a Database Using DBCA</ttl> <xreftext>“Changing the Configuration of a Database Using DBCA”</xreftext> <obj element="bridgehead" href="install.htm" number="" targetptr="ADMQS12127"> <ttl>To change the configuration of a database using DBCA:</ttl> <xreftext>“To change the configuration of a database using DBCA:”</xreftext> </obj> </div> <div element="sect2" href="install.htm" number="2.3.4" targetptr="ADMQS0234"> <ttl>Deleting a Database Using DBCA</ttl> <xreftext>“Deleting a Database Using DBCA”</xreftext> <obj element="bridgehead" href="install.htm" number="" targetptr="ADMQS12128"> <ttl>To delete a database using DBCA:</ttl> <xreftext>“To delete a database using DBCA:”</xreftext> </obj> </div> <div element="sect2" href="install.htm" number="2.3.5" targetptr="ADMQS0235"> <ttl>Managing Templates with DBCA</ttl> <xreftext>“Managing Templates with DBCA”</xreftext> <div element="sect3" href="install.htm" number="2.3.5.1" targetptr="ADMQS02351"> <ttl>Advantages of Using Templates</ttl> <xreftext>“Advantages of Using Templates”</xreftext> </div> <div element="sect3" href="install.htm" number="2.3.5.2" targetptr="ADMQS02352"> <ttl>Types of Templates</ttl> <xreftext>“Types of Templates”</xreftext> <obj element="table" href="install.htm" number="2-1" targetptr="ADMQS12327"> <ttl>DBCA Template Types</ttl> <xreftext>“DBCA Template Types”</xreftext> </obj> </div> <div element="sect3" href="install.htm" number="2.3.5.3" targetptr="ADMQS02353"> <ttl>DBCA Templates Provided by Oracle</ttl> <xreftext>“DBCA Templates Provided by Oracle”</xreftext> <obj element="table" href="install.htm" number="2-2" targetptr="ADMQS12328"> <ttl>Oracle-Provided DBCA Templates and Their Corresponding Workloads</ttl> <xreftext>“Oracle-Provided DBCA Templates and Their Corresponding Workloads”</xreftext> </obj> </div> <div element="sect3" href="install.htm" number="2.3.5.4" targetptr="ADMQS02354"> <ttl>Creating Templates Using DBCA</ttl> <xreftext>“Creating Templates Using DBCA”</xreftext> <obj element="bridgehead" href="install.htm" number="" targetptr="ADMQS12129"> <ttl>To create templates:</ttl> <xreftext>“To create templates:”</xreftext> </obj> </div> <div element="sect3" href="install.htm" number="2.3.5.5" targetptr="ADMQS02355"> <ttl>Deleting Templates</ttl> <xreftext>“Deleting Templates”</xreftext> <obj element="bridgehead" href="install.htm" number="" targetptr="ADMQS12130"> <ttl>To delete a template:</ttl> <xreftext>“To delete a template:”</xreftext> </obj> </div> </div> </div> <div element="sect1" href="install.htm" number="2.4" targetptr="ADMQS025"> <ttl>Installation: Oracle By Example Series</ttl> <xreftext>“Installation: Oracle By Example Series”</xreftext> </div> </div> <div element="chapter" href="em_manage.htm" number="3" targetptr="ADMQS003"> <ttl>Getting Started with Database Administration</ttl> <xreftext>“Getting Started with Database Administration”</xreftext> <div element="sect1" href="em_manage.htm" number="3.1" targetptr="ADMQS037"> <ttl>Managing Your Database: A Roadmap</ttl> <xreftext>“Managing Your Database: A Roadmap”</xreftext> <obj element="bridgehead" href="em_manage.htm" number="" targetptr="ADMQS12132"> <ttl>To manage your Oracle database:</ttl> <xreftext>“To manage your Oracle database:”</xreftext> </obj> </div> <div element="sect1" href="em_manage.htm" number="3.2" targetptr="ADMQS031"> <ttl>Introduction to Oracle Enterprise Manager Database Control</ttl> <xreftext>“Introduction to Oracle Enterprise Manager Database Control”</xreftext> <obj element="bridgehead" href="em_manage.htm" number="" targetptr="ADMQS12308"> <ttl>Database Home Page</ttl> <xreftext>“Database Home Page”</xreftext> </obj> <obj element="bridgehead" href="em_manage.htm" number="" targetptr="ADMQS12309"> <ttl>Online Help</ttl> <xreftext>“Online Help”</xreftext> </obj> <obj element="bridgehead" href="em_manage.htm" number="" targetptr="ADMQS12310"> <ttl>Navigation</ttl> <xreftext>“Navigation”</xreftext> </obj> </div> <div element="sect1" href="em_manage.htm" number="3.3" targetptr="ADMQS12369"> <ttl>Configuring the Operating System Environment Variables</ttl> <xreftext>“Configuring the Operating System Environment Variables”</xreftext> <obj element="bridgehead" href="em_manage.htm" number="" targetptr="ADMQS12370"> <ttl>To configure operating system environment variables for your database instance on Linux and UNIX systems:</ttl> <xreftext>“To configure operating system environment variables for your database instance on Linux and UNIX systems:”</xreftext> </obj> <obj element="bridgehead" href="em_manage.htm" number="" targetptr="ADMQS12371"> <ttl>To configure operating system environment variables for your database instance on Windows systems:</ttl> <xreftext>“To configure operating system environment variables for your database instance on Windows systems:”</xreftext> </obj> </div> <div element="sect1" href="em_manage.htm" number="3.4" targetptr="ADMQS032"> <ttl>Starting and Stopping the Database Control Console Process</ttl> <xreftext>“Starting and Stopping the Database Control Console Process”</xreftext> <obj element="bridgehead" href="em_manage.htm" number="" targetptr="ADMQS12133"> <ttl>To start or stop, or to view the status of the dbconsole process from the command line:</ttl> <xreftext>“To start or stop, or to view the status of the dbconsole process from the command line:”</xreftext> </obj> <obj element="bridgehead" href="em_manage.htm" number="" targetptr="ADMQS12134"> <ttl>To start or stop dbconsole as a service on Microsoft Windows:</ttl> <xreftext>“To start or stop dbconsole as a service on Microsoft Windows:”</xreftext> </obj> </div> <div element="sect1" href="em_manage.htm" number="3.5" targetptr="ADMQS033"> <ttl>Accessing the Database Home Page</ttl> <xreftext>“Accessing the Database Home Page”</xreftext> <obj element="bridgehead" href="em_manage.htm" number="" targetptr="ADMQS12135"> <ttl>To access the Database Home page:</ttl> <xreftext>“To access the Database Home page:”</xreftext> </obj> </div> <div element="sect1" href="em_manage.htm" number="3.6" targetptr="ADMQS12090"> <ttl>Granting Access to Database Control for Nonadministrative Users</ttl> <xreftext>“Granting Access to Database Control for Nonadministrative Users”</xreftext> </div> <div element="sect1" href="em_manage.htm" number="3.7" targetptr="ADMQS034"> <ttl>Creating Database Control Administrative Users</ttl> <xreftext>“Creating Database Control Administrative Users”</xreftext> <obj element="bridgehead" href="em_manage.htm" number="" targetptr="ADMQS12136"> <ttl>To create a Database Control administrative user:</ttl> <xreftext>“To create a Database Control administrative user:”</xreftext> </obj> </div> <div element="sect1" href="em_manage.htm" number="3.8" targetptr="ADMQS035"> <ttl>Setting Database Control Preferences</ttl> <xreftext>“Setting Database Control Preferences”</xreftext> <div element="sect2" href="em_manage.htm" number="3.8.1" targetptr="ADMQS12034"> <ttl>About Database Control Preferences</ttl> <xreftext>“About Database Control Preferences”</xreftext> <obj element="formalpara" href="em_manage.htm" number="" targetptr="ADMQS12137"> <ttl>Notification</ttl> <xreftext>“Notification”</xreftext> </obj> <obj element="formalpara" href="em_manage.htm" number="" targetptr="ADMQS12138"> <ttl>Blackout Administration</ttl> <xreftext>“Blackout Administration”</xreftext> </obj> <obj element="formalpara" href="em_manage.htm" number="" targetptr="ADMQS12139"> <ttl>Preferred Credentials</ttl> <xreftext>“Preferred Credentials”</xreftext> </obj> </div> <div element="sect2" href="em_manage.htm" number="3.8.2" targetptr="ADMQS0351"> <ttl>Defining Blackout Periods</ttl> <xreftext>“Defining Blackout Periods”</xreftext> <obj element="bridgehead" href="em_manage.htm" number="" targetptr="ADMQS12140"> <ttl>To define a blackout period:</ttl> <xreftext>“To define a blackout period:”</xreftext> </obj> </div> <div element="sect2" href="em_manage.htm" number="3.8.3" targetptr="ADMQS0352"> <ttl>Setting Preferred Credentials</ttl> <xreftext>“Setting Preferred Credentials”</xreftext> <obj element="bridgehead" href="em_manage.htm" number="" targetptr="ADMQS12141"> <ttl>To set preferred credentials for the database:</ttl> <xreftext>“To set preferred credentials for the database:”</xreftext> </obj> </div> </div> <div element="sect1" href="em_manage.htm" number="3.9" targetptr="ADMQS12035"> <ttl>Administering the Database with SQL-Based Management Tools</ttl> <xreftext>“Administering the Database with SQL-Based Management Tools”</xreftext> <div element="sect2" href="em_manage.htm" number="3.9.1" targetptr="ADMQS12311"> <ttl>About SQL</ttl> <xreftext>“About SQL”</xreftext> </div> <div element="sect2" href="em_manage.htm" number="3.9.2" targetptr="ADMQS12312"> <ttl>About SQL*Plus</ttl> <xreftext>“About SQL*Plus”</xreftext> </div> <div element="sect2" href="em_manage.htm" number="3.9.3" targetptr="ADMQS0361"> <ttl>Starting SQL*Plus and Connecting to the Database</ttl> <xreftext>“Starting SQL*Plus and Connecting to the Database”</xreftext> <obj element="bridgehead" href="em_manage.htm" number="" targetptr="ADMQS12142"> <ttl>To start SQL*Plus and connect to the database from the command line:</ttl> <xreftext>“To start SQL*Plus and connect to the database from the command line:”</xreftext> </obj> <obj element="bridgehead" href="em_manage.htm" number="" targetptr="ADMQS12143"> <ttl>To start SQL*Plus and connect to the database from the Windows Start menu:</ttl> <xreftext>“To start SQL*Plus and connect to the database from the Windows Start menu:”</xreftext> </obj> </div> <div element="sect2" href="em_manage.htm" number="3.9.4" targetptr="ADMQS12036"> <ttl>About SQL Developer</ttl> <xreftext>“About SQL Developer”</xreftext> </div> </div> <div element="sect1" href="em_manage.htm" number="3.10" targetptr="ADMQS038"> <ttl>Getting Started with Oracle Enterprise Manager: Oracle By Example Series</ttl> <xreftext>“Getting Started with Oracle Enterprise Manager: Oracle By Example Series”</xreftext> </div> </div> <div element="chapter" href="network.htm" number="4" targetptr="ADMQS004"> <ttl>Configuring the Network Environment</ttl> <xreftext>“Configuring the Network Environment”</xreftext> <div element="sect1" href="network.htm" number="4.1" targetptr="ADMQS041"> <ttl>Understanding Network Configuration</ttl> <xreftext>“Understanding Network Configuration”</xreftext> <div element="sect2" href="network.htm" number="4.1.1" targetptr="ADMQS0411"> <ttl>Oracle Net Listener Configuration</ttl> <xreftext>“Oracle Net Listener Configuration”</xreftext> </div> <div element="sect2" href="network.htm" number="4.1.2" targetptr="ADMQS12313"> <ttl>Client Connections</ttl> <xreftext>“Client Connections”</xreftext> <obj element="bridgehead" href="network.htm" number="" targetptr="ADMQS12353"> <ttl>Connect Descriptors</ttl> <xreftext>“Connect Descriptors”</xreftext> </obj> <obj element="bridgehead" href="network.htm" number="" targetptr="ADMQS12354"> <ttl>Connection Requests</ttl> <xreftext>“Connection Requests”</xreftext> </obj> <obj element="bridgehead" href="network.htm" number="" targetptr="ADMQS12355"> <ttl>Naming Methods</ttl> <xreftext>“Naming Methods”</xreftext> </obj> </div> <div element="sect2" href="network.htm" number="4.1.3" targetptr="ADMQS042"> <ttl>Tools for Network Configuration</ttl> <xreftext>“Tools for Network Configuration”</xreftext> <obj element="bridgehead" href="network.htm" number="" targetptr="ADMQS12356"> <ttl>Net Configuration Assistant</ttl> <xreftext>“Net Configuration Assistant”</xreftext> </obj> <obj element="bridgehead" href="network.htm" number="" targetptr="ADMQS12357"> <ttl>Oracle Enterprise Manager</ttl> <xreftext>“Oracle Enterprise Manager”</xreftext> </obj> <obj element="bridgehead" href="network.htm" number="" targetptr="ADMQS12358"> <ttl>Oracle Net Manager</ttl> <xreftext>“Oracle Net Manager”</xreftext> </obj> </div> </div> <div element="sect1" href="network.htm" number="4.2" targetptr="ADMQS043"> <ttl>Viewing Listener Configuration</ttl> <xreftext>“Viewing Listener Configuration”</xreftext> <obj element="bridgehead" href="network.htm" number="" targetptr="ADMQS12144"> <ttl>To view information about the listener with Database Control:</ttl> <xreftext>“To view information about the listener with Database Control:”</xreftext> </obj> <obj element="bridgehead" href="network.htm" number="" targetptr="ADMQS12145"> <ttl>To view information about the listener at the command line:</ttl> <xreftext>“To view information about the listener at the command line:”</xreftext> </obj> </div> <div element="sect1" href="network.htm" number="4.3" targetptr="ADMQS044"> <ttl>Starting and Stopping the Listener</ttl> <xreftext>“Starting and Stopping the Listener”</xreftext> <obj element="bridgehead" href="network.htm" number="" targetptr="ADMQS12146"> <ttl>To stop the listener with Database Control:</ttl> <xreftext>“To stop the listener with Database Control:”</xreftext> </obj> <obj element="bridgehead" href="network.htm" number="" targetptr="ADMQS12147"> <ttl>To start the listener with Database Control:</ttl> <xreftext>“To start the listener with Database Control:”</xreftext> </obj> <obj element="bridgehead" href="network.htm" number="" targetptr="ADMQS12148"> <ttl>To start or stop the listener at the command line:</ttl> <xreftext>“To start or stop the listener at the command line:”</xreftext> </obj> </div> <div element="sect1" href="network.htm" number="4.4" targetptr="ADMQS045"> <ttl>Connecting to an Oracle Database from a Client Computer</ttl> <xreftext>“Connecting to an Oracle Database from a Client Computer”</xreftext> <obj element="bridgehead" href="network.htm" number="" targetptr="ADMQS12150"> <ttl>To connect to an Oracle database from a client computer using easy connect naming:</ttl> <xreftext>“To connect to an Oracle database from a client computer using easy connect naming:”</xreftext> </obj> </div> <div element="sect1" href="network.htm" number="4.5" targetptr="ADMQS12151"> <ttl>Networking: Oracle By Example Series</ttl> <xreftext>“Networking: Oracle By Example Series”</xreftext> </div> </div> <div element="chapter" href="instance.htm" number="5" targetptr="ADMQS005"> <ttl>Managing the Oracle Instance</ttl> <xreftext>“Managing the Oracle Instance”</xreftext> <div element="sect1" href="instance.htm" number="5.1" targetptr="ADMQS051"> <ttl>Overview of the Oracle Instance and Instance Management</ttl> <xreftext>“Overview of the Oracle Instance and Instance Management”</xreftext> <div element="sect2" href="instance.htm" number="5.1.1" targetptr="ADMQS0511"> <ttl>About Initialization Parameters</ttl> <xreftext>“About Initialization Parameters”</xreftext> </div> <div element="sect2" href="instance.htm" number="5.1.2" targetptr="ADMQS0513"> <ttl>About Background Processes</ttl> <xreftext>“About Background Processes”</xreftext> <obj element="table" href="instance.htm" number="5-1" targetptr="ADMQS12329"> <ttl>Oracle Database Background Processes</ttl> <xreftext>“Oracle Database Background Processes”</xreftext> </obj> </div> <div element="sect2" href="instance.htm" number="5.1.3" targetptr="ADMQS05142"> <ttl>About Server and Client Processes</ttl> <xreftext>“About Server and Client Processes”</xreftext> </div> <div element="sect2" href="instance.htm" number="5.1.4" targetptr="ADMQS0512"> <ttl>About Instance Memory Structure</ttl> <xreftext>“About Instance Memory Structure”</xreftext> <div element="sect3" href="instance.htm" number="5.1.4.1" targetptr="ADMQS05121"> <ttl>System Global Area</ttl> <xreftext>“System Global Area”</xreftext> <obj element="table" href="instance.htm" number="5-2" targetptr="ADMQS12330"> <ttl>SGA Components</ttl> <xreftext>“SGA Components”</xreftext> </obj> </div> <div element="sect3" href="instance.htm" number="5.1.4.2" targetptr="ADMQS05122"> <ttl>Program Global Area</ttl> <xreftext>“Program Global Area”</xreftext> </div> </div> <div element="sect2" href="instance.htm" number="5.1.5" targetptr="ADMQS0514"> <ttl>About Instance Startup and Shutdown</ttl> <xreftext>“About Instance Startup and Shutdown”</xreftext> <div element="sect3" href="instance.htm" number="5.1.5.1" targetptr="ADMQS05141"> <ttl>About Administration Privileges for Startup and Shutdown</ttl> <xreftext>“About Administration Privileges for Startup and Shutdown”</xreftext> </div> <div element="sect3" href="instance.htm" number="5.1.5.2" targetptr="ADMQS05144"> <ttl>About Instance Startup</ttl> <xreftext>“About Instance Startup”</xreftext> </div> <div element="sect3" href="instance.htm" number="5.1.5.3" targetptr="ADMQS05145"> <ttl>About Instance Shutdown</ttl> <xreftext>“About Instance Shutdown”</xreftext> </div> </div> </div> <div element="sect1" href="instance.htm" number="5.2" targetptr="ADMQS052"> <ttl>Shutting Down and Starting Up the Oracle Instance</ttl> <xreftext>“Shutting Down and Starting Up the Oracle Instance”</xreftext> <div element="sect2" href="instance.htm" number="5.2.1" targetptr="ADMQS12037"> <ttl>Shutting Down and Starting Up Using Oracle Enterprise Manager Database Control</ttl> <xreftext>“Shutting Down and Starting Up Using Oracle Enterprise Manager Database Control”</xreftext> <obj element="bridgehead" href="instance.htm" number="" targetptr="ADMQS12152"> <ttl>To shut down and start the Oracle instance using Database Control:</ttl> <xreftext>“To shut down and start the Oracle instance using Database Control:”</xreftext> </obj> </div> <div element="sect2" href="instance.htm" number="5.2.2" targetptr="ADMQS0521"> <ttl>Shutting Down and Starting Up Using the Windows Services Program</ttl> <xreftext>“Shutting Down and Starting Up Using the Windows Services Program”</xreftext> <obj element="bridgehead" href="instance.htm" number="" targetptr="ADMQS12153"> <ttl>To start or stop Oracle Database services:</ttl> <xreftext>“To start or stop Oracle Database services:”</xreftext> </obj> </div> </div> <div element="sect1" href="instance.htm" number="5.3" targetptr="ADMQS053"> <ttl>Viewing and Modifying Initialization Parameters</ttl> <xreftext>“Viewing and Modifying Initialization Parameters”</xreftext> <obj element="bridgehead" href="instance.htm" number="" targetptr="ADMQS12154"> <ttl>To view or modify initialization parameters:</ttl> <xreftext>“To view or modify initialization parameters:”</xreftext> </obj> </div> <div element="sect1" href="instance.htm" number="5.4" targetptr="ADMQS054"> <ttl>Managing Memory</ttl> <xreftext>“Managing Memory”</xreftext> <div element="sect2" href="instance.htm" number="5.4.1" targetptr="ADMQS12038"> <ttl>About Memory Management</ttl> <xreftext>“About Memory Management”</xreftext> <obj element="table" href="instance.htm" number="5-3" targetptr="ADMQS12331"> <ttl>Oracle Database Memory Management Modes</ttl> <xreftext>“Oracle Database Memory Management Modes”</xreftext> </obj> </div> <div element="sect2" href="instance.htm" number="5.4.2" targetptr="ADMQS12039"> <ttl>Enabling Automatic Memory Management</ttl> <xreftext>“Enabling Automatic Memory Management”</xreftext> <obj element="bridgehead" href="instance.htm" number="" targetptr="ADMQS12155"> <ttl>To enable automatic memory management:</ttl> <xreftext>“To enable automatic memory management:”</xreftext> </obj> </div> <div element="sect2" href="instance.htm" number="5.4.3" targetptr="ADMQS12101"> <ttl>Modifying Memory Settings – Automatic Memory Management</ttl> <xreftext>“Modifying Memory Settings – Automatic Memory Management”</xreftext> <obj element="bridgehead" href="instance.htm" number="" targetptr="ADMQS12156"> <ttl>To modify total memory size (new value does not exceed maximum memory size):</ttl> <xreftext>“To modify total memory size (new value does not exceed maximum memory size):”</xreftext> </obj> <obj element="bridgehead" href="instance.htm" number="" targetptr="ADMQS12157"> <ttl>To modify total memory size (new value exceeds maximum memory size):</ttl> <xreftext>“To modify total memory size (new value exceeds maximum memory size):”</xreftext> </obj> </div> <div element="sect2" href="instance.htm" number="5.4.4" targetptr="ADMQS0541"> <ttl>Modifying Memory Settings – Automatic Shared Memory Management</ttl> <xreftext>“Modifying Memory Settings – Automatic Shared Memory Management”</xreftext> <obj element="bridgehead" href="instance.htm" number="" targetptr="ADMQS12158"> <ttl>To modify the total SGA memory size:</ttl> <xreftext>“To modify the total SGA memory size:”</xreftext> </obj> </div> <div element="sect2" href="instance.htm" number="5.4.5" targetptr="ADMQS12102"> <ttl>Modifying Memory Settings – Automatic PGA Memory Management</ttl> <xreftext>“Modifying Memory Settings – Automatic PGA Memory Management”</xreftext> <obj element="bridgehead" href="instance.htm" number="" targetptr="ADMQS12159"> <ttl>To modify the instance PGA size:</ttl> <xreftext>“To modify the instance PGA size:”</xreftext> </obj> </div> </div> <div element="sect1" href="instance.htm" number="5.5" targetptr="ADMQS055"> <ttl>Instances: Oracle By Example Series</ttl> <xreftext>“Instances: Oracle By Example Series”</xreftext> </div> </div> <div element="chapter" href="storage.htm" number="6" targetptr="ADMQS006"> <ttl>Managing Database Storage Structures</ttl> <xreftext>“Managing Database Storage Structures”</xreftext> <div element="sect1" href="storage.htm" number="6.1" targetptr="ADMQS12047"> <ttl>About Database Storage Structures</ttl> <xreftext>“About Database Storage Structures”</xreftext> <obj element="figure" href="storage.htm" number="6-1" targetptr="ADMQS12332"> <ttl>Oracle Database Storage Structures</ttl> <xreftext>“Oracle Database Storage Structures”</xreftext> </obj> <obj element="figure" href="storage.htm" number="6-2" targetptr="ADMQS12333"> <ttl>Storage Options</ttl> <xreftext>“Storage Options”</xreftext> </obj> <div element="sect2" href="storage.htm" number="6.1.1" targetptr="ADMQS12048"> <ttl>About Control Files</ttl> <xreftext>“About Control Files”</xreftext> </div> <div element="sect2" href="storage.htm" number="6.1.2" targetptr="ADMQS12049"> <ttl>About Online Redo Log Files</ttl> <xreftext>“About Online Redo Log Files”</xreftext> <obj element="figure" href="storage.htm" number="6-3" targetptr="ADMQS12334"> <ttl>Online Redo Log Groups and Their Members</ttl> <xreftext>“Online Redo Log Groups and Their Members”</xreftext> </obj> </div> <div element="sect2" href="storage.htm" number="6.1.3" targetptr="ADMQS12050"> <ttl>About Archived Redo Log Files</ttl> <xreftext>“About Archived Redo Log Files”</xreftext> </div> <div element="sect2" href="storage.htm" number="6.1.4" targetptr="ADMQS12051"> <ttl>About Rollback Segments</ttl> <xreftext>“About Rollback Segments”</xreftext> </div> <div element="sect2" href="storage.htm" number="6.1.5" targetptr="ADMQS12052"> <ttl>About Data Files</ttl> <xreftext>“About Data Files”</xreftext> </div> <div element="sect2" href="storage.htm" number="6.1.6" targetptr="ADMQS12053"> <ttl>About Tablespaces</ttl> <xreftext>“About Tablespaces”</xreftext> <obj element="table" href="storage.htm" number="6-1" targetptr="ADMQS12335"> <ttl>Tablespaces and Descriptions</ttl> <xreftext>“Tablespaces and Descriptions”</xreftext> </obj> <div element="sect3" href="storage.htm" number="6.1.6.1" targetptr="ADMQS12054"> <ttl>Locally Managed Tablespaces</ttl> <xreftext>“Locally Managed Tablespaces”</xreftext> </div> <div element="sect3" href="storage.htm" number="6.1.6.2" targetptr="ADMQS12055"> <ttl>Tablespace Types</ttl> <xreftext>“Tablespace Types”</xreftext> </div> <div element="sect3" href="storage.htm" number="6.1.6.3" targetptr="ADMQS12056"> <ttl>Tablespace Status</ttl> <xreftext>“Tablespace Status”</xreftext> </div> <div element="sect3" href="storage.htm" number="6.1.6.4" targetptr="ADMQS12057"> <ttl>Autoextend Tablespace</ttl> <xreftext>“Autoextend Tablespace”</xreftext> </div> <div element="sect3" href="storage.htm" number="6.1.6.5" targetptr="CHDCGHJF"> <ttl>Encrypted Tablespaces</ttl> <xreftext>“Encrypted Tablespaces”</xreftext> </div> </div> <div element="sect2" href="storage.htm" number="6.1.7" targetptr="ADMQS12058"> <ttl>About Other Storage Structures</ttl> <xreftext>“About Other Storage Structures”</xreftext> <obj element="bridgehead" href="storage.htm" number="" targetptr="ADMQS12059"> <ttl>Initialization Parameter File</ttl> <xreftext>“Initialization Parameter File”</xreftext> </obj> <obj element="bridgehead" href="storage.htm" number="" targetptr="ADMQS12060"> <ttl>Password File</ttl> <xreftext>“Password File”</xreftext> </obj> <obj element="bridgehead" href="storage.htm" number="" targetptr="ADMQS12061"> <ttl>Backup Files</ttl> <xreftext>“Backup Files”</xreftext> </obj> </div> </div> <div element="sect1" href="storage.htm" number="6.2" targetptr="ADMQS12062"> <ttl>Viewing Database Storage Structure Information</ttl> <xreftext>“Viewing Database Storage Structure Information”</xreftext> <div element="sect2" href="storage.htm" number="6.2.1" targetptr="ADMQS12063"> <ttl>Viewing Control File Information</ttl> <xreftext>“Viewing Control File Information”</xreftext> <obj element="bridgehead" href="storage.htm" number="" targetptr="ADMQS12160"> <ttl>To view control file information:</ttl> <xreftext>“To view control file information:”</xreftext> </obj> </div> <div element="sect2" href="storage.htm" number="6.2.2" targetptr="ADMQS12064"> <ttl>Viewing Online Redo Log File Information</ttl> <xreftext>“Viewing Online Redo Log File Information”</xreftext> <obj element="bridgehead" href="storage.htm" number="" targetptr="ADMQS12161"> <ttl>To view online redo log file information:</ttl> <xreftext>“To view online redo log file information:”</xreftext> </obj> </div> <div element="sect2" href="storage.htm" number="6.2.3" targetptr="ADMQS12065"> <ttl>Viewing Archived Redo Log File Information</ttl> <xreftext>“Viewing Archived Redo Log File Information”</xreftext> <obj element="bridgehead" href="storage.htm" number="" targetptr="ADMQS12162"> <ttl>To view archived redo log file information:</ttl> <xreftext>“To view archived redo log file information:”</xreftext> </obj> </div> <div element="sect2" href="storage.htm" number="6.2.4" targetptr="ADMQS12066"> <ttl>Viewing Data File Information</ttl> <xreftext>“Viewing Data File Information”</xreftext> <obj element="bridgehead" href="storage.htm" number="" targetptr="ADMQS12163"> <ttl>To view data file information:</ttl> <xreftext>“To view data file information:”</xreftext> </obj> </div> <div element="sect2" href="storage.htm" number="6.2.5" targetptr="ADMQS12067"> <ttl>Viewing Tablespace Information</ttl> <xreftext>“Viewing Tablespace Information”</xreftext> <obj element="bridgehead" href="storage.htm" number="" targetptr="ADMQS12164"> <ttl>To view tablespace information:</ttl> <xreftext>“To view tablespace information:”</xreftext> </obj> </div> </div> <div element="sect1" href="storage.htm" number="6.3" targetptr="ADMQS062"> <ttl>Performing Common Database Storage Tasks</ttl> <xreftext>“Performing Common Database Storage Tasks”</xreftext> <div element="sect2" href="storage.htm" number="6.3.1" targetptr="ADMQS0622"> <ttl>Creating a Tablespace</ttl> <xreftext>“Creating a Tablespace”</xreftext> <obj element="bridgehead" href="storage.htm" number="" targetptr="ADMQS12165"> <ttl>To create a tablespace:</ttl> <xreftext>“To create a tablespace:”</xreftext> </obj> <obj element="figure" href="storage.htm" number="6-4" targetptr="ADMQS12336"> <ttl>Tablespaces Page</ttl> <xreftext>“Tablespaces Page”</xreftext> </obj> </div> <div element="sect2" href="storage.htm" number="6.3.2" targetptr="ADMQS0623"> <ttl>Modifying a Tablespace</ttl> <xreftext>“Modifying a Tablespace”</xreftext> <div element="sect3" href="storage.htm" number="6.3.2.1" targetptr="ADMQS12068"> <ttl>Setting a Tablespace to Automatically Extend</ttl> <xreftext>“Setting a Tablespace to Automatically Extend”</xreftext> <obj element="bridgehead" href="storage.htm" number="" targetptr="ADMQS12166"> <ttl>To set a tablespace to automatically extend:</ttl> <xreftext>“To set a tablespace to automatically extend:”</xreftext> </obj> </div> <div element="sect3" href="storage.htm" number="6.3.2.2" targetptr="ADMQS12069"> <ttl>Changing Space Usage Alert Thresholds for a Tablespace</ttl> <xreftext>“Changing Space Usage Alert Thresholds for a Tablespace”</xreftext> <obj element="bridgehead" href="storage.htm" number="" targetptr="ADMQS12167"> <ttl>To change space usage alert thresholds for tablespaces:</ttl> <xreftext>“To change space usage alert thresholds for tablespaces:”</xreftext> </obj> </div> <div element="sect3" href="storage.htm" number="6.3.2.3" targetptr="ADMQS12070"> <ttl>Taking a Tablespace Offline</ttl> <xreftext>“Taking a Tablespace Offline”</xreftext> <obj element="bridgehead" href="storage.htm" number="" targetptr="ADMQS12168"> <ttl>To take a tablespace offline:</ttl> <xreftext>“To take a tablespace offline:”</xreftext> </obj> </div> </div> <div element="sect2" href="storage.htm" number="6.3.3" targetptr="ADMQS0624"> <ttl>Dropping a Tablespace</ttl> <xreftext>“Dropping a Tablespace”</xreftext> <obj element="bridgehead" href="storage.htm" number="" targetptr="ADMQS12169"> <ttl>To drop a tablespace:</ttl> <xreftext>“To drop a tablespace:”</xreftext> </obj> </div> <div element="sect2" href="storage.htm" number="6.3.4" targetptr="ADMQS0625"> <ttl>Reclaiming Unused Space</ttl> <xreftext>“Reclaiming Unused Space”</xreftext> </div> </div> </div> <div element="sect3" href="storage.htm" number="6.3.4.1" targetptr="ADMQS12071"> <ttl>About Reclaimable Unused Space</ttl> <xreftext>“About Reclaimable Unused Space”</xreftext> </div> <div element="sect3" href="storage.htm" number="6.3.4.2" targetptr="ADMQS12072"> <ttl>About the Segment Advisor</ttl> <xreftext>“About the Segment Advisor”</xreftext> <div element="sect4" href="storage.htm" number="6.3.4.2.1" targetptr="ADMQS12170"> <ttl>Segment Advisor Recommendations</ttl> <xreftext>“Segment Advisor Recommendations”</xreftext> </div> </div> <div element="sect3" href="storage.htm" number="6.3.4.3" targetptr="ADMQS06251"> <ttl>Viewing Segment Advisor Recommendations and Reclaiming Space</ttl> <xreftext>“Viewing Segment Advisor Recommendations and Reclaiming Space”</xreftext> <obj element="bridgehead" href="storage.htm" number="" targetptr="ADMQS12171"> <ttl>To view Segment Advisor recommendations and reclaim space:</ttl> <xreftext>“To view Segment Advisor recommendations and reclaim space:”</xreftext> </obj> <obj element="figure" href="storage.htm" number="6-5" targetptr="ADMQS12337"> <ttl>Home Page Space Summary Section</ttl> <xreftext>“Home Page Space Summary Section”</xreftext> </obj> <obj element="figure" href="storage.htm" number="6-6" targetptr="CHDFEFAB"> <ttl>Segment Advisor Recommendations Page</ttl> <xreftext>“Segment Advisor Recommendations Page”</xreftext> </obj> <obj element="figure" href="storage.htm" number="6-7" targetptr="CHDEIFFE"> <ttl>Recommendation Details for Tablespace Page</ttl> <xreftext>“Recommendation Details for Tablespace Page”</xreftext> </obj> </div> <div element="sect3" href="storage.htm" number="6.3.4.4" targetptr="ADMQS06252"> <ttl>Running the Segment Advisor Manually</ttl> <xreftext>“Running the Segment Advisor Manually”</xreftext> </div> <div element="sect1" href="storage.htm" number="6.4" targetptr="ADMQS12073"> <ttl>Managing the Online Redo Log</ttl> <xreftext>“Managing the Online Redo Log”</xreftext> <div element="sect2" href="storage.htm" number="6.4.1" targetptr="ADMQS12074"> <ttl>Multiplexing the Online Redo Log</ttl> <xreftext>“Multiplexing the Online Redo Log”</xreftext> <obj element="bridgehead" href="storage.htm" number="" targetptr="ADMQS12172"> <ttl>To multiplex the online redo log:</ttl> <xreftext>“To multiplex the online redo log:”</xreftext> </obj> </div> <div element="sect2" href="storage.htm" number="6.4.2" targetptr="ADMQS12075"> <ttl>Switching a Log File</ttl> <xreftext>“Switching a Log File”</xreftext> <obj element="bridgehead" href="storage.htm" number="" targetptr="ADMQS12173"> <ttl>To switch a log file:</ttl> <xreftext>“To switch a log file:”</xreftext> </obj> </div> </div> <div element="sect1" href="storage.htm" number="6.5" targetptr="ADMQS063"> <ttl>Managing Undo Data</ttl> <xreftext>“Managing Undo Data”</xreftext> <div element="sect2" href="storage.htm" number="6.5.1" targetptr="ADMQS0631"> <ttl>About Undo Data</ttl> <xreftext>“About Undo Data”</xreftext> <obj element="bridgehead" href="storage.htm" number="" targetptr="ADMQS12174"> <ttl>Undo Tablespace</ttl> <xreftext>“Undo Tablespace”</xreftext> </obj> <obj element="bridgehead" href="storage.htm" number="" targetptr="ADMQS12175"> <ttl>Undo Retention</ttl> <xreftext>“Undo Retention”</xreftext> </obj> </div> <div element="sect2" href="storage.htm" number="6.5.2" targetptr="ADMQS12104"> <ttl>About Managing Undo Data</ttl> <xreftext>“About Managing Undo Data”</xreftext> </div> <div element="sect2" href="storage.htm" number="6.5.3" targetptr="ADMQS0634"> <ttl>Viewing Undo Information</ttl> <xreftext>“Viewing Undo Information”</xreftext> <obj element="bridgehead" href="storage.htm" number="" targetptr="ADMQS12176"> <ttl>To view undo information:</ttl> <xreftext>“To view undo information:”</xreftext> </obj> </div> <div element="sect2" href="storage.htm" number="6.5.4" targetptr="ADMQS0635"> <ttl>Computing the Minimum Undo Tablespace Size Using the Undo Advisor</ttl> <xreftext>“Computing the Minimum Undo Tablespace Size Using the Undo Advisor”</xreftext> <obj element="bridgehead" href="storage.htm" number="" targetptr="ADMQS12177"> <ttl>To compute the minimum undo tablespace size using the Undo Advisor:</ttl> <xreftext>“To compute the minimum undo tablespace size using the Undo Advisor:”</xreftext> </obj> </div> <div element="sect2" href="storage.htm" number="6.5.5" targetptr="ADMQS12105"> <ttl>Changing the Undo Tablespace to a Fixed Size</ttl> <xreftext>“Changing the Undo Tablespace to a Fixed Size”</xreftext> <obj element="bridgehead" href="storage.htm" number="" targetptr="ADMQS12178"> <ttl>To change the undo tablespace to a fixed size:</ttl> <xreftext>“To change the undo tablespace to a fixed size:”</xreftext> </obj> </div> </div> <div element="sect1" href="storage.htm" number="6.6" targetptr="ADMQS065"> <ttl>Storage: Oracle By Example Series</ttl> <xreftext>“Storage: Oracle By Example Series”</xreftext> </div> <div element="chapter" href="users_secure.htm" number="7" targetptr="ADMQS007"> <ttl>Administering User Accounts and Security</ttl> <xreftext>“Administering User Accounts and Security”</xreftext> <div element="sect1" href="users_secure.htm" number="7.1" targetptr="ADMQS071"> <ttl>About User Accounts</ttl> <xreftext>“About User Accounts”</xreftext> <obj element="bridgehead" href="users_secure.htm" number="" targetptr="ADMQS12179"> <ttl>Predefined User Accounts</ttl> <xreftext>“Predefined User Accounts”</xreftext> </obj> </div> <div element="sect1" href="users_secure.htm" number="7.2" targetptr="ADMQS12001"> <ttl>About User Privileges and Roles</ttl> <xreftext>“About User Privileges and Roles”</xreftext> <obj element="table" href="users_secure.htm" number="7-1" targetptr="ADMQS12341"> <ttl>Oracle Database Predefined Roles</ttl> <xreftext>“Oracle Database Predefined Roles”</xreftext> </obj> </div> <div element="sect1" href="users_secure.htm" number="7.3" targetptr="ADMQS12002"> <ttl>About Administrative Accounts and Privileges</ttl> <xreftext>“About Administrative Accounts and Privileges”</xreftext> <div element="sect2" href="users_secure.htm" number="7.3.1" targetptr="ADMQS12003"> <ttl>SYS and SYSTEM Users</ttl> <xreftext>“SYS and SYSTEM Users”</xreftext> </div> <div element="sect2" href="users_secure.htm" number="7.3.2" targetptr="ADMQS12004"> <ttl>SYSDBA and SYSOPER System Privileges</ttl> <xreftext>“SYSDBA and SYSOPER System Privileges”</xreftext> </div> </div> <div element="sect1" href="users_secure.htm" number="7.4" targetptr="ADMQS072"> <ttl>Administering Roles</ttl> <xreftext>“Administering Roles”</xreftext> <div element="sect2" href="users_secure.htm" number="7.4.1" targetptr="ADMQS0724"> <ttl>Viewing Roles</ttl> <xreftext>“Viewing Roles”</xreftext> </div> <div element="sect2" href="users_secure.htm" number="7.4.2" targetptr="ADMQS0725"> <ttl>Example: Creating a Role</ttl> <xreftext>“Example: Creating a Role”</xreftext> <obj element="table" href="users_secure.htm" number="7-2" targetptr="ADMQS12342"> <ttl>System Privileges Granted to the APPDEV Role</ttl> <xreftext>“System Privileges Granted to the APPDEV Role”</xreftext> </obj> </div> <div element="sect2" href="users_secure.htm" number="7.4.3" targetptr="ADMQS0726"> <ttl>Example: Modifying a Role</ttl> <xreftext>“Example: Modifying a Role”</xreftext> </div> <div element="sect2" href="users_secure.htm" number="7.4.4" targetptr="ADMQS0727"> <ttl>Deleting a Role</ttl> <xreftext>“Deleting a Role”</xreftext> </div> </div> <div element="sect1" href="users_secure.htm" number="7.5" targetptr="ADMQS074"> <ttl>Administering Database User Accounts</ttl> <xreftext>“Administering Database User Accounts”</xreftext> <div element="sect2" href="users_secure.htm" number="7.5.1" targetptr="ADMQS12005"> <ttl>Viewing User Accounts</ttl> <xreftext>“Viewing User Accounts”</xreftext> </div> <div element="sect2" href="users_secure.htm" number="7.5.2" targetptr="ADMQS0741"> <ttl>Example: Creating a User Account</ttl> <xreftext>“Example: Creating a User Account”</xreftext> </div> <div element="sect2" href="users_secure.htm" number="7.5.3" targetptr="ADMQS0742"> <ttl>Creating a New User Account by Duplicating an Existing User Account</ttl> <xreftext>“Creating a New User Account by Duplicating an Existing User Account”</xreftext> </div> <div element="sect2" href="users_secure.htm" number="7.5.4" targetptr="ADMQS12040"> <ttl>Example: Granting Privileges and Roles to a User Account</ttl> <xreftext>“Example: Granting Privileges and Roles to a User Account”</xreftext> </div> <div element="sect2" href="users_secure.htm" number="7.5.5" targetptr="ADMQS12041"> <ttl>Example: Assigning a Tablespace Quota to a User Account</ttl> <xreftext>“Example: Assigning a Tablespace Quota to a User Account”</xreftext> </div> <div element="sect2" href="users_secure.htm" number="7.5.6" targetptr="ADMQS0743"> <ttl>Example: Modifying a User Account</ttl> <xreftext>“Example: Modifying a User Account”</xreftext> </div> <div element="sect2" href="users_secure.htm" number="7.5.7" targetptr="ADMQS12042"> <ttl>Locking and Unlocking User Accounts</ttl> <xreftext>“Locking and Unlocking User Accounts”</xreftext> </div> <div element="sect2" href="users_secure.htm" number="7.5.8" targetptr="ADMQS12043"> <ttl>Expiring a User Password</ttl> <xreftext>“Expiring a User Password”</xreftext> </div> <div element="sect2" href="users_secure.htm" number="7.5.9" targetptr="ADMQS0744"> <ttl>Example: Deleting a User Account</ttl> <xreftext>“Example: Deleting a User Account”</xreftext> </div> </div> <div element="sect1" href="users_secure.htm" number="7.6" targetptr="ADMQS076"> <ttl>Setting the Database Password Policy</ttl> <xreftext>“Setting the Database Password Policy”</xreftext> <div element="sect2" href="users_secure.htm" number="7.6.1" targetptr="ADMQS12044"> <ttl>About Password Policies</ttl> <xreftext>“About Password Policies”</xreftext> </div> <div element="sect2" href="users_secure.htm" number="7.6.2" targetptr="ADMQS12045"> <ttl>Modifying the Default Password Policy</ttl> <xreftext>“Modifying the Default Password Policy”</xreftext> </div> </div> <div element="sect1" href="users_secure.htm" number="7.7" targetptr="ADMQS075"> <ttl>Users: Oracle By Example Series</ttl> <xreftext>“Users: Oracle By Example Series”</xreftext> </div> </div> <div element="chapter" href="schema.htm" number="8" targetptr="ADMQS008"> <ttl>Managing Schema Objects</ttl> <xreftext>“Managing Schema Objects”</xreftext> <div element="sect1" href="schema.htm" number="8.1" targetptr="ADMQS081"> <ttl>About Schema Objects</ttl> <xreftext>“About Schema Objects”</xreftext> <obj element="bridgehead" href="schema.htm" number="" targetptr="ADMQS0812"> <ttl>Naming Schema Objects</ttl> <xreftext>“Naming Schema Objects”</xreftext> </obj> <obj element="bridgehead" href="schema.htm" number="" targetptr="ADMQS12093"> <ttl>The Show SQL Button</ttl> <xreftext>“The Show SQL Button”</xreftext> </obj> </div> <div element="sect1" href="schema.htm" number="8.2" targetptr="ADMQS12092"> <ttl>About Schema Object Management Privileges</ttl> <xreftext>“About Schema Object Management Privileges”</xreftext> </div> <div element="sect1" href="schema.htm" number="8.3" targetptr="ADMQS082"> <ttl>Managing Tables</ttl> <xreftext>“Managing Tables”</xreftext> <div element="sect2" href="schema.htm" number="8.3.1" targetptr="ADMQS0821"> <ttl>About Tables</ttl> <xreftext>“About Tables”</xreftext> </div> </div> </div> <div element="sect3" href="schema.htm" number="8.3.1.1" targetptr="ADMQS08211"> <ttl>About Table Types</ttl> <xreftext>“About Table Types”</xreftext> </div> <div element="sect3" href="schema.htm" number="8.3.1.2" targetptr="ADMQS08212"> <ttl>About Table Column Attributes</ttl> <xreftext>“About Table Column Attributes”</xreftext> <div element="sect4" href="schema.htm" number="8.3.1.2.1" targetptr="ADMQS08216"> <ttl>Data Type</ttl> <xreftext>“Data Type”</xreftext> <obj element="table" href="schema.htm" number="8-1" targetptr="ADMQS12344"> <ttl>Common Data Types</ttl> <xreftext>“Common Data Types”</xreftext> </obj> </div> <div element="sect4" href="schema.htm" number="8.3.1.2.2" targetptr="ADMQS08217"> <ttl>NOT NULL Column Constraint</ttl> <xreftext>“NOT NULL Column Constraint”</xreftext> </div> <div element="sect4" href="schema.htm" number="8.3.1.2.3" targetptr="ADMQS08218"> <ttl>Default Value</ttl> <xreftext>“Default Value”</xreftext> </div> <div element="sect4" href="schema.htm" number="8.3.1.2.4" targetptr="ADMQS12077"> <ttl>Encryption</ttl> <xreftext>“Encryption”</xreftext> </div> </div> <div element="sect3" href="schema.htm" number="8.3.1.3" targetptr="ADMQS08213"> <ttl>About Table-Level Constraints</ttl> <xreftext>“About Table-Level Constraints”</xreftext> </div> <div element="sect3" href="schema.htm" number="8.3.1.4" targetptr="ADMQS08215"> <ttl>Other Table Creation Considerations</ttl> <xreftext>“Other Table Creation Considerations”</xreftext> <div element="sect4" href="schema.htm" number="8.3.1.4.1" targetptr="ADMQS12094"> <ttl>User-Defined Types and Large Objects (LOBs)</ttl> <xreftext>“User-Defined Types and Large Objects (LOBs)”</xreftext> </div> <div element="sect4" href="schema.htm" number="8.3.1.4.2" targetptr="ADMQS12095"> <ttl>Partitioned Tables and Indexes</ttl> <xreftext>“Partitioned Tables and Indexes”</xreftext> </div> <div element="sect4" href="schema.htm" number="8.3.1.4.3" targetptr="ADMQS12320"> <ttl>Physical Storage Attributes</ttl> <xreftext>“Physical Storage Attributes”</xreftext> </div> <div element="sect4" href="schema.htm" number="8.3.1.4.4" targetptr="ADMQS12096"> <ttl>Compressed Tables</ttl> <xreftext>“Compressed Tables”</xreftext> </div> </div> <div element="sect2" href="schema.htm" number="8.3.2" targetptr="ADMQS0822"> <ttl>Viewing Tables</ttl> <xreftext>“Viewing Tables”</xreftext> <obj element="bridgehead" href="schema.htm" number="" targetptr="ADMQS12287"> <ttl>To view tables:</ttl> <xreftext>“To view tables:”</xreftext> </obj> </div> <div element="sect2" href="schema.htm" number="8.3.3" targetptr="ADMQS0823"> <ttl>Viewing Table Data</ttl> <xreftext>“Viewing Table Data”</xreftext> <obj element="bridgehead" href="schema.htm" number="" targetptr="ADMQS12288"> <ttl>To view table data:</ttl> <xreftext>“To view table data:”</xreftext> </obj> </div> <div element="sect2" href="schema.htm" number="8.3.4" targetptr="ADMQS0824"> <ttl>Example: Creating a Table</ttl> <xreftext>“Example: Creating a Table”</xreftext> <obj element="bridgehead" href="schema.htm" number="" targetptr="ADMQS12289"> <ttl>To create the PURCHASE_ORDERS table in the NICK schema:</ttl> <xreftext>“To create the PURCHASE_ORDERS table in the NICK schema:”</xreftext> </obj> </div> <div element="sect2" href="schema.htm" number="8.3.5" targetptr="ADMQS0825"> <ttl>Modifying Table Attributes</ttl> <xreftext>“Modifying Table Attributes”</xreftext> <div element="sect3" href="schema.htm" number="8.3.5.1" targetptr="ADMQS08251"> <ttl>Example: Adding Table Columns</ttl> <xreftext>“Example: Adding Table Columns”</xreftext> <obj element="bridgehead" href="schema.htm" number="" targetptr="ADMQS12290"> <ttl>To add columns to the PURCHASE_ORDERS table:</ttl> <xreftext>“To add columns to the PURCHASE_ORDERS table:”</xreftext> </obj> </div> <div element="sect3" href="schema.htm" number="8.3.5.2" targetptr="ADMQS08252"> <ttl>Example: Deleting a Table Column</ttl> <xreftext>“Example: Deleting a Table Column”</xreftext> <obj element="bridgehead" href="schema.htm" number="" targetptr="ADMQS12291"> <ttl>To delete the PO_REQUESTOR_NAME column:</ttl> <xreftext>“To delete the PO_REQUESTOR_NAME column:”</xreftext> </obj> </div> <div element="sect3" href="schema.htm" number="8.3.5.3" targetptr="ADMQS08253"> <ttl>Example: Adding a New Table Constraint</ttl> <xreftext>“Example: Adding a New Table Constraint”</xreftext> <obj element="bridgehead" href="schema.htm" number="" targetptr="ADMQS12292"> <ttl>To add a table constraint to the PURCHASE_ORDERS table:</ttl> <xreftext>“To add a table constraint to the PURCHASE_ORDERS table:”</xreftext> </obj> </div> <div element="sect3" href="schema.htm" number="8.3.5.4" targetptr="ADMQS08254"> <ttl>Example: Modifying an Existing Table Constraint</ttl> <xreftext>“Example: Modifying an Existing Table Constraint”</xreftext> <obj element="bridgehead" href="schema.htm" number="" targetptr="ADMQS12293"> <ttl>To disable a constraint for the PURCHASE_ORDERS table:</ttl> <xreftext>“To disable a constraint for the PURCHASE_ORDERS table:”</xreftext> </obj> </div> <div element="sect3" href="schema.htm" number="8.3.5.5" targetptr="ADMQS08255"> <ttl>Example: Deleting a Table Constraint</ttl> <xreftext>“Example: Deleting a Table Constraint”</xreftext> <obj element="bridgehead" href="schema.htm" number="" targetptr="ADMQS12294"> <ttl>To delete a constraint from the PURCHASE_ORDERS table:</ttl> <xreftext>“To delete a constraint from the PURCHASE_ORDERS table:”</xreftext> </obj> </div> </div> <div element="sect2" href="schema.htm" number="8.3.6" targetptr="ADMQS0826"> <ttl>Example: Loading Data into a Table</ttl> <xreftext>“Example: Loading Data into a Table”</xreftext> <obj element="bridgehead" href="schema.htm" number="" targetptr="ADMQS12295"> <ttl>To load data into the PURCHASE_ORDERS table:</ttl> <xreftext>“To load data into the PURCHASE_ORDERS table:”</xreftext> </obj> </div> <div element="sect2" href="schema.htm" number="8.3.7" targetptr="ADMQS0827"> <ttl>Deleting a Table</ttl> <xreftext>“Deleting a Table”</xreftext> <obj element="bridgehead" href="schema.htm" number="" targetptr="ADMQS12296"> <ttl>To delete a table:</ttl> <xreftext>“To delete a table:”</xreftext> </obj> </div> <div element="sect1" href="schema.htm" number="8.4" targetptr="ADMQS083"> <ttl>Managing Indexes</ttl> <xreftext>“Managing Indexes”</xreftext> <div element="sect2" href="schema.htm" number="8.4.1" targetptr="ADMQS0831"> <ttl>About Indexes</ttl> <xreftext>“About Indexes”</xreftext> <div element="sect3" href="schema.htm" number="8.4.1.1" targetptr="ADMQS08311"> <ttl>Indexes and Performance</ttl> <xreftext>“Indexes and Performance”</xreftext> </div> <div element="sect3" href="schema.htm" number="8.4.1.2" targetptr="ADMQS08312"> <ttl>Index Attributes</ttl> <xreftext>“Index Attributes”</xreftext> <obj element="bridgehead" href="schema.htm" number="" targetptr="ADMQS12359"> <ttl>Standard (B-tree) and Bitmap</ttl> <xreftext>“Standard (B-tree) and Bitmap”</xreftext> </obj> <obj element="bridgehead" href="schema.htm" number="" targetptr="ADMQS12360"> <ttl>Ascending and Descending</ttl> <xreftext>“Ascending and Descending”</xreftext> </obj> <obj element="bridgehead" href="schema.htm" number="" targetptr="ADMQS12361"> <ttl>Column and Functional</ttl> <xreftext>“Column and Functional”</xreftext> </obj> <obj element="bridgehead" href="schema.htm" number="" targetptr="ADMQS12362"> <ttl>Single-Column and Concatenated</ttl> <xreftext>“Single-Column and Concatenated”</xreftext> </obj> <obj element="bridgehead" href="schema.htm" number="" targetptr="ADMQS12363"> <ttl>Nonpartitioned and Partitioned</ttl> <xreftext>“Nonpartitioned and Partitioned”</xreftext> </obj> </div> </div> <div element="sect2" href="schema.htm" number="8.4.2" targetptr="ADMQS0832"> <ttl>Viewing Indexes</ttl> <xreftext>“Viewing Indexes”</xreftext> <obj element="bridgehead" href="schema.htm" number="" targetptr="ADMQS12297"> <ttl>To view indexes:</ttl> <xreftext>“To view indexes:”</xreftext> </obj> </div> <div element="sect2" href="schema.htm" number="8.4.3" targetptr="ADMQS0833"> <ttl>Example: Creating an Index</ttl> <xreftext>“Example: Creating an Index”</xreftext> <obj element="bridgehead" href="schema.htm" number="" targetptr="ADMQS12298"> <ttl>To create a supplier index on the SH.PRODUCTS table:</ttl> <xreftext>“To create a supplier index on the SH.PRODUCTS table:”</xreftext> </obj> </div> <div element="sect2" href="schema.htm" number="8.4.4" targetptr="ADMQS0834"> <ttl>Example: Deleting an Index</ttl> <xreftext>“Example: Deleting an Index”</xreftext> <obj element="bridgehead" href="schema.htm" number="" targetptr="ADMQS12299"> <ttl>To delete the supplier index on the SH.PRODUCTS table:</ttl> <xreftext>“To delete the supplier index on the SH.PRODUCTS table:”</xreftext> </obj> </div> </div> <div element="sect1" href="schema.htm" number="8.5" targetptr="ADMQS084"> <ttl>Managing Views</ttl> <xreftext>“Managing Views”</xreftext> <div element="sect2" href="schema.htm" number="8.5.1" targetptr="ADMQS0841"> <ttl>About Views</ttl> <xreftext>“About Views”</xreftext> <obj element="bridgehead" href="schema.htm" number="" targetptr="ADMQS12300"> <ttl>Static Data Dictionary Views</ttl> <xreftext>“Static Data Dictionary Views”</xreftext> </obj> <obj element="bridgehead" href="schema.htm" number="" targetptr="ADMQS12301"> <ttl>Dynamic Performance Views</ttl> <xreftext>“Dynamic Performance Views”</xreftext> </obj> </div> <div element="sect2" href="schema.htm" number="8.5.2" targetptr="ADMQS0842"> <ttl>Displaying Views</ttl> <xreftext>“Displaying Views”</xreftext> <obj element="bridgehead" href="schema.htm" number="" targetptr="ADMQS12302"> <ttl>To display views:</ttl> <xreftext>“To display views:”</xreftext> </obj> </div> <div element="sect2" href="schema.htm" number="8.5.3" targetptr="ADMQS0843"> <ttl>Example: Creating a View</ttl> <xreftext>“Example: Creating a View”</xreftext> <obj element="bridgehead" href="schema.htm" number="" targetptr="ADMQS12303"> <ttl>To create the KING_VIEW view on the HR.EMPLOYEES table:</ttl> <xreftext>“To create the KING_VIEW view on the HR.EMPLOYEES table:”</xreftext> </obj> <obj element="bridgehead" href="schema.htm" number="" targetptr="ADMQS12304"> <ttl>To test the new KING_VIEW view:</ttl> <xreftext>“To test the new KING_VIEW view:”</xreftext> </obj> </div> <div element="sect2" href="schema.htm" number="8.5.4" targetptr="ADMQS0844"> <ttl>Example: Deleting a View</ttl> <xreftext>“Example: Deleting a View”</xreftext> <obj element="bridgehead" href="schema.htm" number="" targetptr="ADMQS12305"> <ttl>To delete the HR.KING_VIEW view:</ttl> <xreftext>“To delete the HR.KING_VIEW view:”</xreftext> </obj> </div> </div> <div element="sect1" href="schema.htm" number="8.6" targetptr="ADMQS085"> <ttl>Managing Program Code Stored in the Database</ttl> <xreftext>“Managing Program Code Stored in the Database”</xreftext> <div element="sect2" href="schema.htm" number="8.6.1" targetptr="ADMQS12097"> <ttl>About Program Code Stored in the Database</ttl> <xreftext>“About Program Code Stored in the Database”</xreftext> </div> <div element="sect2" href="schema.htm" number="8.6.2" targetptr="ADMQS12098"> <ttl>Validating (Compiling) Invalid Schema Objects</ttl> <xreftext>“Validating (Compiling) Invalid Schema Objects”</xreftext> <obj element="bridgehead" href="schema.htm" number="" targetptr="ADMQS12306"> <ttl>To validate schema objects starting from an alert:</ttl> <xreftext>“To validate schema objects starting from an alert:”</xreftext> </obj> <obj element="bridgehead" href="schema.htm" number="" targetptr="ADMQS12307"> <ttl>To validate a schema object starting from an object page:</ttl> <xreftext>“To validate a schema object starting from an object page:”</xreftext> </obj> </div> </div> <div element="sect1" href="schema.htm" number="8.7" targetptr="ADMQS086"> <ttl>Working with Other Schema Objects</ttl> <xreftext>“Working with Other Schema Objects”</xreftext> </div> <div element="sect1" href="schema.htm" number="8.8" targetptr="ADMQS087"> <ttl>Schemas: Oracle By Example Series</ttl> <xreftext>“Schemas: Oracle By Example Series”</xreftext> </div> <div element="chapter" href="backrest.htm" number="9" targetptr="ADMQS009"> <ttl>Performing Backup and Recovery</ttl> <xreftext>“Performing Backup and Recovery”</xreftext> <div element="sect1" href="backrest.htm" number="9.1" targetptr="ADMQS091"> <ttl>Overview of Database Backup and Recovery</ttl> <xreftext>“Overview of Database Backup and Recovery”</xreftext> </div> <div element="sect1" href="backrest.htm" number="9.2" targetptr="ADMQS0911"> <ttl>Database Backup and Recovery Concepts</ttl> <xreftext>“Database Backup and Recovery Concepts”</xreftext> <div element="sect2" href="backrest.htm" number="9.2.1" targetptr="ADMQS09111"> <ttl>Consistent and Inconsistent Backups</ttl> <xreftext>“Consistent and Inconsistent Backups”</xreftext> </div> <div element="sect2" href="backrest.htm" number="9.2.2" targetptr="ADMQS09112"> <ttl>Media Recovery</ttl> <xreftext>“Media Recovery”</xreftext> </div> <div element="sect2" href="backrest.htm" number="9.2.3" targetptr="ADMQS09113"> <ttl>Fast Recovery Area</ttl> <xreftext>“Fast Recovery Area”</xreftext> </div> <div element="sect2" href="backrest.htm" number="9.2.4" targetptr="ADMQS09114"> <ttl>RMAN Repository</ttl> <xreftext>“RMAN Repository”</xreftext> </div> </div> <div element="sect1" href="backrest.htm" number="9.3" targetptr="ADMQS092"> <ttl>Configuring Your Database for Basic Backup and Recovery</ttl> <xreftext>“Configuring Your Database for Basic Backup and Recovery”</xreftext> <div element="sect2" href="backrest.htm" number="9.3.1" targetptr="ADMQS0922"> <ttl>Specifying Credentials for Backup and Recovery Using Database Control</ttl> <xreftext>“Specifying Credentials for Backup and Recovery Using Database Control”</xreftext> <obj element="bridgehead" href="backrest.htm" number="" targetptr="ADMQS12217"> <ttl>To enter credentials for backup and recovery tasks:</ttl> <xreftext>“To enter credentials for backup and recovery tasks:”</xreftext> </obj> </div> <div element="sect2" href="backrest.htm" number="9.3.2" targetptr="ADMQS0921"> <ttl>Planning Space Usage and Location for the Fast Recovery Area</ttl> <xreftext>“Planning Space Usage and Location for the Fast Recovery Area”</xreftext> <div element="sect3" href="backrest.htm" number="9.3.2.1" targetptr="ADMQS09211"> <ttl>About the Backup Retention Policy and the Fast Recovery Area</ttl> <xreftext>“About the Backup Retention Policy and the Fast Recovery Area”</xreftext> </div> <div element="sect3" href="backrest.htm" number="9.3.2.2" targetptr="ADMQS09212"> <ttl>About the Fast Recovery Area Size</ttl> <xreftext>“About the Fast Recovery Area Size”</xreftext> </div> </div> <div element="sect2" href="backrest.htm" number="9.3.3" targetptr="ADMQS099"> <ttl>Configuring Recovery Settings</ttl> <xreftext>“Configuring Recovery Settings”</xreftext> <obj element="bridgehead" href="backrest.htm" number="" targetptr="ADMQS12218"> <ttl>To configure a fast recovery area and put the database in ARCHIVELOG mode:</ttl> <xreftext>“To configure a fast recovery area and put the database in <code><span class="codeinlinebold">ARCHIVELOG</span></code> mode:”</xreftext> </obj> </div> <div element="sect2" href="backrest.htm" number="9.3.4" targetptr="ADMQS12106"> <ttl>Monitoring Fast Recovery Area Usage</ttl> <xreftext>“Monitoring Fast Recovery Area Usage”</xreftext> <obj element="bridgehead" href="backrest.htm" number="" targetptr="ADMQS12219"> <ttl>To monitor available space in the fast recovery area:</ttl> <xreftext>“To monitor available space in the fast recovery area:”</xreftext> </obj> </div> <div element="sect2" href="backrest.htm" number="9.3.5" targetptr="ADMQS0925"> <ttl>Configuring Backup Settings</ttl> <xreftext>“Configuring Backup Settings”</xreftext> <div element="sect3" href="backrest.htm" number="9.3.5.1" targetptr="ADMQS0926"> <ttl>About RMAN Backups</ttl> <xreftext>“About RMAN Backups”</xreftext> </div> <div element="sect3" href="backrest.htm" number="9.3.5.2" targetptr="ADMQS09255"> <ttl>Configuring Backup Device Settings</ttl> <xreftext>“Configuring Backup Device Settings”</xreftext> <obj element="bridgehead" href="backrest.htm" number="" targetptr="ADMQS12220"> <ttl>To configure backup settings for disk:</ttl> <xreftext>“To configure backup settings for disk:”</xreftext> </obj> </div> <div element="sect3" href="backrest.htm" number="9.3.5.3" targetptr="ADMQS09252"> <ttl>Configuring Backup Policy Settings</ttl> <xreftext>“Configuring Backup Policy Settings”</xreftext> <obj element="bridgehead" href="backrest.htm" number="" targetptr="ADMQS12221"> <ttl>To configure the backup policy settings:</ttl> <xreftext>“To configure the backup policy settings:”</xreftext> </obj> </div> </div> </div> <div element="sect1" href="backrest.htm" number="9.4" targetptr="ADMQS093"> <ttl>Backing Up Your Database</ttl> <xreftext>“Backing Up Your Database”</xreftext> <div element="sect2" href="backrest.htm" number="9.4.1" targetptr="ADMQS0931"> <ttl>RMAN Backup Concepts</ttl> <xreftext>“RMAN Backup Concepts”</xreftext> <div element="sect3" href="backrest.htm" number="9.4.1.1" targetptr="ADMQS09311"> <ttl>Full Backups of Data Files</ttl> <xreftext>“Full Backups of Data Files”</xreftext> </div> <div element="sect3" href="backrest.htm" number="9.4.1.2" targetptr="ADMQS09312"> <ttl>Incremental Backups of Data Files</ttl> <xreftext>“Incremental Backups of Data Files”</xreftext> </div> <div element="sect3" href="backrest.htm" number="9.4.1.3" targetptr="ADMQS09313"> <ttl>Incrementally Updated Backups: Rolling Forward Image Copies of Data Files</ttl> <xreftext>“Incrementally Updated Backups: Rolling Forward Image Copies of Data Files”</xreftext> </div> <div element="sect3" href="backrest.htm" number="9.4.1.4" targetptr="ADMQS09314"> <ttl>Backup Tags</ttl> <xreftext>“Backup Tags”</xreftext> </div> </div> <div element="sect2" href="backrest.htm" number="9.4.2" targetptr="ADMQS0932"> <ttl>Performing and Scheduling Backups Using Database Control</ttl> <xreftext>“Performing and Scheduling Backups Using Database Control”</xreftext> <div element="sect3" href="backrest.htm" number="9.4.2.1" targetptr="ADMQS09321"> <ttl>Performing a Whole Database Backup</ttl> <xreftext>“Performing a Whole Database Backup”</xreftext> <obj element="bridgehead" href="backrest.htm" number="" targetptr="ADMQS12222"> <ttl>To perform a whole database backup when the database is open:</ttl> <xreftext>“To perform a whole database backup when the database is open:”</xreftext> </obj> <obj element="bridgehead" href="backrest.htm" number="" targetptr="ADMQS12223"> <ttl>To perform a whole database backup when the database is closed:</ttl> <xreftext>“To perform a whole database backup when the database is closed:”</xreftext> </obj> </div> <div element="sect3" href="backrest.htm" number="9.4.2.2" targetptr="ADMQS09322"> <ttl>Using the Oracle Suggested Backup Strategy</ttl> <xreftext>“Using the Oracle Suggested Backup Strategy”</xreftext> <div element="sect4" href="backrest.htm" number="9.4.2.2.1" targetptr="ADMQS12224"> <ttl>About the Oracle Suggested Backup Strategy</ttl> <xreftext>“About the Oracle Suggested Backup Strategy”</xreftext> </div> <div element="sect4" href="backrest.htm" number="9.4.2.2.2" targetptr="ADMQS09325"> <ttl>Backing Up Your Database Using the Oracle Suggested Disk Backup Strategy</ttl> <xreftext>“Backing Up Your Database Using the Oracle Suggested Disk Backup Strategy”</xreftext> <obj element="bridgehead" href="backrest.htm" number="" targetptr="ADMQS12225"> <ttl>To backup your database using the Oracle-suggested disk backup strategy:</ttl> <xreftext>“To backup your database using the Oracle-suggested disk backup strategy:”</xreftext> </obj> </div> </div> <div element="sect3" href="backrest.htm" number="9.4.2.3" targetptr="ADMQS09323"> <ttl>Scheduling Miscellaneous Backup Tasks</ttl> <xreftext>“Scheduling Miscellaneous Backup Tasks”</xreftext> <obj element="bridgehead" href="backrest.htm" number="" targetptr="ADMQS12226"> <ttl>To schedule miscellaneous backup tasks:</ttl> <xreftext>“To schedule miscellaneous backup tasks:”</xreftext> </obj> </div> </div> <div element="sect2" href="backrest.htm" number="9.4.3" targetptr="ADMQS0933"> <ttl>Validating Backups and Testing Your Backup Strategy</ttl> <xreftext>“Validating Backups and Testing Your Backup Strategy”</xreftext> <div element="sect3" href="backrest.htm" number="9.4.3.1" targetptr="ADMQS09525"> <ttl>Validating Selected Backups</ttl> <xreftext>“Validating Selected Backups”</xreftext> <obj element="bridgehead" href="backrest.htm" number="" targetptr="ADMQS12227"> <ttl>To validate selected backups:</ttl> <xreftext>“To validate selected backups:”</xreftext> </obj> </div> <div element="sect3" href="backrest.htm" number="9.4.3.2" targetptr="ADMQS0942"> <ttl>Validating Backups for Restore Operations</ttl> <xreftext>“Validating Backups for Restore Operations”</xreftext> <obj element="bridgehead" href="backrest.htm" number="" targetptr="ADMQS12228"> <ttl>To verify whether specified database files can be restored:</ttl> <xreftext>“To verify whether specified database files can be restored:”</xreftext> </obj> </div> </div> </div> <div element="sect1" href="backrest.htm" number="9.5" targetptr="ADMQS096"> <ttl>Displaying Backup Reports</ttl> <xreftext>“Displaying Backup Reports”</xreftext> <obj element="bridgehead" href="backrest.htm" number="" targetptr="ADMQS12229"> <ttl>To display backup reports:</ttl> <xreftext>“To display backup reports:”</xreftext> </obj> </div> <div element="sect1" href="backrest.htm" number="9.6" targetptr="ADMQS095"> <ttl>Managing Backups</ttl> <xreftext>“Managing Backups”</xreftext> <div element="sect2" href="backrest.htm" number="9.6.1" targetptr="ADMQS0951"> <ttl>About Backup Management</ttl> <xreftext>“About Backup Management”</xreftext> </div> <div element="sect2" href="backrest.htm" number="9.6.2" targetptr="ADMQS0953"> <ttl>Cross-Checking Backups</ttl> <xreftext>“Cross-Checking Backups”</xreftext> <obj element="bridgehead" href="backrest.htm" number="" targetptr="ADMQS12230"> <ttl>To cross-check individual files:</ttl> <xreftext>“To cross-check individual files:”</xreftext> </obj> <obj element="bridgehead" href="backrest.htm" number="" targetptr="ADMQS12231"> <ttl>To cross-check all files:</ttl> <xreftext>“To cross-check all files:”</xreftext> </obj> </div> <div element="sect2" href="backrest.htm" number="9.6.3" targetptr="ADMQS0954"> <ttl>Deleting Expired Backups</ttl> <xreftext>“Deleting Expired Backups”</xreftext> <obj element="bridgehead" href="backrest.htm" number="" targetptr="ADMQS12232"> <ttl>To delete expired backups:</ttl> <xreftext>“To delete expired backups:”</xreftext> </obj> </div> <div element="sect2" href="backrest.htm" number="9.6.4" targetptr="ADMQS0955"> <ttl>Marking Backups as Available or Unavailable</ttl> <xreftext>“Marking Backups as Available or Unavailable”</xreftext> <obj element="bridgehead" href="backrest.htm" number="" targetptr="ADMQS12233"> <ttl>To mark backups as available or unavailable:</ttl> <xreftext>“To mark backups as available or unavailable:”</xreftext> </obj> </div> <div element="sect2" href="backrest.htm" number="9.6.5" targetptr="ADMQS0956"> <ttl>Deleting Obsolete Backups</ttl> <xreftext>“Deleting Obsolete Backups”</xreftext> <obj element="bridgehead" href="backrest.htm" number="" targetptr="ADMQS12234"> <ttl>To delete obsolete backups:</ttl> <xreftext>“To delete obsolete backups:”</xreftext> </obj> </div> </div> <div element="sect1" href="backrest.htm" number="9.7" targetptr="ADMQS098"> <ttl>Performing Oracle Advised Recovery</ttl> <xreftext>“Performing Oracle Advised Recovery”</xreftext> <div element="sect2" href="backrest.htm" number="9.7.1" targetptr="ADMQS100"> <ttl>About Data Recovery Advisor</ttl> <xreftext>“About Data Recovery Advisor”</xreftext> </div> <div element="sect2" href="backrest.htm" number="9.7.2" targetptr="ADMQS0982"> <ttl>Using Data Recovery Advisor</ttl> <xreftext>“Using Data Recovery Advisor”</xreftext> <obj element="bridgehead" href="backrest.htm" number="" targetptr="ADMQS12235"> <ttl>To use the Oracle advised recovery strategy:</ttl> <xreftext>“To use the Oracle advised recovery strategy:”</xreftext> </obj> </div> </div> <div element="sect1" href="backrest.htm" number="9.8" targetptr="ADMQS094"> <ttl>Performing User-Directed Recovery</ttl> <xreftext>“Performing User-Directed Recovery”</xreftext> <div element="sect2" href="backrest.htm" number="9.8.1" targetptr="ADMQS0943"> <ttl>Rewinding a Table Using Oracle Flashback Table</ttl> <xreftext>“Rewinding a Table Using Oracle Flashback Table”</xreftext> <div element="sect3" href="backrest.htm" number="9.8.1.1" targetptr="ADMQS09431"> <ttl>Enabling Row Movement on a Table</ttl> <xreftext>“Enabling Row Movement on a Table”</xreftext> <obj element="bridgehead" href="backrest.htm" number="" targetptr="ADMQS12236"> <ttl>To enable row movement on a table:</ttl> <xreftext>“To enable row movement on a table:”</xreftext> </obj> </div> <div element="sect3" href="backrest.htm" number="9.8.1.2" targetptr="ADMQS09432"> <ttl>Performing a Flashback Table Operation</ttl> <xreftext>“Performing a Flashback Table Operation”</xreftext> <obj element="bridgehead" href="backrest.htm" number="" targetptr="ADMQS12237"> <ttl>To perform the Flashback Table operation:</ttl> <xreftext>“To perform the Flashback Table operation:”</xreftext> </obj> </div> </div> <div element="sect2" href="backrest.htm" number="9.8.2" targetptr="ADMQS0944"> <ttl>Recovering a Dropped Table Using Oracle Flashback Drop</ttl> <xreftext>“Recovering a Dropped Table Using Oracle Flashback Drop”</xreftext> <div element="sect3" href="backrest.htm" number="9.8.2.1" targetptr="ADMQS0945"> <ttl>Dropping a Table</ttl> <xreftext>“Dropping a Table”</xreftext> <obj element="bridgehead" href="backrest.htm" number="" targetptr="ADMQS12238"> <ttl>To create and then drop a table:</ttl> <xreftext>“To create and then drop a table:”</xreftext> </obj> </div> <div element="sect3" href="backrest.htm" number="9.8.2.2" targetptr="ADMQS0946"> <ttl>Retrieving a Dropped Table</ttl> <xreftext>“Retrieving a Dropped Table”</xreftext> <obj element="bridgehead" href="backrest.htm" number="" targetptr="ADMQS12239"> <ttl>To perform the Flashback Drop operation:</ttl> <xreftext>“To perform the Flashback Drop operation:”</xreftext> </obj> </div> </div> <div element="sect2" href="backrest.htm" number="9.8.3" targetptr="ADMQS101"> <ttl>Rewinding a Database Using Oracle Flashback Database</ttl> <xreftext>“Rewinding a Database Using Oracle Flashback Database”</xreftext> <obj element="bridgehead" href="backrest.htm" number="" targetptr="ADMQS12240"> <ttl>To perform a Flashback Database operation:</ttl> <xreftext>“To perform a Flashback Database operation:”</xreftext> </obj> </div> <div element="sect2" href="backrest.htm" number="9.8.4" targetptr="ADMQS0941"> <ttl>Restoring and Recovering the Database</ttl> <xreftext>“Restoring and Recovering the Database”</xreftext> <obj element="bridgehead" href="backrest.htm" number="" targetptr="ADMQS12241"> <ttl>To restore and recover the entire database:</ttl> <xreftext>“To restore and recover the entire database:”</xreftext> </obj> </div> </div> <div element="sect1" href="backrest.htm" number="9.9" targetptr="ADMQS097"> <ttl>Backup and Recovery: Oracle By Example Series</ttl> <xreftext>“Backup and Recovery: Oracle By Example Series”</xreftext> </div> </div> <div element="chapter" href="montune.htm" number="10" targetptr="ADMQS010"> <ttl>Monitoring and Tuning the Database</ttl> <xreftext>“Monitoring and Tuning the Database”</xreftext> <div element="sect1" href="montune.htm" number="10.1" targetptr="ADMQS1001"> <ttl>Proactive Database Monitoring</ttl> <xreftext>“Proactive Database Monitoring”</xreftext> <div element="sect2" href="montune.htm" number="10.1.1" targetptr="ADMQS1011"> <ttl>About Alerts</ttl> <xreftext>“About Alerts”</xreftext> </div> <div element="sect2" href="montune.htm" number="10.1.2" targetptr="ADMQS1012"> <ttl>Performance Self-Diagnostics: Automatic Database Diagnostic Monitor</ttl> <xreftext>“Performance Self-Diagnostics: Automatic Database Diagnostic Monitor”</xreftext> </div> <div element="sect2" href="montune.htm" number="10.1.3" targetptr="ADMQS1013"> <ttl>Monitoring General Database State and Workload</ttl> <xreftext>“Monitoring General Database State and Workload”</xreftext> <obj element="figure" href="montune.htm" number="10-1" targetptr="CHDDICIF"> <ttl>Database Home Page</ttl> <xreftext>“Database Home Page”</xreftext> </obj> <obj element="bridgehead" href="montune.htm" number="" targetptr="ADMQS12242"> <ttl>To monitor the general database state and workload:</ttl> <xreftext>“To monitor the general database state and workload:”</xreftext> </obj> <obj element="bridgehead" href="montune.htm" number="" targetptr="ADMQS12243"> <ttl>To view database performance over time:</ttl> <xreftext>“To view database performance over time:”</xreftext> </obj> </div> <div element="sect2" href="montune.htm" number="10.1.4" targetptr="ADMQS1014"> <ttl>Managing Alerts</ttl> <xreftext>“Managing Alerts”</xreftext> <div element="sect3" href="montune.htm" number="10.1.4.1" targetptr="ADMQS10141"> <ttl>Viewing Metrics and Thresholds</ttl> <xreftext>“Viewing Metrics and Thresholds”</xreftext> <obj element="bridgehead" href="montune.htm" number="" targetptr="ADMQS12244"> <ttl>To view metrics for your database:</ttl> <xreftext>“To view metrics for your database:”</xreftext> </obj> <obj element="figure" href="montune.htm" number="10-2" targetptr="CHDIAJCD"> <ttl>Alerts Section of Database Home Page</ttl> <xreftext>“Alerts Section of Database Home Page”</xreftext> </obj> </div> <div element="sect3" href="montune.htm" number="10.1.4.2" targetptr="ADMQS10142"> <ttl>Setting Metric Thresholds</ttl> <xreftext>“Setting Metric Thresholds”</xreftext> <obj element="bridgehead" href="montune.htm" number="" targetptr="ADMQS12245"> <ttl>To set metric thresholds:</ttl> <xreftext>“To set metric thresholds:”</xreftext> </obj> </div> <div element="sect3" href="montune.htm" number="10.1.4.3" targetptr="ADMQS10143"> <ttl>About Responding to Alerts</ttl> <xreftext>“About Responding to Alerts”</xreftext> </div> <div element="sect3" href="montune.htm" number="10.1.4.4" targetptr="ADMQS10144"> <ttl>Clearing Alerts</ttl> <xreftext>“Clearing Alerts”</xreftext> <obj element="bridgehead" href="montune.htm" number="" targetptr="ADMQS12246"> <ttl>To clear or purge an alert:</ttl> <xreftext>“To clear or purge an alert:”</xreftext> </obj> </div> <div element="sect3" href="montune.htm" number="10.1.4.5" targetptr="ADMQS10145"> <ttl>Setting Up Direct Alert Notification</ttl> <xreftext>“Setting Up Direct Alert Notification”</xreftext> <obj element="bridgehead" href="montune.htm" number="" targetptr="ADMQS12247"> <ttl>To set up your e-mail information:</ttl> <xreftext>“To set up your e-mail information:”</xreftext> </obj> </div> </div> </div> <div element="sect1" href="montune.htm" number="10.2" targetptr="ADMQS102"> <ttl>Diagnosing Performance Problems Using ADDM</ttl> <xreftext>“Diagnosing Performance Problems Using ADDM”</xreftext> <div element="sect2" href="montune.htm" number="10.2.1" targetptr="ADMQS1021"> <ttl>Viewing a Summary of ADDM Performance Findings</ttl> <xreftext>“Viewing a Summary of ADDM Performance Findings”</xreftext> <obj element="bridgehead" href="montune.htm" number="" targetptr="ADMQS12248"> <ttl>To view a summary of ADDM performance findings:</ttl> <xreftext>“To view a summary of ADDM performance findings:”</xreftext> </obj> </div> <div element="sect2" href="montune.htm" number="10.2.2" targetptr="ADMQS1022"> <ttl>Responding to ADDM Performance Findings</ttl> <xreftext>“Responding to ADDM Performance Findings”</xreftext> <obj element="bridgehead" href="montune.htm" number="" targetptr="ADMQS12249"> <ttl>To respond to ADDM performance findings:</ttl> <xreftext>“To respond to ADDM performance findings:”</xreftext> </obj> </div> <div element="sect2" href="montune.htm" number="10.2.3" targetptr="ADMQS1024"> <ttl>Running ADDM Manually</ttl> <xreftext>“Running ADDM Manually”</xreftext> <obj element="bridgehead" href="montune.htm" number="" targetptr="ADMQS12250"> <ttl>To run ADDM manually:</ttl> <xreftext>“To run ADDM manually:”</xreftext> </obj> </div> <div element="sect2" href="montune.htm" number="10.2.4" targetptr="ADMQS1023"> <ttl>Modifying AWR Snapshot Frequency and Retention</ttl> <xreftext>“Modifying AWR Snapshot Frequency and Retention”</xreftext> <obj element="bridgehead" href="montune.htm" number="" targetptr="ADMQS12251"> <ttl>To modify AWR snapshot frequency and retention:</ttl> <xreftext>“To modify AWR snapshot frequency and retention:”</xreftext> </obj> </div> </div> <div element="sect1" href="montune.htm" number="10.3" targetptr="ADMQS103"> <ttl>Using Advisors to Optimize Database Performance</ttl> <xreftext>“Using Advisors to Optimize Database Performance”</xreftext> <div element="sect2" href="montune.htm" number="10.3.1" targetptr="ADMQS1031"> <ttl>About Advisors</ttl> <xreftext>“About Advisors”</xreftext> <obj element="table" href="montune.htm" number="10-1" targetptr="ADMQS12347"> <ttl>Performance Advisors</ttl> <xreftext>“Performance Advisors”</xreftext> </obj> <obj element="table" href="montune.htm" number="10-2" targetptr="ADMQS12348"> <ttl>Other Advisors</ttl> <xreftext>“Other Advisors”</xreftext> </obj> </div> <div element="sect2" href="montune.htm" number="10.3.2" targetptr="ADMQS1036"> <ttl>About the SQL Advisors</ttl> <xreftext>“About the SQL Advisors”</xreftext> <obj element="bridgehead" href="montune.htm" number="" targetptr="ADMQS12252"> <ttl>SQL Tuning Advisor</ttl> <xreftext>“SQL Tuning Advisor”</xreftext> </obj> <obj element="bridgehead" href="montune.htm" number="" targetptr="ADMQS12253"> <ttl>SQL Access Advisor</ttl> <xreftext>“SQL Access Advisor”</xreftext> </obj> <obj element="bridgehead" href="montune.htm" number="" targetptr="ADMQS12254"> <ttl>Statement Tuning and Workload Tuning</ttl> <xreftext>“Statement Tuning and Workload Tuning”</xreftext> </obj> </div> <div element="sect2" href="montune.htm" number="10.3.3" targetptr="ADMQS1037"> <ttl>About the Automatic SQL Tuning Advisor</ttl> <xreftext>“About the Automatic SQL Tuning Advisor”</xreftext> </div> <div element="sect2" href="montune.htm" number="10.3.4" targetptr="ADMQS1038"> <ttl>Configuring the Automatic SQL Tuning Advisor</ttl> <xreftext>“Configuring the Automatic SQL Tuning Advisor”</xreftext> <obj element="bridgehead" href="montune.htm" number="" targetptr="ADMQS12255"> <ttl>To configure the Automatic SQL Tuning Advisor:</ttl> <xreftext>“To configure the Automatic SQL Tuning Advisor:”</xreftext> </obj> </div> <div element="sect2" href="montune.htm" number="10.3.5" targetptr="ADMQS1035"> <ttl>Viewing Automatic SQL Tuning Results</ttl> <xreftext>“Viewing Automatic SQL Tuning Results”</xreftext> <obj element="bridgehead" href="montune.htm" number="" targetptr="ADMQS12256"> <ttl>To view automatic SQL tuning results:</ttl> <xreftext>“To view automatic SQL tuning results:”</xreftext> </obj> </div> <div element="sect2" href="montune.htm" number="10.3.6" targetptr="ADMQS1032"> <ttl>Running the SQL Tuning Advisor</ttl> <xreftext>“Running the SQL Tuning Advisor”</xreftext> <obj element="bridgehead" href="montune.htm" number="" targetptr="ADMQS12257"> <ttl>To run the SQL Tuning Advisor:</ttl> <xreftext>“To run the SQL Tuning Advisor:”</xreftext> </obj> </div> <div element="sect2" href="montune.htm" number="10.3.7" targetptr="ADMQS1033"> <ttl>Running the SQL Access Advisor</ttl> <xreftext>“Running the SQL Access Advisor”</xreftext> <obj element="bridgehead" href="montune.htm" number="" targetptr="ADMQS12258"> <ttl>To run the SQL Access Advisor:</ttl> <xreftext>“To run the SQL Access Advisor:”</xreftext> </obj> </div> <div element="sect2" href="montune.htm" number="10.3.8" targetptr="ADMQS1034"> <ttl>Optimizing Memory Usage with the Memory Advisors</ttl> <xreftext>“Optimizing Memory Usage with the Memory Advisors”</xreftext> <div element="sect3" href="montune.htm" number="10.3.8.1" targetptr="ADMQS12321"> <ttl>About the Memory Advisors</ttl> <xreftext>“About the Memory Advisors”</xreftext> </div> <div element="sect3" href="montune.htm" number="10.3.8.2" targetptr="ADMQS10342"> <ttl>Example: Obtaining Memory Sizing Advice for ASMM</ttl> <xreftext>“Example: Obtaining Memory Sizing Advice for ASMM”</xreftext> <obj element="bridgehead" href="montune.htm" number="" targetptr="ADMQS12259"> <ttl>To obtain memory sizing advice for ASMM:</ttl> <xreftext>“To obtain memory sizing advice for ASMM:”</xreftext> </obj> <obj element="figure" href="montune.htm" number="10-3" targetptr="ADMQS12349"> <ttl>SGA Size Advice</ttl> <xreftext>“SGA Size Advice”</xreftext> </obj> </div> </div> </div> <div element="sect1" href="montune.htm" number="10.4" targetptr="ADMQS104"> <ttl>Monitoring and Tuning: Oracle By Example Series</ttl> <xreftext>“Monitoring and Tuning: Oracle By Example Series”</xreftext> </div> </div> <div element="chapter" href="problems.htm" number="11" targetptr="ADMQS12010"> <ttl>Investigating, Reporting, and Resolving Problems</ttl> <xreftext>“Investigating, Reporting, and Resolving Problems”</xreftext> <div element="sect1" href="problems.htm" number="11.1" targetptr="ADMQS12011"> <ttl>About Database Problems and Incidents</ttl> <xreftext>“About Database Problems and Incidents”</xreftext> </div> <div element="sect1" href="problems.htm" number="11.2" targetptr="ADMQS12107"> <ttl>Investigating, Reporting, and Resolving a Problem</ttl> <xreftext>“Investigating, Reporting, and Resolving a Problem”</xreftext> <div element="sect2" href="problems.htm" number="11.2.1" targetptr="ADMQS12108"> <ttl>Roadmap: Investigating, Reporting, and Resolving a Problem</ttl> <xreftext>“Roadmap: Investigating, Reporting, and Resolving a Problem”</xreftext> <obj element="figure" href="problems.htm" number="11-1" targetptr="ADMQS12350"> <ttl>Workflow for Investigating, Reporting, and Resolving a Problem</ttl> <xreftext>“Workflow for Investigating, Reporting, and Resolving a Problem”</xreftext> </obj> </div> <div element="sect2" href="problems.htm" number="11.2.2" targetptr="ADMQS12109"> <ttl>Task 1 – View Critical Error Alerts in Enterprise Manager</ttl> <xreftext>“Task 1 – View Critical Error Alerts in Enterprise Manager”</xreftext> <obj element="bridgehead" href="problems.htm" number="" targetptr="ADMQS12260"> <ttl>To view critical error alerts:</ttl> <xreftext>“To view critical error alerts:”</xreftext> </obj> </div> <div element="sect2" href="problems.htm" number="11.2.3" targetptr="ADMQS12110"> <ttl>Task 2 – View Problem Details</ttl> <xreftext>“Task 2 – View Problem Details”</xreftext> <obj element="bridgehead" href="problems.htm" number="" targetptr="ADMQS12261"> <ttl>To view problem details:</ttl> <xreftext>“To view problem details:”</xreftext> </obj> </div> <div element="sect2" href="problems.htm" number="11.2.4" targetptr="ADMQS12111"> <ttl>Task 3 – (Optional) Create a Service Request</ttl> <xreftext>“Task 3 – (Optional) Create a Service Request”</xreftext> <obj element="bridgehead" href="problems.htm" number="" targetptr="ADMQS12262"> <ttl>To create a service request:</ttl> <xreftext>“To create a service request:”</xreftext> </obj> </div> <div element="sect2" href="problems.htm" number="11.2.5" targetptr="ADMQS12112"> <ttl>Task 4 – Package and Upload Diagnostic Data to Oracle Support Services</ttl> <xreftext>“Task 4 – Package and Upload Diagnostic Data to Oracle Support Services”</xreftext> <obj element="bridgehead" href="problems.htm" number="" targetptr="ADMQS12263"> <ttl>To package and upload diagnostic data to Oracle Support:</ttl> <xreftext>“To package and upload diagnostic data to Oracle Support:”</xreftext> </obj> </div> <div element="sect2" href="problems.htm" number="11.2.6" targetptr="ADMQS12113"> <ttl>Task 5 – Track the Service Request and Implement Any Repairs</ttl> <xreftext>“Task 5 – Track the Service Request and Implement Any Repairs”</xreftext> <obj element="table" href="problems.htm" number="11-1" targetptr="ADMQS12351"> <ttl>Oracle Advisors that Help Repair Critical Errors</ttl> <xreftext>“Oracle Advisors that Help Repair Critical Errors”</xreftext> </obj> </div> <div element="sect2" href="problems.htm" number="11.2.7" targetptr="ADMQS12114"> <ttl>Task 6 – Close Incidents</ttl> <xreftext>“Task 6 – Close Incidents”</xreftext> <obj element="bridgehead" href="problems.htm" number="" targetptr="ADMQS12264"> <ttl>To close incidents:</ttl> <xreftext>“To close incidents:”</xreftext> </obj> </div> </div> <div element="sect1" href="problems.htm" number="11.3" targetptr="ADMQS12115"> <ttl>Viewing Problems Using the Enterprise Manager Support Workbench</ttl> <xreftext>“Viewing Problems Using the Enterprise Manager Support Workbench”</xreftext> <obj element="bridgehead" href="problems.htm" number="" targetptr="ADMQS12265"> <ttl>To access the Support Workbench home page:</ttl> <xreftext>“To access the Support Workbench home page:”</xreftext> </obj> <obj element="bridgehead" href="problems.htm" number="" targetptr="ADMQS12266"> <ttl>To view details for a particular problem:</ttl> <xreftext>“To view details for a particular problem:”</xreftext> </obj> </div> </div> <div element="chapter" href="software.htm" number="12" targetptr="ADMQS1100"> <ttl>Managing Oracle Database Software</ttl> <xreftext>“Managing Oracle Database Software”</xreftext> <div element="sect1" href="software.htm" number="12.1" targetptr="ADMQS111"> <ttl>About Software Management and Patch Releases</ttl> <xreftext>“About Software Management and Patch Releases”</xreftext> </div> <div element="sect1" href="software.htm" number="12.2" targetptr="ADMQS112"> <ttl>Patching the Oracle Software</ttl> <xreftext>“Patching the Oracle Software”</xreftext> <div element="sect2" href="software.htm" number="12.2.1" targetptr="ADMQS1121"> <ttl>Determining Your Oracle Database Environment</ttl> <xreftext>“Determining Your Oracle Database Environment”</xreftext> <obj element="bridgehead" href="software.htm" number="" targetptr="ADMQS12267"> <ttl>To determine the Oracle Database version:</ttl> <xreftext>“To determine the Oracle Database version:”</xreftext> </obj> <obj element="bridgehead" href="software.htm" number="" targetptr="ADMQS12268"> <ttl>To determine the location of your Oracle home:</ttl> <xreftext>“To determine the location of your Oracle home:”</xreftext> </obj> <obj element="bridgehead" href="software.htm" number="" targetptr="ADMQS12269"> <ttl>To view information about your hardware configuration:</ttl> <xreftext>“To view information about your hardware configuration:”</xreftext> </obj> </div> <div element="sect2" href="software.htm" number="12.2.2" targetptr="ADMQS1122"> <ttl>Setting Your My Oracle Support Credentials</ttl> <xreftext>“Setting Your My Oracle Support Credentials”</xreftext> <obj element="bridgehead" href="software.htm" number="" targetptr="ADMQS12270"> <ttl>To set your My Oracle Support login credentials:</ttl> <xreftext>“To set your My Oracle Support login credentials:”</xreftext> </obj> </div> <div element="sect2" href="software.htm" number="12.2.3" targetptr="ADMQS12372"> <ttl>Configure the Software Library</ttl> <xreftext>“Configure the Software Library”</xreftext> <obj element="bridgehead" href="software.htm" number="" targetptr="ADMQS12373"> <ttl>To configure the Software Library before using the Patch Interface of Database Control:</ttl> <xreftext>“To configure the Software Library before using the Patch Interface of Database Control:”</xreftext> </obj> </div> <div element="sect2" href="software.htm" number="12.2.4" targetptr="ADMQS1123"> <ttl>Staging and Applying Patches and Patch Sets</ttl> <xreftext>“Staging and Applying Patches and Patch Sets”</xreftext> <obj element="bridgehead" href="software.htm" number="" targetptr="ADMQS12271"> <ttl>To stage and apply patches and patch sets using the Patching wizard:</ttl> <xreftext>“To stage and apply patches and patch sets using the Patching wizard:”</xreftext> </obj> </div> </div> <div element="sect1" href="software.htm" number="12.3" targetptr="ADMQS114"> <ttl>Viewing Critical Patch Advisories</ttl> <xreftext>“Viewing Critical Patch Advisories”</xreftext> <obj element="bridgehead" href="software.htm" number="" targetptr="ADMQS12273"> <ttl>To view the critical patch advisories and other recommended patches:</ttl> <xreftext>“To view the critical patch advisories and other recommended patches:”</xreftext> </obj> </div> <div element="sect1" href="software.htm" number="12.4" targetptr="ADMQS024"> <ttl>Upgrading a Database</ttl> <xreftext>“Upgrading a Database”</xreftext> <div element="sect2" href="software.htm" number="12.4.1" targetptr="ADMQS0241"> <ttl>Overview of Database Upgrade Assistant</ttl> <xreftext>“Overview of Database Upgrade Assistant”</xreftext> <obj element="bridgehead" href="software.htm" number="" targetptr="ADMQS12364"> <ttl>Pre-Upgrade Checks</ttl> <xreftext>“Pre-Upgrade Checks”</xreftext> </obj> <obj element="bridgehead" href="software.htm" number="" targetptr="ADMQS12365"> <ttl>Automated Upgrade Tasks</ttl> <xreftext>“Automated Upgrade Tasks”</xreftext> </obj> <obj element="bridgehead" href="software.htm" number="" targetptr="ADMQS12366"> <ttl>Support for Oracle Real Application Clusters</ttl> <xreftext>“Support for Oracle Real Application Clusters”</xreftext> </obj> <obj element="bridgehead" href="software.htm" number="" targetptr="ADMQS12367"> <ttl>About Upgrading Oracle Automatic Storage Management</ttl> <xreftext>“About Upgrading Oracle Automatic Storage Management”</xreftext> </obj> <obj element="bridgehead" href="software.htm" number="" targetptr="ADMQS12368"> <ttl>Support for Silent Mode</ttl> <xreftext>“Support for Silent Mode”</xreftext> </obj> </div> <div element="sect2" href="software.htm" number="12.4.2" targetptr="ADMQS0242"> <ttl>Database Versions Supported by DBUA</ttl> <xreftext>“Database Versions Supported by DBUA”</xreftext> </div> <div element="sect2" href="software.htm" number="12.4.3" targetptr="ADMQS0243"> <ttl>Starting DBUA</ttl> <xreftext>“Starting DBUA”</xreftext> <obj element="bridgehead" href="software.htm" number="" targetptr="ADMQS12274"> <ttl>To start DBUA on Microsoft Windows:</ttl> <xreftext>“To start DBUA on Microsoft Windows:”</xreftext> </obj> <obj element="bridgehead" href="software.htm" number="" targetptr="ADMQS12275"> <ttl>To start DBUA on any supported platform:</ttl> <xreftext>“To start DBUA on any supported platform:”</xreftext> </obj> </div> <div element="sect2" href="software.htm" number="12.4.4" targetptr="ADMQS0244"> <ttl>Upgrading a Database Using DBUA</ttl> <xreftext>“Upgrading a Database Using DBUA”</xreftext> <obj element="bridgehead" href="software.htm" number="" targetptr="ADMQS12276"> <ttl>To upgrade a database using DBUA:</ttl> <xreftext>“To upgrade a database using DBUA:”</xreftext> </obj> </div> </div> <div element="sect1" href="software.htm" number="12.5" targetptr="ADMQS113"> <ttl>Managing Oracle Software: Oracle By Example Series</ttl> <xreftext>“Managing Oracle Software: Oracle By Example Series”</xreftext> </div> </div> <div element="appendix" href="asm.htm" number="A" targetptr="ADMQS12100"> <ttl>Administering Oracle Automatic Storage Management</ttl> <xreftext>“Administering Oracle Automatic Storage Management”</xreftext> <div element="sect1" href="asm.htm" number="A.1" targetptr="ADMQS12078"> <ttl>About Oracle Automatic Storage Management</ttl> <xreftext>“About Oracle Automatic Storage Management”</xreftext> <obj element="bridgehead" href="asm.htm" number="" targetptr="ADMQS12277"> <ttl>The Oracle ASM Instance</ttl> <xreftext>“The Oracle ASM Instance”</xreftext> </obj> <obj element="bridgehead" href="asm.htm" number="" targetptr="ADMQS12278"> <ttl>Administering Oracle ASM</ttl> <xreftext>“Administering Oracle ASM”</xreftext> </obj> </div> <div element="sect1" href="asm.htm" number="A.2" targetptr="ADMQS12079"> <ttl>Overview of Disks, Disk Groups, and Failure Groups</ttl> <xreftext>“Overview of Disks, Disk Groups, and Failure Groups”</xreftext> </div> <div element="sect1" href="asm.htm" number="A.3" targetptr="ADMQS12080"> <ttl>Installing Oracle Automatic Storage Management</ttl> <xreftext>“Installing Oracle Automatic Storage Management”</xreftext> </div> <div element="sect1" href="asm.htm" number="A.4" targetptr="ADMQS12081"> <ttl>Accessing the Oracle Automatic Storage Management Home Page</ttl> <xreftext>“Accessing the Oracle Automatic Storage Management Home Page”</xreftext> <div element="sect2" href="asm.htm" number="A.4.1" targetptr="ADMQS12082"> <ttl>Accessing the Oracle ASM Home Page on a Single-Instance System</ttl> <xreftext>“Accessing the Oracle ASM Home Page on a Single-Instance System”</xreftext> <obj element="bridgehead" href="asm.htm" number="" targetptr="ADMQS12279"> <ttl>To access the Oracle ASM Home page on a single-instance system:</ttl> <xreftext>“To access the Oracle ASM Home page on a single-instance system:”</xreftext> </obj> </div> <div element="sect2" href="asm.htm" number="A.4.2" targetptr="ADMQS12083"> <ttl>Accessing the Oracle ASM Home Page on an Oracle RAC System</ttl> <xreftext>“Accessing the Oracle ASM Home Page on an Oracle RAC System”</xreftext> <obj element="bridgehead" href="asm.htm" number="" targetptr="ADMQS12280"> <ttl>To access the Oracle ASM Home page on an Oracle RAC system:</ttl> <xreftext>“To access the Oracle ASM Home page on an Oracle RAC system:”</xreftext> </obj> </div> </div> <div element="sect1" href="asm.htm" number="A.5" targetptr="ADMQS12084"> <ttl>Monitoring Disk Group Space Usage</ttl> <xreftext>“Monitoring Disk Group Space Usage”</xreftext> <obj element="bridgehead" href="asm.htm" number="" targetptr="ADMQS12281"> <ttl>To view Oracle Automatic Storage Management (Oracle ASM) disk group usage and free space:</ttl> <xreftext>“To view Oracle Automatic Storage Management (Oracle ASM) disk group usage and free space:”</xreftext> </obj> </div> <div element="sect1" href="asm.htm" number="A.6" targetptr="ADMQS12085"> <ttl>Creating a Disk Group</ttl> <xreftext>“Creating a Disk Group”</xreftext> <obj element="bridgehead" href="asm.htm" number="" targetptr="ADMQS12282"> <ttl>To create a disk group:</ttl> <xreftext>“To create a disk group:”</xreftext> </obj> </div> <div element="sect1" href="asm.htm" number="A.7" targetptr="ADMQS12086"> <ttl>Dropping a Disk Group</ttl> <xreftext>“Dropping a Disk Group”</xreftext> <obj element="bridgehead" href="asm.htm" number="" targetptr="ADMQS12283"> <ttl>To drop a disk group:</ttl> <xreftext>“To drop a disk group:”</xreftext> </obj> </div> <div element="sect1" href="asm.htm" number="A.8" targetptr="ADMQS12087"> <ttl>Adding Disks to a Disk Group</ttl> <xreftext>“Adding Disks to a Disk Group”</xreftext> <obj element="bridgehead" href="asm.htm" number="" targetptr="ADMQS12284"> <ttl>To add one or more disks to a disk group:</ttl> <xreftext>“To add one or more disks to a disk group:”</xreftext> </obj> </div> <div element="sect1" href="asm.htm" number="A.9" targetptr="ADMQS12088"> <ttl>Dropping Disks from a Disk Group</ttl> <xreftext>“Dropping Disks from a Disk Group”</xreftext> <obj element="bridgehead" href="asm.htm" number="" targetptr="ADMQS12285"> <ttl>To drop one or more disks from a disk group:</ttl> <xreftext>“To drop one or more disks from a disk group:”</xreftext> </obj> </div> <div element="sect1" href="asm.htm" number="A.10" targetptr="ADMQS12089"> <ttl>Backing Up Oracle ASM-Managed Files</ttl> <xreftext>“Backing Up Oracle ASM-Managed Files”</xreftext> </div> <div element="sect1" href="asm.htm" number="A.11" targetptr="ADMQS12103"> <ttl>Oracle Automatic Storage Management: Oracle By Example Series</ttl> <xreftext>“Oracle Automatic Storage Management: Oracle By Example Series”</xreftext> </div> </div> </div>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de