LIFE@ONLYRING » Oracle RDBMS

Archive for the ‘Oracle RDBMS’ Category

Managing Indexes

September 1st, 2008 by onlyring | No Comments »

1.Classification of Indexes
Logical
- Single column or concatenated
The maximum number of columns in a composite key index is 32.However,the combined size of all the columns cannot exceed roughly one-third of the data block size.
More…

Popularity: 33% [?]
Only sys user and owner can compile the synonym?

August 31st, 2008 by onlyring | No Comments »

Oracle 中的同义词是schema 对象的一个别名。同义词分为公共(public)同义词和私有(private)同义词.公共同义词可以被所有数据库用户所访问，而私有同义词只能被owner和被授权用户访问。
More…

Popularity: 36% [?]

August 24th, 2008 by onlyring | No Comments »

Here is what I like to do to get autotrace working:

    * cd $oracle_home/rdbms/admin
    * log into sqlplus as system
    * run >: @utlxplan
    * run >: create public synonym plan_table for plan_table
    * run >: grant all on plan_table to public
    * exit sqlplus and cd $oracle_home/sqlplus/admin
    * log into sqlplus as SYS
    * run >: @plustrce
    * run >: grant plustrace to public

More…

Popularity: 31% [?]

DISK CLONE后数据库无法启动

August 24th, 2008 by onlyring | No Comments »

前段时间，用disk clone 方式从生产库clone一个数据库，结果数据库无法启动，遇到 ORA-03113: end-of-file on communication channel错误。
More…

Popularity: 26% [?]

10203又遇Bug4927533

July 30th, 2008 by onlyring | No Comments »

Oracle 10g 的bug 还真不少,这次又遇到了个未公布的bug.
数据库遇到07455,472错误,具体信息如下:

Errors in file /data/oracle/sprrprd1/admin/bdump/instance_name_j010_5066.trc: 
ORA-07445: exception encountered: core dump [kghadjust()+152] [SIGSEGV] [Address not mapped to 
object] [0x000000018] [] [] 
Mon Jul 28 14:30:37 2008 
Errors in file /data/oracle/sprrprd1/admin/bdump/instance_name_pmon_25485.trc: 
ORA-07445: exception encountered: core dump [kghadjust()+152] [SIGSEGV] [Address not mapped to 
object] [0x000000018] [] [] 
Mon Jul 28 14:30:59 2008 
CKPT: terminating instance due to error 472 
Mon Jul 28 14:30:59 2008 
Errors in file /data/oracle/sprrprd1/admin/bdump/instance_name_lgwr_25503.trc: 
ORA-00472: PMON process terminated with error 
Mon Jul 28 14:30:59 2008 
Errors in file /data/oracle/sprrprd1/admin/bdump/instanace_name_rvwr_25672.trc: 
ORA-00472: PMON process terminated with error 
Mon Jul 28 14:31:00 2008 
Errors in file /data/oracle/sprrprd1/admin/bdump/instance_name_psp0_25487.trc: 
ORA-00472: PMON process terminated with error 
Termination issued to instance processes. Waiting for the processes to exit 
Instance terminated by CKPT, pid = 25505

得到ORACLE SR回复如下:

It seems that you has got the problem described in Bug4927533, which 
is unfortunately not public and therefore not available on Metalink. 
For more information please read Note:421947.1, Ora-7445 [KGHADJUST] 
Pmon Process Terminated And Instance Crashed. 
Fixed in version: 
- Oracle 11.1 
Workaround: 
- Set "_BLOOM_FILTER_ENABLED" to FALSE. 
No fix exist for Oracle 10.2.0.3.0. 
I recommend that you use the workaround, this will solve your problem.

_BLOOM_FILTER_ENABLED 是一个UNDOCUMENT的参数.这个参数自10.2.0引入.
可以使用ALTER SYSTEM 命令动态修改,由于是隐含参数,所以要加引号.

ALTER SYSTEM SET "_BLOOM_FILTER_ENABLED"= false;

参数具体含义可以参考下面这篇文章
http://www.dbasupport.com/oracle/ora10g/hash.shtml

Popularity: 32% [?]