了解Maclean Liu|向Maclean Liu提问 Oracle ALLSTARS 全明星(群内有多位Oracle高级售后support，N位OCM和ACE) QQ群 # QQ群号:23549328 # 已经升级到 2000人群，空位多多。欢迎有一定基础的Oracle骨友加入，现在入群需要经过Maclean的技术面试，欢迎面试，请加QQ号:47079569 为好友参加面试 2群基础群 适合刚入门的同学，会共享最佳入门实践和资料 QQ群 # QQ群号:171092051 # 已经升级到 500人的超级群，空位多多，无需面试

2010年12月26日

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 阅读(225) 评论(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 阅读(191) 评论(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 阅读(442) 评论(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 阅读(447) 评论(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 阅读(370) 评论(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 阅读(227) 评论(0) 推荐(0) 编辑

导航