Install ZABBIX On Linux 5 监控安装配置(pdf)

•What is zabbix ?
•What can it monitor?
•Structure of ZABBIX and Componentes

Sql Server 2008 简单搭建主从复制

通过将主服务器上备份出来的transaction log 传送到辅助服务器上并进行恢复,实现主从库的同步,有些 […]

ORA-07445 [kggchk()+77] [SIGSEGV] [Address not mapped to object]

今天有个项目系统负载突然变大,查到top sql是一个存储过程,执行计划缺少合理的索引,SQL是个update […]

Enabling Listener Trace ,TNS-01251

Enabling Listener Trace ,TNS-01251 Oracle version 11g i […]

export data from 11g and import into 10G R2 ORA-01455

EXP-00008: ORACLE error 1455 encountered
ORA-01455: converting column overflows integer datatype
EXP-00000: Export terminated unsuccessfully

Dynamic SQL Supports Statements Length Characters Limit (execute immediate sql长度限制)

有时需要在plsql 写一些动态sql,用execute immediate 或dbms_sql 调 用,但是execute immediate 后动态sql 文本的长度限制是多少呢?

To hold the latch manually, DB hang demo(手动持用latch使数据库hang)

It is widely known that the Oracle server uses kslgetl – Kernel Service Lock Management Get Latch function to acquire the latch,oradebug call kslgetl/kslfre can be used to acquire the latch manually. This is very useful to simulate latch related hangs and contention.

Delete the data on the table very slow(删除数据慢)

今天开发的同事问有个表上的数据为什么删不掉?我看了一下,也就不到100000条数据,表上有外键,等了5分钟hang在那里…