随笔档案「2016年1月」 - 思静

路由命令

摘要：ipconfig tracert -d 192.168.1.55 route add [IP] mask [Mask] [Gateway] route add 192.168.1.88 mask 255.255.255.0 192.168.1.1 ping 192.168.1.55 阅读全文

posted @ 2016-01-28 17:28 思静阅读(172) 评论(0) 推荐(0)

修改表触发器对应的序列号（当增加或修改数据时需要用）

摘要：create or replace procedure SP_Change_Sequence_Num(table_name_in varchar2, pk_name_in varchar2, is_positive_growth_in number) is /*********************************************************** ... 阅读全文

posted @ 2016-01-13 12:01 思静阅读(460) 评论(0) 推荐(0)

通过SQL ID查询SQL Text

摘要：SELECT SQL_ID, SQL_TEXT,FIRST_LOAD_TIME, EXECUTIONS FROM V$SQLAREA where SQL_ID='22v8fyk0juw25'; 阅读全文

posted @ 2016-01-13 11:54 思静阅读(2803) 评论(0) 推荐(0)

设置内存管理

摘要：SELECT name, value FROM v$parameter WHERE name like '%target%'; select value/1024/1024/1024 as Value_G from dual; select * from V$MEMORY_TARGET_ADVICE; SELECT ( (SELECT SUM(value) FROM V$... 阅读全文

posted @ 2016-01-13 11:51 思静阅读(157) 评论(0) 推荐(0)

Kill Session

摘要：有时候创建索引或修改表字段时，会提示资源正忙，可以查出表对应的进程并kill掉 select l.session_id,o.owner,o.object_name from v$locked_object l,dba_objects o where l.object_id=o.object_id; select t2.username,t2.sid,t2.serial#,t2.logon... 阅读全文

posted @ 2016-01-13 11:49 思静阅读(433) 评论(0) 推荐(0)

设置In_Memery

摘要：alter system set inmemory_size=4G scope=spfile; alter table table_name inmemory; alter table table_name no inmemory; select * from v$inmemory_area; 阅读全文

posted @ 2016-01-13 11:48 思静阅读(226) 评论(0) 推荐(0)

查询无效对象及重新编译

摘要：-- invalid object statistics： select owner, object_type, status, count(*) from dba_objects where status='INVALID' group by owner, object_type, status order by owner, object_type; -- select inval... 阅读全文

posted @ 2016-01-13 11:46 思静阅读(414) 评论(0) 推荐(0)

Oracle 硬解析查询

摘要：-- 硬解析的 parse count (hard) select * from v$sysstat where name like '%parse%'; select a.value,b.name from v$mystat a, v$statname b where a.STATISTIC#=b.STATISTIC# and b.name like '%parse%'; selec... 阅读全文

posted @ 2016-01-13 11:42 思静阅读(3401) 评论(0) 推荐(1)

设置Oracle 12C OEM 端口

摘要：SQL> exec dbms_xdb_config.sethttpport(8087); 打开OEM: http://DBSIPOrName:8087/em/ 阅读全文

posted @ 2016-01-13 11:38 思静阅读(1124) 评论(0) 推荐(0)

创建Mysql 序列

摘要：create table sequence( name varchar(50) not null primary key, current_value BIGINT not null DEFAULT 0, increment int not null DEFAULT 1, max_value BIGINT, -- 最大值 initial_value BIGIN... 阅读全文

posted @ 2016-01-13 11:27 思静阅读(2712) 评论(0) 推荐(0)

compress 表设置及索引设置

摘要：-- 查看表大小 select segment_name,bytes/1024/1024 from user_segments where segment_name='TableName'; -- 查看表大小 select table_name,blocks*8192/1024/1024 size_m -- 2000.6796875 2211.6953125 from user_tabl... 阅读全文

posted @ 2016-01-11 16:36 思静阅读(1132) 评论(0) 推荐(0)

闪回表

摘要：查询需要闪回的时间的scn:select timestamp_to_scn(to_timestamp('2016-01-11 10:00:00','yyyy-mm-dd hh24:mi:ss')) as scn from dual;如下为执行SQL> flashback table yky.webs... 阅读全文

posted @ 2016-01-11 10:54 思静阅读(205) 评论(0) 推荐(0)