- 博客(26)
- 资源 (6)
- 收藏
- 关注
原创 delayed block clean out不会产生undo
10.2.0.5的库,设置16select s.name,m.VALUE from v$mystat m,v$statname s where m.statistic#=s.STATISTIC# and s.NAMEin( 'undo change vector size','redo size');
2014-06-30 10:30:15 489
转载 查看rollback事务的undo使用情况
http://www.ixora.com.au/scripts/sql/9.0/rolling_back.sql---- Script: rolling_back.sql-- Purpose: to predict when transactions will finish rolling back-- For: 9.0+---- Copyright: (c) Ixor
2014-06-30 09:42:50 515
转载 如何查看一个session使用了多少undo
Session UndoFiled under: Infrastructure,Oracle,Troubleshooting,undo — Jonathan Lewis @ 8:40 pm BST Sep 22,2010 One of the simple scripts I use from time to time monitors the amount of undo
2014-06-30 08:01:43 1105
转载 Know more about Oracle Nologging
Know more about Oracle Nologging2010/01/13 BY MACLEAN LIU 暂无评论
2014-06-29 10:34:39 465
转载 shell 编程之2>&1
经常可以在一些脚本,尤其是在crontab调用时发现如下形式的命令调用/tmp/test.sh > /tmp/test.log 2>&1前半部分/tmp/test.sh > /tmp/test.log很容易理解,那么后面的2>&1是怎么回事呢?要解释这个问题,还是得提到文件重定向。我们知道>和&1的意思就是将标准错误也输出到标准输出当中。下面通过一个例子来展
2014-06-27 08:10:41 412
转载 【分区管理】如何确定分区索引是Global还是Local,PREFIXED 还是NON-PREFIXED
http://www.askmaclean.com/archives/determine-partition-index-local-global-prefixed.html【分区管理】如何确定分区索引是Global还是Local,PREFIXED 还是NON-PREFIXED 可以通过 DBA_PART_INDEXES视图中的LOCALITY和ALIGNM
2014-06-21 08:06:20 1045
转载 Oracle8i - DISABLE VALIDATE constraint state (文档 ID 69637.1)
Introduction~~~~~~~~~~~~Prior to Oracle 8i, integrity constraints could have the following state.1. ENABLE VALIDATE specifies that all old data also complies with the constraint along with th
2014-06-17 21:03:24 525
转载 Rely constraint and ROWID Tips
Relying on Unique Identification of Rows in Data Guard TablesIn the physical standby database, the recovery is achieved using the rowid of segments. Since a logical standby database is not structura
2014-06-17 07:53:01 504
转载 DG的dataguard real time apply
Creating a 10gr2 Data Guard Physical Standby database with Real-Time apply (文档 ID 343424.1)转到底部修改时间:2012-9-21类型:BULLETIN
2014-06-15 22:31:54 1739
转载 Understanding Linux CPU Load - when should you be worried?
This is the blog for Scout, Enterprise-grade server monitoring without the bloat.70+ plugins, realtime charts, alerts, and Chef/Puppet-friendly configuration.JULY 31 ANDREUnderstanding
2014-06-15 11:20:42 535
转载 set autotrace 的选项
You can control the report by setting the AUTOTRACE system variable.• SET AUTOTRACE OFF - No AUTOTRACE report is generated. This is the default.• SET AUTOTRACE ON EXPLAIN - The AUTOTRACE report sh
2014-06-10 08:18:54 514
转载 vim中文编码问题
中文編碼的問題很多朋友常常哀嚎,說他們的 vim 裡面怎麼無法顯示正常的中文啊?其實這很有可能是因為編碼的問題! 因為中文編碼有 big5 與 utf8 兩種,如果你的檔案是使用 big5 編碼製作的,但在 vim 的終端介面中你使用的是萬國碼(utf8), 由於編碼的不同,你的中文檔案內容當然就是一堆亂碼了!怎麼辦?這時你得要考慮許多東西啦!有這些:你的 Linux 系統預設支援
2014-06-10 07:49:33 433
转载 v$session和v$transaction的关系
一个tom论坛的话题:以备以后研究:https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:4226409800346774588
2014-06-09 21:55:02 1589
原创 Effect of Switchovers, Failovers, and Control File Creation on Backups
对dataguard 官方文档里面的这句话不理解,能否给出一个例子说明:10.2.0.5的版本Effect of Switchovers, Failovers, and Control File Creation on BackupsAll the archived redo log files that were generated after the last backup o
2014-06-08 17:13:02 817
转载 failover inloving the physical standby
1 apply as much archivelog as possible2 resolve the archive grap3 f
2014-06-07 16:19:33 446
原创 Physical standby failover steps
1 resolve the archivelog gap2 stop the applying service alter dat
2014-06-05 21:51:18 473
原创 switch over Physical Standby steps
Fisrt switch the primary to standby and then switch the standby to primary1 check the primary if i
2014-06-05 21:18:43 504
原创 使用Net Configuration Assistant时点击Next无反应
10.2.0.5 on windows 2008 64 bit在配置listener时,到最后一步点击Next就是没有反应,listener的服务也没有创建chenggonm
2014-06-05 20:01:44 3181
原创 使用Resize2FS在线扩展lvm出错
RHEL 4[root@linuxtest ~]# resize2fs /dev/testvg/testlvresize2fs 1.35 (28-Feb-2004)/dev/testvg/testlv is mounted; can't resize a mounted filesystem!
2014-06-03 07:44:33 5795
原创 创建standby controlfile的方法
10.2.0.5 on windows 2008 64 bit 在主库mount或open状态下1 alter databas
2014-06-02 09:53:52 5431
转载 default/keep/recycle buffer pool 的区别
引自asktom: Block Buffer Cache So far, we have looked at relatively small components of the SGA. Now we are going to look at one that is possibly huge in size. The
2014-06-01 21:43:53 966
原创 build physical standby steps
1 enable force logging; alter database force logging;2 add standby logfile on the primary for maximize protection and maximize availability3 create the same password file4 set following the i
2014-06-01 16:15:33 685
转载 如何查看linux支持的filesystem类型
This file displays a list of the file system types currently supported by the kernel. Sample output from a generic /proc/filesystems file looks similar to the following:nodev sysfs nodev root
2014-06-01 11:22:28 2258
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人