ITPub博客

我今天也遇到了个问题：　　我有一个大的分区表，有一个字段调整，　步骤：　　１.创建普通表p2010--2014(表结构与分区表，相同)　　２.用exchange partition 交换分区表与普通表：　　SQL> alter table barcode_mas...

           作者 ：OoNiceDream【转载时请务必以超链接形式标明文章原始出处和作者信息】          &n...

LOGIC IO(逻辑读次数）= db block gets + consistent gets consistent get : 在一致读模式下所读的快数，包括从回滚段读的快数。 db block gets ： 在当前读模式下所读的快数，比较少和特殊，例如...

【传输表空间】使用 EXPDP/IMPDP工具的传输表空间完成数据迁移http://space.itpub.net/519536/viewspace-668938

[i=s] 本帖最后由 zhouxianwang 于 2012-6-29 14:49 编辑 SELECT EMP_NO,       EMP_NM,       DEPT_CD,       DEPT_NM,       D...

Hugepages是从Linux kernal 2.6后被引入的，其目的是使用更大的memory page size以适应越来越大的系统内存。在我上大学那会，买一条64M 133Mhz的内存（对，你没看错，64M）价格为500多人民币，而现在4G 1600Mhz的内...

 ID 361468.1 HugePages on Oracle Linux 64-bit In this Document  Purpose  Scope  HugePages on Oracle Linux 64-bit     Introduction &nbs...

本文简单记录一下最近一次数据恢复的过程。事情的起因是，一个应用升级后，某一个操作导致一个表的几个列全部被更新为同一值（忍不住又要唠叨测试的重要性）。这样的错误居然出现在应用代码中，显然是重大的BUG。那...

先来看看官方文档中对这个参数的解释CURSOR_SHARINGProperty Description Parameter type String Syntax CURSOR_SHARING = { SIMILAR | EXACT | FORCE } Default value EXACT Modifiable ALTER SESSION, ALTER SYST...

SQL>alter system set db_keep_cache_size=5g m scope=spfile; SQL>alter table mma_blog_diary storage(buffer_pool keep);SQL> select table_name from dba_tables where buffer_pool='KEEP';TABLE_NA...

Streams enables messaging with queues of type ANYDATA. These queues can stage user messages whose payloads are of ANYDATA type. An ANYDATA payload can be a wrapper for payloads of different datatypes....

alter system set events相关知识： 格式：alter system|session set events ‘[eventnumber|immediate] trace name eventname [forever] [, level levelnumber] : …….’通过:符号，可以连续设置多个事件，...

一.Memory Dumps1).Global AreaALTER SESSION SET EVENTS 'immediate trace name global_area level n';1 包含PGA2 包含SGA4 包含UGA8 包含indrect memory2).Library CacheALTER SESSION SET EVENTS 'immed...

  Figure 2-2 Real-Time Downstream CaptureDescription of "Figure 2-2 Real-Time Downstream Capture" Figure 2-3 Archived-Log Downstream CaptureDescription of "Figure 2-3 Archived-Log...

The Source Database Performs All Change Capture ActionsIf you configure local capture, then the following actions are performed at the source database:The DBMS_CAPTURE_ADM.BUILD procedure is run ...

                    作者 ：OoNiceDream【转载时请务必以超链接形式标明文章原始出处和作者信息】 &n...

ORA-14060: data type or length of a table partitioning column may not be changed  

The Oracle Clusterware requires the following two critical files:Voting Disk—Manages cluster membership by way of a health check and arbitrates cluster ownership among the instances in case of net...

Cluster Synchronization Services (CSS)—Manages the cluster configuration by controlling which nodes are members of the cluster and by notifying members when a node joins or leaves the cluster. If yo...

AFFIRM and NOAFFIRMControls whether redo transport services use synchronous or asynchronous I/O to write redo data to diskAFFIRM—specifies that all disk I/O to archived redo log files and standby...