ITPub博客

DBWR_IO_SLAVES [@more@]DBWR_IO_SLAVESIf it is not practical to use multiple DBWR processes, then Oracle provides a facility whereby the I/O load can be distributed over multiple slave processes. The DBWR process is the only process that scans the buffer cache LRU list for blocks to be written out. However, the I/O for those blocks is performed by the I/O slaves. The number of I/O slaves is determined by the parameter DBWR_IO_SLAVES.DBWR_IO_SLAVES is intended for scenarios where you cannot use m

shell 脚本注意事项[@more@]1，一定要加上相应环境变量。2，crontab 定义每隔多少分钟执行一次的格式如下：*/6 * * * * ls -al >~/123.txt(每隔6分钟执行一次)

[转] 孩子的家庭教育很重要[@more@] 一、孩子把水、牛奶等撒了一桌子。错误做法：训孩子：“你怎么这么笨？连个杯子都拿不住。”更有甚者顺手给孩子一巴掌。结果：大人和孩子都很生气，事情一团糟，孩子学会通过发脾气、打人解决问题。正确做法：安慰孩子：“孩子，没事，我知道你不是故意的，下次注意啊。你把桌子擦干净好吗？”结果：孩子得到的谅解，马上向大人道歉，并高兴的把桌子擦干净。孩子学会宽容。[/url][/url]二、孩子考试不及格。错误做法：训孩子：“你看你，考这么点分，你也不嫌丢人？你看谁谁，人

From Tom[@more@]Submitted on 11-Oct-2012 9:48 Central time zoneTom's latest followup | Bookmark | BottomLast updated 11-Oct-2012 17:01You AskedTom, We are moving from older version of Oracle to new verion 11.2.0.3. The DBA's want to load 11.2.0.3 on dev and set compatibility to 10. whatever. then put 11.2.0.3 on production and set compability tha same. After this is working they want to increase compaibilty to 11.2 in dev and if it works out, they will do the same on production. They want to do

From asktomhow does Exadata *not* require a DBA??? It is a fast, big machine, but just a fast big machine. It is not magic, you still need administrators [@more@]Submitted on 5-Nov-2012 11:13 Central time zoneTom's latest followup | Bookmark | BottomLast updated 5-Nov-2012 11:35You AskedHello Tom: In the last few years we have seen how the number of information systems has increased, but also the automation of database administration processes. Now with the new Exadata and SaaS technologies it s

时间 2012.10.25 08:50 -- 2012.10.25 11:10emc 存储故障，导致 11.2.0.2 linux RAC 数据库停机[@more@]一大帮领导站在身后督战，太锻炼人了。

转载[@more@]Char devices are accessed through names in the filesystem. Those names are called special files or device files or simply nodes of the filesystem tree; they are conventionally located in the /dev directory. Special files for char drivers are identified by a "c" in the first column of the output of ls -l . Block devices appear in /dev as well, but they are identified by a "b." The focus of this chapter is on char devices, but much of the following information appli

DBV-00201: Block, DBA 1175408467, marked corrupt for invalid redo application [@more@]问题：　　　一个朋友在做数据库异机恢复时，整个 restore , recover 过程都顺利进行，数据库也可以正常 open 。 但是他对一些数据文件执行 dbv 时报以下错误。DBV-00201: Block, DBA 1175408467, marked corrupt for invalid redo application DBV-00201: Block, DBA 1175408468, marked corrupt for invalid redo application DBV-00201: Block, DBA 1175408469, marked corrupt for invalid redo application DB

AdbeRdr1010_zh_CN.zipFileCombiner_xp500.com.rar[@more@]

SPB[@more@]手工把 plan 改为 accepted 状态；只有处于 accepted 状态的 plan 才可能被用来执行 sql :variable v_sql_handle varchar2(30);variable v_plan_name_full varchar2(30);variable v_plan_name_index varchar2(30);exec :v_sql_handle := 'SYS_SQL_0993bcb3526c1c35';exec :v_plan_name_full := 'SQL_PLAN_a8qny22gsbtd494ecae5c';exec :v_plan_name_index := 'SQL_PLAN_a8qny22gsbtd40893a4b2';variable v_report clob;exec :v_report := DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE(sql_handle => :v_sql_handle);prin

adrciADR uses what it refers to as a flood-controlled incident system, whereby itallows only a certain number of incidents under a problem to log diagnostic data.By default, ADR allows 5 diagnostic data dumps per hour for a single problem. If anincident occurs 20 times but all the incidents are connected to the same problem,you have to report to Oracle Support only one incident. Flood-controlled incidentreporting ensures that numerous incidents pertaining to the same problem don’toverwhelm th

祝老师们节日快乐！[@more@]

不能有半点浮燥心态！！！自省[@more@]

原厂工程师建议最好停机进行。给出的理由是，在更换过程中一个电源工作，如果系统高负荷运行，可能会导致主机系统温度过高等异常情况，从而导致系统异常宕机。具体发生的概率有多大也不太清楚。总之，他们之前有遇到过。不得已，与客户沟通，还是找系统空闲时间，停机操作。最后是，把该服务器上跑的 10G RAC 的实例关闭，然后进行的电源更换。OS 没有关闭。更换操作顺利完成。整个更换操作在 5 分钟内完成。[@more@]有以下几个需要注意的：1, IBM 电源后面会有 3 个灯，一个 AC （交流） ，一个 DC (直流），另外一个不太清楚是做什么的。

C:Documents and Settingsadmin>rman target system/oracle@acrac恢复管理器: Release 10.2.0.1.0 - Production on 星期五 9月 7 12:19:59 2012Copyright (c) 1982, 2005, Oracle. All rights reserved.RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-00554: 内部恢复管理器程序包初始化失败RMAN-04005: 目标数据库中存在错误:ORA-01031: insuffici

动物的故事[@more@]兔子月薪5千，打算用20万建一个窝。　　狼不允许，说私自建就是违章建筑，只允许向王八买。　　王八是搞房地产的，先用20万贿赂狼取得开发权，再用50万元向狼买这块地，投资10万元把兔子窝盖好，向兔子要价200万元。　　兔子拿不出这么多钱于是向狐狸借200万元，连本带利300万，20年还清，　　兔子全家二十年给狐狸打工。　　狼、狐狸、王八都挣了钱，只有兔子亏，连孩子也不敢生了。　　兔子越来越少，狼觉得这样下去大家没肉吃，于是调控。狼显得非常重视兔窝价格太贵的问题，研究部署了遏制兔窝价格过快上涨的政策措

http://candon123.blog.51cto.com/704299/420303[@more@]

awk 学习资料链接：http://www.ibm.com/developerworks/linux/library/l-awk1/index.htmlhttp://www.grymoire.com/Unix/Awk.html[@more@]2012.09.06 :[root@cdp ~]# cat test3.sh #!/bin/awk -fBEGIN {# Print the squares from 1 to 10 the first wayi=1;while (i <= 10) {printf "The square of " i " is : "i*i "tn";i = i+1;}# do it again, using more concise codefor (i=1; i <= 10; i++) {printf "The square of " i " is : "i*i "tn";}# now endexit;}[root@

北京[@more@]

我的是 SSD 盘，空间本来就不大，伤不起啊！[@more@]