Discussion :

[bernard59139]

Bonjour

y a-t-il un moyen de récupérer la liste des tables et des lignes qui sont vérouillées et qui peuvent planter mes ordres SQL avec un beau message "ora-01591 lock held by in-doubt distributed transaction ...."?

bonne journée

[Ikebukuro]

La vue DBA_2PC_PENDING devrait faire l'affaire.
"DBA_2PC_PENDING describes distributed transactions awaiting recovery."

[bernard59139]

Bonjour

Dans la vue, je n'ai pas remarqué d'information qui relie le lock à la table.
je me trompe peut-être

a+

[Ikebukuro]

Si le lock existe toujours, regarde ces vues.

V$LATCH: aggregate latch statistics for both parent and child latches, grouped by latch name. Individual parent and child latch statistics are broken down in the views V$LATCH_PARENT and V$LATCH_CHILDREN.
V$LATCHNAME: decoded latch names for the latches shown in V$LATCH
V$LATCHHOLDER: information about the current latch holders
V$LATCH_PARENT: statistics about parent latches
V$LATCH_CHILDREN: statistics about child latches. This view includes all columns of V$LATCH plus the CHILD# column. Note that child latches have the same parent if their LATCH# columns match each other.
DBA_HIST_LATCH_NAME: decoded latch names for the latches shown in DBA_HIST_LATCH
DBA_HIST_LATCH: historical aggregate latch statistics for both parent and child latches, grouped by latch name

V$LOCKED_OBJECT: all locks acquired by every transaction on the system
V$LOCK: locks/latches currently held by the Oracle Database and outstanding requests for a lock or latch
DBA_LOCKS (ou DBA_LOCK): locks or latches held or being requested
DBA_LOCK_INTERNAL: displays a row for each lock or latch that is being held, and one row for each outstanding request for a lock or latch.
V$SESSION_BLOCKERS: the blocker sessions for each blocked session
DBA_DDL_LOCKS: DDL locks held or being requested
DBA_DML_LOCKS: DML locks held or being requested
DBA_WAITERS: all the sessions that are waiting for a lock, with waiting session and holding session
DBA_BLOCKERS: displays a session witch is holding a lock on an object for which another session is waiting

DBMS_LOCK_ALLOCATED: user-allocated locks.
V$GLOBAL_BLOCKED_LOCKS: display global blocked locks

[bernard59139]

Bonjour
Merci bcp.

Des pistes très intéressantes, j'en avais déjà suivi qques unes (en en ratant bcp), mais rien.

Je vérifie dès mon retour de congés (cad jeudi).

Encore merci
a+

[bernard59139]

Bonjour

Il n'y a aucune requête SQL permettant d'arriver à afficher tous les locks "in doubt".

Je m'en doutais un peu.

Sur certains sites, il y a des démarches pour retrouver des informations liées aux "in doubt".
Mais quand les logs, les REDO/UNDO ont disparus, c'est quasi mission impossible.

Encore merci
a+