[筆記]Tools of DBA

Tasks:

Tools:

    The Oracle Enterprise Manager

    SQL*Plus

    iSQL*Plus

Introduction to the Oracle Enterprise Manager

      The web-based Database Control serves as the primary tool for managing your Oracle database and sets a new standard in ease-of-use. From the Oracle Enterprise Manager, you can perform administrative tasks such as creating schema objects (tablespaces, tables, and indexes), managing user security, backing up and recovering your database, and importing and exporting data. You can also view performance and status information about your database instance.

l          Database Management Features

l          Online Help

l          Navigational Features

Starting the Oracle Enterprise Manager Console

    To access the Oracle Enterprise Manager Console from a client browser,the dbconsole process needs to be running on the server.This process is automatically started after installation.

SQL*Plus

      SQL*Plus is a command line program you use to issue SQL statements to an Oracle database.

iSQL*Plus

      iSQL*Plus is the web version of SQL*Plus. Before you can connect to it with a URL, you must start the iSQL*Plus application server.