declare
vused number;
valloc number;
begin
dbms_space.create_index_cost('create index IDX_XXX on mvx_perfomance_service(id_date) pctfree 1 compress', vused, valloc );
dbms_output.put_line(vused);
dbms_output.put_line(valloc);
end;
used- The number of bytes representing the actual index data.
alloc - Size of the index when created in the tablespace.
dba-oracle.com
vused number;
valloc number;
begin
dbms_space.create_index_cost('create index IDX_XXX on mvx_perfomance_service(id_date) pctfree 1 compress', vused, valloc );
dbms_output.put_line(vused);
dbms_output.put_line(valloc);
end;
used- The number of bytes representing the actual index data.
alloc - Size of the index when created in the tablespace.
dba-oracle.com