object_number_cache_size

object_number_cache_size.sql

SQL> sho parameter object_number_cache_size

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
_object_number_cache_size            integer     10

SQL> select obj#, dataobj# from obj$ where name='_NEXT_OBJECT';

      OBJ#   DATAOBJ#
---------- ----------
         1      74131

SQL>
SQL> begin
  2    for i in 1..9
  3    loop
  4      execute immediate 'create table t'||i||'(x int)';
  5      execute immediate 'drop table t'||i||' purge';
  6    end loop;
  7  end;
  8  /

PL/SQL procedure successfully completed.

SQL>
SQL> select obj#, dataobj# from obj$ where name='_NEXT_OBJECT';

      OBJ#   DATAOBJ#
---------- ----------
         1      74131

SQL>
SQL> create table t0(x int);

Table created.

SQL>
SQL> select obj#, dataobj# from obj$ where name='_NEXT_OBJECT';

      OBJ#   DATAOBJ#
---------- ----------
         1      74141