The statement cache saves SQL text and plans previously generated for ad hoc SQL statements, enabling Adaptive Server to avoid recompiling incoming SQL that matches a previously cached statement. When enabled, the statement cache reserves a portion of the procedure cache. See the System Administration Guide: Volume 2 for a complete discussion of the statement cache, including its memory usage.
