Install ZABBIX On Linux 5 监控安装配置(pdf)
•What is zabbix ?
•What can it monitor?
•Structure of ZABBIX and Componentes
ORA-07445 [kggchk()+77] [SIGSEGV] [Address not mapped to object]
今天有个项目系统负载突然变大,查到top sql是一个存储过程,执行计划缺少合理的索引,SQL是个update […]
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在那里…