ORDBA WIZARD

This tool is aimed at enabling Oracle DBA to monitor and perform all the jobs of a DBA including creation of database.

This screen is gives all the vital stats that measure performance and information on free space, tablespace and the associated data files, rollback segments, sessions and I/O analysis. It also enables

DBA to kill a session, which is holding the resources and is badly hitting performance or a session that was started but never completed. This data in this screen can be manually updated or set for update

periodically such as every 05, 10, 30 seconds or 01 minute.

This is AT A GLANCE YOUR DATABASE:

Menu

01 File

1.  log on

2.  log out

3.  Exit

Log On sub menu takes you to the Log on screen user shall sign in to the Oracle Database using Oracle Connectivity Conventions.

On Logging on to the database all the statistics are generated and  “DATABASE AT A GLACE “ is known.

In case Oracle is not available or for some reason the database is not open and/or available for operations the user is taken to a window where in he is given an option to log in to server manager or sqlplus as internal or as sysdba to enable the user to perform recovery and/or startup database operations. At that point the user may exit out of the window and inform the DBA to take care of the situation and go back to main screen and wait until the situation is taken care of.

Log out sub menu enable to log out and return to the main menu.

Exit enables the user to exit out of the tool.

2.  System

3.  performance

4.  event viewer

This part of menu is useful when user is on windows plat form.

It brings up the performance window of the server / client where the tool is installed.

The event viewer is also confined to the events that occur on the server / client on which tool is installed.

03.DBA Jobs

1.  Database Assistant

2.  Redo Logs

3.  Control files

4.  RBS Manager

5.  Shared Pool Manager

6.  User Object Manager

7.  Job Manager

Database Assistant: This is a separate tool associated with this tool. While all the menu items are available only after signing in as a database dba user, this menu is available without signing in.

This tool enables to create database or delete database.

It enables to create, edit or delete services on windows platform.

It also creates initialization parameter file (init.ora) file, OFA directory structures and then creates database.

This screen enables to create OFA directory structure on windows platform for a proposed database. Location of the control files, init.ora file, size of the database to be created, data block size and compatibility. It is interactive and suggestive also.

create services for the database on the windows platform

create database or save create database script:

creation of tablespaces:

create  five tablespaces ( creates user, index, temp, rbs and tools tablespaces )

With the help of  this create tablespaces tool you can create 5 tablespaces with the choice parameters and locations of choice. Load spreading and balancing can be easily achieved using this tool.

Redo Logs: This is usable when signed in as a DBA user. It enables get all info about the redo log groups and members, their locations, sizes and status etc., A new group can be added with required number of members. A group can be dropped with members and only members can be dropped and created for a group

It also helps in knowing the archive destination and change the archive destination

Control files: This is to manage the location of control files and to backuyp control files to a destination of choice.

Rollback Segment Manager : This menu enables you to get all the info about the RBS and enables user to create, modify and drop RBS and also provides important docs on the recovery of RBS in case they are corrupt, need media recovery.

Shared Pool Manager

Provides all help with important docs and then finds whether the memory is sufficient or not, so that init.ora parameters can be changed/ modified which effect negatively the performance of the database.

User Object Manager

It enables to browse through the schema of each owner on being selected.

Job Manager

This enables to add, alter and drop jobs as also to run the jobs

4. Utilities

1.  Loader

 It enables to create SQL* Loader Control files, run them to load tables. It has the option to format the data and then load the data.When an new format data is to be loaded, it temporarily creates a staging table and then generates PL/SQL. In the PL/SQL generated it suggests the user to give the strings that are to be considered to load data into the right table identified by the User. Takes the strings and then formats the data as asked by the user and runs that PLSQL to load the data into the table, the PLSQL has identified per the parameters given by User.

1.External Tables – being worked on

2.  Export

Others are being worked on