3130592 - Many duplicate query trees for two SQL functions in procedure cache - SAP ASE

• Procedure cache is getting full
• There are too many duplicate query trees in procedure cache.

Procedure Cache, Top 20:

Database Id: 4
Object Id: 507729030
Version: 0
Uid: 4
Type: view
Number of trees: 57812 <-- too many duplicate trees
Size of trees: 2481.242416 Mb, 2601771248.000000 bytes, 1329676 pages
Bytes lost for alignment 134239464 (Percentage of total: 5.159541)
Number of plans: 0
Size of plans: 0.000000 Mb, 0.000000 bytes, 0 pages
Bytes lost for alignment 0 (Percentage of total: 0.000000)
----
Database Id: 4
Object Id: 523729087
Version: 0
Uid: 4
Type: view
Number of trees: 28906 <--- many duplicate trees
Size of trees: 386.984280 Mb, 405782428.000000 bytes, 231248 pages
Bytes lost for alignment 25841964 (Percentage of total: 6.368429)
Number of plans: 0
Size of plans: 0.000000 Mb, 0.000000 bytes, 0 pages
Bytes lost for alignment 0 (Percentage of total: 0.000000)
----
Database Id: 2
Object Id: 1196621241
Version: 1
Uid: 4
Type: stored procedure
Number of trees: 0
Size of trees: 0.000000 Mb, 0.000000 bytes, 0 pages
Bytes lost for alignment 0 (Percentage of total: 0.000000)
Number of plans: 1
Size of plans: 20.085747 Mb, 21061432.000000 bytes, 10333 pages
Bytes lost for alignment 25111 (Percentage of total: 0.119227)

• SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
• SAP NetWeaver (NW) - All versions

CR#825840, CR825840, CR 825840, 825840 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem