A Summary of Commands

dbfrag

# dbfrag -b

 

SYSTEM Tablespace, Space is in Mega-Bytes

 

 

 

ALLOCATED

FREE

% FREE AVG/FRAG LARGEST FRAGMENTS DB_FILES

ROLLBACK

-----------------129.00

----------------108.88

------------

----------------

-------------- -------------------

--------------

----------------

84.40

5.44

108.12

20

1

7.91

Examples

The following example gets the largest contiguous ORACLE space available.

dbfrag -h awk ‘length>1 {print $5}’

10240

Diagnostics

The program returns the following:

0 — Success

1 — Processing Error

See Also

dbcheck dbfree dbused

UCS 1000 R4.2 Administration 585-313-507

Issue 3 April 2000 407