Oracle 11g ora-7445 new bug 11076457
I'm having an error ORA-07445 in Oracle with zabbix which was opened in the Bug 11076457 support.oracle.com (Metalink). But Oracle is making me some questions that I do not know answer, because some need the help of developer Zabbix can anyone help me?
Following questions:
=== ODM Action Plan ===
Thanks Vilela.
To sum up where we stand currently:
1.) problem is most likely to the huge number of values in the inlist. For such huge inlists it's usually much better if the application
uses a temporary table which is used for storage/retrieval of these values. But that's something which must be addressed by the application developers.
2.) Having said that I could kind of reproduce the problem with SQL*Plus by using large inlists in the delete, I've opened bug 11076457 for that.
There the problem is a crash with a very large delete string with an inlist.
3.) but for problem we have here we need C. So I wrote a little program for to reproduce the issue.
But I noticed I need to know how the delete statement is constructed, i.e. is it a char * pointer which is used here or is it a char[] vector or?
How's memory allocated for this large delete string?
An appropriate code snippet would be appreciated. So pls plet me know the details here.
Regards
Frank
Following questions:
=== ODM Action Plan ===
Thanks Vilela.
To sum up where we stand currently:
1.) problem is most likely to the huge number of values in the inlist. For such huge inlists it's usually much better if the application
uses a temporary table which is used for storage/retrieval of these values. But that's something which must be addressed by the application developers.
2.) Having said that I could kind of reproduce the problem with SQL*Plus by using large inlists in the delete, I've opened bug 11076457 for that.
There the problem is a crash with a very large delete string with an inlist.
3.) but for problem we have here we need C. So I wrote a little program for to reproduce the issue.
But I noticed I need to know how the delete statement is constructed, i.e. is it a char * pointer which is used here or is it a char[] vector or?
How's memory allocated for this large delete string?
An appropriate code snippet would be appreciated. So pls plet me know the details here.
Regards
Frank