- 博客(135)
- 收藏
- 关注
转载 PARALLEL_EXECUTION_MESSAGE_SIZE
PARALLEL_EXECUTION_MESSAGE_SIZE specifies the size of messages for parallel execution (formerly referr...
2012-05-14 11:38:22
391
转载 some suggestions for rac performance
1. If possible, please use CACHE + NOORDER for sequences on RAC:This setting has the least performance...
2012-05-09 23:10:19
160
转载 ORA-01931: cannot grant UNLIMITED TABLESPACE to a role on 10g
SQL> grant unlimited tablespace to dba_role;grant unlimited tablespace to dba_role*ERROR at line 1:OR...
2012-05-09 23:03:16
518
转载 RMAN-06094 Datafile does not exist
RMAN-06094 Datafile does not exist Applies to:oracle server version 10.2.0.2 and later.Symptomeswhen trying t...
2012-05-08 14:51:14
409
转载 MRP0: Background Media Recovery terminated with error 1274
MRP0: Background Media Recovery terminated with error 1274 [ID 739618.1] Modified ...
2012-05-02 00:02:51
322
转载 set up a standby quickly by duplicate.
set up a standby quickly by duplicate.1.Create an Oracle Password File for the Auxiliary InstancePasswor...
2012-04-30 21:17:37
96
转载 how to mount diskgroup automatically
edit pfile and append an entry like *.asm_diskgroups='DG01'startup asm by spfilecreate spfile from pfile...
2012-04-26 12:42:08
108
转载 alias doesn't work on solaris
alias doesn't work on solaris.solaris10 use shell sh default,so alias doesn't work.we can change the she...
2012-04-24 13:54:03
79
转载 ORA-00600 [Kfgfinalize_2] While Mounting Diskgroups In Rac [ID 418063.1]
ORA-00600 [Kfgfinalize_2] While Mounting Diskgroups In Rac [ID 418063.1] Modif...
2012-04-24 12:39:29
122
转载 rac installation on Solaris10 x86-64
Oracle Clusterware and Oracle Real Application ClustersInstallation Guide10g Release 2 (10.2) for Solaris10 x86-64...
2012-04-23 20:47:30
82
转载 How I Resolved Performance Issues After Upgrading from 9i to 10g
In my previous organization, after upgrading the databases from Oracle 9i to 10g, we had a few perform...
2012-04-05 11:04:51
63
转载 xxxx
http://www.en8848.com.cn/yingyu/38/n-77238.htmlhttp://bbs.for68.com/forum-264-242/topic-354277.htmlhttp:...
2011-01-20 15:30:16
995
转载 migrate
[root@rac1 ~]# uname -aLinux rac1 2.6.9-78.ELsmp #1 SMP Wed Jul 9 15:39:47 EDT 2008 i686 i686 i386 GNU/Linux[root@...
2011-01-20 10:53:30
142
转载 oracle db setting auto-bringup
oracle 9i db setting auto-bringup$ vi /etc/oratab *:/uxdb/ora9i/product/9.2:Nora9i:/uxdb/ora9i/product/9.2:Y--indi...
2011-01-18 18:46:33
128
转载 linux 激活vg
解决挂载旧硬盘后无法识别lvmvgscan 找到VolGroup00vgchange -a y VolGroup00 激活ex:[root@rac1 dev]# vgscan Reading all physical...
2011-01-18 15:01:04
1387
转载 xxx
http://movie.yeshj.com/movie/32083/?page=1###http://www.douban.com/group/topic/5201806/ ...
2011-01-15 23:38:16
85
转载 oracle9i installation
installation environment[root@rac1 ~]# uname -aLinux rac1 2.6.9-78.ELsmp #1 SMP Wed Jul 9 15:39:47 EDT 2008 i686 i...
2011-01-13 15:10:12
103
转载 linux下.cpio.gz文件的解压
linux下.cpio.gz文件的解压#gunzip 文件名.cpio.gz#cpio -idmv -- cpio - copy files to and from archives ...
2011-01-12 16:07:12
121
转载 patch系列
Oracle Interim patches:A patch that is applied in between patchset releases with the Opatch utility.Interim patc...
2010-12-21 17:03:47
132
转载 vi
进入vi的命令 vi filename :打开或新建文件,并将光标置于第一行首 vi +n filename :打开文件,并将光标置于第n行首 vi + filename :打开文件,并将光标置于最后一...
2010-12-16 13:46:25
78
转载 shift
我们知道,对于位置变量或命令行参数,其个数必须是确定的,或者当Shell程序不知道其个数时,可以把所有参数一起赋值给变量$*。若用户要求Shell在不知道位置变量个数的情况下,还能逐个的把参数一一处理,也就是在$1后为$2,...
2010-12-13 17:07:41
83
转载 sed
1. Sed简介sed 是一种在线编辑器,它一次处理一行内容。处理时,把当前处理的行存储在临时缓冲区中,称为“模式空间”(pattern space),接着用sed命令处理缓冲区中的内容,处理完成后,把缓冲区的内容送往屏幕。接着...
2010-12-13 16:57:21
77
转载 stty
stty是一个用来改变并打印终端行设置的常用命令,现介绍几个常用的有趣的用法 :-)1,在命令行下,禁止输出大写的方法 stty iuclc #开启stty -iuclc #恢复:-) 2,在命令行下禁止输出小写stty olc...
2010-12-13 16:57:07
126
转载 linux 收集
<(内容)EOF可以把EOF替换成其他东西意思是把内容当作标准输入传给程序这里再简要回顾一下< 符。在该分界符以后的内容都被当作输入,直到s h e l l又看到该分界符(位于单独的一行)。这个分界符可以是你所定义...
2010-12-13 16:30:27
48
转载 syntax
Since常见的四种用法 1) since +过去一个时间点 (如具体的年、月、日期、钟点、1980, last month, half past six)。 I have been here since 1989. 2)...
2010-12-13 13:37:52
96
转载 无知 冲动的后果可能会很严重。。要严谨。
开发环境上执行了cp /dev/zero /..本意想清空这个目录 (客户限制了rm -rf) 结果等了半天没反应看了这个后 一身的冷汗。。/dev/zero has infinite length, so copying fr...
2010-12-10 10:33:51
106
转载 SunOS 操作命令及linux区别整理
SunOS 操作命令及linux区别1. 系统# passwd:修改口令# exit:退出系统2. 文件# cp:复制文件或目录,参数:-a递归目录,-i覆盖确认# mv:改名移动# rm:删除,参数:-r递归删除3. 目录# ...
2010-12-07 15:44:04
2109
转载 eng收集
20101208address vt.1.(写信封,包裹)写姓名地址例:address a parcel to sb 把包裹寄给某人2.向....致意例:address one's thanks to sb.向某人表示感谢3.向...
2010-12-06 09:19:35
101
转载 incremental checkpoint
CHECKPOINT TUNING AND ERROR HANDLING1. What is a Checkpoint?A Checkpoint is a database event wh...
2010-12-02 17:31:59
535
转载 规则收集
http://blog.hr.com.cn/index.php/533332/viewspace-64882.htmlhttp://www.ebigear.com/news-82-32279.html一、 连读 连读有两...
2010-12-02 10:46:17
96
转载 bug收集
2010/12/1Errors in file /opt/oracle/app/oracle/admin/trade/udump/trade_ora_1372824.trc: ORA-00600: internal error ...
2010-12-01 17:04:34
88
转载 oracle date加减时间
SQL> alter session set nls_date_format='yyyymmdd hh24:mi:ss';Session altered.SQL> select to_date('201010...
2010-11-12 20:01:15
256
转载 osw使用手记
安装(下载oswg.zip包 Baseline version 2.0.4)原理:This tool collects the following kinds of data using the resident host o...
2010-11-11 21:10:37
212
转载 锁的认识 更新中。。
lock框架包括3个组件 resource structure,lock structure,enqueue.resource structure,lock structure是数据结构当进程或事务要访问资源时,需从内存中申请一...
2010-10-26 00:22:48
125
转载 RESTORE POINT
RESTORE POINT 目的:以往做闪回时都要指定闪回的scn或timestamp 现在创建了restore point后 可以把table或database闪回到restore point所指定的时间点或scn语法:CRE...
2010-10-21 17:25:05
235
转载 dg设置auto failover
dg设置auto failoverauto failover即设置Fast-Start FailoverEnabling fast-start failover does not trigger a failover. Ins...
2010-10-19 11:57:57
217
转载 broker 学习
配置先决条件[1]server parameter file 启动数据库[2]DG_BROKER_START设置true[]3如果配置环境有rac 则必须配置DG_BROKER_CONFIG_FILEn参数指向共享文件 其可以存...
2010-10-19 11:48:37
410
转载 rman dg duplicate 系列问题更新。。
rman dg duplicate 系列问题更新。。6、RMAN> restore spfile from '/u01/app/oracle/flash_recovery_area/ORCL/autobackup/20...
2010-10-18 19:47:05
211
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人