Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Comments

If you run this from the command line for the console, do you get any output? - just ot see if there are errors.
Also, try to run it with the shell script too, I did see some intermittent issues on 64 bit where some toolbar items were not visible

thanks
B
Answer
Did you install the SDK or JRE of 1.6? It looks like tools.jar is missing; this file is included with the SDK, but not a JRE.

- John
SQL Developer Team
Marked as Answer by 727458 · Sep 27 2020
727458
From previous versions of SQLDev I had desktop shortcut that called the .bat file (because there was no 64bit sqldeveloper.exe previously). It used first java it found in a PATH and it was the one from JRE. Thanks for pointing to right direction!
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 20 2015
Added on Jan 17 2015
#general-database-discussions
3 comments
1,656 views