u010695981的博客

--创建表空间create tablespace RichMediaDevdatafile '/opt/11g/oracle/oradata/orcl/RichMediaDev_DATA01.dbf'size 2048M autoextend on next 100M maxsize 20480M; --创建用户create user richmed

索引重建：rebuild方法一：（先删除后新建）DROP index ZEMESSAGE_BOX;create index ZEMESSAGE_BOX on ZEMESSAGE (BOX); 方法二：alter index ZEMESSAGE_PLATFORM rebuild

Oracle时间查询

根据占用cpu高的进程号来查询者个进程执行的sql语句：SELECT sql_text FROM v$sqltext a WHERE (a.hash_value, a.address) IN (SELECT DECODE(sql_hash_value, 0, prev_hash_value, sql_hash_value), DECODE(sql_hash_value, 0, prev_s...