ITPub博客

OracleDatabase - Enterprise Edition - Version 7.3.4.0 and laterInformation in this document applies to anyplatform.PURPOSEThis article explainshow to perform. a BASIC Health Check on th...

Oracle Server - Enterprise Edition - Version 9.2.0.1 to 11.2.0.2 [Release 9.2 to 11.2]Information in this document applies to any platform.SYMPTOMSRecovery session fails:SQL> recover database;ORA...

Oracle Support Lifecycle AdvisorsWelcome | Agile | E-Business Suite | Engineered Systems | Enterprise Manager | Enterprise Performance Management&nbsp...

NLS_LANG Parameter Fundamentals A locale is a setof information addressing linguistic and cultural requirements that correspondsto a given language and country. Traditionally, the data ...

默认情况下exp/expdp 导出的时候 是针对当前表的一致性读在导入的时候经常遇到: 1ORA-02298: cannot validate  - parent keys not found是因为主表和子表不一致引起的2 ORA-00001 uniqu...

Oracle Server - Enterprise Edition - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]Information in this document applies to any platform.***Checked for relevance on 26-Feb-2009***GOALThis goal wal...

latch: cache buffers chainslatch: redo writinglatch: redo copylatch: Undo Hint Latchlatch: In memory undo latchlatch: MQL Tracking Latchlatch: row cache objectslatch: shared poollatch: library cachela...

APPLIES TO:Oracle Server - Personal Edition - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]Oracle Server - Standard Edition - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]Oracle Server - E...

介绍Oracle数据库11g第2版引入了一个新的数据库功能：Database SmartFlash Cache。此功能可在Solaris和Oracle企业级Linux和允许客户，以增加有效的Oracle数据库缓冲区高速缓存的大小，而不到系统中添加...

Oracle补丁术语介绍By JaneZhang(张建英) on 三月 13, 2013在使用Oracle的技术支持服务的时候，经常会遇到补丁相关的术语。现在对这些术语做些解释说明：Interim patch/One-off patch：是我们常说的小补丁，为...

Linux/Uninx下Oracle的oerr工具的使用Linux/Uninx下Oracle的oerr工具的使用oerr是oracle在unix上的查找ora错误的小工具，极其方便。命令格式为：oerr ora 错误编号例如要查看ora-01632的描述：[oracle@shtdtest orac...

Introduction to VPDVirtual private database (VPD) enables you to enforce security, to a fine level of granularity, directly on tables, views, or synonyms. Because security policies are attached direct...

今天有客户的数据库意外被删除了整个目录中的数据文件，操作系统级别的删除，然而幸运的是这个数据库没有崩溃，仍然处于open状态的时候，客户就发现了问题，求助到我们，最终完整地恢复了所有数据文件。在Linux下大...

How to Recover From Enterprise Manager Grid Control 10g Base Releases (10.2.0.x.0) Installation Errors after 31-Dec-2010 [ID 1228103.1]To BottomModified:30-May-2013Type:BULLETINStatus:PUBLISHEDPriorit...

Issue 1:When i start installing the oem grid control after completing all the pre requesites, we got the following error. The cursor hangs there instead of populating OUI window.[oracle@dhcppc30 ~]$ c...

【转载地址】http://yangtingkun.itpub.net/post/468/279105Oracle的GLOBAL_NAME由两个部分组成：DB_NAME和DB_DOMAIN。如果在建立数据库的时候不指定DB_DOMAIN的值，则GLOBAL_NAME和DB_NAME的值一样。Oracle有一个从...

Structure of the Online Redo LogOnline redo log files contain redo records. A redo record is made up of a group of change vectors, each of which describes a change to a data block. For ...

 Redo log 是用于恢复和一个高级特性的重要数据，一个redo条目包含了相应操作导致的数据库变化的所有信息，所有redo条目最终都要被写入redo文件中去。Redo log buffer是为了避免Redo文件IO导致性能瓶颈而...

In traditional undo update, once record be updated, an undo block will be allocated in the buffer cache, 1 new entry will be inserted into the undo block immediately. If several records be updated in ...

转载请注明出处及原文链接; http://blog.csdn.net/xiangsir/article/details/8573653 【有补充】row chain：When a row is too large to fit into any block, row chaining occurs. In this case, the ...