linux发送手机短信 利用fesion robot
系统监控对于严重紧急的问题发短信通知，利用中国移动的飞信就可以做到免费给飞信好友发送sms短信,飞信机器人就是调用飞信的接口，可以命令行下调用。我们恰好可以利用这点。
weejar zhang
Tuning “Read by other session wait” Event
This wait event occurs when we are trying to access a buffer in the buffer cache but we find that the buffer is currently being read from disk by another user so we need to wait for that to complete before we can access it.
力挺一下sqluldr
客户要求导出大量的数据(约800万记录)，开始为了格式上的好看生成的是ACCESS数据库文件，用Toad 11导出成生ACCESS，本地域名网的DB，生成700W生成的文件有1G多点，都用了约三个小时，更悲惨的是三个小时后，弹出的一个错误窗口，提示无空间，莫名其妙，硬盘空间很充足，当时的心情可真是”唯有长江水无语东流…” 变通一下800万的记录在ACCESS也没有可读性，无非是数据导入，所以考虑生成flat file,文本文件的形式。 想到了老楼的小工具sqluldr，free命令行操作方便。 下面是真实的操作，早知如此何必加那三小时班。 [oracle@dev-db ~]$ ./sqluldr2 user=icme6/icme6 query=”select /*+parallel(t 8)*/* from sdscore t” file=sd_score.txt field=0x09 record=0x0d0x0a 0 rows exported at 2013-04-12 19:59:18, size 0 MB. 1000000 rows exported at 2013-04-12 19:59:21, size 200 MB. 2000000 rows exported at 2013-04-12 19:59:24, size 320 MB. 3000000 rows exported at 2013-04-12 19:59:27, size 420 MB. … Read more
荆棘载途 RAC安装之NFS篇
这两天在NFS上配置一套RAC玩，实在没有好的机器就是三台PC，内存2G，每个PC还单块物理网卡，不过最终安装成功。下面记录安装过程中的一些小问题。
Tuning ‘log file sync’ Event
The log file sync wait occurs at the end of a transaction (COMMIT or End Of Job)and the database writer (DBWR) process must wait for the log file to synchronize with the database.
Troubleshooting wait event: ‘latch: row cache objects’
This latch comes into play when user processes are attempting to access or update the cached data dictionary values.
ORA-00600 [qkssao2s1] internal error issue
ORA-00600: internal error code, arguments: [ORA-00600: internal error code, arguments: [qkssao2s1], [], [], [], [], [], [], []
SQL hint mean force? More about parallel(二)(不并行的场景)
sql中如果使用了parallel hint 或是force parallel query 想并行查询的特性，如果那样做了就一定能保证 query optimizer选择并行的执行计划么？知道那样做实际上产生什么样的影响么？
More about ITL in oracle
ITL(Interested Transaction List ),The Oracle database engine locks the data modified by a transaction at the row level. To implement this feature every data block contains a list of all transactions that are modifying it. This list is commonly called interested transaction list (ITL).
Oracle GoldenGate Trail File
Trail files are generated by both the original extract and the Data Pump (extract) process. Trail files are read by the Data Pump (extract) and Replicat (replicat) processes
Schema level flashback(闪回用户或方案)
Technically there is no schema level flashback feature available. and flashback database is a binary operation, the bits and bytes of the flashed back data are identical to what they used to be, it is not a ‘logical’ flashback, it is a physical flashback. However, provided your recovery period does not include any data dictionary … Read more
Script: Who’s using a database link?(找出谁在使用dblink)
Every once in awhile it is useful to find out which sessions are using a database link in an Oracle database. It’s one of those things that you may not need very often, but when you do need it, it is usually rather important. Yong Huang includes this script on his website, and notes that … Read more
More about index
创建索引可以方便的给DB带来查询上的性能提升，但是DML时index的维护代价也是昂贵的。合理的创建索引，删除不必要的索引。
Tuning PGA Memory
You can get the correct size of PGA using V$PGA_TARGET_ADVICE, dynamic performance view.
HAVING expression default Selectivity
In some cases the query optimizer might can not accurately estimate cardinality (e.g. group by having or like with bind variables cause etc..),therefore the Cardinality estimates are based on default seletivity of build-in oracle coredefault seletivity(5%).
oracle forall instructs must be followed by DML
Oracle BULK COLLECT and Oracle FORALL are the new features in Oracle 8i, 9i and 10g PL/SQL that can really make a different to you PL/SQL performance. The keyword FORALL instructs the PL/SQL engine to bulk-bind input collections before sending them to the SQL engine. Although the FORALL statement contains an iteration scheme, it is … Read more
goldengate extract process abending caused by nologging DDL
I use goldengate(for oracle) to do a SCHEMA synchronized,include DDL operrations. when the the EXTRACT process was running to capture the changes ,then if you try do a DDL such as “alter table t_a no logging” on the capture table will cause EXT process ABENDING, I hit these errors today. ogg version: Oracle GoldenGate Command … Read more
US7ASCII DMP 导入 ZHS16GBK DB 一方案
exp 时注意保证三处的字符集一致，对于本例的US7ASCII(10g) DMP 导入 ZHS16GBK DB (11g),采用了修改dmp文件中的两处字符集编号，最终解决了字符集乱码问题。
The lowercase and quotes table names may not be able to audit(小写表名可能不会审计)
昨一好朋友问我开了审计，有些表但无审计记录。 下面我来还原这个问题 db_version oracle 10201 for linux SQL> show parameter audit NAME TYPE VALUE ———————————— ———– —————————— audit_file_dest string /u1/oracle/admin/ORCL/adump audit_sys_operations boolean FALSE audit_syslog_level string audit_trail string DB, EXTENDED audit select any table by access; SQL> select os_username,username,terminal,timestamp,owner,obj_name,audit_option from DBA_AUDIT_TRAIL order by 4; OS_USERNAM USERNAME TERMINAL TIMESTAMP OWNER OBJ_NAME AUDIT_OPTION ———- ———- ———- ——————- —————————— … Read more
ORA-1688: unable to extend table SYS.WRH$_ACTIVE_SESSION_HISTORY
1) Export the snapshots and then do a manual purge To purge the Table SYS.WRH$_ACTIVE_SESSION_HISTORY, you may first query the Snapshot History with the query below: select snap_id, begin_interval_time from sys.dba_hist_snapshot order by snap_id; Then, you choose the range of snapshot you want to delete, and you execute the following Procedure: exec dbms_workload_repository.drop_snapshot_range ( low_snap_id … Read more