| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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.
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
 |
 |