All,
I've done more testing of the MONITORING option and it does not seem to be a
problem. As Steve Adams correctly points out, it's more to do with array
allocation, this I've got a lot of in the code. Will have to do more work on
it!
Leng.
Leng M Kaing
Email: leng.kaing_at_hancorp.com.au
Tel: 9843-8440
Fax: 9843-8590
-----------------------------------------------------------------------
> -----Original Message-----
> From: Leng Kaing
> Sent: Friday, 1 September 2000 17:35
> To: '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
Received on Tue Sep 05 2000 - 22:28:53 CDT
