Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Help about understand values retrieved by Tom Kyte script for my LOB segment

trajonJan 17 2015 — edited Jan 23 2015

I have LOB segment. When I use Tom Kyte script show_space

(https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:14339684180676) a have this output:

Unformatted Blocks ..................... 107

FS1 Blocks (0-25) ..................... 0

FS2 Blocks (25-50) ..................... 0

FS3 Blocks (50-75) ..................... 0

FS4 Blocks (75-100)..................... 0

Full Blocks ..................... 859,438

Total Blocks............................ 1,746,304

Total Bytes............................. 14,305,722,368

Total MBytes............................ 13,643

Unused Blocks........................... 0

Unused Bytes............................ 0

Last Used Ext FileId.................... 5

Last Used Ext BlockId................... 1,261,056

Last Used Block......................... 128

I have only Full Blocks = 859,438, but Total Blocks = 1,746,304 why so?

This post has been answered by Jonathan Lewis on Jan 17 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 20 2015

Added on Jan 17 2015

#general-database-discussions

3 comments

1,712 views