> 文章列表 / Page 329

Event:10235 ~~~~~~~~~~~ Version/Use: 7.0 - 10.1.X Check memory manager internal structures. 7.0 - 10.1.X "Check memory manager internal structures" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~…

Text:   Stop SMON from cleaning up obj$ ——————————————————————————- NOTE: Events should NEVER be set by customers unless advised to do…

create table SPACE_TEMP ( TABLESPACE_NAME CHAR(30), CONTIGUOUS_BYTES NUMBER) / declare cursor query is select * from dba_free_space order by tablespace_name,…

Overview ——– This script is intended to provide an easy method to provide information necessary to troubleshoot Data Guard issues.…

imp数据导入时往往大多数的时间都消耗在了索引建立上，我们可以通过为导入会话设置一系列session级别的参数来加速索引的建立: begin dbms_system.set_int_param_in_session(&sid, &serial, 'db_file_multiblock_read_count', 64); dbms_system.set_int_param_in_session(&sid, &serial, 'sort_area_size', 209715200); dbms_system.set_int_param_in_session(&sid, &serial, '_sort_multiblock_read_count', 64); end; 注意在PGA自动管理模式下(即当workarea_size_policy=AUTO时)，自行指定的sort_area_size参数将无法生效。MOS上Bug 8939043叙述了目前dbms_system包的功能仅能修改session级别的布尔和数值类型参数，而无法修改字符串类型参数的问题;所以目前也还无法动态修改其他会话中的workarea_size_policy参数(虽然这个参数在session/system级别是可以动态修改的)。

New Background Processes In 11g *  ACMS (atomic controlfile to memory service) per-instance process is an agent that contributes to…

Two purposes of latches were:Serialize Execution,Serialize Access Match the characteristics with latches and enqueues. Several modes of access                   Enqueue FIFO…

We can examine X$BH table to obtain buffer header information,The BH stands for buffer header. Structures that maintain a list…

Reports index fragmentation statistics: ========== Script #1: ========== SET ECHO off REM NAME: TFSIFRAG.SQL REM USAGE:"@path/tfsifrag schema_name index_name" REM ------------------------------------------------------------------------…

Stored objects And Transient objects are stored in the library cache, neither Temporary objects nor Permanent objects. The library cache…