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_USERLOGIN
04-SEP-02 update "ACCOUNT"."USERSTATISIN
04-SEP-02 update "BIDDER"."SHOPCATALOG"
ERROR:
ORA-03113: end-of-file on communication channel
66600 rows selected.
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 to
SQL> 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
[EMAIL PROTECTED]
������
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: zhu chao
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
