Below is a list of some of tools used by DBAs. Note that some tools can be started from the system's command line prompt (the CLI), others can be started from Oracle's Enterprise Management Console (the OEM console), and some can be started either way.
[This information obtained from table 2-1 of Carol McCullough-Dieter's Oracle9i Database Administrator: Implementation and Administration, ©2003 by Course Technology, pages 28-29.]
Name | Purpose | Start from OEM console? |
Start from CLI? |
---|---|---|---|
Analyze Wizard | Collect statics about objects, validates tables | ![]() |
|
Backup Wizard | Creates backup schedules and provides instructions | ![]() |
|
Data Migration (Update) Assistant | Migrates (moves) data from older Oracle versions to newer ones | ![]() |
|
Database Configuration Assistant | Creates nd configures database instances | ![]() |
|
Enterprise Manager Console | Provides access to tools for dtabase creation, configuration, monitoring, and management | ![]() |
|
Export Wizard | Exports data in a standard format | ![]() |
|
Import Wizard | Imports data in from standard format | ![]() |
|
Instance Manager | Start/stop/monitor a database, configure initialization parameters | ![]() |
|
Log Miner | Examines the redo log files | ![]() |
|
Net Configuration Assistant | Configures Oracle Net | ![]() |
|
Net Manager | Another tool to configure Oracle Net | ![]() |
![]() |
Schema Manager | View and modify data, schem objects (tables, ...) | ![]() |
![]() |
Security Manager | Create/view/modify/delete users, roles, and profiles, and change/expire user passwords | ![]() |
|
SQL*Plus | Execute SQL and PL/SQL commands to run queries and reports, and to start/stop the database | ![]() |
|
SQL*Plus Worksheet | Similar to Windows DOSKEY, provides a buffer and extra editing commands to enter SQL statements more easily than with SQL*Plus alone | ![]() |
|
Storage Manager | Monitor and configure database storage | ![]() |
|
Summary Advisor Wisard | Analyizes databases and generates recommendations for data warehousing | ![]() |