⌘KCtrl+K 快速搜索

> 文章列表 / Page 327

2008-04-19

EVENT 10051:"trace OPI calls"

Error: ORA 10051 Text: trace OPI calls ------------------------------------------------------------------------------- Explanation: This is NOT an error but is a special EVENT code. It should *NOT* be...
#POST 2 MIN READ
2008-04-19

EVENT 10235:"check memory manager internal structures"

Event:10235 ~~~~~~~~~~~ Version/Use: 7.0 - 10.1.X Check memory manager internal structures. 7.0 - 10.1.X "Check memory manager internal structures" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~...
#POST 7 MIN READ
2008-04-19

EVENT:10052 "Stop SMON from cleaning up obj$"

Text: Stop SMON from cleaning up obj$ ------------------------------------------------------------------------------- NOTE: Events should NEVER be set by customers unless advised to do so by Oracle Su...
#POST 3 MIN READ
2008-03-25

Script to Detect Tablespace Fragmentation

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...
#POST 9 MIN READ
2008-03-04

Script to Collect Data Guard Diagnostic Information

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...
#POST 39 MIN READ
2008-03-01

利用dbms_system包加速imp导入数据时的索引建立

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...
#POST 2 MIN READ
2008-02-25

Learning 11g New Background Processes

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...
#POST 25 MIN READ
2007-06-30

Know more about Oracle Latches

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...
#POST 22 MIN READ
2007-06-30

Know more about Buffer Cache and Latch

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 ...
#POST 7 MIN READ
2007-06-30

Script:To Report Information on Indexes

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