5 Database Administration

Monitoring the Database

The dbused Command

The dbfrag Command Output

The dbfrag program returns the following values:

0 - Success

1 - Processing error

The dbused command is a shell script that displays the amount of space used by each object for a given user. Objects are tables, indexes, clusters, rollback, and cache. The default user is sti/sti.

dbused Command Options

The dbused command has three options:

-hprints the listing without a header. This option is useful if you want to parse the output to select a specific field.

-sproduces only summary information grouped by objects.

-uuid/passwd specifies the ORACLE user id and password (sti/sti is default) for all users.

dbused Command Output

The dbused program returns the following values:

0 - Success

1 - Processing error

UCS 1000 R4.2 Administration 585-313-507

Issue 3 April 2000 251