Installing Oracle10g in the Windows:
Environment Variables:
$ORACLE_BASE
$ORACLE_HOME
$ORACLE_SID
$ORACLE_HOME/install/portlist.ini -- All the ports for oracle including db control home page and isqlplus
$ORACLE_HOME/Apache/Apache/port.ini -- for oracle9i
体系结构:
Database: ControlFiles DataFiles OnlineRedoLogFiles(日志挖掘工具logminer) PasswordFile ParameterFile ArchivedRedoLog Files
Instance: SGA BackgroundProcess UGA PGA
SGA: SharedPool(LibraryCache&RowCache) BufferCache LargePool JavaPool StreamPool
BackgroundProcess: PMON SMON DBWR LGWR CKPT(必需) ARCn (可选)
PGA: SortArea CursorState SessionInfo StackSpace
参数:
SGA_MAX_SIZE
SGA_TARGET
SHARED_POOL_SIZE
LARGE_POOL_SIZE
JAVA_POOL_SIZE
STREAMS_POOL_SIZE
DB_CACHE_SIZE(DB_BLOCK_SIZE*DB_BLOCK_BUFFER oracle9i)
LOG_BUFFER
动态视图:
X$KSMSP
X$KSMPP
X$KSMUP
select * from db_cache_advice; -- db_cache_advice ON/READY/OFF
-- The End --
阅读(772) | 评论(0) | 转发(0) |