Sunday, August 21, 2016

logdump: Scan for Timestamp



Logdump 267 >sfts 2016-07-21 11:00:00

Scan for timestamp >= 2016/07/21 15:00:00.000.000 GMT
___________________________________________________________________
Hdr-Ind    :     E  (x45)     Partition  :     .  (x04)
UndoFlag   :     .  (x00)     BeforeAfter:     A  (x41)
RecLength  :    59  (x003b)   IO Time    : 2016/07/21 11:00:31.999.422
IOType     :    15  (x0f)     OrigNode   :   255  (xff)
TransInd   :     .  (x03)     FormatType :     R  (x52)
SyskeyLen  :     0  (x00)     Incomplete :     .  (x00)
AuditRBA   :     179323       AuditPos   : 111691280
Continued  :     N  (x00)     RecCount   :     1  (x01)

2016/07/21 11:00:31.999.422 FieldComp            Len    59 RBA 161945260
Name: GGADMIN.HEARTBEAT
After  Image:                                             Partition 4   GU s
 0001 000c 0000 0008 6f76 616c 3030 3970 000e 0004 | ........delta09....
 ffff 0000 000f 001f 0000 3230 3136 2d30 372d 3231 | ..........2016-07-21
 3a31 313a 3030 3a33 322e 3233 3136 3936 3030 30   | :11:00:32.231696000
Column     1 (x0001), Len    12 (x000c)
 0000 0008 6f76 616c 3030 3970                     | ....delta09
Column    14 (x000e), Len     4 (x0004)
 ffff 0000                                         | ....
Column    15 (x000f), Len    31 (x001f)
 0000 3230 3136 2d30 372d 3231 3a31 313a 3030 3a33 | ..2016-07-21:11:00:3
 322e 3233 3136 3936 3030 30                       | 2.231696000


--Nikhil Tatineni--

--Goldengate -- 

Querys to monitor RAC

following few  Query's will help to find out culprits-  Query to check long running transaction from last 8 hours  Col Sid Fo...