ITPub博客

【转载地址】http://blog.csdn.net/tianlesoftware/article/details/7237448MOS 文档：kccrsz: expanded controlfile message in"alert.log" [ID 101020.1]  Problem Description----------------...

【摘于】http://www.eygle.com/archives/2007/08/stepbs_oracle_chp1_08.html对于可传输表空间有一个重要概念：自包含（Self-Contained）。在表空间传输的中，要求表空间集为自包含的，自包含表示用于传输的内部...

什么是条带化(striping)     当多个进程同时访问一个磁盘时，可能会出现磁盘冲突。大多数磁盘系统都对访问次数（每秒的 I/O 操作，IOPS）和数据传输率（每秒传输的数据量，TPS）有限制。当...

今天再论坛看到一个问题 关于 lost write 突然想到LGWR 在commit 时是如何保证写道磁盘的 在网上查到一篇文章很好的解释了这个Direct I/O and Redo writes.Here is a subject that has bothered me for some...

FORCEIf the database is open, then FORCE shuts down the database with a SHUTDOWN ABORT statement before re-opening it. If the database is closed, then FORCE opens th...

Instance Recovery Performance Tuning: Fast-Start Fault RecoveryThis section describes instance recovery, and how Oracle's Fast-Start Fault Recovery improves availability in the event of a crash or ins...

***This article is being delivered in Draft form. and may containerrors. Please use the MetaLink "Feedback" button to adviseOracle of any issues related to this article.***PURPOSE-------V$se...

Applies to:Linux OS - Version Enterprise Linux 4.0 and laterLinux x86Linux x86-64***Checked for relevance on 17-Jun-2010*** ***Checked for relevance on 20-Feb-2013*** PurposeThis article wil...

Applies to:Enterprise Manager Base Platform. - Version 10.2.0.1 to 11.1.0.1 [Release 10.2 to 11.1]Information in this document applies to any platform.Checked for relevance on Feb-18-2013GoalThis is a...

转载地址:http://www.dba-oracle.com/t_alter_system_switch_logfile_vs_alter_system_archivelog_current.htmQuestion:  I understand that there are times that you need to force a log switch for ba...

1.安装好Oracle数据库后: 执行 dbstart和dbshut会提示：[oracle@oracle11g ~]$ dbstartFailed to auto-start Oracle Net Listene using /ade/vikrkuma_new/oracle/bin/tnslsnrProcessing Database instance "test": ...

DSI是Data Server Internals的缩写,是Oracle公司内部用来培训Oracle售后工程师使用的教材. DSI3是Oracle 8系列的, DSI4是Oracle 9系列的. 这样的文档上通常都印着:Oracle Confidential:For internal Use Only. ...

控制文件（control file）中包含了其所属数据库的信息，实例（instance）在启动，及正常工作期间都需要存取这些信息。控制文件的内容只能由Oracle修改，数据库管理员或用户都不应编辑控制文件。控制文件（contro...

Oracle文档阅读指南 　　Oracle官方文档数量庞大，而且往往没有侧重点，让oracle新手看起来很费力。但是，仍有很多Oracle使用者认为任何oracle学习资料都比不上Oracle官方文档的权威和扼要，且兼具基础与全面。...

oracle 标准审计1 开启和关闭审计(Enabling and Disabling Standard Auditing)设置AUDIT_TRAIL参数，参数选型如下:  DB  启动审计功能，并且把审计结果存放在数据库的 SYS.AUD$ 表中...

Hacking Prevention with Failed Logon DelaysA hacker may attempt a brute force hack to break into your Oracle Database. This is where they try constant logons to the database using some form. of a word...

一  删除后再插入二  需要开启row movement 的相关操作    1 flashback table   2 alter table t shrink space    3 alter table t move ..---此操作不用开...

Wrong Results From Query Using Parallel Execution And Global Temporary Table(s) [ID 457040.1]To BottomModified:23-Nov-2010Type:PROBLEMStatus:PUBLISHEDPriority:3Comments (0)In this Document &n...

 [ID 332187.1]Applies to:Enterprise Manager Base Platform. - Version 10.1.0.2 to 10.2.0.1 [Release 10.1 to 10.2]SUSE \ UnitedLinux x86-64SymptomsChecked for relevance on 29-JUL-2010Grid Control 1...

手工锁表：lock table tbl_t1 in row share mode nowait;                --2lock table tbl_t1 in share update mode nowait;            ...