发布时间：2013-07-10 12:52:42

点击(此处)折叠或打开I tend to cache some objects in buffer_pool cache to reduce buffer_gets and increase oracle performance.Keep cache is a part of oracle instance's buffer_pool.Configure keep cache is done with following: &n.........【阅读全文】

发布时间：2013-07-04 21:41:53

Today, I have received a call that my friend wanted me to build a network installation server with sparc of SUN Solaris 10.Assume that there is a Sun Solaris10 Server with a good dvd-rom. 1.login the system as root or there is a role which equivalent root2. Insert the DV.........【阅读全文】

发布时间：2013-07-04 10:51:15

在Solaris 10 X86上安装Oracle10g，在86%左右遇到一个错误，具体描述是：调用makefile'/u01/app/oracle/product/10.2.0/db_1/network/lib/ins__net_client.mk'的目标'client_sharedlib'时出错。请参阅/u01/app/oracle/oraInventory/logs/installActions2012-06-05_09-30-10PM.log在Metalink上查阅是一.........【阅读全文】

发布时间：2013-07-01 17:24:18

点击(此处)折叠或打开1、系统权限UNLIMITED TABLESPACE 不能被授予role，可以被授予用户。 2、UNLIMITED TABLESPACE 没有被包括在resource role中，但是UNLIMITED TABLESPACE 随着resource的授出而被授予用户的。3、UNLIMITED TABLESPACE 不能伴随着resource被授.........【阅读全文】

发布时间：2013-06-25 17:17:19

look up the table which is locked.SELECT P.SPID,       A.SERIAL#,       C.OBJECT_NAME,       B.SESSION_ID,       B.ORACLE_USERNAME,&n.........【阅读全文】