SAP Note 507254 - ORA-4031 and ORA-3113 when processing large IN lists

Component : Oracle -

Solution : https://service.sap.com/sap/support/notes/507254 (SAP Service marketplace login required)

Key words :
database type oracleusage type aactive indicator aanalysis method, oracle cost-based optimizer, kocludatabase object type, oracle shared pool, svrmgrlconnect internalselect last_analyzed, pool tables generally, database server, p10customer indicator, prerequisites generally, last_analyzed column

Related Notes :

690241The Shared SQL Area in the Shared Pool and large SQL Stmnts
557447ORA-4031 After upgrade to Oracle 8.1.x.x
556764Upgrade hangs in phase ACT_<REL>
521264Hang situations
505246Several ora-600 [12333] and ora-4031 errors