Specifies the maximum length of time that a two-phase commit transaction can be inactive before it is automatically aborted by the Oracle system. The unit for this time limit is in seconds. The value of 0 indicates no limit. The default is 60 seconds.
The syntax for session_time_limit is:
session_time_limit=value
This parameter is dynamic.