[firebase-br] RES: select * from MON$TRANSACTIONS

[Alexandre]

MON$TRANSACTIONS (started transactions)


- MON$TRANSACTION_ID (transaction ID)
- MON$ATTACHMENT_ID (attachment ID)
- MON$STATE (transaction state)
0: idle (state after prepare, until execution begins)
1: active (state during execution and fetch. Idle state
returns after cursor is closed)
- MON$TIMESTAMP (transaction start date/time)
- MON$TOP_TRANSACTION (top transaction)
- MON$OLDEST_TRANSACTION (local OIT number)
- MON$OLDEST_ACTIVE (local OAT number)
- MON$ISOLATION_MODE (isolation mode)
0: consistency
1: concurrency
2: read committed record version
3: read committed no record version
- MON$LOCK_TIMEOUT (lock timeout)
-1: infinite wait
0: no wait
N: timeout N
- MON$READ_ONLY (read-only flag)
- MON$AUTO_COMMIT (auto-commit flag)
- MON$AUTO_UNDO (auto-undo flag)
- MON$STAT_ID (statistics ID)
• MON$TOP_TRANSACTION is the upper limit used by the sweeper transaction
when advancing the
global OIT. All transactions above this threshold are considered active. It
is normally equivalent to the
MON$TRANSACTION_ID but COMMIT RETAINING or ROLLBACK RETAINING will cause MON
$TOP_TRANSACTION to remain unchanged (“stuck”) when the transaction ID is
incremented.
•
Administrative Features
114
MON$AUTO_UNDO indicates the auto-undo status set for the transaction, i.e.,
whether a transaction-
level savepoint was created. The existence of the transaction-level
savepoint allows changes to be
undone if ROLLBACK is called and the transaction is then just committed. If
this savepoint does not
exist, or it does exist but the number of changes is very large, then an
actual ROLLBACK is executed
and the the transaction is marked in the TIP as “dead”.

Fonte :  /firebird_2_1/doc/Firebird_v2.1.4.ReleaseNotes.pdf





-----Mensagem original-----
De: lista [mailto:lista-bounces em firebase.com.br] Em nome de Juliana Maria
Enviada em: terça-feira, 4 de dezembro de 2012 14:45
Para: 'FireBase'
Assunto: [firebase-br] select * from MON$TRANSACTIONS

Boa tarde,
Faço um "select * from MON$TRANSACTIONS" e gostaria de saber se tem como
alterar os valores dos campos retornados e o que cada um deles significa.
Ogriada.


______________________________________________
FireBase-BR (www.firebase.com.br) - Hospedado em www.locador.com.br
Para saber como gerenciar/excluir seu cadastro na lista, use:
http://www.firebase.com.br/fb/artigo.php?id=1107
Para consultar mensagens antigas: http://firebase.com.br/pesquisa