This is not a real database snapshot but set of demo screenshots. Please allow some inaccuracy in numbers and dates.

[02/17/12 05:37:27pm]    Database: rdemo16    Instance: #2 rdemo162    rrac16b.obzora.prv    10.2.0.4.0    Uptime: 10 days 18 hours 20 minutes



[an error occurred while processing this directive]
SID Serial PID Logon Time Username SQL ID Lock Type Lock Name Mode Held Mode Requested Object Block Time, s
2026 6499 24438 02/09/12 10:18:48pm ER696_RO an300d0j205ch TX TRANSACTION ENQUEUE Exclusive (X) NONE RS+SLOT#524322 WRP#769499 0 253780
1972 17218 24440 02/09/12 10:18:51pm UXR21_RO an300d0j205ch TX TRANSACTION ENQUEUE Exclusive (X) NONE RS+SLOT#1638445 WRP#139469 0 253777
2136 13498 24442 02/09/12 10:18:53pm UR696_RO an300d0j205ch TX TRANSACTION ENQUEUE Exclusive (X) NONE RS+SLOT#1245216 WRP#282665 0 253774
1724 16993 29614 02/13/12 06:34:29pm ER696_UXR TO TO row-X (SX) NONE ID1=172469 ID2=1 0 61654
1879 17663 29604 02/13/12 06:34:29pm UR696_UXR TX TRANSACTION ENQUEUE Exclusive (X) NONE RS+SLOT#2293773 WRP#97405 0 175
1918 55510 29596 02/13/12 06:34:29pm UR696_UXR TX TRANSACTION ENQUEUE Exclusive (X) NONE RS+SLOT#2031645 WRP#119698 0 474
1959 33533 29610 02/13/12 06:34:29pm ER696_UXR TX TRANSACTION ENQUEUE Exclusive (X) NONE RS+SLOT#458787 WRP#795414 0 1077
2023 47338 29608 02/13/12 06:34:29pm ER696_UXR TX TRANSACTION ENQUEUE Exclusive (X) NONE RS+SLOT#1769504 WRP#136053 0 1376
1757 42477 29602 02/13/12 06:34:29pm ER696_UXR TX TRANSACTION ENQUEUE Exclusive (X) NONE RS+SLOT#393228 WRP#672760 0 777
2102 20708 11589 02/15/12 11:00:31pm ER696_UXR TX TRANSACTION ENQUEUE Exclusive (X) NONE RS+SLOT#786470 WRP#361723 0 176
1660 21294 19267 02/16/12 04:00:46pm EMLIGHT TO TO row-X (SX) NONE ID1=230378 ID2=1 0 419
1880 5425 19312 02/16/12 04:01:05pm EMLIGHT TO TO row-X (SX) NONE ID1=230378 ID2=1 0 417
2020 371 19316 02/16/12 04:01:05pm EMLIGHT TO TO row-X (SX) NONE ID1=230378 ID2=1 0 417
1854 50414 19319 02/16/12 04:01:07pm EMLIGHT TO TO row-X (SX) NONE ID1=230378 ID2=1 0 416
1597 43483 19321 02/16/12 04:01:07pm EMLIGHT TO TO row-X (SX) NONE ID1=230378 ID2=1 0 416
1981 51643 19859 02/16/12 04:08:02pm EMLIGHT f7r3vg815znyx TO TO row-X (SX) NONE ID1=230378 ID2=1 0 0