--创建表
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 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
--创建sequence 对象
DROP SEQUENCE PAYMENT.SEQ_OPTLOG_ID;
CREATE SEQUENCE PAYMENT.SEQ_OPTLOG_ID
START WITH 1
MAXVALUE 999999999999999999999999999
MINVALUE 0
NOCYCLE
NOCACHE
NOORDER;
--收集系统信息
vmstat 3 > cpuusage
--监控系统连接数
select count(*) from v$session ;
select count(*) from v$session where status='ACTIVE';
--给9.2.0.4 数据库打安全patch