SHELL:Find Memory Usage In Linux (统计每个程序内存使用情况)
shell统计linux系统中每个程序的内存使用情况，因为内存结构非常复杂，不一定100%精确，
scn format (scn格式)
scn(system change number) 结构主要维护 oracle数据库内部的数据一致性，SCN 有两部分组成: Base and wrap，wrap 是16bit的数字，base是32bit的数字,这样其实就可以算scn的有效范围，它的格式(redo dump trace)是wrap.base，当base超过了2的32次方,然后wrap 就会加1，其实用sql 很好验证。
SQL Test Case Builder generate test case automatically(自动生成SQL所需测试数据)
Why SQL Test Case Builder? For most SQL problems, the single most important factor for a speedy bug resolution is to obtain a reproducible test case. However, this is normally the longest and most painful step for customers. The goal of the SQL Test Case Builder (TCB) is to automatically gather as much information as … Read more
ORA-00313,ORA-00312,ORA-27037,ORA-19527 DATAGARD 11G r2
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
DDE: Problem Key ‘ORA 312’ was flood controlled (0x5) (no incident)
ORA-00312: online log 2 thread 1: ‘/oracle/oradata/icme/redo02.log’
Error 19527 creating/clearing online redo logfile 2
Send email using utl_smtp in Oracle 11g (results in ORA-24247)(11g ACL 网络访问控制列表)
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at “SYS.UTL_TCP”, line 17
ORA-06512: at “SYS.UTL_TCP”, line 267
OGG-01028 Oracle GoldenGate Capture for Oracle,Table compression is not supported
2013-09-29 10:03:15 ERROR OGG-01028 Oracle GoldenGate Capture for Oracle, eicmec.prm: Object with object number 81069 is compressed. Table compression is not supported.
Oradebug Security
DEMO 1,How to use oradebug to call OS commands via the database
DEMO 2,Disable sys audit
How to imp job to another schema in same db(同一数据库导入JOB到另外一用户)
ORA-39083: Object type JOB failed to create with error:
ORA-00001: unique constraint (SYS.I_JOB_JOB) violated
Goldengate source and target table differ in column structure part-2(ogg同步不同的表结构数据)
map icme.test_s, target icme.test_t,
COLMAP(usedefaults,
create_date =@IF(@STREQ(@GETENV(“GGHEADER”,”OPTYPE”),”INSERT”),@DATENOW(),@COLSTAT(MISSING)),
last_update_date=@datenow()
Goldengate source and target table differ in column structure part-1(ogg同步不同的表结构数据)
昨天一朋友问如果用GOLDENGATE同步数据(ETL)，如果目标端比源端多出一个时间字段表示最后的修改日期，OGG可以实现么？可以的，下面是我step-by-step 的演示.耗时两天做个总结，在这特殊日子也祝 各位 库友中秋团圆！ source db sid:icme tablename:test_t ————- |id ,name | ————- target db sid:ggs tablename:test_t —————————————- |id ,name, create_date, last_update_date| —————————————– create_date 取记录的生成时间 last_update_date 取最后DML的时间 Source DB — 建立新表 icme@ICME>create table test_s(id int,name varchar2(20)); — ogg 的配置文件，这是我之前配置源和目标库表结构一样的环境，有启用DDL同步,后面我会陆续修改，OGG安装参考以前的文章 GGSCI (icme-db) 2> view params eicmec extract eicmec —————————————— — local extract for icme schema change … Read more
Dynamically Changing shared_pool_size fail!(动态修改Shared pool size失败)
因安装数据库时启用了ASMM,过了几天发现分配不太理想想禁用ASMM，手动调整shared_pool_size, 这是一个动态参数，修改后立即生效无需重启数据库实例，但修改时遇到了比较奇怪的现象。
Install ZABBIX On Linux 5 监控安装配置(pdf)
•What is zabbix ?
•What can it monitor?
•Structure of ZABBIX and Componentes
Sql Server 2008 简单搭建主从复制
通过将主服务器上备份出来的transaction log 传送到辅助服务器上并进行恢复,实现主从库的同步，有些类似mysql 的主从和oracle 的OGG，不过sqlserver 的日志传输当主服务器宕机的时候，日志传送功能并不能实现从主服务器到辅助服务器的自动故障转移功能，需要手动将辅助服务器切换到联机状态，使得辅助服务器上数据库来提供服务，从而实现数据库的高可用性。 Parimary DB ——————– IP: 192.168.217.240 OS: windows 2003 x64 DB: Sql server 2008 ——————– Secondly DB ——————– IP: 192.168.217.240 OS: windows 2003 x32 DB: Sql server 2008 ——————– Transaction Log data flow ————————- primary db –>backup e:\db_backup –> shared e:\db_backup as \\192.168.217.240\db_bacup | |secondly copy \\192.168.217.240\db_bacup to local e:\db_restore … Read more
ORA-07445 [kggchk()+77] [SIGSEGV] [Address not mapped to object]
今天有个项目系统负载突然变大，查到top sql是一个存储过程,执行计划缺少合理的索引，SQL是个update操作，于是kill 调用的几个session 建立一个索引，结果发现kill几个用户进程后实例挂了.下面是alert日志，可见instance crash前出现过死锁,就是那个update sql Thu Aug 15 11:08:04 2013 ORA-00060: Deadlock detected. More info in file /oracle/admin/icme/udump/icme_ora_24011.trc. Thu Aug 15 11:27:00 2013 ORA-00060: Deadlock detected. More info in file /oracle/admin/icme/udump/icme_ora_26527.trc. Thu Aug 15 11:27:03 2013 ORA-00060: Deadlock detected. More info in file /oracle/admin/icme/udump/icme_ora_26912.trc. Thu Aug 15 11:32:46 2013 ORA-00060: Deadlock detected. More info … Read more
Enabling Listener Trace ,TNS-01251
Enabling Listener Trace ,TNS-01251 Oracle version 11g introduced the ADR or Automatic Diagnostic Repository feature,Trying to change the log file using the Lsnrctl utility fails with: TNS-01251: Cannot set trace/log directory under ADR. oracle@db231 trace]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.3.0 – Production on 15-AUG-2013 14:15:59 Copyright (c) 1991, 2011, Oracle. All rights reserved. … Read more
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在那里…
Know more about Oracle ASH
《Know More about Oracle AWR》 姐妹篇，oracle 10g引入，ASH 是性能诊断工具，不像sql trace总是默认打开， 保存历史上发生了什么， 提供比AWR更细粒度的数据，即使当系统负载很高时，它也工作的很好，因为使用类似memcopy的数据收集，不会有太大的额外负担，没用任何类型的数据库lock。 Active(‘Active’ == Non-idle sessions) Session History Licensed as part of the Diagnostic pack,