Get init trans value of Object

 Get init trans value of Object:

=========================


select table_name, INI_TRANS  from dba_tables  where table_name = 'TABLE_NAME';

 SELECT table_name, index_name, status, ini_trans   FROM DBA_INDEXES

  

INITTRANS value set double for index than object, like below ex:

ALTER TABLE TABLE_NAME MOVE INITRANS 10;

ALTER INDEX TABLE_NAME_PK REBUILD INITRANS 20;

ALTER INDEX TABLE_NAME_I1 REBUILD INITRANS 20;






No comments:

Post a Comment

View running queries in postgresql

 View running queries in postgreSQL: SELECT * FROM pg_stat_activity;