- Create Table Create Table AdminUser (Username Varchar2 (30) Not Null Primary Key, Password Varchar2 (50) NOT NULL, MID VARCHAR2 (256), CREATE_TIME DATE
Create Table AdminModule (Mid Number (3) Primary Key, MURL VARCHAR2 (256), MEMO VARCHAR2 (256));
Create Table Optlog (ID Number (11) Not Null Primary Key, Optuser Varchar2 (30), Optid Number (3), OPTTIME DATE, OPTIP VARCHAR2 (20), OPTBAK VARCHAR2 (256));
Create Table Optmemo (Optid Number (3) Primary Key, OptMemo Varchar2 (256));
- Create an index create index payment.idx_optlog_optid on payment.optlog (Optid) TABLESPACE INDX
Create index payment.idx_optlog_optuser on payment.optlog (optuser) TABLESPACE INDX
CREATE INDEX Payment.idx_optlog_opttime on payment.optlog (OPTTIME) TABLESPACE INDX - Create a sequence object drop sequence payment.seq_optlog_id;
CREATE SEQUENCE PAYMENT.SEQ_OPTLOG_ID START WITH 1 MAXVALUE 999999999999999999999999999 MINVALUE 0 NOCYCLE NOCACHE NOORDER; - collecting system information vmstat 3> cpuusage-- monitoring system connections select count (*) from v $ session; select count (*) from v $ session Where status = 'active'; - Give 9.2.0.4 Database Safety Patch
