Databases and segments

List of all segments and the objects on them. Use a worksheet as in the following example:

Database name

DB options set

Size (Mb)

Segments names

Device name

Size (Mb)

master

none

700

default.system.log

master

3

master

none

500

default.system.log

master

2

master

none

300

default.system.log

master

1

model

none

200

default.system.log

master

2

tempdb

select into/bulkcopy

200

default.system.log

master

2

TRD

none

10000

system, trd_seg1

TRD_dev1

10020

TRD

none

5000

system, trd_seg1, trd_seg2

TRD_dev2

5020

TRD

none

1000

log

TRD_log

1020

CIS

none

4000

system, cis_seg1

CIS_dev1

4020

CIS

none

400

log

CIS_log

420