ORA-01037 Errror Message, SImple Explain Path

From: <ishay_friedman_at_pch.gc.ca>
Date: 1998/10/26
Message-ID: <712bgv$nd5$1_at_nnrp1.dejanews.com>#1/1

Hello,

We are running SAP v3.0F on Oracle v7.3.3.6 and DEC Unix (v4.0A). An ABAP/4 code (Native SAP language) SQL statement generates an 'ORA-1037' system message in our production system (Not in out QA and development systems).

According to Oracle, 'The ORA-01037 error is issued when the server tries to create too many frames while building a shared cursor. The limit is hard-wired into the code at 32K frames. This should be large enough to execute just about any query'.

Our query, though, is simple, although there is a lot of data contained in the 'BKPF' table from which the query tries to extract data. (Does the amount of data affect the ORA-01037 error?)

The 'OPEN_CURSORS' value in the 'INIT.ORA' file is 800 in production and development.

It doesn't seem that there is an easy way to simplify the SQL query; It is fairly straightforward.

SAP shows Oracle's 'Explain SQL' as follows:

SQL Statement

---

• SELECT "MANDT" , "BUKRS" , "BELNR" , "GJAHR" , "BLART" , "BLDAT" ,
  "BUDAT" , "MONAT" , "CPUDT" , "CPUTM" , "AEDAT" , "UPDDT" , "WWERT" ,
  "USNAM" , "TCODE" , "BVORG" , "XBLNR" , "DBBLG" , "STBLG" , "STJAH" ,
  "BKTXT" , "WAERS" , "KURSF" , "KZWRS" , "KZKRS" , "BSTAT" , "XNETB" ,
  "FRATH" , "XRUEB" , "GLVOR" , "GRPID" , "DOKID" , "ARCID" , "IBLAR" ,
  "AWTYP" , "AWKEY" , "FIKRS" , "HWAER" , "HWAE2" , "HWAE3" , "KURS2" ,
  "KURS3" , "BASW2" , "BASW3" , "UMRD2" , "UMRD3" , "XSTOV" , "STODT" ,
  "XMWST" , "CURT2" , "CURT3" , "KUTY2" , "KUTY3" , "XSNET" , "AUSBK" ,
  "XUSVR" , "DUEFL" , "AWSYS" , "TXKRS" , "LOTKZ" , "XWVOF" , "PSOTY" ,
  "PSOAK" , "PSOKS" , "PSOSG" , "PPNAM" , "PSOBT" , "PSOZL" , "ZZBATCHNO" ,
  "ZSOURCE" , "ZRUNDATE" , "ZSTATUS" FROM "BKPF" WHERE "MANDT" = :A0 AND
  "BUKRS" = :A1 AND "BELNR" = :A2 AND "GJAHR" = :A3
  

Execution Plan

---

• SELECT STATEMENT ( Estimated Costs = 0 ) | |-- TABLE ACCESS BY ROWID BKPF | |-----INDEX UNIQUE SCAN BKPF______0

Any suggestions or ideas would be greatly appreciated.

Thanks,

Ishay Friedman
SAP Basis Administration
MCI Systemhouse Inc.
'ifriedman_at_hotmail.com'

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Oct 26 1998 - 00:00:00 CET