> 文章列表 / Page 322

From Vinod Haval's <Inside Overview of ASM Metadata> These Views helps in understanding the following metrics Physical Mapping Provides Undocumented Information 18 X$ Tables (May be more) TABLE ...

View: X$KCCRS [K]ernel [C]ache [C]ontrolfile management controlfile [R]ecord [S]ection directory Column Type Description -------- ---- ----------- ADDR RAW(4) address of this row/entry in the SGA INDX...

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