RE: Monitoring "corrupts" data??

I've had the same problem ( solaris 2.6, don't remember if it was on Oracle 7 or 8 ).
I did not investigate further, so I don't know if monitoring was on, but I would be interested if you find something.

Thanks.

> ----------
> From: Leng Kaing[SMTP:leng.kaing_at_hancorp.com.au]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Friday, September 01, 2000 11:16
> To: Multiple recipients of list ORACLE-L
> Subject: Monitoring "corrupts" data??
>
> Guys,
>
> Env: 8.1.6 on Solaris 2.7
>
> Have you noticed anything strange with turning on monitoring for a table?
>
> We've got a problem whereby when a user-defined package is executed the
> first time, it all works well. But subsequent executions caues ORA-7445.
> ie.
> reconnecting and re-executing is fine. Just multiple executions from the
> one
> session fails. The SQL*Plus session gets ORA-3114 and ORA-3113. The
> alert.log gets ORA-7445.
>
> Exception signal: 10 (SIGBUS), code: 1 (Invalid address alignment), addr:
> 0x49442c8b, PC: kolcsiz()+24
> ksedmp: internal or fatal error
> ORA-07445: exception encountered: core dump [kolcsiz()+24] [SIGBUS]
> [Invalid address alignment] [1229204619] [] []
> Current SQL statement for this session:
> BEGIN pkg_jim.call_accumulation; END;
>
>
> I've done the validate structure cascade for ALL tables in the
> schema and there are no errors. I've also dropped and recreated the
> package. But error persists.
>
> But when the table was dropped and recreated without monitoring, multiple
> executions from the one session are fine. The only thing I can see that's
> different is that I've turned off monitoring. Will have to test further,
> to
> prove the theory. But would like to know if anybody has already
> encountered
> this problem.
>
> Thanks,
>
>
> Leng.
>
> -----------------------------------------------------------------------
> Leng M Kaing
> Email: leng.kaing_at_hancorp.com.au
> Tel: 9843-8440
> Fax: 9843-8590
> -----------------------------------------------------------------------
>
>
>
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
>
> This footnote also confirms that this email message has been swept by
> MIMEsweeper for the presence of computer viruses.
>
> www.mimesweeper.com
> **********************************************************************
> --
> Author: Leng Kaing
> INET: leng.kaing_at_hancorp.com.au
>
> 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
Received on Fri Sep 01 2000 - 06:33:41 CDT