> 文章列表 / Page 322

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 so by Oracle Su...

create table SPACE_TEMP ( TABLESPACE_NAME CHAR(30), CONTIGUOUS_BYTES NUMBER) / declare cursor query is select * from dba_free_space order by tablespace_name, block_id; this_row query%rowtype; previous...

Overview -------- This script is intended to provide an easy method to provide information necessary to troubleshoot Data Guard issues. Script Notes ------------- This script is intended to be run via...

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(&s...

New Background Processes In 11g * ACMS (atomic controlfile to memory service) per-instance process is an agent that contributes to ensuring a distributed SGA memory update is either globally committed...

Two purposes of latches were:Serialize Execution,Serialize Access Match the characteristics with latches and enqueues. Several modes of access Enqueue FIFO queue acquisition Enqueue Mostly exclusive a...

We can examine X$BH table to obtain buffer header information,The BH stands for buffer header. Structures that maintain a list of data buffer headers are called:Hash buckets. Hash buckets are grouped ...

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 is structured as a Hash table .But Library cache objects are co...