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.

Allocated and wasted space in blob field

User_94JECJul 14 2022

I have a blob field in a table.
if I execute the dbms_lob.getlength function:
select sum(dbms_lob.getlength("CAMPO")) as bytes from TABLE;
I get this result:
85659787749 (about 79.7GB)

If I execute the dbms_space.space_usage procedure on the lob field I get:
There is a big difference between the Full Bytes in segment value and the result from the dbms_lob.getlength procedure. Why?

Type : LOB
Attr1 : USER
Attr2 : SYS_LOB0008853631C00007$$
Message : space saved 117145600 byte.
More info :
Allocated space: 115432488960
Utilized space: 115315343360
Reclaimed space :117145600

I would like to understand why there is such difference between the output from the dbms_space.space_usage procedure and the dbms_lob.getlength function.

This post has been answered by Jonathan Lewis on Jul 15 2022

Jump to Answer

ora_tech

Hi,

Welcome 2 Oracle Forums :)

Does oracle 8i and 9i supported for AIX 6.1 (32 and 64 bit)

RDBMS 8i/9i are very old versions, these may not be certified with IBM-AIX 6.1

Please refer to the certification matrix tab from https://support.oracle.com/CSP/ui/flash.html

Regards,
X A H E E R

740218

thanks for helping me ..
but somehow i am not able to acces this link..
can you give me other link or help me in some other way from which it can be verified ?

Helios-GunesEROL

Hi user;

Please check below and see its helpful

http://www.oracle.com/technology/support/metalink/index.html

Regard
Helios

450804

Hi,

based on 169706.1 (Modified: 06-MAY-2009) only 10.2.0.4 and 11.1 are so far supported on AIX 6.1. For Oracle 9.2 and 8.1.7 AIX 5.3 appears to be fine. ;)

Cheers,
David

OCP 9i
http://www.oratoolkit.ch/otn.php

738216

Hi

Old thread I know... but did you attempt to install Oracle 8i on AIX 6.1? Did it work?

I'm considering this as a temporary solution to assist with a migration but have concerns that it might not install. I'm not too worried about being certified at this point as it will only be in service for a couple of weeks!

Thanks

Sean

1 - 5

Added on Jul 14 2022

#general-database-discussions

6 comments

1,021 views

Oracle Database Discussions

Allocated and wasted space in blob field

Comments

Post Details