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.


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.


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 #