TPO
From Oracle FAQ
TPO (Transaction Processing Option) was an Oracle 6 database option that was later replaced with the Oracle 7 Procedural Option.
Features[edit]
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.
Enable[edit]
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 | # |
