Edit D:\rfid\database\database\doc\server.112\e10897\index.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html lang="en" xml:lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Language" content="en" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <meta name="robots" content="all" scheme="http://www.robotstxt.org/" /> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = document) - Version 5.1" /> <meta name="Date" content="2009-09-09T22:35:16Z" /> <meta name="doctitle" content="Oracle® Database 2 Day DBA 11g Release 2 (11.2)" /> <meta name="partno" content="E10897-02" /> <meta name="docid" content="ADMQS" /> <link rel="Start" href="../../index.htm" title="Home" type="text/html" /> <link rel="Copyright" href="../../dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="Stylesheet" href="../../dcommon/css/blafdoc.css" title="Default" type="text/css" /> <script type="text/javascript" src="../../dcommon/js/doccd.js"> </script> <link rel="Contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="Prev" href="asm.htm" title="Previous" type="text/html" /> <link rel="alternate" href="../e10897.pdf" title="PDF version" type="application/pdf" /> <title>Index</title> </head> <body> <div class="header"> <div class="zz-skip-header"><a name="top" id="top" href="#BEGIN">Skip Headers</a></div> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <tr> <td align="left" valign="top"><b>Oracle® Database 2 Day DBA<br /> 11<i>g</i> Release 2 (11.2)</b><br /> Part Number E10897-02</td> <td valign="bottom" align="right"> <table class="icons oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="196"> <tr> <td align="center" valign="top"><a href="../../index.htm"><img width="24" height="24" src="../../dcommon/gifs/doclib.gif" alt="Go to Documentation Home" /><br /> <span class="icon">Home</span></a></td> <td align="center" valign="top"><a href="../../nav/portal_booklist.htm"><img width="24" height="24" src="../../dcommon/gifs/booklist.gif" alt="Go to Book List" /><br /> <span class="icon">Book List</span></a></td> <td align="center" valign="top"><a href="toc.htm"><img width="24" height="24" src="../../dcommon/gifs/toc.gif" alt="Go to Table of Contents" /><br /> <span class="icon">Contents</span></a></td> <td align="center" valign="top"><a href="../../dcommon/html/feedback.htm"><img width="24" height="24" src="../../dcommon/gifs/feedbck2.gif" alt="Go to Feedback page" /><br /> <span class="icon">Contact Us</span></a></td> </tr> </table> </td> </tr> </table> <hr /> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <tr> <td align="left" valign="top"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="49"> <tr> <td align="center" valign="top"><a href="asm.htm"><img width="24" height="24" src="../../dcommon/gifs/leftnav.gif" alt="Go to previous page" /><br /> <span class="icon">Previous</span></a></td> </tr> </table> </td> <td align="right" valign="top" style="font-size: 90%"><a href="../e10897.pdf">View PDF</a></td> </tr> </table> <a name="BEGIN" id="BEGIN"></a></div> <div class="IND"><!-- End Header --> <h1 class="it">Index</h1> <a href="#A">A</a> <a href="#B">B</a> <a href="#C">C</a> <a href="#D">D</a> <a href="#E">E</a> <a href="#F">F</a> <a href="#G">G</a> <a href="#I">I</a> <a href="#J">J</a> <a href="#L">L</a> <a href="#M">M</a> <a href="#N">N</a> <a href="#O">O</a> <a href="#P">P</a> <a href="#Q">Q</a> <a href="#R">R</a> <a href="#S">S</a> <a href="#T">T</a> <a href="#U">U</a> <a href="#V">V</a> <a href="#W">W</a> <a id="A" name="A"></a> <hr /> <h2>A</h2> <dl class="l1ix"> <dd class="l1ix">adding</dd> <dd> <dl class="l2ix"> <dd class="l2ix">columns to a table, <a href="schema.htm#sthref500">8.3.5.1</a></dd> <dd class="l2ix">disks to Oracle ASM disk groups, <a href="asm.htm#sthref826">A.8</a></dd> <dd class="l2ix">table constraints, <a href="schema.htm#sthref505">8.3.5.3</a></dd> </dl> </dd> <dd class="l1ix">ADDM</dd> <dd> <dl class="l2ix"> <dd class="l2ix"><span class="italic">See</span> Automatic Database Diagnostics Monitor</dd> </dl> </dd> <dd class="l1ix">administering</dd> <dd> <dl class="l2ix"> <dd class="l2ix">Oracle ASM, <a href="asm.htm#sthref805">A.1</a></dd> <dd class="l2ix">users, <a href="users_secure.htm#sthref404">7.5</a></dd> </dl> </dd> <dd class="l1ix">administrative user accounts, <a href="users_secure.htm#sthref380">7.3</a></dd> <dd> <dl class="l2ix"> <dd class="l2ix">SYS, <a href="instance.htm#sthref200">5.1.5.1</a>, <a href="users_secure.htm#sthref387">7.3.1</a></dd> <dd class="l2ix">SYSTEM, <a href="instance.htm#sthref201">5.1.5.1</a></dd> </dl> </dd> <dd class="l1ix">advisors</dd> <dd> <dl class="l2ix"> <dd class="l2ix">Automatic Database Diagnostics Monitor (ADDM), <a href="montune.htm#sthref693">10.3.1</a></dd> <dd class="l2ix">Buffer Cache Advisor, <a href="montune.htm#sthref701">10.3.1</a>, <a href="montune.htm#sthref708">10.3.1</a></dd> <dd class="l2ix">description, <a href="montune.htm#sthref687">10.3.1</a></dd> <dd class="l2ix">Memory Advisor, <a href="montune.htm#sthref698">10.3.1</a>, <a href="montune.htm#sthref704">10.3.1</a></dd> <dd> <dl class="l3ix"> <dd class="l3ix">using, <a href="montune.htm#sthref736">10.3.8.1</a></dd> </dl> </dd> <dd class="l2ix">performance, <a href="montune.htm#sthref690">10.3.1</a></dd> <dd class="l2ix">PGA Advisor, <a href="montune.htm#sthref702">10.3.1</a>, <a href="montune.htm#sthref710">10.3.1</a></dd> <dd class="l2ix">repairing critical errors, <a href="problems.htm#sthref767">11.2.6</a></dd> <dd class="l2ix">Segment Advisor, <a href="montune.htm#sthref713">10.3.1</a></dd> <dd> <dl class="l3ix"> <dd class="l3ix">using, <a href="storage.htm#sthref317">6.3.4.2</a></dd> </dl> </dd> <dd class="l2ix">SGA Advisor, <a href="montune.htm#sthref699">10.3.1</a></dd> <dd class="l2ix">Shared Pool Advisor, <a href="montune.htm#sthref700">10.3.1</a>, <a href="montune.htm#sthref706">10.3.1</a></dd> <dd class="l2ix">SQL Access Advisor, <a href="montune.htm#sthref696">10.3.1</a></dd> <dd> <dl class="l3ix"> <dd class="l3ix">using, <a href="montune.htm#sthref719">10.3.2</a></dd> </dl> </dd> <dd class="l2ix">SQL Tuning Advisor, <a href="montune.htm#sthref695">10.3.1</a></dd> <dd> <dl class="l3ix"> <dd class="l3ix">using, <a href="montune.htm#sthref731">10.3.6</a></dd> </dl> </dd> <dd class="l2ix">Undo Advisor, <a href="storage.htm#sthref355">6.5.4</a>, <a href="montune.htm#sthref715">10.3.1</a></dd> </dl> </dd> <dd class="l1ix">alerts</dd> <dd> <dl class="l2ix"> <dd class="l2ix">reviewing critical errors, <a href="problems.htm#sthref749">11.2.2</a></dd> <dd class="l2ix">tablespace space usage, <a href="storage.htm#sthref306">6.3.2.2</a></dd> </dl> </dd> <dd class="l1ix">ALTER SYSTEM statement, <a href="instance.htm#sthref220">5.3</a></dd> <dd class="l1ix">archived redo log files</dd> <dd> <dl class="l2ix"> <dd class="l2ix">advantages of using, <a href="install.htm#sthref70">2.3.2.6</a></dd> <dd class="l2ix">description of, <a href="install.htm#sthref68">2.3.2.6</a>, <a href="storage.htm#sthref246">6.1.3</a></dd> <dd class="l2ix">viewing, <a href="storage.htm#sthref294">6.2.3</a></dd> </dl> </dd> <dd class="l1ix">ARCHIVELOG mode, <a href="install.htm#sthref64">2.3.2.6</a></dd> <dd class="l1ix">archiving, <a href="install.htm#sthref69">2.3.2.6</a></dd> <dd class="l1ix">ARC<span class="italic">n</span> processes, <a href="instance.htm#sthref178">5.1.2</a></dd> <dd class="l1ix">ASM</dd> <dd> <dl class="l2ix"> <dd class="l2ix"><span class="italic">See</span> Automatic Storage Management (Oracle ASM)</dd> <dd class="l2ix"><span class="italic">See</span> Oracle Automatic Storage Management</dd> </dl> </dd> <dd class="l1ix">autoextend</dd> <dd> <dl class="l2ix"> <dd class="l2ix">data files and tablespaces, <a href="storage.htm#sthref285">6.1.6.4</a></dd> </dl> </dd> <dd class="l1ix">Automatic Database Diagnostics Monitor (ADDM)</dd> <dd> <dl class="l2ix"> <dd class="l2ix">description, <a href="montune.htm#sthref692">10.3.1</a></dd> <dd class="l2ix">findings, <a href="montune.htm#sthref665">10.1.2</a></dd> <dd class="l2ix">modifying snapshot frequency and retention, <a href="montune.htm#sthref686">10.2.4</a></dd> <dd class="l2ix">overview, <a href="montune.htm#sthref662">10.1.2</a></dd> <dd class="l2ix">snapshots, <a href="montune.htm#sthref664">10.1.2</a></dd> <dd class="l2ix">viewing performance analysis, <a href="montune.htm#sthref680">10.2.1</a></dd> </dl> </dd> <dd class="l1ix">Automatic Diagnostic Repository, <a href="problems.htm#sthref742">11.1</a></dd> <dd class="l1ix">automatic memory management, <a href="install.htm#sthref76">2.3.2.8.1</a>, <a href="instance.htm#sthref224">5.4.1</a></dd> <dd> <dl class="l2ix"> <dd class="l2ix">enabling, <a href="instance.htm#sthref228">5.4.2</a></dd> <dd class="l2ix">modifying settings, <a href="instance.htm#sthref229">5.4.3</a></dd> </dl> </dd> <dd class="l1ix">automatic PGA memory management</dd> <dd> <dl class="l2ix"> <dd class="l2ix">modifying settings, <a href="instance.htm#sthref235">5.4.5</a></dd> </dl> </dd> <dd class="l1ix">automatic shared memory management, <a href="install.htm#sthref77">2.3.2.8.1</a>, <a href="instance.htm#sthref225">5.4.1</a></dd> <dd> <dl class="l2ix"> <dd class="l2ix">modifying settings, <a href="instance.htm#sthref232">5.4.4</a></dd> </dl> </dd> <dd class="l1ix">Automatic SQL Tuning Advisor</dd> <dd> <dl class="l2ix"> <dd class="l2ix">about, <a href="montune.htm#sthref720">10.3.3</a></dd> <dd class="l2ix">configuring, <a href="montune.htm#sthref723">10.3.4</a></dd> <dd class="l2ix">viewing results, <a href="montune.htm#sthref727">10.3.5</a></dd> </dl> </dd> <dd class="l1ix">Automatic Storage Management</dd> <dd> <dl class="l2ix"> <dd class="l2ix">See Oracle Automatic Storage Management (Oracle ASM)</dd> </dl> </dd> <dd class="l1ix">Automatic Workload Repository, <a href="montune.htm#sthref672">10.1.4.1</a></dd> <dd class="l1ix">AWR</dd> <dd> <dl class="l2ix"> <dd class="l2ix"><span class="italic">See</span> Automatic Workload Repository</dd> </dl> </dd> </dl> <a id="B" name="B"></a> <hr /> <h2>B</h2> <dl class="l1ix"> <dd class="l1ix">background processes</dd> <dd> <dl class="l2ix"> <dd class="l2ix">and database configuration, <a href="install.htm#sthref80">2.3.2.8.2</a></dd> <dd class="l2ix">archiver (ARC<span class="italic">n</span>), <a href="instance.htm#sthref177">5.1.2</a></dd> <dd class="l2ix">checkpoint, <a href="instance.htm#sthref169">5.1.2</a></dd> <dd class="l2ix">database writer (DBW<span class="italic">n</span>), <a href="instance.htm#sthref165">5.1.2</a></dd> <dd class="l2ix">description, <a href="intro.htm#sthref9">1.2</a>, <a href="instance.htm#sthref163">5.1.2</a></dd> <dd class="l2ix">log writer (LGWR), <a href="instance.htm#sthref167">5.1.2</a></dd> <dd class="l2ix">manageability monitor (MMON), <a href="instance.htm#sthref179">5.1.2</a></dd> <dd class="l2ix">process monitor (PMON), <a href="network.htm#sthref142">4.1.1</a>, <a href="instance.htm#sthref175">5.1.2</a></dd> <dd class="l2ix">system monitor (SMON), <a href="instance.htm#sthref173">5.1.2</a></dd> <dd class="l2ix">use by database instances, <a href="instance.htm#sthref155">5.1</a></dd> </dl> </dd> <dd class="l1ix">backup</dd> <dd> <dl class="l2ix"> <dd class="l2ix">available, <a href="backrest.htm#sthref625">9.6.1</a></dd> <dd class="l2ix">backup pieces, <a href="backrest.htm#sthref604">9.3.5.1</a></dd> <dd class="l2ix">channels, <a href="backrest.htm#sthref606">9.3.5.1</a></dd> <dd class="l2ix">consistent, <a href="backrest.htm#sthref582">9.2.1</a></dd> <dd class="l2ix">cross-checking, <a href="backrest.htm#sthref629">9.6.1</a>, <a href="backrest.htm#sthref630">9.6.2</a></dd> <dd class="l2ix">deleting expired backups, <a href="backrest.htm#sthref631">9.6.3</a></dd> <dd class="l2ix">deleting obsolete backups, <a href="backrest.htm#sthref633">9.6.5</a></dd> <dd class="l2ix">expired, <a href="backrest.htm#sthref626">9.6.1</a></dd> <dd class="l2ix">files, <a href="storage.htm#sthref292">6.1.7</a></dd> <dd class="l2ix">full backup of data files, <a href="backrest.htm#sthref609">9.4.1.1</a></dd> <dd class="l2ix">image copies, <a href="backrest.htm#sthref602">9.3.5.1</a></dd> <dd class="l2ix">inconsistent, <a href="backrest.htm#sthref583">9.2.1</a></dd> <dd class="l2ix">incremental backup of data files, <a href="backrest.htm#sthref612">9.4.1.2</a></dd> <dd class="l2ix">making unavailable, <a href="backrest.htm#sthref632">9.6.4</a></dd> <dd class="l2ix">managing, <a href="backrest.htm#sthref623">9.6</a></dd> <dd class="l2ix">obsolete, <a href="backrest.htm#sthref628">9.6.1</a></dd> <dd class="l2ix">Oracle suggested backup strategy, <a href="backrest.htm#sthref617">9.4.2.2</a></dd> <dd class="l2ix">overview, <a href="backrest.htm#sthref571">9.1</a></dd> <dd class="l2ix">sets, <a href="backrest.htm#sthref603">9.3.5.1</a></dd> <dd class="l2ix">settings, <a href="backrest.htm#sthref601">9.3.5</a></dd> <dd class="l2ix">tags, <a href="backrest.htm#sthref613">9.4.1.4</a></dd> <dd class="l2ix">unavailable, <a href="backrest.htm#sthref627">9.6.1</a></dd> <dd class="l2ix">validating, <a href="backrest.htm#sthref620">9.4.3</a></dd> <dd class="l2ix">whole database backup, <a href="backrest.htm#sthref615">9.4.2.1</a></dd> </dl> </dd> <dd class="l1ix">backup and recovery area</dd> <dd> <dl class="l2ix"> <dd class="l2ix">specifying during database creation, <a href="install.htm#sthref71">2.3.2.6</a></dd> </dl> </dd> <dd class="l1ix">BasicFiles, <a href="schema.htm#sthref481">8.3.1.4.1</a></dd> <dd class="l1ix">blackouts</dd> <dd> <dl class="l2ix"> <dd class="l2ix">defining time periods, <a href="em_manage.htm#sthref130">3.8.2</a></dd> <dd class="l2ix">description, <a href="em_manage.htm#sthref128">3.8.1</a></dd> </dl> </dd> <dd class="l1ix">block size</dd> <dd> <dl class="l2ix"> <dd class="l2ix">configuring for the database, <a href="install.htm#sthref78">2.3.2.8.2</a></dd> </dl> </dd> <dd class="l1ix">Buffer Cache Advisor</dd> <dd> <dl class="l2ix"> <dd class="l2ix">description, <a href="montune.htm#sthref707">10.3.1</a></dd> </dl> </dd> </dl> <a id="C" name="C"></a> <hr /> <h2>C</h2> <dl class="l1ix"> <dd class="l1ix">central database management</dd> <dd> <dl class="l2ix"> <dd class="l2ix">configuring, <a href="install.htm#sthref60">2.3.2.3</a></dd> </dl> </dd> <dd class="l1ix">character sets, <a href="install.htm#sthref35">2.1.2.7</a></dd> <dd> <dl class="l2ix"> <dd class="l2ix">defining, <a href="install.htm#sthref81">2.3.2.8.3</a></dd> <dd class="l2ix">description, <a href="install.htm#sthref82">2.3.2.8.3</a></dd> </dl> </dd> <dd class="l1ix">checkpoint</dd> <dd> <dl class="l2ix"> <dd class="l2ix">of the database, <a href="instance.htm#sthref171">5.1.2</a></dd> </dl> </dd> <dd class="l1ix">checkpoint process, <a href="instance.htm#sthref170">5.1.2</a></dd> <dd class="l1ix">classes, Java, <a href="schema.htm#sthref551">8.6.1</a></dd> <dd class="l1ix">CLOB data type, <a href="schema.htm#sthref472">8.3.1.2.1</a></dd> <dd class="l1ix">code</dd> <dd> <dl class="l2ix"> <dd class="l2ix">database-resident, <a href="schema.htm#sthref545">8.6.1</a></dd> </dl> </dd> <dd class="l1ix">columns</dd> <dd> <dl class="l2ix"> <dd class="l2ix">adding, <a href="schema.htm#sthref501">8.3.5.1</a></dd> <dd class="l2ix">deleting, <a href="schema.htm#sthref503">8.3.5.2</a></dd> </dl> </dd> <dd class="l1ix">comments</dd> <dd> <dl class="l2ix"> <dd class="l2ix">adding to problem activity logs, <a href="problems.htm#sthref763">11.2.6</a></dd> </dl> </dd> <dd class="l1ix">compiling schema objects, <a href="schema.htm#sthref556">8.6.2</a></dd> <dd class="l1ix">compressed tables, <a href="storage.htm#sthref321">6.3.4.2.1</a>, <a href="schema.htm#sthref484">8.3.1.4.4</a></dd> <dd class="l1ix">configuring</dd> <dd> <dl class="l2ix"> <dd class="l2ix">Automatic SQL Tuning Advisor, <a href="montune.htm#sthref722">10.3.4</a></dd> </dl> </dd> <dd class="l1ix">connect descriptors</dd> <dd> <dl class="l2ix"> <dd class="l2ix">description, <a href="network.htm#sthref144">4.1.2</a></dd> <dd class="l2ix">example, <a href="network.htm#sthref145">4.1.2</a></dd> </dl> </dd> <dd class="l1ix">CONNECT role, <a href="users_secure.htm#sthref374">7.2</a></dd> <dd class="l1ix">connect strings</dd> <dd> <dl class="l2ix"> <dd class="l2ix">description, <a href="network.htm#sthref146">4.1.2</a></dd> </dl> </dd> <dd class="l1ix">connection modes</dd> <dd> <dl class="l2ix"> <dd class="l2ix">configuring, <a href="install.htm#sthref83">2.3.2.8.4</a></dd> </dl> </dd> <dd class="l1ix">connection privileges</dd> <dd> <dl class="l2ix"> <dd class="l2ix">SYSASM, <a href="asm.htm#sthref809">A.1</a></dd> <dd class="l2ix">SYSDBA, <a href="instance.htm#sthref197">5.1.5.1</a></dd> <dd class="l2ix">SYSOPER, <a href="instance.htm#sthref196">5.1.5.1</a></dd> </dl> </dd> <dd class="l1ix">constraints, <a href="schema.htm#sthref475">8.3.1.3</a></dd> <dd> <dl class="l2ix"> <dd class="l2ix">adding, <a href="schema.htm#sthref507">8.3.5.3</a></dd> <dd class="l2ix">deleting, <a href="schema.htm#sthref513">8.3.5.5</a></dd> <dd class="l2ix">modifying, <a href="schema.htm#sthref510">8.3.5.4</a></dd> </dl> </dd> <dd class="l1ix">control files</dd> <dd> <dl class="l2ix"> <dd class="l2ix">description, <a href="storage.htm#sthref241">6.1.1</a></dd> <dd class="l2ix">multiplexing, <a href="storage.htm#sthref242">6.1.1</a></dd> <dd class="l2ix">SQL*Loader, <a href="schema.htm#sthref520">8.3.6</a></dd> </dl> </dd> <dd class="l1ix">creating</dd> <dd> <dl class="l2ix"> <dd class="l2ix">databases</dd> <dd> <dl class="l3ix"> <dd class="l3ix">overview, <a href="install.htm#sthref11">2.1</a></dd> <dd class="l3ix">steps, <a href="install.htm#sthref45">2.2</a></dd> <dd class="l3ix">using standalone DBCA, <a href="install.htm#sthref57">2.3</a></dd> </dl> </dd> <dd class="l2ix">indexes, <a href="schema.htm#sthref535">8.4.3</a></dd> <dd class="l2ix">service requests, <a href="problems.htm#sthref753">11.2.4</a></dd> <dd class="l2ix">tables, <a href="schema.htm#sthref492">8.3.4</a></dd> <dd class="l2ix">users, <a href="users_secure.htm#sthref410">7.5.2</a></dd> </dl> </dd> <dd class="l1ix">customized repairs, <a href="backrest.htm#sthref640">9.8</a></dd> </dl> <a id="D" name="D"></a> <hr /> <h2>D</h2> <dl class="l1ix"> <dd class="l1ix">data</dd> <dd> <dl class="l2ix"> <dd class="l2ix">loading, <a href="schema.htm#sthref516">8.3.6</a></dd> </dl> </dd> <dd class="l1ix">data blocks</dd> <dd> <dl class="l2ix"> <dd class="l2ix">description of, <a href="install.htm#sthref79">2.3.2.8.2</a>, <a href="storage.htm#sthref254">6.1.5</a></dd> </dl> </dd> <dd class="l1ix">data dictionary tables</dd> <dd> <dl class="l2ix"> <dd class="l2ix">access to as user SYS, <a href="users_secure.htm#sthref391">7.3.2</a></dd> </dl> </dd> <dd class="l1ix">data files</dd> <dd> <dl class="l2ix"> <dd class="l2ix">and the Oracle Suggested Backup Strategy, <a href="backrest.htm#sthref618">9.4.2.2.1</a></dd> <dd class="l2ix">autoextend, <a href="storage.htm#sthref284">6.1.6.4</a>, <a href="storage.htm#sthref304">6.3.2.1</a></dd> <dd class="l2ix">autoextend and Oracle Flashback, <a href="storage.htm#sthref344">6.5.2</a></dd> <dd class="l2ix">backing up, <a href="backrest.htm#sthref578">9.2</a></dd> <dd class="l2ix">backups of only used blocks, <a href="backrest.htm#sthref605">9.3.5.1</a></dd> <dd class="l2ix">data blocks, <a href="storage.htm#sthref255">6.1.5</a></dd> <dd class="l2ix">description of, <a href="storage.htm#sthref248">6.1.5</a></dd> <dd class="l2ix">example of corrupt block detection, <a href="backrest.htm#sthref638">9.7.2</a></dd> <dd class="l2ix">extents, <a href="storage.htm#sthref253">6.1.5</a></dd> <dd class="l2ix">full backups, <a href="backrest.htm#sthref610">9.4.1.1</a></dd> <dd class="l2ix">image copies of, <a href="backrest.htm#sthref611">9.4.1.1</a></dd> <dd class="l2ix">media recovery, <a href="backrest.htm#sthref587">9.2.2</a></dd> <dd class="l2ix">missing, <a href="backrest.htm#sthref576">9.1</a></dd> <dd class="l2ix">recovering from the loss of, <a href="backrest.htm#sthref655">9.8.4</a></dd> <dd class="l2ix">recovery without restoration, <a href="backrest.htm#sthref575">9.1</a></dd> <dd class="l2ix">restoring from consistent and inconsistent backups, <a href="backrest.htm#sthref584">9.2.1</a></dd> <dd class="l2ix">segments, <a href="storage.htm#sthref251">6.1.5</a></dd> <dd class="l2ix">SQL*Loader, <a href="schema.htm#sthref518">8.3.6</a></dd> <dd class="l2ix">tempfiles, <a href="storage.htm#sthref249">6.1.5</a></dd> <dd class="l2ix">validating backups of, <a href="backrest.htm#sthref621">9.4.3.2</a></dd> <dd class="l2ix">viewing information about, <a href="storage.htm#sthref295">6.2.4</a></dd> </dl> </dd> <dd class="l1ix">data integrity, <a href="schema.htm#sthref474">8.3.1.3</a></dd> <dd class="l1ix">Data Recovery Advisor, <a href="backrest.htm#sthref634">9.7</a></dd> <dd class="l1ix">data types</dd> <dd> <dl class="l2ix"> <dd class="l2ix">CLOB, <a href="schema.htm#sthref471">8.3.1.2.1</a></dd> <dd class="l2ix">DATE, <a href="schema.htm#sthref469">8.3.1.2.1</a></dd> <dd class="l2ix">NUMBER, <a href="schema.htm#sthref467">8.3.1.2.1</a></dd> <dd class="l2ix">overview, <a href="schema.htm#sthref463">8.3.1.2.1</a></dd> <dd class="l2ix">user-defined, <a href="schema.htm#sthref476">8.3.1.4.1</a></dd> <dd class="l2ix">VARCHAR2, <a href="schema.htm#sthref465">8.3.1.2.1</a></dd> </dl> </dd> <dd class="l1ix">database</dd> <dd> <dl class="l2ix"> <dd class="l2ix">domain, <a href="install.htm#sthref31">2.1.2.6</a></dd> <dd class="l2ix">global name, <a href="install.htm#sthref32">2.1.2.6</a></dd> <dd class="l2ix">management options, <a href="install.htm#sthref38">2.1.2.7</a></dd> </dl> </dd> <dd class="l1ix">database administration</dd> <dd> <dl class="l2ix"> <dd class="l2ix">privileges required, <a href="users_secure.htm#sthref383">7.3</a></dd> </dl> </dd> <dd class="l1ix">database checkpoint, <a href="instance.htm#sthref172">5.1.2</a></dd> <dd class="l1ix">Database Configuration Assistant (DBCA)</dd> <dd> <dl class="l2ix"> <dd class="l2ix">configuring database options, <a href="install.htm#sthref86">2.3.3</a></dd> <dd class="l2ix">deleting a databases, <a href="install.htm#sthref88">2.3.4</a></dd> <dd class="l2ix">managing database templates, <a href="install.htm#sthref91">2.3.5</a></dd> <dd class="l2ix">using to create a database, <a href="install.htm#sthref54">2.3</a></dd> </dl> </dd> <dd class="l1ix">database configuration options, <a href="install.htm#sthref34">2.1.2.7</a></dd> <dd class="l1ix">Database Control</dd> <dd> <dl class="l2ix"> <dd class="l2ix"><span class="italic">See</span> Oracle Enterprise Manager Database Control</dd> </dl> </dd> <dd class="l1ix">database edition, <a href="install.htm#sthref16">2.1.2.3</a></dd> <dd class="l1ix">database links</dd> <dd> <dl class="l2ix"> <dd class="l2ix">description, <a href="schema.htm#sthref570">8.7</a></dd> </dl> </dd> <dd class="l1ix">database objects</dd> <dd> <dl class="l2ix"> <dd class="l2ix">naming, <a href="schema.htm#sthref454">8.1</a></dd> </dl> </dd> <dd class="l1ix">Database Upgrade Assistant (DBUA)</dd> <dd> <dl class="l2ix"> <dd class="l2ix">overview, <a href="software.htm#sthref791">12.4.1</a></dd> <dd class="l2ix">restrictions on versions, <a href="software.htm#sthref792">12.4.2</a></dd> <dd class="l2ix">starting, <a href="software.htm#sthref793">12.4.3</a></dd> <dd class="l2ix">steps for upgrading, <a href="software.htm#sthref795">12.4.4</a></dd> </dl> </dd> <dd class="l1ix">database-resident program code, <a href="schema.htm#sthref544">8.6.1</a></dd> <dd class="l1ix">databases</dd> <dd> <dl class="l2ix"> <dd class="l2ix">advisors</dd> <dd> <dl class="l3ix"> <dd class="l3ix">using, <a href="montune.htm#sthref688">10.3.1</a></dd> </dl> </dd> <dd class="l2ix">alerts, <a href="montune.htm#sthref659">10.1.1</a></dd> <dd> <dl class="l3ix"> <dd class="l3ix">responding to alerts, <a href="montune.htm#sthref677">10.1.4.3</a></dd> <dd class="l3ix">setting metric thresholds, <a href="montune.htm#sthref675">10.1.4.2</a></dd> <dd class="l3ix">setting notification rules, <a href="montune.htm#sthref678">10.1.4.5</a></dd> <dd class="l3ix">viewing metrics, <a href="montune.htm#sthref671">10.1.4.1</a></dd> </dl> </dd> <dd class="l2ix">backup</dd> <dd> <dl class="l3ix"> <dd class="l3ix">description, <a href="backrest.htm#sthref577">9.2</a></dd> </dl> </dd> <dd class="l2ix">backup and recovery, <a href="backrest.htm#sthref573">9.1</a></dd> <dd class="l2ix">configuring options, <a href="install.htm#sthref87">2.3.3</a></dd> <dd class="l2ix">creating with DBCA, <a href="install.htm#sthref56">2.3</a></dd> <dd class="l2ix">deleting using DBCA, <a href="install.htm#sthref89">2.3.4</a></dd> <dd class="l2ix">diagnosing performance problems, <a href="montune.htm#sthref679">10.2</a></dd> <dd class="l2ix">duplicating, <a href="install.htm#sthref95">2.3.5</a></dd> <dd class="l2ix">managing</dd> <dd> <dl class="l3ix"> <dd class="l3ix">roadmap, <a href="em_manage.htm#sthref105">3.1</a></dd> <dd class="l3ix">with Oracle Enterprise Manager Database Control, <a href="em_manage.htm#sthref103">3</a></dd> </dl> </dd> <dd class="l2ix">metric thresholds, <a href="montune.htm#sthref661">10.1.1</a></dd> <dd class="l2ix">monitoring</dd> <dd> <dl class="l3ix"> <dd class="l3ix">alert-based, <a href="montune.htm#sthref660">10.1.1</a></dd> <dd class="l3ix">performance, <a href="montune.htm#sthref657">10.1</a></dd> </dl> </dd> <dd class="l2ix">overview of creating, <a href="install.htm#sthref12">2.1</a></dd> <dd class="l2ix">performance</dd> <dd> <dl class="l3ix"> <dd class="l3ix">advisors, <a href="montune.htm#sthref689">10.3.1</a></dd> <dd class="l3ix">monitoring, <a href="montune.htm#sthref658">10.1</a></dd> </dl> </dd> <dd class="l2ix">recovery</dd> <dd> <dl class="l3ix"> <dd class="l3ix">description, <a href="backrest.htm#sthref580">9.2</a>, <a href="backrest.htm#sthref581">9.2</a></dd> <dd class="l3ix">point-in-time, <a href="backrest.htm#sthref588">9.2.2</a></dd> </dl> </dd> <dd class="l2ix">restoring</dd> <dd> <dl class="l3ix"> <dd class="l3ix">description, <a href="backrest.htm#sthref579">9.2</a></dd> </dl> </dd> <dd class="l2ix">starting and stopping on Microsoft Windows, <a href="instance.htm#sthref215">5.2.2</a></dd> <dd class="l2ix">steps for installing and creating, <a href="install.htm#sthref44">2.2</a></dd> <dd class="l2ix">storage structure</dd> <dd> <dl class="l3ix"> <dd class="l3ix">logical structures, <a href="storage.htm#sthref238">6.1</a></dd> <dd class="l3ix">physical structures, <a href="storage.htm#sthref237">6.1</a></dd> </dl> </dd> <dd class="l2ix">tuning, <a href="montune.htm#sthref656">10.1</a></dd> <dd class="l2ix">upgrading, <a href="software.htm#sthref790">12.4</a>, <a href="software.htm#sthref796">12.4.4</a></dd> <dd class="l2ix">users, <a href="users_secure.htm#sthref360">7</a></dd> <dd class="l2ix">using DBCA templates, <a href="install.htm#sthref92">2.3.5</a></dd> </dl> </dd> <dd class="l1ix">DATE data type, <a href="schema.htm#sthref470">8.3.1.2.1</a></dd> <dd class="l1ix">DBA role, <a href="users_secure.htm#sthref378">7.2</a>, <a href="schema.htm#sthref457">8.2</a></dd> <dd class="l1ix">DBUA</dd> <dd> <dl class="l2ix"> <dd class="l2ix"><span class="italic">See</span> Database Upgrade Assistant</dd> </dl> </dd> <dd class="l1ix">DBW<span class="italic">n</span> processes, <a href="instance.htm#sthref166">5.1.2</a></dd> <dd class="l1ix">dedicated server mode, <a href="install.htm#sthref84">2.3.2.8.4</a></dd> <dd class="l1ix">dedicated server processes, <a href="instance.htm#sthref182">5.1.3</a></dd> <dd class="l1ix">deleting</dd> <dd> <dl class="l2ix"> <dd class="l2ix">constraints, <a href="schema.htm#sthref514">8.3.5.5</a></dd> <dd class="l2ix">databases, <a href="install.htm#sthref90">2.3.4</a></dd> <dd class="l2ix">table columns, <a href="schema.htm#sthref504">8.3.5.2</a></dd> <dd class="l2ix">tables, <a href="schema.htm#sthref524">8.3.7</a></dd> <dd class="l2ix">users, <a href="users_secure.htm#sthref444">7.5.9</a></dd> <dd class="l2ix">views, <a href="schema.htm#sthref543">8.5.4</a></dd> </dl> </dd> <dd class="l1ix">deployment procedures, <a href="software.htm#sthref781">12.2.3</a></dd> <dd class="l1ix">directory</dd> <dd> <dl class="l2ix"> <dd class="l2ix">Oracle base, <a href="install.htm#sthref22">2.1.2.4</a></dd> <dd class="l2ix">Oracle inventory, <a href="install.htm#sthref24">2.1.2.4</a></dd> </dl> </dd> <dd class="l1ix">disk discovery</dd> <dd> <dl class="l2ix"> <dd class="l2ix">in Oracle Automatic Storage Management, <a href="asm.htm#sthref812">A.2</a></dd> </dl> </dd> <dd class="l1ix">disk groups</dd> <dd> <dl class="l2ix"> <dd class="l2ix">adding disks to, <a href="asm.htm#sthref825">A.8</a></dd> <dd class="l2ix">creating, <a href="asm.htm#sthref821">A.6</a></dd> <dd class="l2ix">dropping, <a href="asm.htm#sthref823">A.7</a></dd> <dd class="l2ix">dropping disks from, <a href="asm.htm#sthref829">A.9</a></dd> <dd class="l2ix">monitoring disk space usage, <a href="asm.htm#sthref819">A.5</a></dd> <dd class="l2ix">overview, <a href="asm.htm#sthref811">A.2</a></dd> </dl> </dd> <dd class="l1ix">dropping</dd> <dd> <dl class="l2ix"> <dd class="l2ix">disk groups, <a href="asm.htm#sthref824">A.7</a></dd> <dd class="l2ix">disks from disk groups, <a href="asm.htm#sthref830">A.9</a></dd> <dd class="l2ix">tablespaces, <a href="storage.htm#sthref311">6.3.3</a></dd> <dd class="l2ix">undoing with Flashback Drop, <a href="backrest.htm#sthref648">9.8.2.1</a></dd> </dl> </dd> <dd class="l1ix">duplicating</dd> <dd> <dl class="l2ix"> <dd class="l2ix">databases, <a href="install.htm#sthref94">2.3.5</a></dd> <dd class="l2ix">users, <a href="users_secure.htm#sthref413">7.5.3</a></dd> </dl> </dd> </dl> <a id="E" name="E"></a> <hr /> <h2>E</h2> <dl class="l1ix"> <dd class="l1ix">emctl, <a href="em_manage.htm#sthref112">3.4</a></dd> <dd class="l1ix">enabling</dd> <dd> <dl class="l2ix"> <dd class="l2ix">automatic memory management, <a href="instance.htm#sthref227">5.4.2</a></dd> </dl> </dd> <dd class="l1ix">Enterprise Edition, <a href="install.htm#sthref17">2.1.2.3</a></dd> <dd class="l1ix">Enterprise Manager</dd> <dd> <dl class="l2ix"> <dd class="l2ix"><span class="italic">See</span> Oracle Enterprise Manager Database Control</dd> </dl> </dd> <dd class="l1ix">EXAMPLE tablespace, <a href="storage.htm#sthref258">6.1.6</a></dd> <dd> <dl class="l2ix"> <dd class="l2ix">configuring, <a href="install.htm#sthref74">2.3.2.7</a></dd> </dl> </dd> <dd class="l1ix">expiring passwords</dd> <dd> <dl class="l2ix"> <dd class="l2ix">reasons for, <a href="users_secure.htm#sthref441">7.5.8</a></dd> </dl> </dd> <dd class="l1ix">extending</dd> <dd> <dl class="l2ix"> <dd class="l2ix">tablespaces, <a href="storage.htm#sthref282">6.1.6.4</a>, <a href="storage.htm#sthref302">6.3.2.1</a></dd> <dd class="l2ix">tablespaces and Oracle Flashback, <a href="storage.htm#sthref342">6.5.2</a></dd> <dd class="l2ix">undo tablespaces, <a href="storage.htm#sthref345">6.5.2</a></dd> </dl> </dd> <dd class="l1ix">extents</dd> <dd> <dl class="l2ix"> <dd class="l2ix">description of, <a href="storage.htm#sthref252">6.1.5</a></dd> </dl> </dd> </dl> <a id="F" name="F"></a> <hr /> <h2>F</h2> <dl class="l1ix"> <dd class="l1ix">failure groups, <a href="asm.htm#sthref814">A.2</a></dd> <dd class="l1ix">fast recovery area, <a href="backrest.htm#sthref592">9.2.3</a></dd> <dd> <dl class="l2ix"> <dd class="l2ix">configuring, <a href="backrest.htm#sthref600">9.3.3</a></dd> <dd class="l2ix">retention policies, <a href="backrest.htm#sthref599">9.3.2.1</a></dd> <dd class="l2ix">specifying during database creation, <a href="install.htm#sthref72">2.3.2.6</a></dd> </dl> </dd> <dd class="l1ix">Flashback Database, <a href="backrest.htm#sthref650">9.8.3</a></dd> <dd class="l1ix">Flashback Drop, <a href="backrest.htm#sthref646">9.8.2</a></dd> <dd class="l1ix">flashback features</dd> <dd> <dl class="l2ix"> <dd class="l2ix">Flashback Database, <a href="backrest.htm#sthref651">9.8.3</a></dd> <dd class="l2ix">Flashback Drop, <a href="backrest.htm#sthref647">9.8.2</a></dd> <dd class="l2ix">Flashback Table, <a href="backrest.htm#sthref644">9.8.1</a></dd> </dl> </dd> <dd class="l1ix">Flashback Table, <a href="backrest.htm#sthref643">9.8.1</a>, <a href="backrest.htm#sthref645">9.8.1.2</a></dd> <dd class="l1ix">functions, PL/SQL, <a href="schema.htm#sthref549">8.6.1</a></dd> </dl> <a id="G" name="G"></a> <hr /> <h2>G</h2> <dl class="l1ix"> <dd class="l1ix">global database name, <a href="install.htm#sthref27">2.1.2.6</a></dd> <dd class="l1ix">global indexes, <a href="schema.htm#sthref528">8.4.1.2</a></dd> <dd class="l1ix">granting</dd> <dd> <dl class="l2ix"> <dd class="l2ix">privileges, <a href="users_secure.htm#sthref420">7.5.4</a></dd> <dd class="l2ix">roles, <a href="users_secure.htm#sthref419">7.5.4</a></dd> </dl> </dd> <dd class="l1ix">grid control</dd> <dd> <dl class="l2ix"> <dd class="l2ix">configuring, <a href="install.htm#sthref62">2.3.2.3</a></dd> </dl> </dd> </dl> <a id="I" name="I"></a> <hr /> <h2>I</h2> <dl class="l1ix"> <dd class="l1ix">inactive, <a href="storage.htm#sthref332">6.4.2</a></dd> <dd class="l1ix">incidents</dd> <dd> <dl class="l2ix"> <dd class="l2ix">about, <a href="problems.htm#sthref744">11.1</a></dd> <dd class="l2ix">closed, viewing, <a href="problems.htm#sthref772">11.3</a></dd> <dd class="l2ix">closing, <a href="problems.htm#sthref768">11.2.7</a></dd> <dd class="l2ix">tracking, <a href="problems.htm#sthref745">11.1</a></dd> </dl> </dd> <dd class="l1ix">indexes</dd> <dd> <dl class="l2ix"> <dd class="l2ix">creating, <a href="schema.htm#sthref534">8.4.3</a>, <a href="schema.htm#sthref536">8.4.3</a></dd> <dd class="l2ix">description, <a href="schema.htm#sthref527">8.4.1</a></dd> <dd class="l2ix">global, <a href="schema.htm#sthref529">8.4.1.2</a></dd> <dd class="l2ix">viewing, <a href="schema.htm#sthref531">8.4.2</a></dd> </dl> </dd> <dd class="l1ix">initialization parameter file, <a href="storage.htm#sthref286">6.1.7</a></dd> <dd class="l1ix">initialization parameters</dd> <dd> <dl class="l2ix"> <dd class="l2ix">description, <a href="instance.htm#sthref156">5.1</a></dd> <dd class="l2ix">how they are used by the database, <a href="instance.htm#sthref160">5.1.1</a></dd> <dd class="l2ix">server parameter files, <a href="instance.htm#sthref158">5.1</a>, <a href="instance.htm#sthref162">5.1.1</a></dd> <dd class="l2ix">viewing and modifying, <a href="instance.htm#sthref216">5.3</a></dd> </dl> </dd> <dd class="l1ix">installation</dd> <dd> <dl class="l2ix"> <dd class="l2ix">checking prerequisites, <a href="install.htm#sthref13">2.1.1</a></dd> <dd class="l2ix">choices, <a href="install.htm#sthref15">2.1.2</a></dd> <dd class="l2ix">overview, <a href="install.htm#sthref10">2.1</a></dd> <dd class="l2ix">software location, <a href="install.htm#sthref20">2.1.2.4</a></dd> <dd class="l2ix">steps, <a href="install.htm#sthref43">2.2</a></dd> <dd class="l2ix">storage options, <a href="install.htm#sthref25">2.1.2.5</a></dd> <dd class="l2ix">using DBCA for database, <a href="install.htm#sthref55">2.3</a></dd> </dl> </dd> <dd class="l1ix">instances</dd> <dd> <dl class="l2ix"> <dd class="l2ix">database instances, <a href="instance.htm#sthref154">5.1</a></dd> <dd class="l2ix">management, <a href="instance.htm#sthref159">5.1</a></dd> <dd class="l2ix">memory structure, <a href="instance.htm#sthref184">5.1.4</a></dd> <dd class="l2ix">Oracle instances, <a href="instance.htm#sthref153">5.1</a></dd> <dd class="l2ix">PGA</dd> <dd> <dl class="l3ix"> <dd class="l3ix">definition, <a href="instance.htm#sthref193">5.1.4.2</a></dd> </dl> </dd> <dd class="l2ix">shutdown, <a href="instance.htm#sthref208">5.1.5.3</a></dd> <dd class="l2ix">startup, <a href="instance.htm#sthref207">5.1.5.2</a></dd> </dl> </dd> <dd class="l1ix">invalid schema objects, <a href="schema.htm#sthref555">8.6.1</a></dd> </dl> <a id="J" name="J"></a> <hr /> <h2>J</h2> <dl class="l1ix"> <dd class="l1ix">Java classes, <a href="schema.htm#sthref550">8.6.1</a></dd> <dd class="l1ix">Java source code, <a href="schema.htm#sthref552">8.6.1</a></dd> </dl> <a id="L" name="L"></a> <hr /> <h2>L</h2> <dl class="l1ix"> <dd class="l1ix">language</dd> <dd> <dl class="l2ix"> <dd class="l2ix">used by software, <a href="install.htm#sthref33">2.1.2.7</a></dd> </dl> </dd> <dd class="l1ix">LGWR process, <a href="instance.htm#sthref168">5.1.2</a></dd> <dd class="l1ix">licensed software options, <a href="install.htm#sthref19">2.1.2.3</a></dd> <dd class="l1ix">listener.ora files, <a href="network.htm#sthref140">4.1.1</a></dd> <dd class="l1ix">listeners</dd> <dd> <dl class="l2ix"> <dd class="l2ix"><span class="italic">See</span> Oracle listeners</dd> </dl> </dd> <dd class="l1ix">Load Data wizard</dd> <dd> <dl class="l2ix"> <dd class="l2ix">using, <a href="schema.htm#sthref522">8.3.6</a></dd> </dl> </dd> <dd class="l1ix">loading data, <a href="schema.htm#sthref515">8.3.6</a></dd> <dd class="l1ix">LOB columns, <a href="schema.htm#sthref478">8.3.1.4.1</a></dd> <dd class="l1ix">local database management</dd> <dd> <dl class="l2ix"> <dd class="l2ix">configuring, <a href="install.htm#sthref61">2.3.2.3</a></dd> </dl> </dd> <dd class="l1ix">locally managed tablespaces, <a href="storage.htm#sthref271">6.1.6.1</a></dd> <dd class="l1ix">locking and unlocking users, <a href="users_secure.htm#sthref437">7.5.7</a></dd> <dd class="l1ix">log switch</dd> <dd> <dl class="l2ix"> <dd class="l2ix">description, <a href="install.htm#sthref67">2.3.2.6</a></dd> </dl> </dd> </dl> <a id="M" name="M"></a> <hr /> <h2>M</h2> <dl class="l1ix"> <dd class="l1ix">managing</dd> <dd> <dl class="l2ix"> <dd class="l2ix">memory, <a href="instance.htm#sthref221">5.4</a></dd> </dl> </dd> <dd class="l1ix">media recovery, <a href="backrest.htm#sthref585">9.2.2</a></dd> <dd class="l1ix">memory</dd> <dd> <dl class="l2ix"> <dd class="l2ix">configuring, <a href="install.htm#sthref75">2.3.2.8.1</a></dd> <dd class="l2ix">management, <a href="instance.htm#sthref186">5.1.4</a>, <a href="instance.htm#sthref222">5.4</a>, <a href="instance.htm#sthref223">5.4.1</a></dd> <dd class="l2ix">requirements, <a href="install.htm#sthref14">2.1.1</a></dd> <dd class="l2ix">structure of in an Oracle instance, <a href="instance.htm#sthref185">5.1.4</a></dd> </dl> </dd> <dd class="l1ix">Memory Advisors</dd> <dd> <dl class="l2ix"> <dd class="l2ix">description, <a href="montune.htm#sthref697">10.3.1</a>, <a href="montune.htm#sthref703">10.3.1</a></dd> <dd class="l2ix">using, <a href="montune.htm#sthref735">10.3.8.1</a></dd> </dl> </dd> <dd class="l1ix">mirroring, <a href="asm.htm#sthref799">A.1</a></dd> <dd class="l1ix">MMON process, <a href="instance.htm#sthref180">5.1.2</a></dd> <dd class="l1ix">modifying</dd> <dd> <dl class="l2ix"> <dd class="l2ix">initialization parameters, <a href="instance.htm#sthref218">5.3</a></dd> <dd class="l2ix">table attributes, <a href="schema.htm#sthref498">8.3.5</a></dd> <dd class="l2ix">table constraints, <a href="schema.htm#sthref511">8.3.5.4</a></dd> <dd class="l2ix">users, <a href="users_secure.htm#sthref434">7.5.6</a></dd> </dl> </dd> </dl> <a id="N" name="N"></a> <hr /> <h2>N</h2> <dl class="l1ix"> <dd class="l1ix">Net Configuration Assistant (NETCA)</dd> <dd> <dl class="l2ix"> <dd class="l2ix">description, <a href="network.htm#sthref151">4.1.3</a></dd> </dl> </dd> <dd class="l1ix">NETCA</dd> <dd> <dl class="l2ix"> <dd class="l2ix"><span class="italic">See</span> Net Configuration Assistant (NETCA)</dd> </dl> </dd> <dd class="l1ix">network configuration</dd> <dd> <dl class="l2ix"> <dd class="l2ix">connection requests, <a href="network.htm#sthref139">4.1.1</a></dd> <dd class="l2ix">description, <a href="network.htm#sthref137">4.1</a></dd> </dl> </dd> <dd class="l1ix">notification of alerts</dd> <dd> <dl class="l2ix"> <dd class="l2ix">alert notification, <a href="em_manage.htm#sthref126">3.8.1</a></dd> </dl> </dd> <dd class="l1ix">NUMBER data type, <a href="schema.htm#sthref468">8.3.1.2.1</a></dd> </dl> <a id="O" name="O"></a> <hr /> <h2>O</h2> <dl class="l1ix"> <dd class="l1ix">object privileges, <a href="users_secure.htm#sthref367">7.2</a></dd> <dd class="l1ix">offline tablespaces, <a href="storage.htm#sthref281">6.1.6.3</a>, <a href="storage.htm#sthref309">6.3.2.3</a></dd> <dd class="l1ix">online redo log files, <a href="storage.htm#sthref331">6.4.2</a></dd> <dd> <dl class="l2ix"> <dd class="l2ix">current, <a href="storage.htm#sthref330">6.4.2</a></dd> <dd class="l2ix">description of, <a href="install.htm#sthref65">2.3.2.6</a>, <a href="storage.htm#sthref243">6.1.2</a></dd> <dd class="l2ix">multiplexing, <a href="storage.htm#sthref244">6.1.2</a>, <a href="storage.htm#sthref328">6.4.1</a></dd> <dd class="l2ix">switching, <a href="storage.htm#sthref329">6.4.2</a></dd> <dd class="l2ix">viewing, <a href="storage.htm#sthref293">6.2.2</a></dd> </dl> </dd> <dd class="l1ix">online redo log groups</dd> <dd> <dl class="l2ix"> <dd class="l2ix">description of, <a href="install.htm#sthref66">2.3.2.6</a></dd> </dl> </dd> <dd class="l1ix">online table redefinition, <a href="storage.htm#sthref313">6.3.4.1</a></dd> <dd class="l1ix">operating system groups, <a href="install.htm#sthref42">2.1.2.7</a></dd> <dd class="l1ix">Oracle Automatic Storage Management (Oracle ASM), <a href="asm.htm#sthref797">A</a></dd> <dd> <dl class="l2ix"> <dd class="l2ix">administering, <a href="asm.htm#sthref804">A.1</a></dd> <dd class="l2ix">definition, <a href="asm.htm#sthref798">A.1</a></dd> <dd class="l2ix">disk discovery, <a href="asm.htm#sthref813">A.2</a></dd> <dd class="l2ix">failure groups, <a href="asm.htm#sthref815">A.2</a></dd> <dd class="l2ix">installation, <a href="install.htm#sthref26">2.1.2.5</a></dd> <dd class="l2ix">mirroring, <a href="asm.htm#sthref800">A.1</a></dd> <dd class="l2ix">monitoring disk group space usage, <a href="asm.htm#sthref818">A.5</a></dd> <dd class="l2ix">rebalancing, <a href="asm.htm#sthref802">A.1</a></dd> </dl> </dd> <dd class="l1ix">Oracle base directory, <a href="install.htm#sthref21">2.1.2.4</a></dd> <dd class="l1ix">Oracle Enterprise Manager</dd> <dd> <dl class="l2ix"> <dd class="l2ix">Software Library concepts and configuration, <a href="software.htm#sthref778">12.2.3</a></dd> </dl> </dd> <dd class="l1ix">Oracle Enterprise Manager Database Control</dd> <dd> <dl class="l2ix"> <dd class="l2ix">backup, <a href="backrest.htm#sthref614">9.4.2</a></dd> <dd class="l2ix">backup and recovery, <a href="backrest.htm#sthref597">9.3.1</a></dd> <dd class="l2ix">configuration information, <a href="install.htm#sthref53">2.2</a></dd> <dd class="l2ix">description, <a href="em_manage.htm#sthref106">3.2</a></dd> <dd class="l2ix">features, <a href="em_manage.htm#sthref107">3.2</a></dd> <dd class="l2ix">installing, <a href="install.htm#sthref39">2.1.2.7</a></dd> <dd class="l2ix">managing databases, <a href="em_manage.htm#sthref104">3</a></dd> <dd class="l2ix">online help, <a href="em_manage.htm#sthref108">3.2</a></dd> <dd class="l2ix">starting and stopping, <a href="em_manage.htm#sthref113">3.4</a></dd> </dl> </dd> <dd class="l1ix">Oracle inventory directory, <a href="install.htm#sthref23">2.1.2.4</a></dd> <dd class="l1ix">Oracle listeners</dd> <dd> <dl class="l2ix"> <dd class="l2ix">listener.ora file, <a href="network.htm#sthref141">4.1.1</a></dd> <dd class="l2ix">starting</dd> </dl> </dd> <dd class="l1ix">Oracle Net</dd> <dd> <dl class="l2ix"> <dd class="l2ix">description, <a href="network.htm#sthref136">4.1</a></dd> <dd class="l2ix">listener configuration, <a href="network.htm#sthref138">4.1.1</a>, <a href="network.htm#sthref152">4.2</a></dd> <dd class="l2ix">mapping methods, <a href="network.htm#sthref147">4.1.2</a></dd> <dd> <dl class="l3ix"> <dd class="l3ix">directory naming, <a href="network.htm#sthref150">4.1.2</a></dd> <dd class="l3ix">easy connect naming, <a href="network.htm#sthref148">4.1.2</a></dd> <dd class="l3ix">local naming, <a href="network.htm#sthref149">4.1.2</a></dd> </dl> </dd> </dl> </dd> <dd class="l1ix">Oracle suggested repair, <a href="backrest.htm#sthref635">9.7</a></dd> <dd class="l1ix">Oracle system identifier, <a href="install.htm#sthref28">2.1.2.6</a></dd> <dd class="l1ix">ORACLE_BASE environment variable, <a href="install.htm#sthref48">2.2</a>, <a href="install.htm#sthref50">2.2</a>, <a href="install.htm#sthref52">2.2</a></dd> <dd class="l1ix">ORACLE_HOME environment variable, <a href="install.htm#sthref49">2.2</a>, <a href="install.htm#sthref51">2.2</a></dd> </dl> <a id="P" name="P"></a> <hr /> <h2>P</h2> <dl class="l1ix"> <dd class="l1ix">PAR files, <a href="software.htm#sthref779">12.2.3</a></dd> <dd class="l1ix">parameter file, <a href="storage.htm#sthref287">6.1.7</a></dd> <dd class="l1ix">partitioned tables, <a href="schema.htm#sthref482">8.3.1.4.2</a></dd> <dd class="l1ix">password file, <a href="storage.htm#sthref291">6.1.7</a></dd> <dd class="l1ix">password policies</dd> <dd> <dl class="l2ix"> <dd class="l2ix">default, <a href="users_secure.htm#sthref448">7.6.1</a></dd> <dd class="l2ix">description of, <a href="users_secure.htm#sthref449">7.6.1</a></dd> <dd class="l2ix">setting, <a href="users_secure.htm#sthref446">7.6</a></dd> </dl> </dd> <dd class="l1ix">passwords</dd> <dd> <dl class="l2ix"> <dd class="l2ix">expiring, <a href="users_secure.htm#sthref440">7.5.8</a></dd> </dl> </dd> <dd class="l1ix">patch sets, <a href="software.htm#sthref774">12.1</a></dd> <dd class="l1ix">patches, <a href="software.htm#sthref773">12.1</a></dd> <dd class="l1ix">Patching wizard, <a href="software.htm#sthref783">12.2.4</a></dd> <dd class="l1ix">PGA</dd> <dd> <dl class="l2ix"> <dd class="l2ix"><span class="italic">See</span> Program Global Area</dd> </dl> </dd> <dd class="l1ix">PGA Advisor</dd> <dd> <dl class="l2ix"> <dd class="l2ix">description, <a href="montune.htm#sthref709">10.3.1</a></dd> </dl> </dd> <dd class="l1ix">PMON process, <a href="network.htm#sthref143">4.1.1</a>, <a href="instance.htm#sthref176">5.1.2</a></dd> <dd class="l1ix">predefined roles, <a href="users_secure.htm#sthref373">7.2</a></dd> <dd class="l1ix">privileges</dd> <dd> <dl class="l2ix"> <dd class="l2ix">administrative, <a href="users_secure.htm#sthref382">7.3</a></dd> <dd class="l2ix">and synonyms, <a href="schema.htm#sthref567">8.7</a></dd> <dd class="l2ix">authenticating SYSDBA and SYSOPER users, <a href="storage.htm#sthref290">6.1.7</a></dd> <dd class="l2ix">connection, <a href="instance.htm#sthref198">5.1.5.1</a></dd> <dd class="l2ix">for installation of Oracle Database software, <a href="install.htm#sthref46">2.2</a></dd> <dd class="l2ix">granting, <a href="users_secure.htm#sthref417">7.5.4</a></dd> <dd class="l2ix">granting to a Database Control administrative user, <a href="em_manage.htm#sthref122">3.7</a></dd> <dd class="l2ix">object, <a href="users_secure.htm#sthref368">7.2</a></dd> <dd class="l2ix">recommended, <a href="users_secure.htm#sthref361">7.1</a></dd> <dd class="l2ix">required for database administration, <a href="em_manage.htm#sthref115">3.6</a>, <a href="users_secure.htm#sthref384">7.3</a></dd> <dd class="l2ix">revoking a system, <a href="users_secure.htm#sthref424">7.5.4</a></dd> <dd class="l2ix">schema object management, <a href="schema.htm#sthref455">8.2</a></dd> <dd class="l2ix">SYSASM, <a href="asm.htm#sthref808">A.1</a></dd> <dd class="l2ix">SYSDBA, <a href="instance.htm#sthref206">5.1.5.1</a>, <a href="backrest.htm#sthref598">9.3.1</a></dd> <dd class="l2ix">SYSOPER, <a href="instance.htm#sthref199">5.1.5.1</a></dd> <dd class="l2ix">system, <a href="users_secure.htm#sthref366">7.2</a></dd> <dd class="l2ix">users, <a href="users_secure.htm#sthref363">7.2</a></dd> <dd> <dl class="l3ix"> <dd class="l3ix">using roles to manage, <a href="users_secure.htm#sthref369">7.2</a></dd> </dl> </dd> </dl> </dd> <dd class="l1ix">problem activity logs</dd> <dd> <dl class="l2ix"> <dd class="l2ix">adding comments to, <a href="problems.htm#sthref762">11.2.6</a></dd> </dl> </dd> <dd class="l1ix">problems</dd> <dd> <dl class="l2ix"> <dd class="l2ix">about, <a href="problems.htm#sthref741">11.1</a></dd> <dd class="l2ix">adding comments to activity logs, <a href="problems.htm#sthref764">11.2.6</a></dd> <dd class="l2ix">problem key, <a href="problems.htm#sthref743">11.1</a></dd> <dd class="l2ix">viewing, <a href="problems.htm#sthref769">11.3</a></dd> <dd class="l2ix">viewing detail, <a href="problems.htm#sthref752">11.2.3</a></dd> </dl> </dd> <dd class="l1ix">procedures, <a href="schema.htm#sthref548">8.6.1</a></dd> <dd class="l1ix">profiles, <a href="users_secure.htm#sthref450">7.6.1</a></dd> <dd class="l1ix">Program Global Area (PGA)</dd> <dd> <dl class="l2ix"> <dd class="l2ix">components, <a href="instance.htm#sthref192">5.1.4.2</a></dd> <dd class="l2ix">definition, <a href="instance.htm#sthref194">5.1.4.2</a></dd> <dd class="l2ix">description, <a href="instance.htm#sthref190">5.1.4.2</a></dd> <dd class="l2ix">target setting, <a href="montune.htm#sthref738">10.3.8.1</a></dd> </dl> </dd> <dd class="l1ix">Provisioning procedures, <a href="software.htm#sthref780">12.2.3</a></dd> </dl> <a id="Q" name="Q"></a> <hr /> <h2>Q</h2> <dl class="l1ix"> <dd class="l1ix">quotas</dd> <dd> <dl class="l2ix"> <dd class="l2ix">assigning for a tablespace, <a href="users_secure.htm#sthref429">7.5.5</a></dd> </dl> </dd> </dl> <a id="R" name="R"></a> <hr /> <h2>R</h2> <dl class="l1ix"> <dd class="l1ix">read consistency, <a href="storage.htm#sthref336">6.5.1</a></dd> <dd class="l1ix">read only tablespaces, <a href="storage.htm#sthref280">6.1.6.3</a></dd> <dd class="l1ix">read write tablespaces, <a href="storage.htm#sthref279">6.1.6.3</a></dd> <dd class="l1ix">rebalancing, <a href="asm.htm#sthref801">A.1</a></dd> <dd class="l1ix">reclaiming space, <a href="storage.htm#sthref316">6.3.4.1</a></dd> <dd class="l1ix">recovery</dd> <dd> <dl class="l2ix"> <dd class="l2ix">complete, <a href="backrest.htm#sthref589">9.2.2</a></dd> <dd class="l2ix">configuration, <a href="install.htm#sthref63">2.3.2.6</a></dd> <dd class="l2ix">fast recovery area, <a href="backrest.htm#sthref593">9.2.3</a></dd> <dd class="l2ix">incomplete, <a href="backrest.htm#sthref590">9.2.2</a></dd> <dd class="l2ix">media, <a href="backrest.htm#sthref586">9.2.2</a></dd> <dd class="l2ix">overview, <a href="backrest.htm#sthref572">9.1</a></dd> <dd class="l2ix">whole database recovery, <a href="backrest.htm#sthref652">9.8.3</a>, <a href="backrest.htm#sthref654">9.8.3</a></dd> </dl> </dd> <dd class="l1ix">Recovery Manager (RMAN)</dd> <dd> <dl class="l2ix"> <dd class="l2ix">channels, <a href="backrest.htm#sthref607">9.3.5.1</a></dd> <dd class="l2ix">control file use, <a href="backrest.htm#sthref596">9.2.4</a></dd> <dd class="l2ix">overview, <a href="backrest.htm#sthref574">9.1</a></dd> <dd class="l2ix">parallelism, <a href="backrest.htm#sthref608">9.3.5.1</a></dd> <dd class="l2ix">recovery catalog, <a href="backrest.htm#sthref595">9.2.4</a></dd> <dd class="l2ix">repository, <a href="backrest.htm#sthref594">9.2.4</a></dd> </dl> </dd> <dd class="l1ix">recycle bins, <a href="schema.htm#sthref525">8.3.7</a></dd> <dd class="l1ix">redo log files</dd> <dd> <dl class="l2ix"> <dd class="l2ix"><span class="italic">See</span> online redo log files <span class="italic">or</span> archived redo log files</dd> </dl> </dd> <dd class="l1ix">reference collection, <a href="montune.htm#sthref668">10.1.3</a></dd> <dd class="l1ix">reorganizing tables, <a href="storage.htm#sthref314">6.3.4.1</a></dd> <dd class="l1ix">repairs</dd> <dd> <dl class="l2ix"> <dd class="l2ix">customized, <a href="backrest.htm#sthref641">9.8</a></dd> <dd class="l2ix">Oracle suggested, <a href="backrest.htm#sthref636">9.7</a></dd> </dl> </dd> <dd class="l1ix">RESOURCE role, <a href="users_secure.htm#sthref376">7.2</a>, <a href="schema.htm#sthref459">8.2</a></dd> <dd class="l1ix">revalidating schema objects, <a href="schema.htm#sthref558">8.6.2</a></dd> <dd class="l1ix">revoking</dd> <dd> <dl class="l2ix"> <dd class="l2ix">roles, <a href="users_secure.htm#sthref425">7.5.4</a></dd> <dd class="l2ix">system privileges, <a href="users_secure.htm#sthref426">7.5.4</a></dd> </dl> </dd> <dd class="l1ix">roles</dd> <dd> <dl class="l2ix"> <dd class="l2ix">administering, <a href="users_secure.htm#sthref392">7.4</a></dd> <dd class="l2ix">CONNECT, <a href="users_secure.htm#sthref375">7.2</a></dd> <dd class="l2ix">DBA, <a href="users_secure.htm#sthref379">7.2</a>, <a href="schema.htm#sthref458">8.2</a></dd> <dd class="l2ix">granting, <a href="users_secure.htm#sthref418">7.5.4</a></dd> <dd class="l2ix">predefined, <a href="users_secure.htm#sthref372">7.2</a></dd> <dd class="l2ix">RESOURCE, <a href="users_secure.htm#sthref377">7.2</a>, <a href="schema.htm#sthref460">8.2</a></dd> <dd class="l2ix">revoking, <a href="users_secure.htm#sthref423">7.5.4</a></dd> <dd class="l2ix">using to manage user privileges, <a href="users_secure.htm#sthref370">7.2</a></dd> <dd class="l2ix">viewing, <a href="users_secure.htm#sthref393">7.4.1</a></dd> </dl> </dd> <dd class="l1ix">rollback, <a href="storage.htm#sthref335">6.5.1</a></dd> <dd class="l1ix">rollback segments</dd> <dd> <dl class="l2ix"> <dd class="l2ix">description, <a href="storage.htm#sthref247">6.1.4</a></dd> </dl> </dd> </dl> <a id="S" name="S"></a> <hr /> <h2>S</h2> <dl class="l1ix"> <dd class="l1ix">sample schemas</dd> <dd> <dl class="l2ix"> <dd class="l2ix">configuring, <a href="install.htm#sthref73">2.3.2.7</a></dd> <dd class="l2ix">installation of, <a href="install.htm#sthref37">2.1.2.7</a></dd> </dl> </dd> <dd class="l1ix">schema objects</dd> <dd> <dl class="l2ix"> <dd class="l2ix">compiling, <a href="schema.htm#sthref559">8.6.2</a></dd> <dd class="l2ix">database links, <a href="schema.htm#sthref569">8.7</a></dd> <dd class="l2ix">description of, <a href="schema.htm#sthref453">8.1</a></dd> <dd class="l2ix">indexes, <a href="schema.htm#sthref526">8.4.1</a></dd> <dd> <dl class="l3ix"> <dd class="l3ix">creating, <a href="schema.htm#sthref533">8.4.3</a></dd> <dd class="l3ix">viewing, <a href="schema.htm#sthref530">8.4.2</a></dd> </dl> </dd> <dd class="l2ix">invalid, <a href="schema.htm#sthref554">8.6.1</a></dd> <dd class="l2ix">privileges, <a href="schema.htm#sthref456">8.2</a></dd> <dd class="l2ix">sequences, <a href="schema.htm#sthref563">8.7</a></dd> <dd class="l2ix">synonyms, <a href="schema.htm#sthref565">8.7</a></dd> <dd class="l2ix">tables, <a href="schema.htm#sthref461">8.3.1</a></dd> <dd> <dl class="l3ix"> <dd class="l3ix">constraints, <a href="schema.htm#sthref473">8.3.1.3</a></dd> <dd class="l3ix">modifying, <a href="schema.htm#sthref497">8.3.5</a></dd> </dl> </dd> <dd class="l2ix">validating, <a href="schema.htm#sthref560">8.6.2</a></dd> <dd class="l2ix">views, <a href="schema.htm#sthref538">8.5.1</a></dd> </dl> </dd> <dd class="l1ix">schemas, <a href="users_secure.htm#sthref362">7.1</a></dd> <dd class="l1ix">SecureFiles, <a href="schema.htm#sthref480">8.3.1.4.1</a></dd> <dd class="l1ix">security options, <a href="install.htm#sthref36">2.1.2.7</a></dd> <dd class="l1ix">Segment Advisor</dd> <dd> <dl class="l2ix"> <dd class="l2ix">description, <a href="montune.htm#sthref712">10.3.1</a></dd> <dd class="l2ix">description of, <a href="storage.htm#sthref318">6.3.4.2</a></dd> <dd class="l2ix">manual operation, <a href="storage.htm#sthref327">6.3.4.4</a></dd> <dd class="l2ix">recommendations, <a href="storage.htm#sthref320">6.3.4.2.1</a></dd> <dd class="l2ix">viewing recommendations, <a href="storage.htm#sthref323">6.3.4.3</a></dd> </dl> </dd> <dd class="l1ix">segments</dd> <dd> <dl class="l2ix"> <dd class="l2ix">description of, <a href="storage.htm#sthref250">6.1.5</a></dd> </dl> </dd> <dd class="l1ix">sequences</dd> <dd> <dl class="l2ix"> <dd class="l2ix">description, <a href="schema.htm#sthref564">8.7</a></dd> </dl> </dd> <dd class="l1ix">server parameter files, <a href="instance.htm#sthref157">5.1</a>, <a href="instance.htm#sthref161">5.1.1</a></dd> <dd class="l1ix">server processes</dd> <dd> <dl class="l2ix"> <dd class="l2ix">description, <a href="instance.htm#sthref181">5.1.3</a></dd> </dl> </dd> <dd class="l1ix">service requests</dd> <dd> <dl class="l2ix"> <dd class="l2ix">creating, <a href="problems.htm#sthref754">11.2.4</a></dd> <dd class="l2ix">tracking, <a href="problems.htm#sthref761">11.2.6</a></dd> </dl> </dd> <dd class="l1ix">services</dd> <dd> <dl class="l2ix"> <dd class="l2ix">on Microsoft Windows, <a href="instance.htm#sthref212">5.2.2</a></dd> </dl> </dd> <dd class="l1ix">session</dd> <dd> <dl class="l2ix"> <dd class="l2ix">description of, <a href="instance.htm#sthref191">5.1.4.2</a></dd> </dl> </dd> <dd class="l1ix">setting</dd> <dd> <dl class="l2ix"> <dd class="l2ix">password policies, <a href="users_secure.htm#sthref447">7.6</a></dd> </dl> </dd> <dd class="l1ix">SGA</dd> <dd> <dl class="l2ix"> <dd class="l2ix"><span class="italic">See</span> System Global Area</dd> </dl> </dd> <dd class="l1ix">Shared Pool Advisor</dd> <dd> <dl class="l2ix"> <dd class="l2ix">description, <a href="montune.htm#sthref705">10.3.1</a></dd> </dl> </dd> <dd class="l1ix">shared server mode, <a href="install.htm#sthref85">2.3.2.8.4</a></dd> <dd class="l1ix">shared server processes, <a href="instance.htm#sthref183">5.1.3</a></dd> <dd class="l1ix">shrinking segments, <a href="storage.htm#sthref315">6.3.4.1</a></dd> <dd class="l1ix">shutting down databases</dd> <dd> <dl class="l2ix"> <dd class="l2ix">Microsoft Windows, <a href="instance.htm#sthref214">5.2.2</a></dd> </dl> </dd> <dd class="l1ix">SID, <a href="install.htm#sthref29">2.1.2.6</a></dd> <dd class="l1ix">SMON process, <a href="instance.htm#sthref174">5.1.2</a></dd> <dd class="l1ix">snapshots, <a href="montune.htm#sthref663">10.1.2</a></dd> <dd class="l1ix">Software Library</dd> <dd> <dl class="l2ix"> <dd class="l2ix">configuring, <a href="software.htm#sthref776">12.2.3</a></dd> </dl> </dd> <dd class="l1ix">software library</dd> <dd> <dl class="l2ix"> <dd class="l2ix">configuring, <a href="software.htm#sthref777">12.2.3</a></dd> </dl> </dd> <dd class="l1ix">source code, Java, <a href="schema.htm#sthref553">8.6.1</a></dd> <dd class="l1ix">space usage alerts for tablespaces, <a href="storage.htm#sthref307">6.3.2.2</a></dd> <dd class="l1ix">SQL Access Advisor</dd> <dd> <dl class="l2ix"> <dd class="l2ix">using, <a href="montune.htm#sthref718">10.3.2</a></dd> </dl> </dd> <dd class="l1ix">SQL Advisors</dd> <dd> <dl class="l2ix"> <dd class="l2ix">about, <a href="montune.htm#sthref716">10.3.2</a></dd> <dd class="l2ix">description, <a href="montune.htm#sthref694">10.3.1</a></dd> </dl> </dd> <dd class="l1ix">SQL Profile, <a href="montune.htm#sthref721">10.3.3</a></dd> <dd class="l1ix">SQL Response Time, <a href="montune.htm#sthref669">10.1.3</a></dd> <dd class="l1ix">SQL statements</dd> <dd> <dl class="l2ix"> <dd class="l2ix">about, <a href="em_manage.htm#sthref135">3.9.1</a></dd> </dl> </dd> <dd class="l1ix">SQL Tuning Advisor</dd> <dd> <dl class="l2ix"> <dd class="l2ix">about, <a href="montune.htm#sthref717">10.3.2</a></dd> <dd class="l2ix">using, <a href="montune.htm#sthref730">10.3.6</a></dd> </dl> </dd> <dd class="l1ix">SQL Tuning Set, <a href="montune.htm#sthref667">10.1.3</a></dd> <dd class="l1ix">SQL*Loader</dd> <dd> <dl class="l2ix"> <dd class="l2ix">control file, <a href="schema.htm#sthref519">8.3.6</a></dd> </dl> </dd> <dd class="l1ix">Standard Edition, <a href="install.htm#sthref18">2.1.2.3</a></dd> <dd class="l1ix">starting databases</dd> <dd> <dl class="l2ix"> <dd class="l2ix">Microsoft Windows, <a href="instance.htm#sthref213">5.2.2</a></dd> </dl> </dd> <dd class="l1ix">startup and shutdown</dd> <dd> <dl class="l2ix"> <dd class="l2ix">about, <a href="instance.htm#sthref195">5.1.5</a></dd> <dd class="l2ix">privileges required for, <a href="instance.htm#sthref205">5.1.5.1</a></dd> </dl> </dd> <dd class="l1ix">subprograms, <a href="schema.htm#sthref546">8.6.1</a></dd> <dd class="l1ix">Support Workbench</dd> <dd> <dl class="l2ix"> <dd class="l2ix">about, <a href="problems.htm#sthref740">11</a></dd> <dd class="l2ix">Custom Packaging process, <a href="problems.htm#sthref758">11.2.5</a></dd> <dd class="l2ix">home page, <a href="problems.htm#sthref746">11.2.1</a></dd> <dd class="l2ix">Quick Packaging process, <a href="problems.htm#sthref756">11.2.5</a></dd> <dd class="l2ix">viewing problems, <a href="problems.htm#sthref770">11.3</a></dd> </dl> </dd> <dd class="l1ix">synonyms</dd> <dd> <dl class="l2ix"> <dd class="l2ix">and privileges, <a href="schema.htm#sthref568">8.7</a></dd> <dd class="l2ix">description, <a href="schema.htm#sthref566">8.7</a></dd> </dl> </dd> <dd class="l1ix">SYS user, <a href="em_manage.htm#sthref116">3.7</a>, <a href="em_manage.htm#sthref119">3.7</a>, <a href="instance.htm#sthref202">5.1.5.1</a>, <a href="users_secure.htm#sthref385">7.3.1</a></dd> <dd class="l1ix">SYSASM system privilege, <a href="asm.htm#sthref806">A.1</a></dd> <dd class="l1ix">SYSAUX tablespace, <a href="storage.htm#sthref262">6.1.6</a></dd> <dd class="l1ix">SYSDBA, <a href="install.htm#sthref40">2.1.2.7</a></dd> <dd class="l1ix">SYSDBA system privilege, <a href="instance.htm#sthref204">5.1.5.1</a>, <a href="storage.htm#sthref288">6.1.7</a>, <a href="users_secure.htm#sthref388">7.3.2</a></dd> <dd class="l1ix">SYSMAN user, <a href="em_manage.htm#sthref118">3.7</a>, <a href="em_manage.htm#sthref121">3.7</a></dd> <dd class="l1ix">SYSOPER, <a href="install.htm#sthref41">2.1.2.7</a></dd> <dd class="l1ix">SYSOPER system privilege, <a href="storage.htm#sthref289">6.1.7</a>, <a href="users_secure.htm#sthref389">7.3.2</a></dd> <dd class="l1ix">System Global Area (SGA)</dd> <dd> <dl class="l2ix"> <dd class="l2ix">components, <a href="instance.htm#sthref188">5.1.4.1</a></dd> <dd class="l2ix">description, <a href="instance.htm#sthref187">5.1.4.1</a></dd> <dd class="l2ix">target setting, <a href="montune.htm#sthref737">10.3.8.1</a></dd> </dl> </dd> <dd class="l1ix">system identifier (SID), <a href="install.htm#sthref30">2.1.2.6</a></dd> <dd class="l1ix">system privileges, <a href="users_secure.htm#sthref365">7.2</a></dd> <dd> <dl class="l2ix"> <dd class="l2ix">SYSASM, <a href="asm.htm#sthref810">A.1</a></dd> <dd class="l2ix">SYSDBA and SYSOPER, <a href="users_secure.htm#sthref390">7.3.2</a></dd> </dl> </dd> <dd class="l1ix">SYSTEM tablespace, <a href="storage.htm#sthref260">6.1.6</a></dd> <dd class="l1ix">SYSTEM user, <a href="em_manage.htm#sthref117">3.7</a>, <a href="em_manage.htm#sthref120">3.7</a>, <a href="instance.htm#sthref203">5.1.5.1</a>, <a href="users_secure.htm#sthref386">7.3.1</a></dd> </dl> <a id="T" name="T"></a> <hr /> <h2>T</h2> <dl class="l1ix"> <dd class="l1ix">tables</dd> <dd> <dl class="l2ix"> <dd class="l2ix">adding columns to, <a href="schema.htm#sthref499">8.3.5.1</a></dd> <dd class="l2ix">adding constraints, <a href="schema.htm#sthref506">8.3.5.3</a></dd> <dd class="l2ix">compressed, <a href="storage.htm#sthref322">6.3.4.2.1</a>, <a href="schema.htm#sthref485">8.3.1.4.4</a></dd> <dd class="l2ix">creating, <a href="schema.htm#sthref493">8.3.4</a></dd> <dd class="l2ix">deleting, <a href="schema.htm#sthref523">8.3.7</a></dd> <dd class="l2ix">deleting columns, <a href="schema.htm#sthref502">8.3.5.2</a></dd> <dd class="l2ix">deleting constraints, <a href="schema.htm#sthref512">8.3.5.5</a></dd> <dd class="l2ix">description, <a href="schema.htm#sthref462">8.3.1</a></dd> <dd class="l2ix">loading data into, <a href="schema.htm#sthref517">8.3.6</a></dd> <dd class="l2ix">LOB columns, <a href="schema.htm#sthref479">8.3.1.4.1</a></dd> <dd class="l2ix">modifying attributes, <a href="schema.htm#sthref496">8.3.5</a></dd> <dd class="l2ix">modifying constraints, <a href="schema.htm#sthref509">8.3.5.4</a></dd> <dd class="l2ix">partitions, <a href="schema.htm#sthref483">8.3.1.4.2</a></dd> <dd class="l2ix">retrieving a dropped table, <a href="backrest.htm#sthref649">9.8.2.2</a></dd> <dd class="l2ix">viewing data in, <a href="schema.htm#sthref490">8.3.3</a></dd> <dd class="l2ix">viewing information about, <a href="schema.htm#sthref486">8.3.2</a></dd> </dl> </dd> <dd class="l1ix">tablespaces</dd> <dd> <dl class="l2ix"> <dd class="l2ix">autoextend, <a href="storage.htm#sthref283">6.1.6.4</a>, <a href="storage.htm#sthref303">6.3.2.1</a></dd> <dd class="l2ix">autoextend and Oracle Flashback, <a href="storage.htm#sthref343">6.5.2</a></dd> <dd class="l2ix">creating, <a href="storage.htm#sthref297">6.3.1</a></dd> <dd class="l2ix">description, <a href="storage.htm#sthref256">6.1.6</a></dd> <dd class="l2ix">dropping, <a href="storage.htm#sthref312">6.3.3</a></dd> <dd class="l2ix">EXAMPLE, <a href="storage.htm#sthref259">6.1.6</a></dd> <dd class="l2ix">extending undo tablespaces, <a href="storage.htm#sthref347">6.5.2</a></dd> <dd class="l2ix">locally managed, <a href="storage.htm#sthref270">6.1.6.1</a></dd> <dd class="l2ix">modifying, <a href="storage.htm#sthref300">6.3.2</a></dd> <dd class="l2ix">offline, <a href="storage.htm#sthref278">6.1.6.3</a></dd> <dd class="l2ix">quotas, <a href="users_secure.htm#sthref430">7.5.5</a></dd> <dd class="l2ix">read only and read write, <a href="storage.htm#sthref277">6.1.6.3</a></dd> <dd class="l2ix">Segment Advisor, <a href="storage.htm#sthref301">6.3.2</a></dd> <dd class="l2ix">space usage alerts, <a href="storage.htm#sthref305">6.3.2.2</a></dd> <dd class="l2ix">SYSAUX, <a href="storage.htm#sthref263">6.1.6</a></dd> <dd class="l2ix">SYSTEM, <a href="storage.htm#sthref261">6.1.6</a></dd> <dd class="l2ix">taking offline, <a href="storage.htm#sthref310">6.3.2.3</a></dd> <dd class="l2ix">TEMP, <a href="storage.htm#sthref265">6.1.6</a></dd> <dd class="l2ix">temporary tablespaces, <a href="storage.htm#sthref275">6.1.6.2</a></dd> <dd class="l2ix">types of, <a href="storage.htm#sthref272">6.1.6.2</a></dd> <dd class="l2ix">undo tablespaces, <a href="storage.htm#sthref274">6.1.6.2</a>, <a href="storage.htm#sthref338">6.5.1</a></dd> <dd class="l2ix">UNDOTBS1, <a href="storage.htm#sthref267">6.1.6</a></dd> <dd class="l2ix">USERS, <a href="storage.htm#sthref269">6.1.6</a></dd> <dd class="l2ix">viewing information about, <a href="storage.htm#sthref296">6.2.5</a></dd> </dl> </dd> <dd class="l1ix">TEMP tablespace, <a href="storage.htm#sthref264">6.1.6</a></dd> <dd class="l1ix">templates</dd> <dd> <dl class="l2ix"> <dd class="l2ix">creating databases with, <a href="install.htm#sthref59">2.3.2.1</a></dd> <dd class="l2ix">using with DBCA, <a href="install.htm#sthref93">2.3.5</a></dd> </dl> </dd> <dd class="l1ix">temporary tablespaces, <a href="storage.htm#sthref276">6.1.6.2</a></dd> <dd class="l1ix">triggers, <a href="schema.htm#sthref547">8.6.1</a></dd> </dl> <a id="U" name="U"></a> <hr /> <h2>U</h2> <dl class="l1ix"> <dd class="l1ix">undo</dd> <dd> <dl class="l2ix"> <dd class="l2ix">about, <a href="storage.htm#sthref334">6.5.1</a></dd> <dd class="l2ix">advisor, <a href="storage.htm#sthref354">6.5.4</a></dd> <dd class="l2ix">managing, <a href="storage.htm#sthref333">6.5</a>, <a href="storage.htm#sthref341">6.5.2</a></dd> <dd class="l2ix">tablespaces, <a href="storage.htm#sthref273">6.1.6.2</a></dd> <dd class="l2ix">viewing, <a href="storage.htm#sthref348">6.5.3</a></dd> </dl> </dd> <dd class="l1ix">Undo Advisor</dd> <dd> <dl class="l2ix"> <dd class="l2ix">computing minimum undo tablespace size with, <a href="storage.htm#sthref350">6.5.4</a></dd> <dd class="l2ix">description, <a href="montune.htm#sthref714">10.3.1</a></dd> <dd class="l2ix">setting minimum undo retention period with, <a href="storage.htm#sthref351">6.5.4</a></dd> </dl> </dd> <dd class="l1ix">undo retention, <a href="storage.htm#sthref340">6.5.1</a></dd> <dd class="l1ix">undo retention period</dd> <dd> <dl class="l2ix"> <dd class="l2ix">setting with Undo Advisor, <a href="storage.htm#sthref352">6.5.4</a></dd> </dl> </dd> <dd class="l1ix">undo tablespaces</dd> <dd> <dl class="l2ix"> <dd class="l2ix">autoextend, <a href="storage.htm#sthref346">6.5.2</a></dd> <dd class="l2ix">changing to fixed-size, <a href="storage.htm#sthref358">6.5.5</a></dd> <dd class="l2ix">computing minimum size for fixed-size tablespace, <a href="storage.htm#sthref353">6.5.4</a></dd> <dd class="l2ix">default configuration, <a href="storage.htm#sthref339">6.5.1</a></dd> <dd class="l2ix">description of, <a href="storage.htm#sthref337">6.5.1</a></dd> </dl> </dd> <dd class="l1ix">UNDOTBS1 tablespace, <a href="storage.htm#sthref266">6.1.6</a></dd> <dd class="l1ix">upgrading a database, <a href="software.htm#sthref794">12.4.4</a></dd> <dd class="l1ix">user-defined data types, <a href="schema.htm#sthref477">8.3.1.4.1</a></dd> <dd class="l1ix">users</dd> <dd> <dl class="l2ix"> <dd class="l2ix">accounts</dd> <dd> <dl class="l3ix"> <dd class="l3ix">administrative, <a href="users_secure.htm#sthref381">7.3</a></dd> <dd class="l3ix">description, <a href="users_secure.htm#sthref359">7</a></dd> </dl> </dd> <dd class="l2ix">administering, <a href="users_secure.htm#sthref403">7.5</a></dd> <dd class="l2ix">creating, <a href="users_secure.htm#sthref409">7.5.2</a></dd> <dd class="l2ix">creating by duplication, <a href="users_secure.htm#sthref415">7.5.3</a></dd> <dd class="l2ix">deleting, <a href="users_secure.htm#sthref443">7.5.9</a></dd> <dd class="l2ix">duplicating, <a href="users_secure.htm#sthref414">7.5.3</a></dd> <dd class="l2ix">expiring passwords for, <a href="users_secure.htm#sthref439">7.5.8</a></dd> <dd class="l2ix">locking and unlocking, <a href="users_secure.htm#sthref436">7.5.7</a></dd> <dd class="l2ix">modifying, <a href="users_secure.htm#sthref433">7.5.6</a></dd> <dd class="l2ix">privileges, <a href="users_secure.htm#sthref364">7.2</a></dd> <dd class="l2ix">SYSASM, <a href="asm.htm#sthref807">A.1</a></dd> <dd class="l2ix">viewing, <a href="users_secure.htm#sthref405">7.5.1</a></dd> </dl> </dd> <dd class="l1ix">USERS tablespace, <a href="storage.htm#sthref268">6.1.6</a></dd> </dl> <a id="V" name="V"></a> <hr /> <h2>V</h2> <dl class="l1ix"> <dd class="l1ix">validating schema objects, <a href="schema.htm#sthref557">8.6.2</a></dd> <dd class="l1ix">VARCHAR2 data type, <a href="schema.htm#sthref466">8.3.1.2.1</a></dd> <dd class="l1ix">viewing</dd> <dd> <dl class="l2ix"> <dd class="l2ix">indexes, <a href="schema.htm#sthref532">8.4.2</a></dd> <dd class="l2ix">initialization parameters, <a href="instance.htm#sthref217">5.3</a></dd> <dd class="l2ix">table data, <a href="schema.htm#sthref489">8.3.3</a></dd> <dd class="l2ix">table information, <a href="schema.htm#sthref487">8.3.2</a></dd> <dd class="l2ix">users, <a href="users_secure.htm#sthref406">7.5.1</a></dd> <dd class="l2ix">views, <a href="schema.htm#sthref541">8.5.2</a></dd> </dl> </dd> <dd class="l1ix">views</dd> <dd> <dl class="l2ix"> <dd class="l2ix">deleting, <a href="schema.htm#sthref542">8.5.4</a></dd> <dd class="l2ix">description, <a href="schema.htm#sthref539">8.5.1</a></dd> <dd class="l2ix">displaying, <a href="schema.htm#sthref540">8.5.2</a></dd> </dl> </dd> </dl> <a id="W" name="W"></a> <hr /> <h2>W</h2> <dl class="l1ix"> <dd class="l1ix">wizards</dd> <dd> <dl class="l2ix"> <dd class="l2ix">Create Blackout, <a href="em_manage.htm#sthref131">3.8.2</a></dd> <dd class="l2ix">database creation, <a href="install.htm#sthref58">2.3.2</a></dd> <dd class="l2ix">incident reporting, <a href="problems.htm#sthref748">11.2.1</a>, <a href="problems.htm#sthref757">11.2.5</a></dd> <dd class="l2ix">Load Data wizard, <a href="schema.htm#sthref521">8.3.6</a></dd> <dd class="l2ix">Oracle ASM migration, <a href="asm.htm#sthref803">A.1</a></dd> <dd class="l2ix">Patching, <a href="software.htm#sthref782">12.2.4</a></dd> <dd class="l2ix">Quick Packaging, <a href="problems.htm#sthref759">11.2.5</a></dd> <dd class="l2ix">Recovery, <a href="backrest.htm#sthref591">9.2.2</a>, <a href="backrest.htm#sthref642">9.8</a>, <a href="backrest.htm#sthref653">9.8.3</a></dd> <dd class="l2ix">Schedule Customized Backup, <a href="backrest.htm#sthref619">9.4.2.3</a></dd> <dd class="l2ix">SQL Access Advisor, <a href="montune.htm#sthref733">10.3.7</a></dd> </dl> </dd> </dl> </div> <!-- class="ind" --> <div class="footer"> <hr /> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="33%" /> <col width="*" /> <col width="33%" /> <tr> <td align="left"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="49"> <tr> <td align="center" valign="top"><a href="asm.htm"><img width="24" height="24" src="../../dcommon/gifs/leftnav.gif" alt="Go to previous page" /><br /> <span class="icon">Previous</span></a></td> </tr> </table> </td> <td style="font-size: 90%" align="center" class="copyrightlogo"><img width="144" height="18" src="../../dcommon/gifs/oracle.gif" alt="Oracle" /><br /> Copyright © 2004, 2009, Oracle and/or its affiliates. All rights reserved.<br /> <a href="../../dcommon/html/cpyr.htm">Legal Notices</a></td> <td align="right"> <table class="icons oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="196"> <tr> <td align="center" valign="top"><a href="../../index.htm"><img width="24" height="24" src="../../dcommon/gifs/doclib.gif" alt="Go to Documentation Home" /><br /> <span class="icon">Home</span></a></td> <td align="center" valign="top"><a href="../../nav/portal_booklist.htm"><img width="24" height="24" src="../../dcommon/gifs/booklist.gif" alt="Go to Book List" /><br /> <span class="icon">Book List</span></a></td> <td align="center" valign="top"><a href="toc.htm"><img width="24" height="24" src="../../dcommon/gifs/toc.gif" alt="Go to Table of Contents" /><br /> <span class="icon">Contents</span></a></td> <td align="center" valign="top"><a href="../../dcommon/html/feedback.htm"><img width="24" height="24" src="../../dcommon/gifs/feedbck2.gif" alt="Go to Feedback page" /><br /> <span class="icon">Contact Us</span></a></td> </tr> </table> </td> </tr> </table> </div> <noscript> <p>Scripting on this page enhances content navigation, but does not change the content in any way.</p> </noscript> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de