Edit D:\rfid\database\database\doc\win.112\e10845\tools.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="2010-03-05T15:45:35Z" /> <meta name="doctitle" content="Oracle® Database Platform Guide 11g Release 2 (11.2) for Microsoft Windows" /> <meta name="partno" content="E10845-01" /> <meta name="docid" content="NTQRF" /> <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="Index" href="index.htm" title="Index" type="text/html" /> <link rel="Glossary" href="glossary.htm" title="Glossary" type="text/html" /> <link rel="Prev" href="architec.htm" title="Previous" type="text/html" /> <link rel="Next" href="create.htm" title="Next" type="text/html" /> <link rel="alternate" href="../e10845.pdf" title="PDF version" type="application/pdf" /> <title>Database Tools on Windows</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 Platform Guide<br /> 11<i>g</i> Release 2 (11.2) for Microsoft Windows</b><br /> Part Number E10845-01</td> <td valign="bottom" align="right"> <table class="icons oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="245"> <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="index.htm"><img width="24" height="24" src="../../dcommon/gifs/index.gif" alt="Go to Index" /><br /> <span class="icon">Index</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="98"> <tr> <td align="center" valign="top"><a href="architec.htm"><img width="24" height="24" src="../../dcommon/gifs/leftnav.gif" alt="Go to previous page" /><br /> <span class="icon">Previous</span></a></td> <td align="center" valign="top"><a href="create.htm"><img width="24" height="24" src="../../dcommon/gifs/rightnav.gif" alt="Go to next page" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </td> <td align="right" valign="top" style="font-size: 90%"><a href="../e10845.pdf">View PDF</a></td> </tr> </table> <a name="BEGIN" id="BEGIN"></a></div> <div class="IND"><!-- End Header --><a id="g1019547" name="g1019547"></a><a id="NTQRF040" name="NTQRF040"></a><a id="i1007485" name="i1007485"></a> <h1 class="chapter"><span class="secnum">2</span> Database Tools on Windows</h1> <p>Oracle Database for Windows includes various tools to perform database functions. This chapter describes preferred tools to perform common database administration tasks and explains how tools can be started.</p> <p>Unless otherwise noted, features described in this guide are common to Oracle Database Enterprise Edition, Oracle Database Standard Edition, Oracle Database Standard Edition One and Oracle Database Personal Edition.</p> <p>This chapter contains these topics:</p> <ul> <li> <p><a href="#i1005655">Choosing a Database Tool</a></p> </li> <li> <p><a href="#i1006205">Starting Database Tools</a></p> </li> <li> <p><a href="#i1006973">Using SQL*Loader</a></p> </li> <li> <p><a href="#i1007064">Using Windows Tools</a></p> </li> <li> <p><a href="#i1007213">Optional Windows Diagnostic and Tuning Utilities</a></p> </li> </ul> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <ul> <li> <p><a href="admin.htm#g1021616">Chapter 5, "Administering a Database on Windows"</a> for OracleService<span class="italic">SID</span> configuration tasks</p> </li> <li> <p><a href="monitor.htm#g1012722">Chapter 6, "Monitoring a Database on Windows"</a> for thread management tasks</p> </li> <li> <p><a href="authen.htm#g1010864">Chapter 9, "Authenticating Database Users with Windows"</a> for authentication tasks</p> </li> <li> <p><a href="registry.htm#g1015622">Chapter 15, "Configuration Parameters and the Registry"</a> and <a href="monitor.htm#g1012722">Chapter 6, "Monitoring a Database on Windows"</a> for Oracle Counters for Windows Performance Monitor tasks</p> </li> <li> <p><a class="olink NTDBI" href="../../install.112/e10843/toc.htm"><span class="italic">Oracle Database Installation Guide for Microsoft Windows</span></a> for components available for installation</p> </li> </ul> </div> <a id="i1005655" name="i1005655"></a><a id="NTQRF99992" name="NTQRF99992"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1">Choosing a Database Tool</h2> <p>Database tools is a collective term for tools, utilities, and assistants that you can use to perform database administration tasks. Some database tools perform similar tasks, though no one database tool performs all database administration tasks. The following sections indicate which database tools can be used on particular operating systems and preferred tools to use for common database administration tasks.</p> <ul> <li> <p><a href="#CIHIDEEJ">Database Tools and Operating System Compatibility</a></p> </li> <li> <p><a href="#i1006020">Preferred Database Tools</a></p> </li> </ul> <a id="CIHIDEEJ" name="CIHIDEEJ"></a><a id="NTQRF99993" name="NTQRF99993"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><a id="sthref29" name="sthref29"></a>Database Tools and Operating System Compatibility</h3> <p>Almost all database tools are available on all supported versions of Windows. The exceptions are:</p> <ul> <li> <p>Oracle Migration Workbench is available only at Oracle Technology Network (OTN). See</p> <p><code><a href="http://www.oracle.com/technology/tech/migration/workbench/index.html">http://www.oracle.com/technology/tech/migration/workbench/index.html</a></code></p> </li> <li> <p>Oracle Enterprise Manager and its optional management packs have additional integrated tools to assist in managing databases. See <a class="olink OEMCN01000" href="http://www.oracle.com/pls/db112/lookup?id=OEMCN01000"><span class="italic">Oracle Enterprise Manager Concepts</span></a> for more information.</p> </li> </ul> </div> <!-- class="sect2" --> <a id="i1006020" name="i1006020"></a><a id="NTQRF99996" name="NTQRF99996"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><a id="sthref30" name="sthref30"></a><a id="sthref31" name="sthref31"></a><a id="sthref32" name="sthref32"></a><a id="sthref33" name="sthref33"></a><a id="sthref34" name="sthref34"></a>Preferred Database <a id="sthref35" name="sthref35"></a><a id="sthref36" name="sthref36"></a><a id="sthref37" name="sthref37"></a><a id="sthref38" name="sthref38"></a><a id="sthref39" name="sthref39"></a><a id="sthref40" name="sthref40"></a>Tools<a id="sthref41" name="sthref41"></a><a id="sthref42" name="sthref42"></a><a id="sthref43" name="sthref43"></a><a id="sthref44" name="sthref44"></a><a id="sthref45" name="sthref45"></a><a id="sthref46" name="sthref46"></a></h3> <p><a href="#g1012470">Table 2-1</a> lists various database tools you can use to perform common database administration tasks. Oracle recommends you use tools listed in the "Preferred Database Tool" column of the table. After choosing a tool to perform a task, go to <a href="#g1012550">Table 2-2</a>, for instructions on how to start the tool.</p> <div class="infoboxnote"> <p class="notep1">Note:</p> The <code>VOLSIZE</code> parameter for Export and Import utilities is not supported on Windows. If you attempt to use the utilities with the <code>VOLSIZE</code> parameter, then error LRM-00101 occurs. For example: <pre xml:space="preserve" class="oac_no_warn">D:\> exp system full=y volsize=100m; Password: <span class="italic">password</span> LRM-00101: unknown parameter name 'volsize' EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help EXP-00000: Export terminated unsuccessfully </pre></div> <div class="tblhruleformalwide"><a id="NTQRF99997" name="NTQRF99997"></a><a id="sthref47" name="sthref47"></a><a id="g1012470" name="g1012470"></a> <p class="titleintable">Table 2-1 Preferred Database Tools</p> <table class="HRuleFormalWide" title="Preferred Database Tools" summary="Rows are tasks. For each task, the first column is the name of the task, the second column is the preferred tool, and the third column shows one or more other tools to do the task." dir="ltr" border="1" width="100%" frame="hsides" rules="rows" cellpadding="3" cellspacing="0"> <col width="28%" /> <col width="*" /> <col width="34%" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t4">Administration Task</th> <th align="left" valign="bottom" id="r1c2-t4">Preferred Tool</th> <th align="left" valign="bottom" id="r1c3-t4">Other Tools</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t4" headers="r1c1-t4"> <p>Create a database</p> </td> <td align="left" headers="r2c1-t4 r1c2-t4"> <p>Database Configuration Assistant</p> </td> <td align="left" headers="r2c1-t4 r1c3-t4"> <p>SQL*Plus or SQL*Plus Worksheet</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t4" headers="r1c1-t4"> <p>Create database <a href="glossary.htm#i432487"><span class="xrefglossterm">services</span></a></p> </td> <td align="left" headers="r3c1-t4 r1c2-t4"> <p>Database Configuration Assistant</p> </td> <td align="left" headers="r3c1-t4 r1c3-t4"> <p>ORADIM</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t4" headers="r1c1-t4"> <p>Delete database <a href="glossary.htm#i432487"><span class="xrefglossterm">services</span></a></p> </td> <td align="left" headers="r4c1-t4 r1c2-t4"> <p>Database Configuration Assistant</p> </td> <td align="left" headers="r4c1-t4 r1c3-t4"> <p>ORADIM</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t4" headers="r1c1-t4"> <p>Start a database</p> </td> <td align="left" headers="r5c1-t4 r1c2-t4"> <p>Oracle Enterprise Manager Database Control</p> </td> <td align="left" headers="r5c1-t4 r1c3-t4"> <p>SQL*Plus or SQL*Plus Worksheet</p> <p>Or</p> <p><code>srvctl</code> for database managed by Oracle Clusterware.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r6c1-t4" headers="r1c1-t4"> <p>Shut down a database</p> </td> <td align="left" headers="r6c1-t4 r1c2-t4"> <p>Oracle Enterprise Manager Database Control</p> </td> <td align="left" headers="r6c1-t4 r1c3-t4"> <p>Control Panel</p> <p>SQL*Plus or SQL*Plus Worksheet</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r7c1-t4" headers="r1c1-t4"> <p>Change passwords in the database password file</p> </td> <td align="left" headers="r7c1-t4 r1c2-t4"> <p>ORAPWD</p> </td> <td align="left" headers="r7c1-t4 r1c3-t4"> <p>ORADIM</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r8c1-t4" headers="r1c1-t4"> <p>Migrate database users to a directory</p> </td> <td align="left" headers="r8c1-t4 r1c2-t4"> <p>User Migration Utility</p> </td> <td align="left" headers="r8c1-t4 r1c3-t4"> <p>None</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r9c1-t4" headers="r1c1-t4"> <p>Migrate a database</p> </td> <td align="left" headers="r9c1-t4 r1c2-t4"> <p>Oracle Database Upgrade Assistant</p> </td> <td align="left" headers="r9c1-t4 r1c3-t4"> <p>Upgrade Information Tool</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r10c1-t4" headers="r1c1-t4"> <p>Upgrade a database</p> </td> <td align="left" headers="r10c1-t4 r1c2-t4"> <p>Oracle Database Upgrade Assistant</p> </td> <td align="left" headers="r10c1-t4 r1c3-t4"> <p>Run provided scripts in SQL*Plus</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r11c1-t4" headers="r1c1-t4"> <p>Export data</p> </td> <td align="left" headers="r11c1-t4 r1c2-t4"> <p>Data Pump Export (EXPDP)</p> </td> <td align="left" headers="r11c1-t4 r1c3-t4"> <p>Export (EXP)</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r12c1-t4" headers="r1c1-t4"> <p>Import data</p> </td> <td align="left" headers="r12c1-t4 r1c2-t4"> <p>Data Pump Import (IMPDP)</p> </td> <td align="left" headers="r12c1-t4 r1c3-t4"> <p>Import (IMP)</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r13c1-t4" headers="r1c1-t4"> <p>Load data</p> </td> <td align="left" headers="r13c1-t4 r1c2-t4"> <p>Oracle Enterprise Manager Load Wizard</p> </td> <td align="left" headers="r13c1-t4 r1c3-t4"> <p>SQL*Loader (SQLLDR)</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r14c1-t4" headers="r1c1-t4"> <p>Back up database</p> </td> <td align="left" headers="r14c1-t4 r1c2-t4"> <p>Oracle Enterprise Manager Backup Wizard</p> </td> <td align="left" headers="r14c1-t4 r1c3-t4"> <p>Recovery Manager (RMAN)</p> <p>OCOPY</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r15c1-t4" headers="r1c1-t4"> <p>Recover database</p> </td> <td align="left" headers="r15c1-t4 r1c2-t4"> <p>Oracle Enterprise Manager Recovery Wizard</p> </td> <td align="left" headers="r15c1-t4 r1c3-t4"> <p>Recovery Manager (RMAN)</p> <p>OCOPY</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r16c1-t4" headers="r1c1-t4"> <p>Authenticate database administrators and users</p> </td> <td align="left" headers="r16c1-t4 r1c2-t4"> <p>Oracle Enterprise Manager Database Control</p> </td> <td align="left" headers="r16c1-t4 r1c3-t4"> <p>SQL*Plus or SQL*Plus Worksheet</p> <p>Windows operating system</p> <p>Oracle Administration Assistant for Windows</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r17c1-t4" headers="r1c1-t4"> <p>Store encrypted and decrypted Oracle Wallet (Oracle Advanced Security and <a href="glossary.htm#i432412"><span class="xrefglossterm">Oracle PKI</span></a> integration)</p> </td> <td align="left" headers="r17c1-t4 r1c2-t4"> <p>Oracle Wallet Manager</p> </td> <td align="left" headers="r17c1-t4 r1c3-t4"> <p>None</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r18c1-t4" headers="r1c1-t4"> <p>Grant database roles</p> </td> <td align="left" headers="r18c1-t4 r1c2-t4"> <p>Oracle Enterprise Manager Database Control</p> </td> <td align="left" headers="r18c1-t4 r1c3-t4"> <p>Local Users and Groups</p> <p>SQL*Plus</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r19c1-t4" headers="r1c1-t4"> <p>Create database objects</p> </td> <td align="left" headers="r19c1-t4 r1c2-t4"> <p>Oracle Enterprise Manager Database Control</p> </td> <td align="left" headers="r19c1-t4 r1c3-t4"> <p>SQL*Plus</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblhruleformalwide" --> <p>The following points refer to tools listed in <a href="#g1012470">Table 2-1, "Preferred Database Tools"</a>:</p> <ul> <li> <p>SQL*Plus Worksheet is part of Oracle Enterprise Manager and is only supported on Windows 32-Bit.</p> </li> <li> <p>ORADIM can only set a password when none was previously set. If a password has been previously set, then ORADIM can change it only by deleting and re-creating Oracle Database services.</p> </li> <li> <p>User Migration Utility can migrate local or external users to enterprise users. For more information, see "Using the User Migration Utility" in <a class="olink DBIMI200" href="http://www.oracle.com/pls/db112/lookup?id=DBIMI200"><span class="italic">Oracle Database Enterprise User Security Administrator's Guide</span></a>.</p> </li> <li> <p>Oracle Database Upgrade Assistant can upgrade the following databases to the current release: Oracle9<span class="italic">i</span> Release 2 (9.2), Oracle Database 10<span class="italic">g</span> Release 1 (10.1), and 2 (10.2). Oracle Database Upgrade Assistant can also be used to apply patch sets.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <a class="olink UPGRD" href="http://www.oracle.com/pls/db112/lookup?id=UPGRD"><span class="italic">Oracle Database Upgrade Guide</span></a> for more information about upgrading single instance and cluster databases</div> </li> <li> <p>Data Pump Export and Data Pump Import are preferred for Oracle Database 10<span class="italic">g</span> Release 1 (10.1) and later data; Export and Import are preferred for earlier data.</p> </li> <li> <p>If you back up files while you are shutting down the database, then your backup will be invalid. You cannot use an invalid backup to restore files at a later date.</p> </li> <li> <p>You cannot use earlier versions of Oracle Wallet Manager to manage Oracle Database 10<span class="italic">g</span> Release 1 (10.1) and later wallets that contain password-based credentials for authentication to Oracle Internet Directory. These credentials are placed in the wallet when an Oracle Database server is registered in Oracle Internet Directory.</p> <p>The database wallet that Database Configuration Assistant automatically generates during database registration can only be used with an Oracle Database 10<span class="italic">g</span> Release 1 (10.1) or later server. You cannot use this database wallet for earlier versions of the database, nor can you use it for Oracle Internet Directory Release 9.0.4 or earlier.</p> </li> <li> <p>For guidelines on creating database objects, see <a class="olink ADMIN021" href="http://www.oracle.com/pls/db112/lookup?id=ADMIN021"><span class="italic">Oracle Database Administrator's Guide</span></a>.</p> </li> </ul> </div> <!-- class="sect2" --></div> <!-- class="sect1" --> <a id="i1006205" name="i1006205"></a><a id="NTQRF99998" name="NTQRF99998"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1">Starting Database Tools</h2> <p>This section describes how to start each of the database tools in the following categories:</p> <ul> <li> <p><a href="#i1006229">Starting Database Tools in Multiple Oracle Homes</a></p> </li> <li> <p><a href="#BABDAAAJ">Running Tools with Windows User Account Control</a></p> </li> <li> <p><a href="#i1006265">Starting Database Tools from the Start Menu</a></p> </li> <li> <p><a href="#i1006527">Starting Database Tools from the Command Line</a></p> </li> <li> <p><a href="#i1006857">Starting Windows Tools</a></p> </li> </ul> <a id="i1006229" name="i1006229"></a><a id="NTQRF99999" name="NTQRF99999"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><a id="sthref48" name="sthref48"></a>Starting Database Tools in Multiple Oracle Homes</h3> <p>If you have <a href="glossary.htm#CHDIAIIB"><span class="xrefglossterm">multiple Oracle homes</span></a> on your computer from previous releases, then see Appendix B, "Optimal Flexible Architecture", in <a class="olink NTDBI" href="../../install.112/e10843/toc.htm"><span class="italic">Oracle Database Installation Guide for Microsoft Windows</span></a><a class="olink NTDBX" href="http://www.oracle.com/pls/db112/lookup?id=NTDBX"></a> for a description of differences between Oracle homes in different releases.</p> <a id="NTQRF101" name="NTQRF101"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --><a id="sthref49" name="sthref49"></a> <h4 class="sect3">Starting Tools from Oracle8<span class="italic">i</span> Release 8.1.3 and Later Multiple Oracle Homes</h4> <p>Beginning in Oracle8<span class="italic">i</span> release 8.1.3, each Oracle home, including the first Oracle home you create on your computer, has a unique <span class="italic">HOME_NAME</span>. To start Oracle Administration Assistant for Windows from any Oracle home, from the <span class="bold">Start</span> menu, select <span class="bold">Programs</span>, then select <span class="bold">Oracle -</span> <span class="bolditalic">HOME_NAME</span>, then select <span class="bold">Configuration and Migration Tools</span> and then select <span class="bold">Administration Assistant for Windows</span></p> </div> <!-- class="sect3" --></div> <!-- class="sect2" --> <a id="BABDAAAJ" name="BABDAAAJ"></a><a id="NTQRF102" name="NTQRF102"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><a name="NTQRF99960" id="NTQRF99960"></a>Running Tools with Windows User Account Control</h3> <p>To ensure that only trusted applications run on your computer, Windows Vista, Windows Server 2008, Windows Server 2008 R2, and Windows 7 provide User Account Control. If you have enabled this security feature, then, depending on how you have configured it, Oracle Universal Installer prompts you for either your consent or your credentials when installing Oracle Database Client. Provide either the consent or your Windows Administrator credentials as appropriate.</p> <p>You must have Administrator privileges to run some configuration tools, or to run any tool or application that writes to any directory within the Oracle home. If User Account Control is enabled, and you are logged in as the local Administrator, then you can successfully run each of these commands in the usual way. However, if you are logged in as a member of the Administrator group, then you must explicitly run these tasks with Windows Administrator privileges.</p> <p>The following tools must be run with Administrator privileges:</p> <ul> <li> <p>Oracle Administration Assistant for Windows. This tool is available as a Configuration and Migration Tool.</p> </li> <li> <p>Oracle Net Configuration Assistant. This tool is available as a Configuration and Migration Tool.</p> </li> <li> <p>Oracle OLAP Analytic Workspace Manager and Worksheet. This tool is available as an Integrated Management Tool.</p> </li> <li> <p>Oracle Database Configuration Assistant. This tool is available as a Configuration and Migration Tool.</p> </li> <li> <p>Oracle Database Wallet Manager. This tool is available as an Integrated Management Tool.</p> </li> <li> <p>Oracle Database Upgrade Assistant. This tool is available as a Configuration and Migration Tool.</p> </li> <li> <p>Oracle Net Manager. This tool is available as a Configuration and Migration Tool.</p> </li> </ul> <p>To run any command with Administrator privileges:</p> <ol> <li> <p>Click the <span class="bold">Start</span> menu button.</p> </li> <li> <p>Navigate to Programs, then to Oracle - <span class="italic">HOME_NAME</span>.</p> </li> <li> <p>Right-click the name of the command or application you want to run, then select <span class="bold">Run as administrator</span>.</p> </li> </ol> <p>To create a Windows shortcut with Administrator privileges:</p> <ol> <li> <p>On your desktop, create a shortcut for the command prompt window. An icon for that shortcut appears on the desktop.</p> </li> <li> <p>Right-click the icon for the newly created shortcut, and specify <span class="bold">Run as administrator</span>.</p> </li> </ol> <p>When you open this window, the title bar reads Administrator: Command Prompt. Commands run from within this window are run with Administrator privileges.</p> </div> <!-- class="sect2" --> <a id="i1006265" name="i1006265"></a><a id="NTQRF103" name="NTQRF103"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><a id="sthref50" name="sthref50"></a>Starting Database Tools from the Start Menu</h3> <p><a href="#g1012550">Table 2-2</a> describes how to start assistants and other tools from the Start Menu. It also tells where to go for further information on using these products.</p> <div class="infoboxnote"> <p class="notep1">Note:</p> When you use an assistant, you must have read and write access to the directory where database files will be moved or created. To create an Oracle Database, you must have an administrative <a href="glossary.htm#i432451"><span class="xrefglossterm">privilege</span></a>. If you run Database Configuration Assistant from an account that is not part of the Administrators group, then the tool exits without completing the operation.</div> <div class="infoboxnote"> <p class="notep1">Note:</p> All Start Menu paths begin with the <span class="bold">Start</span> menu where you select <span class="bold">Programs</span>, then select <span class="bold">Oracle -</span> <span class="bolditalic">HOME_NAME</span> and so on.</div> <div class="tblhruleformalwide"><a id="NTQRF104" name="NTQRF104"></a><a id="sthref51" name="sthref51"></a><a id="g1012550" name="g1012550"></a> <p class="titleintable">Table 2-2 Starting Database Tools from the Start Menu</p> <table class="HRuleFormalWide" title="Starting Database Tools from the Start Menu" summary="Rows are tools. For each tool, the first column is the name of the tool, the second column is the Start Menu path, and the third column shows where to find more information about the tool." dir="ltr" border="1" width="100%" frame="hsides" rules="rows" cellpadding="3" cellspacing="0"> <col width="20%" /> <col width="35%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t8">Tool</th> <th align="left" valign="bottom" id="r1c2-t8">Start Menu Path</th> <th align="left" valign="bottom" id="r1c3-t8">More Information</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t8" headers="r1c1-t8"> <p><a id="sthref52" name="sthref52"></a><a id="sthref53" name="sthref53"></a>Oracle Administration Assistant for Windows</p> </td> <td align="left" headers="r2c1-t8 r1c2-t8"> <p>From <span class="bold">Configuration and Migration Tools</span>, select <span class="bold">Administration Assistant for Windows</span></p> </td> <td align="left" headers="r2c1-t8 r1c3-t8"> <p><a href="authen.htm#g1010864">Chapter 9, "Authenticating Database Users with Windows"</a></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t8" headers="r1c1-t8"> <p><a id="sthref54" name="sthref54"></a><a id="sthref55" name="sthref55"></a>Database Configuration Assistant</p> </td> <td align="left" headers="r3c1-t8 r1c2-t8"> <p>From <span class="bold">Configuration and Migration Tools</span>, select <span class="bold">Database Configuration Assistant</span></p> </td> <td align="left" headers="r3c1-t8 r1c3-t8"> <p><a href="create.htm#i1005759">"Creating a Database on Windows Using Database Configuration Assistant"</a></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t8" headers="r1c1-t8"> <p><a id="sthref56" name="sthref56"></a><a id="sthref57" name="sthref57"></a>Oracle Locale Builder</p> </td> <td align="left" headers="r4c1-t8 r1c2-t8"> <p>From <span class="bold">Configuration and Migration Tools</span>, select <span class="bold">Locale Builder</span></p> </td> <td align="left" headers="r4c1-t8 r1c3-t8"> <p><a class="olink NLSPG001" href="http://www.oracle.com/pls/db112/lookup?id=NLSPG001"><span class="italic">Oracle Database Globalization Support Guide</span></a></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t8" headers="r1c1-t8"> <p><a id="sthref58" name="sthref58"></a><a id="sthref59" name="sthref59"></a>Microsoft ODBC Administrator</p> </td> <td align="left" headers="r5c1-t8 r1c2-t8"> <p>From <span class="bold">Configuration and Migration Tools</span>, select <span class="bold">Microsoft ODBC Administration</span></p> </td> <td align="left" headers="r5c1-t8 r1c3-t8"> <p>Microsoft ODBC Administration online help</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r6c1-t8" headers="r1c1-t8"> <p><a id="sthref60" name="sthref60"></a><a id="sthref61" name="sthref61"></a>Oracle Migration Workbench</p> </td> <td align="left" headers="r6c1-t8 r1c2-t8"> <p>From <span class="bold">Configuration and Migration Tools</span>, select <span class="bold">Migration Workbench</span></p> </td> <td align="left" headers="r6c1-t8 r1c3-t8"> <p>Oracle Migration Workbench software and documentation are available at</p> <pre xml:space="preserve" class="oac_no_warn"><a href="http://www.oracle.com/technology/tech/migration/workbench/index.html">http://www.oracle.com/technology/tech/migration/workbench/index.html</a> </pre></td> </tr> <tr align="left" valign="top"> <td align="left" id="r7c1-t8" headers="r1c1-t8"> <p><a id="sthref62" name="sthref62"></a><a id="sthref63" name="sthref63"></a>Oracle Net Configuration Assistant</p> </td> <td align="left" headers="r7c1-t8 r1c2-t8"> <p>From <span class="bold">Configuration and Migration Tools</span>, select <span class="bold">Net Configuration Assistant</span></p> </td> <td align="left" headers="r7c1-t8 r1c3-t8"> <p><a class="olink NETAG005" href="http://www.oracle.com/pls/db112/lookup?id=NETAG005"><span class="italic">Oracle Database Net Services Administrator's Guide</span></a></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r8c1-t8" headers="r1c1-t8"> <p><a id="sthref64" name="sthref64"></a><a id="sthref65" name="sthref65"></a>Oracle Net Manager</p> </td> <td align="left" headers="r8c1-t8 r1c2-t8"> <p>From <span class="bold">Configuration and Migration Tools</span>, select <span class="bold">Net Manager</span></p> </td> <td align="left" headers="r8c1-t8 r1c3-t8"> <p><a class="olink NETAG005" href="http://www.oracle.com/pls/db112/lookup?id=NETAG005"><span class="italic">Oracle Database Net Services Administrator's Guide</span></a></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r9c1-t8" headers="r1c1-t8"> <p><a id="sthref66" name="sthref66"></a><a id="sthref67" name="sthref67"></a>Oracle Directory Manager</p> </td> <td align="left" headers="r9c1-t8 r1c2-t8"> <p>From <span class="bold">Integrated Management Tools</span>, select <span class="bold">Oracle Directory Manager</span></p> </td> <td align="left" headers="r9c1-t8 r1c3-t8"> <p><a class="olink OIDAG" href="http://www.oracle.com/pls/db112/lookup?id=OIDAG"><span class="italic">Oracle Internet Directory Administrator's Guide</span></a></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r10c1-t8" headers="r1c1-t8"> <p><a id="sthref68" name="sthref68"></a><a id="sthref69" name="sthref69"></a>Oracle Counters for Windows Performance Monitor</p> </td> <td align="left" headers="r10c1-t8 r1c2-t8"> <p>From <span class="bold">Configuration and Migration Tools</span>, select <span class="bold">Oracle Counters for Windows Performance Monitor</span></p> </td> <td align="left" headers="r10c1-t8 r1c3-t8"> <p>To install Oracle Counters for Windows Performance Monitor, choose Advanced Installation and then the Custom installation type.</p> <p><a href="monitor.htm#i1005706">"Using Oracle Counters for Windows Performance Monitor"</a></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r11c1-t8" headers="r1c1-t8"> <p><a id="sthref70" name="sthref70"></a><a id="sthref71" name="sthref71"></a>SQL*Plus</p> </td> <td align="left" headers="r11c1-t8 r1c2-t8"> <p>From <span class="bold">Application Development</span>, select <span class="bold">SQL*Plus</span></p> </td> <td align="left" headers="r11c1-t8 r1c3-t8"> <p><a class="olink SQPUG" href="http://www.oracle.com/pls/db112/lookup?id=SQPUG"><span class="italic">SQL*Plus User's Guide and Reference</span></a></p> <p><a href="admin.htm#CDCEJADC">"Starting and Shutting Down a Database with SQL*Plus"</a></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r12c1-t8" headers="r1c1-t8"> <p><a id="sthref72" name="sthref72"></a><a id="sthref73" name="sthref73"></a>SQL*Plus Worksheet</p> </td> <td align="left" headers="r12c1-t8 r1c2-t8"> <p>From <span class="bold">Application Development</span>, select <span class="bold">SQL*Plus Worksheet</span></p> <p>From <span class="bold">Integrated Management Tools</span>, select <span class="bold">SQL*Plus Worksheet</span></p> </td> <td align="left" headers="r12c1-t8 r1c3-t8"> <p>SQL*Plus Worksheet is available from the Start Menu only with Oracle Database Client.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r13c1-t8" headers="r1c1-t8"> <p><a id="sthref74" name="sthref74"></a><a id="sthref75" name="sthref75"></a>Oracle Wallet Manager</p> </td> <td align="left" headers="r13c1-t8 r1c2-t8"> <p>From <span class="bold">Integrated Management Tools</span>, select <span class="bold">Wallet Manager</span></p> </td> <td align="left" headers="r13c1-t8 r1c3-t8"> <p><a class="olink ASOAG160" href="http://www.oracle.com/pls/db112/lookup?id=ASOAG160"><span class="italic">Oracle Database Advanced Security Administrator's Guide</span></a></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r14c1-t8" headers="r1c1-t8"> <p>User Migration Utility</p> </td> <td align="left" headers="r14c1-t8 r1c2-t8"> <p>No GUI. Command line must be used.</p> </td> <td align="left" headers="r14c1-t8 r1c3-t8"> <p><a class="olink DBIMI" href="http://www.oracle.com/pls/db112/lookup?id=DBIMI"><span class="italic">Oracle Database Enterprise User Security Administrator's Guide</span></a></p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblhruleformalwide" --> <div class="infoboxnote"> <p class="notep1">Note:</p> After installing Oracle Database 11<span class="italic">g</span> Companion Products, Oracle Wallet Manager is not available from the Start menu. See <a href="#g1012638">Table 2-3, "Starting Database Tools from the Command Line"</a> for instructions on starting Oracle Wallet Manager from the command line.</div> </div> <!-- class="sect2" --> <a id="i1006527" name="i1006527"></a><a id="NTQRF105" name="NTQRF105"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><a id="sthref76" name="sthref76"></a>Starting Database Tools from the Command Line</h3> <p><a href="#g1012638">Table 2-3</a> describes how to start Oracle Database tools from the command line, and where to go for further information on using these products.</p> <div class="tblhruleformalwide"><a id="NTQRF106" name="NTQRF106"></a><a id="sthref77" name="sthref77"></a><a id="g1012638" name="g1012638"></a> <p class="titleintable">Table 2-3 Starting Database Tools from the Command Line</p> <table class="HRuleFormalWide" title="Starting Database Tools from the Command Line" summary="Rows are tools. For each tool, the first column is the name of the tool, the second column shows what to enter at the prompt, and the third column shows where to look for more information about the tool." dir="ltr" border="1" width="100%" frame="hsides" rules="rows" cellpadding="3" cellspacing="0"> <col width="17%" /> <col width="*" /> <col width="36%" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t10">Tool</th> <th align="left" valign="bottom" id="r1c2-t10">Enter at Prompt</th> <th align="left" valign="bottom" id="r1c3-t10">More Information</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t10" headers="r1c1-t10"> <p><a id="sthref78" name="sthref78"></a><a id="sthref79" name="sthref79"></a>DBVERIFY</p> </td> <td align="left" headers="r2c1-t10 r1c2-t10"> <p><code>C:\> dbv</code></p> <p>DBVERIFY starts and prompts you for a filename parameter. To obtain a list of parameters, enter:</p> <p><code>C:\> dbv help=y</code></p> </td> <td align="left" headers="r2c1-t10 r1c3-t10"> <p><a class="olink SUTIL013" href="http://www.oracle.com/pls/db112/lookup?id=SUTIL013"><span class="italic">Oracle Database Utilities</span></a></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t10" headers="r1c1-t10"> <p><a id="sthref80" name="sthref80"></a><a id="sthref81" name="sthref81"></a>Data Pump Export</p> </td> <td align="left" headers="r3c1-t10 r1c2-t10"> <p><code>C:\> exp username</code></p> <p>EXP starts and prompts you for parameters. To obtain a list of these parameters, enter:</p> <p><code>C:\> exp help=y</code></p> </td> <td align="left" headers="r3c1-t10 r1c3-t10"> <p><a class="olink SUTIL200" href="http://www.oracle.com/pls/db112/lookup?id=SUTIL200"><span class="italic">Oracle Database Utilities</span></a> for instructions on use of Data Pump Export</p> <p><a class="olink ERRMG" href="http://www.oracle.com/pls/db112/lookup?id=ERRMG"><span class="italic">Oracle Database Error Messages</span></a> for information on error messages</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t10" headers="r1c1-t10"> <p><a id="sthref82" name="sthref82"></a><a id="sthref83" name="sthref83"></a>Data Pump Import</p> </td> <td align="left" headers="r4c1-t10 r1c2-t10"> <p><code>C:\> imp username</code></p> <p>IMP starts and prompts you for parameters. To get a list of these parameters, enter:</p> <p><code>C:\> imp help=y</code></p> </td> <td align="left" headers="r4c1-t10 r1c3-t10"> <p><a class="olink SUTIL300" href="http://www.oracle.com/pls/db112/lookup?id=SUTIL300"><span class="italic">Oracle Database Utilities</span></a> for instructions on use of Data Pump Import</p> <p><a class="olink ERRMG" href="http://www.oracle.com/pls/db112/lookup?id=ERRMG"><span class="italic">Oracle Database Error Messages</span></a> for information on error messages</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t10" headers="r1c1-t10"> <p>Database Configuration Assistant</p> </td> <td align="left" headers="r5c1-t10 r1c2-t10"> <p><code>C:\> dbca</code></p> <p>DBCA wizard starts in interactive mode. For silent options and other command line options enter:</p> <p><code>C:\> dbca -help</code></p> </td> <td align="left" headers="r5c1-t10 r1c3-t10"> <p>"Using DBCA" in <a class="olink ADMQS0231" href="../../server.112/e10897/install.htm#ADMQS0231"><span class="italic">Oracle Database 2 Day DBA</span></a></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r6c1-t10" headers="r1c1-t10"> <p>Database Upgrade Assistant</p> </td> <td align="left" headers="r6c1-t10 r1c2-t10"> <p><code>C:\> dbua</code></p> <p>DBUA wizard starts in interactive mode. For silent options and other command line options enter:</p> <p><code>C:\> dbua -help</code></p> </td> <td align="left" headers="r6c1-t10 r1c3-t10"> <p>"Using the Database Upgrade Assistant" in <a class="olink UPGRD105" href="http://www.oracle.com/pls/db112/lookup?id=UPGRD105"><span class="italic">Oracle Database Upgrade Guide</span></a></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r7c1-t10" headers="r1c1-t10"> <p><a id="sthref84" name="sthref84"></a><a id="sthref85" name="sthref85"></a>Export</p> </td> <td align="left" headers="r7c1-t10 r1c2-t10"> <p><code>C:\> exp username</code></p> <p>EXP starts and prompts you for parameters. To obtain a list of these parameters, enter:</p> <p><code>C:\> exp help=y</code></p> </td> <td align="left" headers="r7c1-t10 r1c3-t10"> <p><a class="olink SUTIL3634" href="http://www.oracle.com/pls/db112/lookup?id=SUTIL3634"><span class="italic">Oracle Database Utilities</span></a> for instructions on use of Export</p> <p><a class="olink ERRMG" href="http://www.oracle.com/pls/db112/lookup?id=ERRMG"><span class="italic">Oracle Database Error Messages</span></a> for information on error messages</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r8c1-t10" headers="r1c1-t10"> <p>Net Services Configuration</p> </td> <td align="left" headers="r8c1-t10 r1c2-t10"> <p><code>C:\> netca</code></p> <p>NETCA wizard starts in interactive mode. For silent options and other command line options enter:</p> <p><code>C:\> netca -help</code></p> </td> <td align="left" headers="r8c1-t10 r1c3-t10"> <p>"Configuring the Network Environment" in <a class="olink UPGRD105" href="http://www.oracle.com/pls/db112/lookup?id=UPGRD105"><span class="italic">Oracle Database Upgrade Guide</span></a></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r9c1-t10" headers="r1c1-t10"> <p>Import</p> </td> <td align="left" headers="r9c1-t10 r1c2-t10"> <p><code>C:\> imp username</code></p> <p>IMP starts and prompts you for parameters. To get a list of these parameters, enter:</p> <p><code>C:\> imp help=y</code></p> </td> <td align="left" headers="r9c1-t10 r1c3-t10"> <p><a class="olink SUTIL001" href="http://www.oracle.com/pls/db112/lookup?id=SUTIL001"><span class="italic">Oracle Database Utilities</span></a> for instructions on use of Import</p> <p><a class="olink ERRMG" href="http://www.oracle.com/pls/db112/lookup?id=ERRMG"><span class="italic">Oracle Database Error Messages</span></a> for information on error messages</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r10c1-t10" headers="r1c1-t10"> <p><a id="sthref86" name="sthref86"></a><a id="sthref87" name="sthref87"></a>operfcfg</p> </td> <td align="left" headers="r10c1-t10 r1c2-t10"> <p><code>C:\> operfcfg</code></p> </td> <td align="left" headers="r10c1-t10 r1c3-t10"> <p><a href="registry.htm#i1006295">"Modifying Oracle Counters for Windows Performance Monitor Parameters"</a></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r11c1-t10" headers="r1c1-t10"> <p>Oracle Wallet Manager</p> </td> <td align="left" headers="r11c1-t10 r1c2-t10"> <p><code>C:\> cd</code> <code><span class="codeinlineitalic">ORACLE_HOME</span></code><code>\bin</code></p> <p><code>C:\</code><code><span class="codeinlineitalic">ORACLE_HOME</span></code><code>\bin</code>> <code>launch.exe</code> <code><span class="codeinlineitalic">ORACLE_HOME</span></code><code>\bin owm.cl</code></p> </td> <td align="left" headers="r11c1-t10 r1c3-t10"> <p><a href="wallets.htm#g1007989">Chapter 11, "Storing Oracle Wallets in the Windows Registry"</a></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r12c1-t10" headers="r1c1-t10"> <p><a id="sthref88" name="sthref88"></a><a id="sthref89" name="sthref89"></a>ORADIM</p> </td> <td align="left" headers="r12c1-t10 r1c2-t10"> <p><code>C:\> oradim</code> <code><span class="codeinlineitalic">options</span></code></p> <p>To get a list of ORADIM options, enter either of the following:</p> <p><code>C:\> oradim</code></p> <p><code>C:\> oradim -? | -h | -help</code></p> </td> <td align="left" headers="r12c1-t10 r1c3-t10"> <p><a href="create.htm#i1006533">"Using ORADIM to Administer an Oracle Database Instance"</a></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r13c1-t10" headers="r1c1-t10"> <p><a id="sthref90" name="sthref90"></a><a id="sthref91" name="sthref91"></a>Password Utility (ORAPWD)</p> </td> <td align="left" headers="r13c1-t10 r1c2-t10"> <p><code>C:\> orapwd</code></p> <p>Password file is hidden. Use Windows Explorer to see it in a file list. From the <span class="bold">View</span> menu, select <span class="bold">Options</span>, then select <span class="bold">View</span> and then select <span class="bold">Show All Files</span></p> </td> <td align="left" headers="r13c1-t10 r1c3-t10"> <p><a href="admin.htm#i1006252">"Creating and Populating Password Files"</a></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r14c1-t10" headers="r1c1-t10"> <p><a id="sthref92" name="sthref92"></a><a id="sthref93" name="sthref93"></a>Recovery Manager (RMAN)</p> </td> <td align="left" headers="r14c1-t10 r1c2-t10"> <p><code>C:\> rman</code> <code><span class="codeinlineitalic">parameters</span></code></p> </td> <td align="left" headers="r14c1-t10 r1c3-t10"> <p><a class="olink BRBSC002" href="http://www.oracle.com/pls/db112/lookup?id=BRBSC002"><span class="italic">Oracle Database Backup and Recovery Basics</span></a></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r15c1-t10" headers="r1c1-t10"> <p><a id="sthref94" name="sthref94"></a><a id="sthref95" name="sthref95"></a>SQL*Plus (SQLPLUS)</p> </td> <td align="left" headers="r15c1-t10 r1c2-t10"> <p><code>C:\> sqlplus</code></p> </td> <td align="left" headers="r15c1-t10 r1c3-t10"> <p><a class="olink SQPUG" href="http://www.oracle.com/pls/db112/lookup?id=SQPUG"><span class="italic">SQL*Plus User's Guide and Reference</span></a></p> <p><a href="admin.htm#CDCEJADC">"Starting and Shutting Down a Database with SQL*Plus"</a></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r16c1-t10" headers="r1c1-t10"> <p><a id="sthref96" name="sthref96"></a><a id="sthref97" name="sthref97"></a>SQL*Loader (SQLLDR)</p> </td> <td align="left" headers="r16c1-t10 r1c2-t10"> <p><code>C:\> sqlldr</code></p> <p>SQL*Loader displays a Help screen with available keywords and default values.</p> </td> <td align="left" headers="r16c1-t10 r1c3-t10"> <p><a class="olink SUTIL003" href="http://www.oracle.com/pls/db112/lookup?id=SUTIL003"><span class="italic">Oracle Database Utilities</span></a></p> <p><a class="olink ERRMG" href="http://www.oracle.com/pls/db112/lookup?id=ERRMG"><span class="italic">Oracle Database Error Messages</span></a></p> <p><a href="#i1006857">"Starting Windows Tools"</a></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r17c1-t10" headers="r1c1-t10"> <p><a id="sthref98" name="sthref98"></a><a id="sthref99" name="sthref99"></a>TKPROF</p> </td> <td align="left" headers="r17c1-t10 r1c2-t10"> <p><code>C:\> tkprof</code></p> </td> <td align="left" headers="r17c1-t10 r1c3-t10"> <p><a class="olink PFGRF01010" href="http://www.oracle.com/pls/db112/lookup?id=PFGRF01010"><span class="italic">Oracle Database Performance Tuning Guide</span></a></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r18c1-t10" headers="r1c1-t10"> <p>User Migration Utility</p> </td> <td align="left" headers="r18c1-t10 r1c2-t10"> <p><code>C:\> umu</code> <code><span class="codeinlineitalic">parameters</span></code></p> <p>To get a list of parameters, enter:</p> <p><code>C:\> umu</code> <code>help=yes</code></p> </td> <td align="left" headers="r18c1-t10 r1c3-t10"> <p>"Using the User Migration Utility" in <a class="olink DBIMI200" href="http://www.oracle.com/pls/db112/lookup?id=DBIMI200"><span class="italic">Oracle Database Enterprise User Security Administrator's Guide</span></a></p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblhruleformalwide" --> <div class="infoboxnote"> <p class="notep1">Note:</p> <ul> <li> <p>Three special conditions apply when running Export or Import utilities on Windows. First, default values for <code>BUFFER</code> and <code>RECORDLENGTH</code> parameters are 4 KB and 2 KB respectively. This default <code>RECORDLENGTH</code> parameter does not depend on the value of <code>BUFSIZ</code> defined in the system header file. If you specify a value larger than <code>USHRT_MAX</code> (64 KB), you will get a warning message. Second, the <code>VOLSIZE</code> parameter is not supported. Third, to export an entire database, you must use the <code>EXP_FULL_DATABASE</code> role.</p> </li> <li> <p>Oracle Enterprise Manager Database Control is another database tool for managing the database. For more information, see "Logging in to Enterprise Manager Database Control" in <a class="olink NTDBI0052" href="../../install.112/e10843/startrdb.htm#NTDBI0052"><span class="italic">Oracle Database Installation Guide for Microsoft Windows</span></a>.</p> </li> </ul> </div> </div> <!-- class="sect2" --> <a id="i1006857" name="i1006857"></a><a id="NTQRF107" name="NTQRF107"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">Starting Windows Tools</h3> <p><a href="#g1012706">Table 2-4</a> describes how to start each Windows tool and where to go for more information on using these products.</p> <div class="tblhruleformalwide"><a id="NTQRF108" name="NTQRF108"></a><a id="sthref100" name="sthref100"></a><a id="g1012706" name="g1012706"></a> <p class="titleintable">Table 2-4 Starting Windows Tools</p> <table class="HRuleFormalWide" title="Starting Windows Tools" summary="Rows are tools. For each tool, the first column is the name of the tool, the second column is the start procedure for the tool, and the third column shows where to look for more information about the tool." dir="ltr" border="1" width="100%" frame="hsides" rules="rows" cellpadding="3" cellspacing="0"> <col width="18%" /> <col width="31%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t12">Tool</th> <th align="left" valign="bottom" id="r1c2-t12">Start Procedure</th> <th align="left" valign="bottom" id="r1c3-t12">More Information</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t12" headers="r1c1-t12"> <p><a id="sthref101" name="sthref101"></a><a id="sthref102" name="sthref102"></a>Event Viewer</p> </td> <td align="left" headers="r2c1-t12 r1c2-t12"> <p>From the <span class="bold">Start</span> menu, select <span class="bold">Programs</span>, then select <span class="bold">Administrative Tools</span> and then select <span class="bold">Event Viewer</span></p> </td> <td align="left" headers="r2c1-t12 r1c3-t12"> <p><a href="#i1007091">"Using Event Viewer to Monitor a Database"</a></p> <p>Your operating system documentation</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t12" headers="r1c1-t12"> <p><a id="sthref103" name="sthref103"></a><a id="sthref104" name="sthref104"></a>Microsoft Management Console (MMC)</p> </td> <td align="left" headers="r3c1-t12 r1c2-t12"> <p>From the <span class="bold">Start</span> menu, select <span class="bold">Programs</span>, then select <span class="bold">Oracle -</span> <span class="bolditalic">HOME_NAME</span>, then select <span class="bold">Configuration and Migration Tools</span> and then select <span class="bold">Administration Assistant for Windows</span></p> </td> <td align="left" headers="r3c1-t12 r1c3-t12"> <p>Your operating system documentation</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t12" headers="r1c1-t12"> <p><a id="sthref105" name="sthref105"></a><a id="sthref106" name="sthref106"></a>Oracle Counters for Windows Performance Monitor</p> </td> <td align="left" headers="r4c1-t12 r1c2-t12"> <p>From the <span class="bold">Start</span> menu, select <span class="bold">Programs</span>, then select <span class="bold">Oracle -</span> <span class="bolditalic">HOME_NAME</span>, then select <span class="bold">Configuration and Migration Tools</span> and then select <span class="bold">Oracle Counters for Windows Performance Monitor</span></p> </td> <td align="left" headers="r4c1-t12 r1c3-t12"> <p><a href="monitor.htm#i1005706">"Using Oracle Counters for Windows Performance Monitor"</a></p> <p>Your operating system documentation</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t12" headers="r1c1-t12"> <p><a id="sthref107" name="sthref107"></a><a id="sthref108" name="sthref108"></a>Registry Editor</p> </td> <td align="left" headers="r5c1-t12 r1c2-t12"> <p>At the command prompt, enter:</p> <pre xml:space="preserve" class="oac_no_warn">C:\> regedit </pre></td> <td align="left" headers="r5c1-t12 r1c3-t12"> <p><a href="#i1007164">"Using Registry Editor to Modify Configuration Information"</a></p> <p><a href="registry.htm#g1015622">Chapter 15, "Configuration Parameters and the Registry"</a></p> <p>Your operating system documentation</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r6c1-t12" headers="r1c1-t12"> <p><a id="sthref109" name="sthref109"></a><a id="sthref110" name="sthref110"></a>Task Manager</p> </td> <td align="left" headers="r6c1-t12 r1c2-t12"> <p>Right-click the Task Bar and select <span class="bold">Task Manager</span></p> </td> <td align="left" headers="r6c1-t12 r1c3-t12"> <p><a href="#i1007188">"Using Task Manager to Monitor Applications and Processes"</a></p> <p>Your operating system documentation</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r7c1-t12" headers="r1c1-t12"> <p>Local Users and Groups</p> </td> <td align="left" headers="r7c1-t12 r1c2-t12"> <p>From the <span class="bold">Start</span> menu, select <span class="bold">Settings</span>, then select <span class="bold">Control Panel</span>. Double-click <span class="bold">Administrative Tools</span>. Double-click <span class="bold">Computer Management</span>. In the console tree, click <span class="bold">Local Users and Groups</span>.</p> </td> <td align="left" headers="r7c1-t12 r1c3-t12"> <p><a href="#i1010636">"Using Local Users and Groups to Manage Users and Groups"</a></p> <p><a href="authen.htm#g1010864">Chapter 9, "Authenticating Database Users with Windows"</a></p> <p>Your operating system documentation</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblhruleformalwide" --> <div class="infoboxnote"> <p class="notep1">Note:</p> Microsoft Management Console is started whenever Oracle Administration Assistant for Windows is started.</div> </div> <!-- class="sect2" --></div> <!-- class="sect1" --> <a id="i1006973" name="i1006973"></a><a id="NTQRF110" name="NTQRF110"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1">Using SQL*Loader</h2> <p>This section describes Windows-specific information for using SQL*Loader (<code>SQLLDR</code>).</p> <ul> <li> <p><a href="#CIHEGJIE">Windows Processing Options</a></p> </li> <li> <p><a href="#CIHGHJFC">Control File Conventions</a></p> </li> </ul> <a id="CIHEGJIE" name="CIHEGJIE"></a><a id="NTQRF111" name="NTQRF111"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">Windows Processing Options</h3> <p>This section discusses possible values for the operating system dependent file processing specifications string option (<code>os_file_proc_clause</code>), referred to in "Specifying Datafile Format and Buffering" in Chapter 8, "SQL*Loader Control File Reference", in <a class="olink SUTIL005" href="http://www.oracle.com/pls/db112/lookup?id=SUTIL005"><span class="italic">Oracle Database Utilities.</span></a></p> <a id="NTQRF112" name="NTQRF112"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --><a id="sthref111" name="sthref111"></a> <h4 class="sect3">Default (No Processing Option) or "str terminator_string"</h4> <p>Stream record format in which each record is terminated by a record terminator. If "str terminator_string" is not specified, then the record terminator defaults to either the Windows-style record terminator (the two-character sequence carriage return, \r, followed by line feed, \n) or the UNIX-style record terminator (single-character line feed, \n). Maximum record size is 48 KB.</p> <p>When processing stream format datafiles, SQL*Loader can usually recognize record terminators automatically, whether they are Windows-style or UNIX-style. So you usually do not need to specify which record terminator you are using.</p> <p>For external table loads, however, only Windows-style record terminators are recognized automatically. If your datafile contains UNIX-style record terminators, you must specify the record terminator. If you are using SQL*Loader (with <code>external_table</code> option), then specify the UNIX-style record terminator by specifying <code>"str</code> <code>'\n'"</code> on the <code>INFILE</code> line in the SQL*Loader control file. For example:</p> <pre xml:space="preserve" class="oac_no_warn">INFILE mydata.dat "str '\n'" </pre> <p>You can also specify the record terminator in hex, by specifying <code>"str x'0a'"</code> (assuming an ASCII-based character set). For example:</p> <pre xml:space="preserve" class="oac_no_warn">INFILE mydata.dat "str x'0a'" </pre> <p>Note that the "<code>0</code>" (zero) before the "<code>a</code>" is required. If you are using SQL with an access parameter list to create the external table, then you must specify <code>'\n'</code> in a <code>RECORDS</code> <code>DELIMITED</code> <code>BY</code> clause. For example:</p> <pre xml:space="preserve" class="oac_no_warn">RECORDS DELIMITED BY '\n' </pre> <p>You can also use a hex string in this case. For example:</p> <pre xml:space="preserve" class="oac_no_warn">RECORDS DELIMITED BY 0x'0a' </pre> <p>Note that in this case, the "0" (zero) before the "x" and the "0" (zero) before the "a" are both required.</p> </div> <!-- class="sect3" --></div> <!-- class="sect2" --> <a id="CIHGHJFC" name="CIHGHJFC"></a><a id="NTQRF117" name="NTQRF117"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><a id="sthref112" name="sthref112"></a>Control File Conventions</h3> <p>When preparing SQL*Loader control files (<code>.ctl</code>), you must follow certain syntax and notational conventions.</p> <p>In full path descriptions, backslashes do not require escape characters or other special treatment. When embedding a single or double quotation mark inside a string delimited by double quotation marks, place a backslash escape character before the embedded quotation mark.</p> <p>When specifying data types in the SQL*Loader control file, note that the default sizes of native data types shown in <a href="#g1012742">Table 2-5</a> are specific to Windows. These data types can be loaded with correct results only between systems where they have the same length in bytes. You cannot override these defaults in the control file. If the byte order is different between the systems, you can indicate the byte order of the data with the <code>BYTEORDER</code> parameter, or you can place a byte-order mark (BOM) in the file.</p> <div class="tblhruleformal"><a id="NTQRF118" name="NTQRF118"></a><a id="sthref113" name="sthref113"></a><a id="g1012742" name="g1012742"></a> <p class="titleintable">Table 2-5 Default Sizes of Native Data types</p> <table class="HRuleFormal" title="Default Sizes of Native Data types" summary="Rows are datatypes. For each datatype, the first column is its name, and the second column is its default field length." dir="ltr" border="1" width="100%" frame="hsides" rules="rows" cellpadding="3" cellspacing="0"> <col width="*" /> <col width="49%" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t14">Native Data Types</th> <th align="left" valign="bottom" id="r1c2-t14">Default Field Length</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t14" headers="r1c1-t14"> <p>DOUBLE</p> </td> <td align="left" headers="r2c1-t14 r1c2-t14"> <p>8</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t14" headers="r1c1-t14"> <p>FLOAT</p> </td> <td align="left" headers="r3c1-t14 r1c2-t14"> <p>4</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t14" headers="r1c1-t14"> <p>INTEGER <a href="#BABGDAJI"><span class="xrefglossterm">Note</span></a></p> </td> <td align="left" headers="r4c1-t14 r1c2-t14"> <p>4</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t14" headers="r1c1-t14"> <p>SMALLINT</p> </td> <td align="left" headers="r5c1-t14 r1c2-t14"> <p>2</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblhruleformal" --> <a id="BABGDAJI" name="BABGDAJI"></a><a id="NTQRF119" name="NTQRF119"></a> <p class="subhead2">Note</p> <p>The default listed is correct if <code>INTEGER</code> is specified without a size. But <code>INTEGER(n)</code> is also allowed. In that case, <code>n</code> specifies the size of the <code>INTEGER</code> field in bytes.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <a class="olink SUTIL003" href="http://www.oracle.com/pls/db112/lookup?id=SUTIL003"><span class="italic">Oracle Database Utilities</span></a> for a complete list of options and instructions on using SQL*Loader</div> </div> <!-- class="sect2" --></div> <!-- class="sect1" --> <a id="i1007064" name="i1007064"></a><a id="NTQRF121" name="NTQRF121"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1">Using Windows Tools</h2> <p>You can use Windows tools in various ways to manage Oracle Database:</p> <ul> <li> <p><a href="#i1007091">Using Event Viewer to Monitor a Database</a></p> </li> <li> <p><a href="#i1007118">Using Microsoft Management Console to Administer a Database</a></p> </li> <li> <p><a href="#i1007142">Using Oracle Counters for Windows Performance Monitor</a></p> </li> <li> <p><a href="#i1007164">Using Registry Editor to Modify Configuration Information</a></p> </li> <li> <p><a href="#i1007188">Using Task Manager to Monitor Applications and Processes</a></p> </li> <li> <p><a href="#i1010636">Using Local Users and Groups to Manage Users and Groups</a></p> </li> </ul> <a id="i1007091" name="i1007091"></a><a id="NTQRF122" name="NTQRF122"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><a id="sthref114" name="sthref114"></a><a id="sthref115" name="sthref115"></a>Using Event Viewer to Monitor a Database</h3> <p>Event Viewer lets you monitor events in your system. An event is an important occurrence in the system or application (such as Oracle Database) that requires user notification. While messages for major events can appear on-screen as you work at your computer, events not requiring your immediate attention are recorded by Windows in the Event Viewer log file. You can then view this information at your convenience.</p> <p>Use Event Viewer to monitor Oracle Database events, such as:</p> <ul> <li> <p>Initialization of <a href="glossary.htm#i432537"><span class="xrefglossterm">System Global Area</span></a> for active <a href="glossary.htm#CHDFBCHH"><span class="xrefglossterm">instance</span></a></p> </li> <li> <p>Initialization of Program Global Area (PGA) for background processes of active instance</p> </li> <li> <p>Connection to Oracle Database using <code>AS</code> <code>SYSDBA</code></p> </li> </ul> <p><a id="sthref116" name="sthref116"></a><a id="sthref117" name="sthref117"></a><a id="sthref118" name="sthref118"></a>In addition, the operating system audit trail is logged in the Event Log, which is viewable with the Event Viewer.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <a href="monitor.htm#g1012722">Chapter 6, "Monitoring a Database on Windows"</a> for specific instructions on accessing and using Event Viewer to monitor Oracle Database events</div> </div> <!-- class="sect2" --> <a id="i1007118" name="i1007118"></a><a id="NTQRF123" name="NTQRF123"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><a id="sthref119" name="sthref119"></a><a id="sthref120" name="sthref120"></a><a id="sthref121" name="sthref121"></a>Using Microsoft Management Console to Administer a Database</h3> <p>Microsoft Management Console provides a central location for network administration. Microsoft Management Console hosts applications (called <a href="glossary.htm#i432512"><span class="xrefglossterm">snap-ins</span></a>) that administrators can use to manage their networks. Oracle snap-ins enable database administrators to:</p> <ul> <li> <p>Configure Oracle Database administrators, operators, users, and roles so the Windows operating system can <a href="glossary.htm#i432183"><span class="xrefglossterm">authenticate</span></a> them</p> </li> <li> <p>Configure <code>OracleService</code><code><span class="codeinlineitalic">SID</span></code></p> </li> <li> <p>Modify <a href="glossary.htm#i432474"><span class="xrefglossterm">registry</span></a> parameters for all Oracle homes on the computer</p> </li> <li> <p>Modify the computer host name, <a href="glossary.htm#i432581"><span class="xrefglossterm">username</span></a>, and password for the database being monitored by Oracle Counters for Windows Performance Monitor</p> </li> <li> <p>View and terminate an Oracle Database <a href="glossary.htm#i432558"><span class="xrefglossterm">thread</span></a></p> </li> </ul> </div> <!-- class="sect2" --> <a id="i1007142" name="i1007142"></a><a id="NTQRF124" name="NTQRF124"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><a id="sthref122" name="sthref122"></a><a id="sthref123" name="sthref123"></a><a id="sthref124" name="sthref124"></a><a id="sthref125" name="sthref125"></a>Using Oracle Counters for Windows Performance Monitor</h3> <a id="i1007145" name="i1007145"></a> <p>Oracle Counters for Windows Performance Monitor is integrated into Windows Performance Monitor. This tool enables you to view performance of processors, memory, cache, threads, and processes. Performance information provided includes device usage, queue lengths, delays, throughput measurements, and internal congestion measurements. This information is provided as charts, alerts, and reports.</p> <p>You can use Oracle Counters for Windows Performance Monitor to monitor key Oracle Database information, such as:</p> <ul> <li> <p>Library cache</p> </li> <li> <p>Buffer cache</p> </li> <li> <p>Data dictionary cache</p> </li> <li> <p>Redo log buffer cache</p> </li> <li> <p>Thread activity</p> </li> </ul> <p>You can use your findings to improve database performance.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <a href="monitor.htm#i1005706">"Using Oracle Counters for Windows Performance Monitor"</a> for specific instructions on accessing and using Oracle Counters for Windows Performance Monitor to monitor Oracle Database performance</div> </div> <!-- class="sect2" --> <a id="i1007164" name="i1007164"></a><a id="NTQRF125" name="NTQRF125"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">Using Registry Editor to Modify Configuration Information</h3> <p>Oracle Database stores its configuration information in a structure known as the registry. You can view and modify this configuration information through Registry Editor. The registry contains configuration information for your computer and must not be accessible for editing by inexperienced users. Only experienced administrators should view and change this information.</p> <p>Registry Editor displays configuration information in a format similar to Windows Explorer. In the left-hand window is a tree-like format consisting of keys (or folders). When one of these keys is highlighted, parameters and values assigned to that key are displayed in the right-hand window.</p> <p>When you install products from your media, configuration parameters are automatically entered in the registry. These parameters are read each time your Windows computer is started and whenever an Oracle Database product is started. These parameters include settings for:</p> <ul> <li> <p>Oracle home directory</p> </li> <li> <p>Language</p> </li> <li> <p>Company name</p> </li> <li> <p>Oracle home subdirectories for individual products</p> </li> <li> <p>Individual products such as SQL*Plus</p> </li> <li> <p>Services</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <a href="registry.htm#g1015622">Chapter 15, "Configuration Parameters and the Registry"</a> for definitions of Oracle Database configuration parameters and specific instructions on using the registry to modify Oracle Database configuration parameters</div> </li> </ul> </div> <!-- class="sect2" --> <a id="i1007188" name="i1007188"></a><a id="NTQRF126" name="NTQRF126"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><a id="sthref126" name="sthref126"></a>Using Task Manager to Monitor Applications and Processes</h3> <p>Task Manager has four tabs:</p> <ul> <li> <p>Applications tab displays what applications run. This is useful for identifying and ending unresponsive tasks. (Oracle Database does not appear as an application because it runs as a service.)</p> </li> <li> <p>Processes tab displays details of currently running processes and their resource usage. Columns are customizable.</p> </li> <li> <p>Performance tab graphically displays real-time CPU and memory usage, which is useful for spotting sudden changes.</p> </li> <li> <p>Networking tab graphically displays the network traffic taking place over the computer's network connections.</p> </li> </ul> </div> <!-- class="sect2" --> <a id="i1010636" name="i1010636"></a><a id="NTQRF127" name="NTQRF127"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">Using Local Users and Groups to Manage Users and Groups</h3> <p>Local Users and Groups enables you to manage users and groups on Windows. Specifically, you can:</p> <ul> <li> <p>Create and modify local user accounts</p> </li> <li> <p>Create and modify user profiles</p> </li> <li> <p>Create, add, and delete local groups</p> </li> </ul> </div> <!-- class="sect2" --></div> <!-- class="sect1" --> <a id="i1007213" name="i1007213"></a><a id="NTQRF128" name="NTQRF128"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1"><a id="sthref127" name="sthref127"></a><a id="sthref128" name="sthref128"></a>Optional Windows Diagnostic and Tuning Utilities</h2> <p>Windows Resource Kit includes several diagnostic and tuning utilities.</p> <p><a id="sthref129" name="sthref129"></a>Process Viewer summarizes resource usage by a process.</p> <p>Process Monitor displays real-time file systems, registry and process-thread activity. It combines <code>Filemon</code> and <code>Regmon</code> utilities and provides reliable process information.</p> <p><a id="sthref130" name="sthref130"></a>Process Explorer provides a detailed display of resource usage by a process.</p> <p><a id="sthref131" name="sthref131"></a><a id="sthref132" name="sthref132"></a>Task List displays resource usage and other details of a process when its processor identifier or process name is given as an argument. This tool also displays a list of executables and DLLs associated with a process.</p> </div> <!-- class="sect1" --></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="98"> <tr> <td align="center" valign="top"><a href="architec.htm"><img width="24" height="24" src="../../dcommon/gifs/leftnav.gif" alt="Go to previous page" /><br /> <span class="icon">Previous</span></a></td> <td align="center" valign="top"><a href="create.htm"><img width="24" height="24" src="../../dcommon/gifs/rightnav.gif" alt="Go to next page" /><br /> <span class="icon">Next</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 © 1996, 2010, 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="245"> <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="index.htm"><img width="24" height="24" src="../../dcommon/gifs/index.gif" alt="Go to Index" /><br /> <span class="icon">Index</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