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

[Juliana Maria]

Obrigada!

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

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


______________________________________________
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