Skip to Content
Former Member
Nov 19, 2010 at 04:16 AM

Difference between library size and actual size of SQL Package


Hi All,

I noticed that my ASP size is growing but the database size remain constant. I suspect it is the SQL Packages that are contributing to the growth in ASP size and discovered that there is a difference between the library size and actual size of SQL Packages. E.g, R3<SID>X0000.

[] (Screen shot showing SQL package library size)

[] (Screen shot showing SQL package size capture from DBACOCKPIT)

Why is there a difference between the two sizes? Is it possible to reduce the library size of the SQL Packages so as to free up the ASP space?

What other factors could contribute to ASP growth if the database size remain constant?

Thanks in advance.