Database Administration (MOSC)

MOSC Banner

missmatch between dbms_space.unused_space and dbms_space.space_usage

Hi,

I'm running some tests on oracle database 12.2, i create a table insert rows and run dbms_space.unused_space and dbms_space.space_usage and numbers reported dont match.

1) create table test (a number, b varchar2(50)) tablespace users;

insert into test values (1,null);

commit;


2) run dbms_space.space_usage and got:

Total number of blocks that are unformatted: 0

Number of blocks that has at least 0 to 25% free space: 0

Number of blocks that has at least 25 to 50% free space: 0

Number of blocks that has at least 50 to 75% free space: 0

Number of blocks that has at least 75 to 100% free space: 5

Total number of blocks that are full in the segment: 0

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center