SAP Knowledge Base Article - Preview

2246782 - Unable to kill a spid that execute a query with a large IN clause or a lot of OR predicates - SAP ASE

Symptom

  • Running a query with a very large IN clause or lots of search arguments OR-ed together
  • The optimizer may take a long time to optimize the query while it examines the histograms
  • During this time the process in ASE may be unkillable and could use a large amount of procedure cache
  • dbcc stacktrace may show the following functions:
    upyield
    memalloc
    GtPRS::GtInitGcPerGt
    HistStatObject::HistStatObject
    StGcInfo::StGcInfo
    StTcInfo::StTcAllocateCellNormalized
    TcElement::TcAllocateColCost
    HasHistAlgebraState::HasFindColCost
    StTcInfo::StTcAndSargIntoHist
    HasHistAlgebraState::HasCellNormalizedInit
    OptBlock::OptPhase2bInit

Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

predicate, huge, "OR predicate", kill, OptPhase2bInit, CnhCellNormalizedHist, 791364, CR791364, , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.