ITPub博客

oracle sqlplus 把查询结果生成CVS文件，并邮件发送

REDIS是KEY-VALUE数据库，用于做缓存是很不错的选择。一、REDIS 集群安装步骤安装相关软件yum install -y ruby  ruby-rdoc;rpm -ivh rubygems-1.3.7-2.3.noarch.rpm下载wget https://rubygems.global.ssl.fastly.net/gems/redis-3.2.1.gemgem install redis-3.2.1.gem --localwget http://download.redis...

SAN存储交换机性能之fill word

linux 存储多路径软件 device-mapper-multipath 、 EMC powerpath

oracle impdp 直接从源库导入到目的库

以eclipse插件、maven插件方式安装 mybatis-generator

eclipse 安装maven

-- 启用DG日志应用alter database start logical standby apply immediate;-- 停止DG日志应用alter database stop logical standby apply; -- 跳过出错的事务 select * from  DBA_LOGSTDBY_EVENTS t order by t.event_time desc; begin dbms_logstdby.skip_transaction(70,15,721998);end;-- ...

ORACLE DG为RAC时使用scan-ip连接数据库会报 ORA-12545错误

MySQL参数调整

ansible自动化运维工具

MySQL MHA集群

ORACLE：使用tcpdump 监控客户端发过来的所有SQL语句

ORA-04067: not executed, package body "OGG.DDLREPLICATION" does not existORA-06508: PL/SQL: could not find program unit being called: "OGG.DDLREPLICATION"ORA-04067: not executed, package body "OGG.DDLREPLICATION" does not existORA-06508: PL/SQL: could not find program unit being called: "OGG.DDLREPLICATION"

Kubernetes1.3 - K8S安装1       Kubernetes规划1.1   规划Master     192.168.1.11  apiserver、controller-manager、scheduleretcd          192.168.1.11  etcdNODE &...

mysql在线建立半同步复制的从库

ORACLE自动重编译包导致查询被卡 cursor: pin S wait on X

--- 查看进程正在执行的SQLselect p.SPID,sql.SQL_TEXT,sql.sql_id,s.* from gv$process p , gv$session s,gv$sqlarea sql where p.ADDR=s.PADDR and p.INST_ID=s.INST_ID  and sql.INST_ID=s.INST_IDand sql.ADDRESS=s.SQL_ADDRESS-- ORACLE 获取绑定变量值：SELECT SQL_ID,NAME, POSITION, value...

DG为RAC的逻辑备库?LOG_AUTO_DELETE（TRUE）参数不起作用