Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Runing logmnr always 3113 and core dump!
hi, list friends:
I am trying to analyze the redo log in oracle 8172 64bit on solaris.Whatever i tried , it always core dump after fetching about 60k records from the v$logmnr_contents. I tried to analyze the logfile on 8172(64bit), 901 64bit on solairs, but in vain. Here is the example output: 04-SEP-02 update "EACHPAY"."UL_USERLOGIN04-SEP-02 update "ACCOUNT"."USERSTATISIN 04-SEP-02 update "BIDDER"."SHOPCATALOG"
and in the background trace file, there is alert like: Errors in file /export/home/oracle9i/admin/test9i/udump/test9i_ora_4534.trc: ORA-07445: exception encountered: core dump [FFFFFFFF7F790794] [SIGSEGV] [Address not mapped to object] [0x0000000D8] [] []
Count(*)from v$logmnr_contents also give out such error. I tried to enlarge the shared_pool, shared_pool_reserved toSQL> show parameter shared_pool
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ shared_pool_reserved_size big integer 20000000 shared_pool_size big integer 234881024 Still get that error. Is there someone also ever hit similiar error ?
Regards
zhu chao
Eachnet DBA
86-21-32174588-667
chao_ping_at_vip.163.com
กกกกกก
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: zhu chao
INET: chaospku_at_163.net
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Sep 05 2002 - 00:38:18 CDT
![]() |
![]() |