发布时间: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.........【阅读全文】