Table attributes PCT_FREE and PCT_USED shifted

Toad for Oracle
1

Hi

Toad 14.1 and 15 also.

SQL> create table raulkaubi.proov2(id number) tablespace users pctfree 0;
Table created.

SQL> col owner for a15;
col table_name for a15;
select owner, table_name, pct_free, pct_used from dba_tables where table_name in ('PROOV2');

OWNER           TABLE_NAME        PCT_FREE   PCT_USED
--------------- --------------- ---------- ----------
RAULKAUBI       PROOV2                   0

SQL> set pagesize 0
set lines 200
set long 90000
set feedback off
set echo off
select dbms_metadata.get_ddl('TABLE','PROOV2','RAULKAUBI') from dual;

  CREATE TABLE "RAULKAUBI"."PROOV2"
   (    "ID" NUMBER
   ) SEGMENT CREATION DEFERRED
  PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255
 NOCOMPRESS LOGGING
  TABLESPACE "USERS"

So PCT_USED is DEFAULT (40% seems like DEFAULT value for oracle)!
And PCT_FREE is specified 0.

Here is what TOAD shows me.

image

When I alter table, seems like something is just the opposite.
image

This is quite interesting. Toad indeed shows correct information for some tables. But whenever I create a new table, this is what happens at the moment.

Regards
Raul

2

Whenever I create first row, this information is corrected, at least for PCT_FREE.
PCT_USED is still wrong, it is not 0 actually (dbms_metadata.get_ddl shows me 40, which is default value).
Also PCTUSED parameter is somewhat irrelevant these days. Is it possible to turn off displaying this parameter at all (at least when using ASSM - which should be the one to use these days)..?

SQL> insert into raulkaubi.proov2(id) values(1);
SQL> commit;

image

image

Raul

3

Thanks Raul.

I'm not working today but I've made a note of this to look when I get back.

-John

4

Hi

Is there an update regarding the issue..?

Regards
Raul Kaubi

5

Hi Raul,

It was fixed in the most recent beta. Sorry that I did not update this thread. 15.1 is planned for release near the end of January.

-John