From Oracle FAQ
Jump to: navigation, search

TPO (Transaction Processing Option) was an Oracle 6 database option that was later replaced with the Oracle 7 Procedural Option.

[edit] Features

TPO introduced two features:

  • The row level lock manager
  • PL/SQL - a procedural language extension to SQL. With PL/SQL, multiple SQL statements, conditional control statements, error handling etc., are sent to the database as one procedure which reduces communication overhead and boosts performance.

[edit] Enable

To enable the TPO, one had to set the "row_locking" parameter to "always" in the database's INIT.ORA file.

$ oerr ora 1082
01082, 00000, "'row_locking = always' requires the transaction processing option"
// *Cause:  "row_locking = always" is specified in INIT.ORA file.
//          This feature is not supported by ORACLE without the
//          transaction processing option.
// *Action: Remove it from INIT.ORA file or set it to "default" or "intent".
Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #