-
编辑 删除
数据缓存管理
Buffer manage=forground process+DBWR（+LCK）Internal structure：1db cache management[@more@]Buffer manage=forground process+DBWR（+LCK）Internal structure：cache buffer chains 2． the LRUW list (dirty list) 3． LRU list2 cache buffer chains 1 cache buffer chains latch ->n hash table (buckets)->1 hash list->n buffer header->1 buffer block LruMru->lruBlock Status:free/pinned(pinned clean/pinned dirty)/dirtyLruw1. write dirty buffers/find clean buffers foreground process begin search
-
编辑 删除
lab:手工创建物理standby数据库
created by lucky.laudate: 2005-05-30[@more@]============================================================================== /*准备工作*/ ============================================================================== SQL> desc v$database 名称 是否为空? 类型 ----------------------------------------- -------- -------------------- DBID NUMBER NAME VARCHAR2(9) CREATED DATE RESETLOGS_CHANGE# NUMBER RESETLOGS_TIME DATE PRIOR_RESETLOGS_CHANGE# NUMBER PRIOR_RESETLOGS_TIME DATE LOG_MODE VARCHAR2(12) CHE
-
编辑 删除
lab:工创建逻辑standby数据库
Created by lucky.lauDate:2005-5-31创建逻辑standby数据库======================================================================[@more@]/*准备创建逻辑standby数据库*/ Microsoft Windows 2000 [Version 5.00.2195] (C) 版权所有 1985-2000 Microsoft Corp. C:Documents and SettingsAdministrator.LUCKY>set oracle_sid=lucky C:Documents and SettingsAdministrator.LUCKY>sqlplus /nolog SQL*Plus: Release 9.2.0.6.0 - Production on 星期二 5月 31 09:45:29 2005 Copyright (c)
