ITPub博客

 追踪enqueue lock,DDL语句锁SQL> alter session set timed_statistics = true;SQL> alter session set statistics_level=all;SQL> alter session set max_dump_file_size = unlimited;SQL> alter session set ...

Select extract(day from snap_interval) * 24 * 60 +       extract(hour from snap_interval) * 60 +       extract(minute from snap_interval) "S...

 1把之前drop的日志文件group1,group2,group3重新使用，同时删除drop group4,group5,group6。select * from v$log;col member for a50select * from v$logfile;alter database add logfile group 1 ('/umm...

http://www.oracleonlinux.cn/2012/09/log-miner-recover-data/http://www.killdb.com/index-of-articlehttps://support.oracle.com/epmos/faces/ui/km/SearchDocDisplay.jspx?_afrLoop=1339099855777434&_afrWind...

想收集SQL trace信息使用tvdxtat.在用户目录下.bash_profile加入alias tvdxtat=' .  /uhrms/scripts/tvdxtat.sh'然后source .bash_profile生效。

1 今天做HRMS Clone工作，需要更改数据库名。改了数据库名发现，数据库打不开。报错SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01194: file 1 needs more re...

http://www.itpub.net/forum.php?mod=viewthread&tid=1361814http://www.oracle.com/technetwork/cn/articles/rac11g-setting-100145-zhs.html#tophttp://www.oracledatabase12g.com/archives/step-by-step-instal...

 oracle新特性http://yangtingkun.itpub.net/post/468/448296  VCS服务http://cache.baidu.com/c?m=9d78d513d98710ee4fede5245e4397240d13c03d338d96533dc3923b8e7908030527f4bb50784b13d3b22c345af90e...

 介紹安裝oracle 11grac 安裝http://dbastreet.com/docs/11gR2RacInstall_gridinfra.htmlhttp://dbastreet.com/docs/11gR2RacInstall_rac.htmlhttp://dbastreet.com/docs/11gR2RacInstall_dbca.htmlhttp://...

echo '--------------------------------------------------'echo 'Enter your choice :';read -t 15 nameif [ "$name" = "" ] then         echo  'Welcome to...

11323

配置Oracle数据库和监听随Linux系统自启动 1.设置/etc/oratabtestdb2:/opt/oracle/product/9.2.0:Y要把最后一个选项从N改为Y 2.测试dbstart和dbshut命令dbstart和dbshut会检查/etc/oratab的设置，如果设置为Y...

vi /etc/pam.d/system-authpassword    required      /lib/security/$ISA/pam_cracklib.so retry=3 minlen=8 lcredit=-1 dcredit=-1 credit=-1 vi /etc/profileHIS...

122313123

Oracle数据库有时候出现不能使用索引的现象，出现该现象的原因有很多，该怎么去定位呢?本文我们主要就介绍这一部分内容。　　首先，我们要确定数据库运行在何种优化模式下，相应的参数是： optimizer_mode .可在 sv...

http://www.itpub.net/thread-1009235-1-8.html  安裝oracle rac

无人值守批量安装linux操作系统 找redhat实验

#!/bin/bash chkconfig --list | awk '{print "chkconfig " $1 " off"}' > /tmp/chkconfiglist.sh;/bin/sh /tmp/chkconfiglist.sh;rm -rf&nb...

 root@ :   grep HugePages /proc/meminfoHugePages_Total: 33288HugePages_Free:  33288HugePages_Rsvd:      0 sar -r 1 5 | tail -n 1|awk ' {print $9}' 93...

1.监控事例的等待：select event,sum(decode(wait_time,0,0,1)) prev, sum(decode(wait_time,0,1,0)) curr,count(*) from v$session_wait group by event order by 4;2.回滚段的争用情况：select name,waits,gets,w...