> 文章列表 / Page 327

Error: ORA 10051 Text: trace OPI calls ------------------------------------------------------------------------------- Explanation: This is NOT an error but is a special EVENT code. It should *NOT* be...

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 -------------------------------------...