Alternative solution for DBIF_RSQL_SQL_ERROR

[Former Member]

Dear All

Currently we are getting around 50 dumps in our R/3 Production (SAP R/3 4.7 E, Backend Oracle 9.2.0.5.0 ) all are giving DBIF_RSQL_SQL_ERROR

the jobs which has sheduled in background or forground jobs with around 6 months aur above selction or some

critical jobs like BW delta jobs also giving this error

As per my primary analysis i came to know its related to some memory related issue or some memory paremeters has to be changed

BUt as per our Basis Guys here changing the memory parameters are very very risky so is there any alternative solution for this ?

and how risky it is if we change?

Regards

Amiya

[Former Member]

ok

[Former Member]

Hi Amiya,

It is the cause of database deadlocks(ORA-0060), so please follow the note-84348, it will resolves your issue.

Let me know if you need anything else.

Thanks

Kishore

[Former Member]

Hi Kishore

thanks

can u please tell me how risky it is if we implement some note to avoid this and what impact it can give.

as our basis consultants are telling its a very risky job and after soing this the systme may not UP again.

Regards

Amiya

[Former Member]

Dear Amiya,

It wont be risky, first inform your Basis guys to look into that note, for applying this note you dont need to restart the system.

Moreover, if you face any issue, we are here to resolve that issue )

You please carryon with applying that note.

ALL THE BEST.

Thanks

Kishore