Download General Reference - ALTIBASE Customer Support

Transcript
2.3 Performance Properties
2.3.52.3 Attributes
Read-Write, Single Value
2.3.52.4 Range
[0, 232 – 1]
2.3.52.5 Description
This property indicates the maximum number of statements to return to the application in response
to a SELECT query executed on V$STATEMENT, V$SQLTEXT, or V$PLANTEXT. If this property is set to
0, all rows pertaining to all statements are returned.
This property can be changed using the ALTER SYSTEM statement while the system is running.
2.3.53 TABLE_INITRANS
2.3.53.1 Data Type
Unsigned Integer
2.3.53.2 Default Value
2
2.3.53.3 Attributes
Read-Only, Single Value
2.3.53.4 Range
[0, 120]
2.3.53.5 Description
This property indicates the initial number of TTS (Touched Transaction Slots) to be maintained in a
table page.
2.3.54 TABLE_LOCK_ENABLE
2.3.54.1 Data Type
Unsigned integer
129
ALTIBASE HDB Properties