webpages - Githubissues

建表空间、建用户 create tablespace zmxtest datafile '/opt/oracle/oradb/oradata/crmdb/zmxtest' size 512M autoExtend on next 512M maxsize 10240M; create user zmxtest identified by <password> default tablespace zmxtest; alter user zmxtest quota unlimited on zmxtest; grant connect, resource, create any view, create database link to zmxtest;

行数 select count(1) from t_cmp_perf_stat; 删数据 delete from t_cmp_perf_stat where begintime < to_date('2016-10-24 00:00:00', 'yyyy-mm-dd hh24:mi:ss');

SELECT * FROM DBA_DATA_FILES; alter database datafile '/opt/oracle/oradb/oradata/crmdb/ops.dbf' autoextend on; alter database datafile '/opt/oracle/oradb/oradata/crmdb/ops.dbf' autoextend on next 512M maxsize 10240M;

打开连接池： SELECT * FROM DBA_CPOOL_INFO;

exec DBMS_CONNECTION_POOL.START_POOL('SYS_DEFAULT_CONNECTION_POOL');

exec DBMS_CONNECTION_POOL.ALTER_PARAM ('','minsize','10'); exec DBMS_CONNECTION_POOL.ALTER_PARAM ('','maxsize','100');

用户角色很重要，需要弄清楚sys，system，sysdba等概念

oracle重启：（1）以oracle身份登录数据库，命令：su – oracle （2）进入Sqlplus控制台，命令：sqlplus /nolog （3）以系统管理员登录，命令：connect / as sysdba （4）启动数据库，命令：startup （5）如果是关闭数据库，命令：shutdown immediate （6）退出sqlplus控制台，命令：exit （7）进入监听器控制台，命令：lsnrctl （8）启动监听器，命令：start （9）退出监听器控制台，命令：exit （10）重启数据库结束

查看redo切换频度：

select sequence#,first_time,nexttime,round(((first_time-nexttime)24)60*60,2) diff from (select sequence#,first_time,lag(first_time) over(order by sequence#) nexttime from v$log_history where thread#=1) order by sequence# desc;

查看当前redo状态：

select group#,members,bytes/1024/1024,status from v$log;

创建新的redo

alter database add logfile group 7 ('/opt/oracle/oradb/oradata/crmdb/redo07.log') size 1024M; alter database add logfile group 8 ('/opt/oracle/oradb/oradata/crmdb/redo08.log') size 1024M; alter database add logfile group 9 ('/opt/oracle/oradb/oradata/crmdb/redo09.log') size 1024M;

切换状态为current redo到新创建的上面（配合查看redo状态命令，多次切换）

alter system switch logfile;

设置新创建的redo为检查点

alter system checkpoint;

删除老的redo

alter database drop logfile group 4; alter database drop logfile group 5; alter database drop logfile group 6;

zhaowawj commented 7 years ago

setsid java -jar mock.jar > mock.out

zhaowawj commented 7 years ago

https://www.tutorialspoint.com/easymock/easymock_overview.htm https://github.com/jayway/powermock/wiki/mockitousage https://devlearnings.wordpress.com/2010/05/13/easymock-expectationeasymock-expect-flavours-explained/

zhaowawj commented 7 years ago

java http://www.java67.com/2012/08/what-are-difference-between-wait-and.html http://howtodoinjava.com/core-java/multi-threading/difference-between-sleep-and-wait/ http://stackoverflow.com/questions/1036754/difference-between-wait-and-sleep