martes, 13 de junio de 2017

INITRANS

SQL> CREATE TABLE test (id NUMBER);

Table created.

SQL> SELECT ini_trans, max_trans from dba_tables WHERE table_name = 'TEST';

 INI_TRANS  MAX_TRANS
---------- ----------
         1        255

SQL> ALTER TABLE TEST INITRANS 5 MAXTRANS 255 ;

Table altered.

SQL> SELECT ini_trans, max_trans from dba_tables WHERE table_name = 'TEST' ;

 INI_TRANS  MAX_TRANS
---------- ----------
         5        255

jueves, 8 de junio de 2017

CREATE TRIGGER uptime_log

SQL>
SQL> CREATE TABLE uptime_log (
  2      database_name       VARCHAR2(30),
  3      event_name          VARCHAR2(20),
  4      event_time          DATE,
  5      triggered_by_user   VARCHAR2(30)
  6  );

Table created.

SQL>
SQL>
SQL> CREATE OR REPLACE TRIGGER log_shutdown
  2  BEFORE SHUTDOWN ON DATABASE
  3  BEGIN
  4      INSERT INTO uptime_log
  5          (database_name,
  6           event_name,
  7           event_time,
  8           triggered_by_user)
  9          VALUES (sys.database_name,
 10                  sys.sysevent,
 11                  sysdate,
 12                  sys.login_user);
 13      COMMIT;
 14  END;
 15  /

Trigger created.

SQL>
SQL> drop table uptime_log;

Table dropped.