2010 年 12月 26 日随笔档案 - Oracle和MySQL

Latches and Tuning:Redo Log Buffer and Latches

摘要： 1. The size of the redo log buffer is determined by the LOG_BUFFER parameter.a. Determine the size of the LOG_BUFFER by executing the following query:> select * from v$sga;b. View the LOG_BUFFER set... 阅读全文

posted @ 2010-12-26 23:12 Oracle和MySQL 阅读(237) 评论(0) 推荐(0)

Latches and Tuning:Buffer Cache

摘要： 1. The buffer pool is structured into pools; RECYCLE, KEEP, and DEFAULT. Unless otherwise specified at create time or altered, an object will reside in the DEFAULT pool.a. Suppose you have a table t... 阅读全文

posted @ 2010-12-26 22:49 Oracle和MySQL 阅读(207) 评论(0) 推荐(0)

How to set LOGSOURCE PATHMAP on GoldenGate

摘要： Question:the source machine os is solaris ,the mid machine os is linux ,the target machine os is solaris,i want extract archive log file and pump trail fileto target on mid machine , i check GoldenGat... 阅读全文

posted @ 2010-12-26 14:25 Oracle和MySQL 阅读(449) 评论(0) 推荐(0)

Veritas ODM Async and Oracle

摘要：简单来说对于Veritas Vxfs和ODM FILE而言filesystemio_options不生效(This parameter is not applicable to VxFS files, ODM files, or Quick I/O files.)，必要检查ODM SO是否正确LINK。ls -l$ORACLE_HOME/lib/libodm*对于JFS2而言，一般建议设置... 阅读全文

posted @ 2010-12-26 11:40 Oracle和MySQL 阅读(460) 评论(0) 推荐(0)

How GoldenGate process consumes memory

摘要： Question:We are using Golden Gate to replicate the data from Oracle 9.2.0.8 on Solaris8 SPARC 64 bit (GoldenGate Version 10.4.0.31 Build 001) to Oracle RAC 11.2.0.1 on Solaris10 SPARC 64bit (GoldenGat... 阅读全文

posted @ 2010-12-26 09:03 Oracle和MySQL 阅读(381) 评论(0) 推荐(0)

Latches and Tuning:The Library Cache

摘要： 1. The shared pool is determined by the value of SHARED_POOL_SIZE as indicated in the init.ora file. The librarycache is part of the shared pool.a. Determine the size of the shared poool by executin... 阅读全文

posted @ 2010-12-26 06:54 Oracle和MySQL 阅读(240) 评论(0) 推荐(0)

ORACLE数据库服务热线：13764045638 诗檀软件