How to Encrypt Your Bash Shell Script on Linux Using SHC?(加密shell script)
当需要写shell连接数据库取一些数据或备份等操作时，shell中可能包含数据库的用户密码等敏感信息，被一些不怀好意的人发现是你的灾难，出于安全的考虑需要对shell明文加密，使用shc 就可以把原shell编译为可执行程序(二进制)，这样就无法再明文打开shell。
Manually create Oracle 11g physical standby DG ,Switchover, Convert to Logical standby(Scripts and Short Descriptions)
Manually create physical standby with rman;
Primary role and Primary standby role switchover;
Converting Physical Standby to Logical Standby ;
CTAS will loss default value define on columns
The CTAS operation although copies column constraints such as NULL, NOT NULL from the normal table to the partitioned table during the partitioned table creation, it does not copy DEFAULT VALUEs of the columns.
script:purge ADR file
[oracle@db231 ~]$ ./adr_purge
INFO: Purge started at Thu May 16 07:35:32 CST 2013
INFO: adrci purge started at Thu May 16 07:35:32 CST 2013
INFO: adrci purging diagnostic destination diag/tnslsnr/db231/listener
INFO: purging ALERT older than 90 days …
INFO: purging INCIDENT older than 30 days …
ORA-12034: materialized view log on xx.xx younger than last refresh when a mview fast refresh after Impdp
ORA-12012: error on auto execute of job 88
ORA-12034: materialized view log on “TOPBOX”.”TOPBOX_COURSESTUDY” younger than last refresh
ORA-06512: at “SYS.DBMS_SNAPSHOT”, line 2256
About ORACLE CPU, PSU, SPU Patch Nomenclature
It all started in January 2005 with Critical Patch Updates (CPU). Then Patch Set Updates (PSU) were added as cumulative patches that included priority fixes as well as security fixes.
linux发送手机短信 利用fesion robot
系统监控对于严重紧急的问题发短信通知，利用中国移动的飞信就可以做到免费给飞信好友发送sms短信,飞信机器人就是调用飞信的接口，可以命令行下调用。我们恰好可以利用这点。
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.
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).
Script: Who’s using a database link?(找出谁在使用dblink)
Every once in awhile it is useful to find out which ses […]
