loryliu的专栏

DB：10.2.0.5OS：windows 2008 64 bitMAXDATAFILES和db_files都是设定datafile的s

本文地址：http://wallimn.iteye.com/blog/1199561，转载请保留。

http://www.ixora.com.au/notes/rba.htmRedo Byte Address (RBA)Recent entries in the redo thread of an Oracle instance are addressed using a 3-part redo byte address, or RBA. An RBA is compri

10.2.0.5windows 2008 64 bitsql>shutdown immediatesql

今天在看10g document的时候看到如下的描述You should monitor temporary tablespace activity to check how many extents arebeing allocated for the temporary segment. If an application extensively usestemporary

10.2.0.5 windows 2008 64 bit在physical standby 在v$archived_log中的creator

APPLIES TO:Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.5 - Release: 10.2 to 10.2Information in this document applies to any platform.GOALThis Note describes the behavior

10g的文档里面说创建normal restore point并不需要特别的设定。在不开启fla

The previous post in this series showed you how v$reqdist summarised the time taken by tasks running through shared servers – but there are several other ways we need to look at what’s going on with

Manually stopping a dispatcher process is one of the things I have to look up each time, since it’s needed not that often. And, the word “dispatcher” does not appear in the command line! :)alter sys

ID 1514588.1

10g的文档写到，在primary db 里面rename数据文件后，此信息不会更新到standby。在refresh

STANDBY_FILE_MANAGEMENT 这个参数只有在standby

10.2.0.5 on windows 2008 64 bit在进行切换时出现：

ORL: Online Redo LogSRL:Standby Redo Log

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

10.2.0.5文档里面说，

10.2.0.5 on windows 2008 64 bit在配置listener时，到最后一步点击Next就是没有反应，listener的服务也没有创建chenggonm

1 resolve the archivelog gap2 stop the applying service alter dat

在网上找到的解释：ata Guard - SYNC vs AFFIRMLGWR SYNC AFFIRM in Oracle Data Guard is used for zero data loss. How does one ensure zero data loss? Well, the redo block generated at the primary has

版本：10.2.0.5 on windows 2008 64 bit查看v$database

经常可以在一些脚本，尤其是在crontab调用时发现如下形式的命令调用/tmp/test.sh > /tmp/test.log 2>&1前半部分/tmp/test.sh > /tmp/test.log很容易理解，那么后面的2>&1是怎么回事呢？要解释这个问题，还是得提到文件重定向。我们知道>和&1的意思就是将标准错误也输出到标准输出当中。下面通过一个例子来展

1 apply as much archivelog as possible2 resolve the archive grap3 f

10.2.0.5 on windows 2008 64bit在10g里面temporary tablespace是ASSM，而且只能以uniform

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

http://www.oraclerealworld.com/oracle-buffer-busy-wait/Oracle 10 and 11Buffer Busy Waits usually happen on Oracle 10 and 11 mainly because of insert contention into tables or I

This is really the write threshhold. When this many blocks in the redo buffer are filled, lgwr willinitiate a write of the log buffer automatically (without getting a sync request). This defaults to

Know more about Oracle Nologging2010/01/13 BY MACLEAN LIU 暂无评论

一个tom论坛的话题：以备以后研究：https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:4226409800346774588

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

下文是MOS上的：Data Guard Gap Detection and Resolution Possibilities (文档 ID 1537316.1)

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');

@广州-lqq 程序中如果在insert中大量使用append和parallel的提示，会造成碎片  你去dba_free_space试图里查小于1M的空间有多少。一般来说，表的默认扩展extent大小是1M，所以基于这个查。如果你的表有特殊设置，那就要看那个设置的扩展值来查了。

10.2.0.5 on windows 64 bit官方文档的解释是

16000007FF0A7A6128000007FF0A7A6160139TX196618969601813000007FF0B104C88000007FF0B104CA8142TX19661896906120

10.2.0.5 on windows 2008 64 bit总是在primary database上修改protection mode。

1 首先在V$lock中 type为TX ID1和ID2的意思

10.2.0.5 on windows 64 bit现象：从一个DB

在windows 下使用cmd进入命令模式，使用sert serveroutput

10.2.0.5 on windows 2008 64 bit 在主库mount或open状态下1 alter databas