text prefetch size limits the number of pages of text, unitext, and image data that can be prefetched into an existing buffer pool.
|
Summary Information |
|
|---|---|
|
Default value |
16 |
|
Valid values |
0–65535 |
|
Status |
Dynamic |
|
Display level |
Comprehensive |
|
Required role |
System administrator |
|
Configuration Group |
Network Communications |
SAP ASE prefetches only text, unitext, and image data that was created with SAP ASE 12.x or was upgraded using dbcc rebuild_text.