Dbfrag, Synopsis, Description – HP R4.2 User Manual

Page 445

Advertising
background image

A

Summary of Commands

dbfrag

UCS 1000 R4.2 Administration 585-313-507

Issue 3 April 2000 406

dbfrag

The dbfrag command lists fragmentation information on the database
(Version 7 ORACLE).

Synopsis

dbfrag

[-h -b]

Description

The dbfrag

command is a shell script that reports on database allocation,

usage, and fragmentation. The block size reported is in ORACLE blocks
(2048 bytes). You can request the information to be reported in Mbytes with
the

-b

option. This tool is useful to get a quick check on database usage and

provides a shell interface into some key ORACLE statistics.

This tool only reports on information in the SYSTEM tablespace. With the

-h

option, the listing is printed without a header. This option is useful if you want
to parse this output to select a specific field.

The following requests fragmentation information in megabytes (using the

-b

option).

Advertising