home *** CD-ROM | disk | FTP | other *** search
open in: 
MacOS 8.1
|
Win98
|
DOS
view JSON data
|
view as text
This file was processed as: DiskDupe Disk Image
(archive/diskDupeDiskImage).
You can browse this item here: 28.ddi
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 49 4d 00 00 00 00 00 00 | 00 00 02 00 00 00 00 00 |IM......|........|
|00000010| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000040| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000050| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000060| 00 00 00 00 01 01 00 00 | 00 01 01 02 00 00 00 01 |........|........|
|00000070| 01 03 00 00 00 01 01 04 | 00 00 00 01 01 05 00 00 |........|........|
|00000080| 00 01 01 06 00 00 00 01 | 01 07 00 00 00 01 01 08 |........|........|
|00000090| 00 00 00 01 01 09 00 00 | 00 01 01 0a 00 00 00 01 |........|........|
|000000a0| 01 0b 00 00 00 01 01 0c | 00 00 00 01 01 0d 00 00 |........|........|
|000000b0| 00 01 01 0e 00 00 00 01 | 01 0f 00 00 00 01 01 10 |........|........|
|000000c0| 00 00 00 01 01 11 00 00 | 00 01 01 12 00 00 00 01 |........|........|
|000000d0| 01 13 00 00 00 01 01 14 | 00 00 00 01 01 15 00 00 |........|........|
|000000e0| 00 01 01 16 00 00 00 01 | 01 17 00 00 00 01 01 18 |........|........|
|000000f0| 00 00 00 01 01 19 00 00 | 00 01 01 1a 00 00 00 01 |........|........|
|00000100| 01 1b 00 00 00 01 01 1c | 00 00 00 01 01 1d 00 00 |........|........|
|00000110| 00 01 01 1e 00 00 00 01 | 01 1f 00 00 00 01 01 20 |........|....... |
|00000120| 00 00 00 01 01 21 00 00 | 00 01 01 22 00 00 00 01 |.....!..|..."....|
|00000130| 01 23 00 00 00 01 01 24 | 00 00 00 01 01 25 00 00 |.#.....$|.....%..|
|00000140| 00 01 01 26 00 00 00 01 | 01 27 00 00 00 01 01 28 |...&....|.'.....(|
|00000150| 00 00 00 01 01 29 00 00 | 00 01 01 2a 00 00 00 01 |.....)..|...*....|
|00000160| 01 2b 00 00 00 01 01 2c | 00 00 00 01 01 2d 00 00 |.+.....,|.....-..|
|00000170| 00 01 01 2e 00 00 00 01 | 01 2f 00 00 00 01 01 30 |........|./.....0|
|00000180| 00 00 00 01 01 31 00 00 | 00 01 01 32 00 00 00 01 |.....1..|...2....|
|00000190| 01 33 00 00 00 01 01 34 | 00 00 00 01 01 35 00 00 |.3.....4|.....5..|
|000001a0| 00 01 01 36 00 00 00 01 | 01 37 00 00 00 01 01 38 |...6....|.7.....8|
|000001b0| 00 00 00 01 01 39 00 00 | 00 01 01 3a 00 00 00 01 |.....9..|...:....|
|000001c0| 01 3b 00 00 00 01 01 3c | 00 00 00 01 01 3d 00 00 |.;.....<|.....=..|
|000001d0| 00 01 01 3e 00 00 00 01 | 01 3f 00 00 00 01 01 40 |...>....|.?.....@|
|000001e0| 00 00 00 01 01 41 00 00 | 00 01 01 42 00 00 00 01 |.....A..|...B....|
|000001f0| 01 43 00 00 00 01 01 44 | 00 00 00 01 01 45 00 00 |.C.....D|.....E..|
|00000200| 00 01 01 46 00 00 00 01 | 01 47 00 00 00 01 01 48 |...F....|.G.....H|
|00000210| 00 00 00 01 01 49 00 00 | 00 01 01 4a 00 00 00 01 |.....I..|...J....|
|00000220| 01 4b 00 00 00 01 01 4c | 00 00 00 01 01 4d 00 00 |.K.....L|.....M..|
|00000230| 00 01 01 4e 00 00 00 01 | 01 4f 00 00 00 01 01 50 |...N....|.O.....P|
|00000240| 00 00 00 01 01 51 00 00 | 00 01 01 52 00 00 00 01 |.....Q..|...R....|
|00000250| 01 53 00 00 00 01 01 54 | 00 00 00 01 01 55 00 00 |.S.....T|.....U..|
|00000260| 00 01 01 56 00 00 00 01 | 01 57 00 00 00 01 01 58 |...V....|.W.....X|
|00000270| 00 00 00 01 01 59 00 00 | 00 01 01 5a 00 00 00 01 |.....Y..|...Z....|
|00000280| 01 5b 00 00 00 01 01 5c | 00 00 00 01 01 5d 00 00 |.[.....\|.....]..|
|00000290| 00 01 01 5e 00 00 00 01 | 01 5f 00 00 00 01 01 60 |...^....|._.....`|
|000002a0| 00 00 00 01 01 61 00 00 | 00 01 01 62 00 00 00 01 |.....a..|...b....|
|000002b0| 01 63 00 00 00 01 01 64 | 00 00 00 01 01 65 00 00 |.c.....d|.....e..|
|000002c0| 00 01 01 66 00 00 00 01 | 01 67 00 00 00 01 01 68 |...f....|.g.....h|
|000002d0| 00 00 00 01 01 69 00 00 | 00 01 01 6a 00 00 00 01 |.....i..|...j....|
|000002e0| 01 6b 00 00 00 01 01 6c | 00 00 00 01 01 6d 00 00 |.k.....l|.....m..|
|000002f0| 00 01 01 6e 00 00 00 01 | 01 6f 00 00 00 01 01 70 |...n....|.o.....p|
|00000300| 00 00 00 01 01 71 00 00 | 00 01 01 72 00 00 00 01 |.....q..|...r....|
|00000310| 01 73 00 00 00 01 01 74 | 00 00 00 01 01 75 00 00 |.s.....t|.....u..|
|00000320| 00 01 01 76 00 00 00 01 | 01 77 00 00 00 01 01 78 |...v....|.w.....x|
|00000330| 00 00 00 01 01 79 00 00 | 00 01 01 7a 00 00 00 01 |.....y..|...z....|
|00000340| 01 7b 00 00 00 01 01 7c | 00 00 00 01 01 7d 00 00 |.{.....||.....}..|
|00000350| 00 01 01 7e 00 00 00 01 | 01 7f 00 00 00 01 01 80 |...~....|........|
|00000360| 00 00 00 01 01 81 00 00 | 00 01 01 82 00 00 00 01 |........|........|
|00000370| 01 83 00 00 00 01 01 84 | 00 00 00 01 01 85 00 00 |........|........|
|00000380| 00 01 01 86 00 00 00 01 | 01 87 00 00 00 01 01 88 |........|........|
|00000390| 00 00 00 01 01 89 00 00 | 00 01 01 8a 00 00 00 01 |........|........|
|000003a0| 01 8b 00 00 00 01 01 8c | 00 00 00 01 01 8d 00 00 |........|........|
|000003b0| 00 01 01 8e 00 00 00 01 | 01 8f 00 00 00 01 01 90 |........|........|
|000003c0| 00 00 00 01 01 91 00 00 | 00 01 01 92 00 00 00 01 |........|........|
|000003d0| 01 93 00 00 00 01 01 94 | 00 00 00 01 01 95 00 00 |........|........|
|000003e0| 00 01 01 96 00 00 00 01 | 01 97 00 00 00 01 01 98 |........|........|
|000003f0| 00 00 00 01 01 99 00 00 | 00 01 01 9a 00 00 00 01 |........|........|
|00000400| 01 9b 00 00 00 01 01 9c | 00 00 00 01 01 9d 00 00 |........|........|
|00000410| 00 01 01 9e 00 00 00 01 | 01 9f 00 00 00 01 01 a0 |........|........|
|00000420| 00 00 00 01 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000430| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000440| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000450| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000460| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000470| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000480| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000490| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000500| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000510| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000520| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000530| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000540| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000550| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000560| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000570| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000580| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000590| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000600| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000610| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000620| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000630| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000640| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000650| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000660| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000670| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000680| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000690| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000700| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000710| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000720| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000730| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000740| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000750| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000760| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000770| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000780| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000790| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000800| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000810| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000820| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000830| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000840| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000850| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000860| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000870| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000880| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000890| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000900| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000910| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000920| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000930| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000940| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000950| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000960| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000970| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000980| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000990| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000aa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ab0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ac0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ad0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ae0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000af0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ba0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000bb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000bc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000bd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000be0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000bf0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ca0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000cb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000cc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000cd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ce0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000cf0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000da0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000db0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000dc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000dd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000de0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000df0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ea0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000eb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ec0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ed0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ee0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ef0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fe0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ff0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001000| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001010| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001040| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001050| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001060| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001070| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001080| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001090| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001100| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001110| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001120| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001130| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001140| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001150| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001160| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001170| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001180| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001190| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000011a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000011b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000011c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000011d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000011e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000011f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001200| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001210| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001220| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001230| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001240| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001250| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001260| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001270| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001280| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001290| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000012a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000012b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000012c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000012d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000012e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000012f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001300| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001310| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001320| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001330| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001340| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001350| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001360| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001370| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001380| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001390| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000013a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000013b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000013c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000013d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000013e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000013f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001400| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001410| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001420| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001430| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001440| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001450| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001460| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001470| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001480| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001490| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000014a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000014b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000014c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000014d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000014e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000014f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001500| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001510| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001520| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001530| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001540| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001550| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001560| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001570| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001580| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001590| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000015a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000015b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000015c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000015d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000015e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000015f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001600| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001610| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001620| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001630| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001640| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001650| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001660| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001670| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001680| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001690| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000016a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000016b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000016c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000016d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000016e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000016f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001700| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001710| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001720| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001730| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001740| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001750| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001760| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001770| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001780| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001790| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000017a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000017b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000017c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000017d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000017e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000017f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001800| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001810| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001820| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001830| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001840| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001850| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001860| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001870| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001880| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001890| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000018a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000018b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000018c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000018d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000018e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000018f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001900| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001910| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001920| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001930| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001940| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001950| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001960| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001970| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001980| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001990| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000019a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000019b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000019c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000019d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000019e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000019f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001aa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ab0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ac0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ad0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ae0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001af0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001b00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001b10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001b20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001b30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001b40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001b50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001b60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001b70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001b80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001b90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ba0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001bb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001bc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001bd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001be0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001bf0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001c00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001c10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001c20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001c30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001c40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001c50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001c60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001c70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001c80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001c90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ca0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001cb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001cc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001cd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ce0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001cf0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001d00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001d10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001d20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001d30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001d40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001d50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001d60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001d70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001d80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001d90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001da0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001db0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001dc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001dd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001de0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001df0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001e00| 30 37 30 37 30 37 30 30 | 30 34 35 30 30 31 30 30 |07070700|04500100|
|00001e10| 30 30 30 34 30 37 37 37 | 30 30 30 33 31 31 30 30 |00040777|00031100|
|00001e20| 30 30 36 32 30 30 30 30 | 31 31 30 30 30 30 30 30 |00620000|11000000|
|00001e30| 30 34 37 36 34 35 37 35 | 33 34 31 30 30 30 30 30 |04764575|34100000|
|00001e40| 32 30 30 30 30 30 30 30 | 30 30 30 30 2e 00 30 37 |20000000|0000..07|
|00001e50| 30 37 30 37 30 30 30 34 | 35 30 30 31 30 30 30 31 |07070004|50010001|
|00001e60| 30 34 30 37 35 35 30 30 | 30 33 31 31 30 30 30 30 |04075500|03110000|
|00001e70| 36 32 30 30 30 30 30 32 | 30 30 30 30 30 30 30 34 |62000002|00000004|
|00001e80| 37 36 34 36 34 34 33 33 | 30 30 30 30 30 30 36 30 |76464433|00000060|
|00001e90| 30 30 30 30 30 30 30 30 | 30 30 61 64 6d 69 6e 00 |00000000|00admin.|
|00001ea0| 30 37 30 37 30 37 30 30 | 30 34 35 30 30 31 30 30 |07070700|04500100|
|00001eb0| 30 32 31 30 30 34 34 34 | 30 30 30 33 31 31 30 30 |02100444|00031100|
|00001ec0| 30 30 36 32 30 30 30 30 | 30 31 30 30 30 30 30 30 |00620000|01000000|
|00001ed0| 30 34 37 36 34 35 37 34 | 30 35 32 30 30 30 30 32 |04764574|05200002|
|00001ee0| 33 30 30 30 30 30 30 30 | 37 35 30 33 61 64 6d 69 |30000000|7503admi|
|00001ef0| 6e 2f 62 6c 6f 63 6b 69 | 6e 67 2e 73 71 6c 00 72 |n/blocki|ng.sql.r|
|00001f00| 65 6d 0a 72 65 6d 20 24 | 48 65 61 64 65 72 3a 20 |em.rem $|Header: |
|00001f10| 62 6c 6f 63 6b 69 6e 67 | 2e 73 71 6c 2c 76 20 36 |blocking|.sql,v 6|
|00001f20| 30 30 32 36 30 37 2e 32 | 20 38 39 2f 31 30 2f 31 |002607.2| 89/10/1|
|00001f30| 32 20 31 39 3a 35 37 3a | 32 30 20 63 79 61 6e 67 |2 19:57:|20 cyang|
|00001f40| 20 45 78 70 20 24 20 62 | 6c 6f 63 6b 69 6e 67 2e | Exp $ b|locking.|
|00001f50| 73 71 6c 20 43 6f 70 79 | 72 20 28 63 29 20 31 39 |sql Copy|r (c) 19|
|00001f60| 38 39 20 4f 72 61 63 6c | 65 0a 72 65 6d 0a 2f 2a |89 Oracl|e.rem./*|
|00001f70| 20 54 68 69 73 20 73 63 | 72 69 70 74 20 63 72 65 | This sc|ript cre|
|00001f80| 61 74 65 73 20 61 20 76 | 69 65 77 20 63 61 6c 6c |ates a v|iew call|
|00001f90| 65 64 20 62 6c 6f 63 6b | 69 6e 67 5f 6c 6f 63 6b |ed block|ing_lock|
|00001fa0| 73 20 74 68 61 74 20 63 | 61 6e 20 62 65 20 71 75 |s that c|an be qu|
|00001fb0| 65 72 69 65 64 0a 20 2a | 20 74 6f 20 64 65 74 65 |eried. *| to dete|
|00001fc0| 72 6d 69 6e 65 20 77 68 | 69 63 68 20 6c 6f 63 6b |rmine wh|ich lock|
|00001fd0| 73 20 61 72 65 20 62 6c | 6f 63 6b 69 6e 67 20 74 |s are bl|ocking t|
|00001fe0| 68 65 20 73 79 73 74 65 | 6d 2e 20 20 49 74 20 69 |he syste|m. It i|
|00001ff0| 73 20 6d 6f 73 74 6c 79 | 20 75 73 65 66 75 6c 0a |s mostly| useful.|
|00002000| 20 2a 20 66 6f 72 20 66 | 69 6e 64 69 6e 67 20 70 | * for f|inding p|
|00002010| 72 6f 63 65 73 73 65 73 | 20 74 68 61 74 20 68 61 |rocesses| that ha|
|00002020| 76 65 20 64 69 65 64 20 | 68 6f 6c 64 69 6e 67 20 |ve died |holding |
|00002030| 6c 6f 63 6b 73 2c 20 61 | 6e 64 20 74 68 61 74 20 |locks, a|nd that |
|00002040| 66 6f 72 20 73 6f 6d 65 | 0a 20 2a 20 72 65 61 73 |for some|. * reas|
|00002050| 6f 6e 20 68 61 76 65 20 | 6e 6f 74 20 62 65 65 6e |on have |not been|
|00002060| 20 63 6c 65 61 6e 65 64 | 20 75 70 20 62 79 20 50 | cleaned| up by P|
|00002070| 4d 4f 4e 2e 0a 20 2a 20 | 20 0a 20 2a 20 49 74 20 |MON.. * | . * It |
|00002080| 66 69 6e 64 73 20 61 6c | 6c 20 74 68 65 20 6c 6f |finds al|l the lo|
|00002090| 63 6b 73 20 61 6e 64 20 | 6c 61 74 63 68 65 73 20 |cks and |latches |
|000020a0| 74 68 61 74 20 68 61 76 | 65 20 70 72 6f 63 65 73 |that hav|e proces|
|000020b0| 73 65 73 20 77 61 69 74 | 69 6e 67 20 6f 6e 20 74 |ses wait|ing on t|
|000020c0| 68 65 6d 0a 20 2a 20 74 | 68 61 74 20 61 72 65 20 |hem. * t|hat are |
|000020d0| 68 65 6c 64 20 62 79 20 | 61 20 70 72 6f 63 65 73 |held by |a proces|
|000020e0| 73 20 74 68 61 74 20 69 | 73 20 6e 6f 74 20 77 61 |s that i|s not wa|
|000020f0| 69 74 69 6e 67 20 6f 6e | 20 61 6e 6f 74 68 65 72 |iting on| another|
|00002100| 20 6c 6f 63 6b 2e 20 20 | 49 6e 0a 20 2a 20 6f 74 | lock. |In. * ot|
|00002110| 68 65 72 20 77 6f 72 64 | 73 20 69 74 20 66 69 6e |her word|s it fin|
|00002120| 64 73 20 74 68 65 20 6c | 6f 63 6b 73 20 74 68 61 |ds the l|ocks tha|
|00002130| 74 20 61 72 65 20 61 74 | 20 74 68 65 20 74 6f 70 |t are at| the top|
|00002140| 20 6f 66 20 74 68 65 20 | 77 61 69 74 2d 66 6f 72 | of the |wait-for|
|00002150| 0a 20 2a 20 67 72 61 70 | 68 2e 0a 20 2a 20 20 0a |. * grap|h.. * .|
|00002160| 20 2a 20 54 68 65 20 62 | 6c 6f 63 6b 69 6e 67 5f | * The b|locking_|
|00002170| 6c 6f 63 6b 73 20 76 69 | 65 77 20 61 6c 73 6f 20 |locks vi|ew also |
|00002180| 67 69 76 65 73 20 69 6e | 66 6f 72 6d 61 74 69 6f |gives in|formatio|
|00002190| 6e 20 6f 6e 20 74 68 65 | 20 70 72 6f 63 65 73 73 |n on the| process|
|000021a0| 20 74 68 61 74 20 69 73 | 0a 20 2a 20 68 6f 6c 64 | that is|. * hold|
|000021b0| 69 6e 67 20 74 68 65 20 | 6c 6f 63 6b 20 74 68 61 |ing the |lock tha|
|000021c0| 74 20 69 73 20 62 6c 6f | 63 6b 69 6e 67 20 74 68 |t is blo|cking th|
|000021d0| 65 20 73 79 73 74 65 6d | 2e 0a 20 2a 20 20 0a 20 |e system|.. * . |
|000021e0| 2a 20 4e 6f 74 65 20 74 | 68 61 74 20 74 68 69 73 |* Note t|hat this|
|000021f0| 20 76 69 65 77 20 77 69 | 6c 6c 20 6e 6f 74 20 77 | view wi|ll not w|
|00002200| 6f 72 6b 20 69 66 20 74 | 68 65 72 65 20 69 73 20 |ork if t|here is |
|00002210| 73 6f 6d 65 20 73 6f 72 | 74 20 6f 66 20 63 69 72 |some sor|t of cir|
|00002220| 63 75 6c 61 72 0a 20 2a | 20 64 65 70 65 6e 64 65 |cular. *| depende|
|00002230| 6e 63 65 20 62 65 74 77 | 65 65 6e 20 70 72 6f 63 |nce betw|een proc|
|00002240| 65 73 73 65 73 20 68 6f | 6c 64 69 6e 67 20 6c 6f |esses ho|lding lo|
|00002250| 63 6b 73 2e 20 20 54 68 | 61 74 20 69 73 2c 20 69 |cks. Th|at is, i|
|00002260| 74 20 77 69 6c 6c 20 6e | 6f 74 20 77 6f 72 6b 0a |t will n|ot work.|
|00002270| 20 2a 20 69 6e 20 74 68 | 65 20 63 61 73 65 20 74 | * in th|e case t|
|00002280| 68 61 74 20 74 68 65 72 | 65 20 69 73 20 61 20 64 |hat ther|e is a d|
|00002290| 65 61 64 6c 6f 63 6b 20 | 74 68 61 74 20 69 73 20 |eadlock |that is |
|000022a0| 6e 6f 74 20 64 65 74 65 | 63 74 65 64 20 61 75 74 |not dete|cted aut|
|000022b0| 6f 6d 61 74 69 63 61 6c | 6c 79 0a 20 2a 20 62 79 |omatical|ly. * by|
|000022c0| 20 74 68 65 20 73 79 73 | 74 65 6d 2e 20 20 41 6c | the sys|tem. Al|
|000022d0| 73 6f 2c 20 74 68 65 20 | 72 65 73 75 6c 74 73 20 |so, the |results |
|000022e0| 6f 66 20 74 68 65 20 76 | 69 65 77 20 61 72 65 20 |of the v|iew are |
|000022f0| 6e 6f 74 20 64 65 70 65 | 6e 64 61 62 6c 65 20 69 |not depe|ndable i|
|00002300| 66 20 74 68 65 72 65 0a | 20 2a 20 61 72 65 20 61 |f there.| * are a|
|00002310| 20 6c 6f 74 20 6f 66 20 | 6c 6f 63 6b 20 74 72 61 | lot of |lock tra|
|00002320| 6e 73 69 74 69 6f 6e 73 | 2e 20 20 49 74 20 69 73 |nsitions|. It is|
|00002330| 20 72 65 61 6c 6c 79 20 | 6f 6e 6c 79 20 75 73 65 | really |only use|
|00002340| 66 75 6c 20 66 6f 72 20 | 74 68 65 20 63 61 73 65 |ful for |the case|
|00002350| 20 77 68 65 6e 0a 20 2a | 20 74 68 65 20 73 79 73 | when. *| the sys|
|00002360| 74 65 6d 20 69 73 20 77 | 65 64 67 65 64 2e 0a 20 |tem is w|edged.. |
|00002370| 2a 20 20 0a 20 2a 20 59 | 6f 75 20 6d 75 73 74 20 |* . * Y|ou must |
|00002380| 68 61 76 65 20 61 63 63 | 65 73 73 20 74 6f 20 74 |have acc|ess to t|
|00002390| 68 65 20 66 69 78 65 64 | 20 74 61 62 6c 65 73 20 |he fixed| tables |
|000023a0| 28 6f 77 6e 65 64 20 62 | 79 20 73 79 73 29 20 69 |(owned b|y sys) i|
|000023b0| 6e 20 6f 72 64 65 72 20 | 74 6f 0a 20 2a 20 75 73 |n order |to. * us|
|000023c0| 65 20 74 68 65 20 62 6c | 6f 63 6b 69 6e 67 5f 6c |e the bl|ocking_l|
|000023d0| 6f 63 6b 73 20 76 69 65 | 77 2e 0a 20 2a 2f 0a 0a |ocks vie|w.. */..|
|000023e0| 64 72 6f 70 20 76 69 65 | 77 20 41 4c 4c 5f 4c 4f |drop vie|w ALL_LO|
|000023f0| 43 4b 53 5f 56 49 45 57 | 3b 0a 0a 2f 2a 20 41 6c |CKS_VIEW|;../* Al|
|00002400| 6c 5f 6c 6f 63 6b 73 5f | 76 69 65 77 20 68 61 73 |l_locks_|view has|
|00002410| 20 61 20 72 6f 77 20 66 | 6f 72 20 65 61 63 68 20 | a row f|or each |
|00002420| 6c 6f 63 6b 20 6f 72 20 | 6c 61 74 63 68 20 74 68 |lock or |latch th|
|00002430| 61 74 20 69 73 20 62 65 | 69 6e 67 20 68 65 6c 64 |at is be|ing held|
|00002440| 2c 20 61 6e 64 20 0a 20 | 2a 20 6f 6e 65 20 72 6f |, and . |* one ro|
|00002450| 77 20 66 6f 72 20 65 61 | 63 68 20 6f 75 74 73 74 |w for ea|ch outst|
|00002460| 61 6e 64 69 6e 67 20 72 | 65 71 75 65 73 74 20 66 |anding r|equest f|
|00002470| 6f 72 20 61 20 6c 6f 63 | 6b 20 6f 72 20 6c 61 74 |or a loc|k or lat|
|00002480| 63 68 2e 0a 20 2a 20 54 | 68 65 20 63 6f 6c 75 6d |ch.. * T|he colum|
|00002490| 6e 73 20 20 6f 66 20 61 | 6c 6c 5f 6c 6f 63 6b 73 |ns of a|ll_locks|
|000024a0| 5f 76 69 65 77 20 61 72 | 65 3a 0a 20 2a 20 20 20 |_view ar|e:. * |
|000024b0| 74 79 70 65 20 20 20 20 | 2d 20 74 79 70 65 20 6f |type |- type o|
|000024c0| 66 20 6c 6f 63 6b 20 28 | 44 44 4c 2c 20 4c 41 54 |f lock (|DDL, LAT|
|000024d0| 43 48 2c 20 65 74 63 2e | 29 0a 20 2a 20 20 20 6c |CH, etc.|). * l|
|000024e0| 6d 6f 64 65 20 20 20 2d | 20 6d 6f 64 65 20 74 68 |mode -| mode th|
|000024f0| 65 20 6c 6f 63 6b 20 69 | 73 20 63 75 72 72 65 6e |e lock i|s curren|
|00002500| 74 6c 79 20 68 65 6c 64 | 20 69 6e 20 62 79 20 70 |tly held| in by p|
|00002510| 72 6f 63 65 73 73 20 70 | 69 64 0a 20 2a 20 20 20 |rocess p|id. * |
|00002520| 70 69 64 20 20 20 20 20 | 2d 20 6f 72 61 63 6c 65 |pid |- oracle|
|00002530| 20 70 69 64 20 6f 66 20 | 70 72 6f 63 65 73 73 20 | pid of |process |
|00002540| 74 68 61 74 20 74 68 69 | 73 20 72 6f 77 20 64 65 |that thi|s row de|
|00002550| 73 63 72 69 62 65 73 0a | 20 2a 20 20 20 69 64 31 |scribes.| * id1|
|00002560| 20 20 20 20 20 2d 20 6c | 6f 63 6b 20 73 70 65 63 | - l|ock spec|
|00002570| 69 66 69 63 20 69 64 65 | 6e 74 69 66 69 65 72 20 |ific ide|ntifier |
|00002580| 6f 66 20 74 68 65 20 6c | 6f 63 6b 0a 20 2a 20 20 |of the l|ock. * |
|00002590| 20 69 64 32 20 20 20 20 | 20 2d 20 6c 6f 63 6b 20 | id2 | - lock |
|000025a0| 73 70 65 63 69 66 69 63 | 20 69 64 65 6e 74 69 66 |specific| identif|
|000025b0| 69 65 72 20 6f 66 20 74 | 68 65 20 6c 6f 63 6b 0a |ier of t|he lock.|
|000025c0| 20 2a 20 20 20 72 65 71 | 75 65 73 74 20 2d 20 6d | * req|uest - m|
|000025d0| 6f 64 65 20 74 68 61 74 | 20 74 68 65 20 6c 6f 63 |ode that| the loc|
|000025e0| 6b 20 69 73 20 62 65 69 | 6e 67 20 72 65 71 75 65 |k is bei|ng reque|
|000025f0| 73 74 65 64 20 69 6e 20 | 62 79 20 70 72 6f 63 65 |sted in |by proce|
|00002600| 73 73 20 70 69 64 0a 20 | 2a 2f 0a 63 72 65 61 74 |ss pid. |*/.creat|
|00002610| 65 20 76 69 65 77 20 41 | 4c 4c 5f 4c 4f 43 4b 53 |e view A|LL_LOCKS|
|00002620| 5f 56 49 45 57 20 61 73 | 0a 20 20 73 65 6c 65 63 |_VIEW as|. selec|
|00002630| 74 20 74 79 70 65 2c 20 | 6c 6d 6f 64 65 2c 20 70 |t type, |lmode, p|
|00002640| 69 64 2c 20 74 6f 5f 63 | 68 61 72 28 69 64 31 29 |id, to_c|har(id1)|
|00002650| 20 69 64 31 2c 20 74 6f | 5f 63 68 61 72 28 69 64 | id1, to|_char(id|
|00002660| 32 29 20 69 64 32 2c 20 | 72 65 71 75 65 73 74 20 |2) id2, |request |
|00002670| 0a 20 20 20 20 20 20 66 | 72 6f 6d 20 76 24 6c 6f |. f|rom v$lo|
|00002680| 63 6b 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |ck | |
|00002690| 20 20 2f 2a 20 70 72 6f | 63 65 73 73 65 73 20 77 | /* pro|cesses w|
|000026a0| 61 69 74 69 6e 67 20 6f | 6e 20 6f 72 20 68 6f 6c |aiting o|n or hol|
|000026b0| 64 69 6e 67 20 65 6e 71 | 75 65 75 65 73 20 2a 2f |ding enq|ueues */|
|000026c0| 0a 20 75 6e 69 6f 6e 0a | 20 20 73 65 6c 65 63 74 |. union.| select|
|000026d0| 20 27 4c 41 54 43 48 27 | 2c 20 36 2c 20 70 69 64 | 'LATCH'|, 6, pid|
|000026e0| 2c 20 72 61 77 74 6f 68 | 65 78 28 6c 61 64 64 72 |, rawtoh|ex(laddr|
|000026f0| 29 2c 20 27 20 27 2c 20 | 30 20 20 20 2f 2a 20 70 |), ' ', |0 /* p|
|00002700| 72 6f 63 73 20 68 6f 6c | 64 69 6e 67 20 6c 61 74 |rocs hol|ding lat|
|00002710| 63 68 65 73 20 2a 2f 0a | 20 20 20 20 20 20 66 72 |ches */.| fr|
|00002720| 6f 6d 20 76 24 6c 61 74 | 63 68 68 6f 6c 64 65 72 |om v$lat|chholder|
|00002730| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002740| 20 20 20 20 20 20 2f 2a | 20 36 20 3d 20 65 78 63 | /*| 6 = exc|
|00002750| 6c 75 73 69 76 65 2c 20 | 30 20 3d 20 6e 6f 74 20 |lusive, |0 = not |
|00002760| 68 65 6c 64 20 2a 2f 0a | 20 75 6e 69 6f 6e 0a 20 |held */.| union. |
|00002770| 20 73 65 6c 65 63 74 20 | 27 4c 41 54 43 48 27 2c | select |'LATCH',|
|00002780| 20 30 2c 20 70 69 64 2c | 20 6c 61 74 63 68 77 61 | 0, pid,| latchwa|
|00002790| 69 74 2c 27 20 27 2c 36 | 20 20 20 20 20 20 20 20 |it,' ',6| |
|000027a0| 20 20 2f 2a 20 70 72 6f | 63 73 20 77 61 69 74 69 | /* pro|cs waiti|
|000027b0| 6e 67 20 6f 6e 20 6c 61 | 74 63 68 20 2a 2f 0a 20 |ng on la|tch */. |
|000027c0| 20 20 20 20 20 66 72 6f | 6d 20 76 24 70 72 6f 63 | fro|m v$proc|
|000027d0| 65 73 73 0a 20 20 20 20 | 77 68 65 72 65 20 6c 61 |ess. |where la|
|000027e0| 74 63 68 77 61 69 74 20 | 69 73 20 6e 6f 74 20 6e |tchwait |is not n|
|000027f0| 75 6c 6c 3b 0a 0a 2f 2a | 20 64 72 6f 70 20 6f 6c |ull;../*| drop ol|
|00002800| 64 20 6f 62 73 6f 6c 65 | 74 65 20 76 69 65 77 20 |d obsole|te view |
|00002810| 2a 2f 0a 64 72 6f 70 20 | 76 69 65 77 20 42 4c 4f |*/.drop |view BLO|
|00002820| 43 4b 49 4e 47 5f 4c 4f | 43 4b 53 31 3b 0a 0a 64 |CKING_LO|CKS1;..d|
|00002830| 72 6f 70 20 76 69 65 77 | 20 42 4c 4f 43 4b 49 4e |rop view| BLOCKIN|
|00002840| 47 5f 4c 4f 43 4b 53 3b | 0a 0a 2f 2a 20 4c 6f 63 |G_LOCKS;|../* Loc|
|00002850| 6b 73 20 62 65 69 6e 67 | 20 72 65 71 75 65 73 74 |ks being| request|
|00002860| 65 64 20 62 79 20 73 6f | 6d 65 20 70 72 6f 63 65 |ed by so|me proce|
|00002870| 73 73 2c 20 74 68 61 74 | 20 61 72 65 20 68 65 6c |ss, that| are hel|
|00002880| 64 20 62 79 20 70 72 6f | 63 65 73 73 65 73 20 0a |d by pro|cesses .|
|00002890| 20 2a 20 74 68 61 74 20 | 61 72 65 20 6e 6f 74 20 | * that |are not |
|000028a0| 77 61 69 74 69 6e 67 20 | 74 6f 20 61 63 71 75 69 |waiting |to acqui|
|000028b0| 72 65 20 73 6f 6d 65 20 | 6f 74 68 65 72 20 6c 6f |re some |other lo|
|000028c0| 63 6b 2e 20 20 49 6e 20 | 6f 74 68 65 72 20 77 6f |ck. In |other wo|
|000028d0| 72 64 73 20 0a 20 2a 20 | 74 68 65 20 6c 6f 63 6b |rds . * |the lock|
|000028e0| 73 20 20 61 74 20 74 68 | 65 20 74 6f 70 20 6f 66 |s at th|e top of|
|000028f0| 20 74 68 65 20 57 41 49 | 54 2d 46 4f 52 20 74 72 | the WAI|T-FOR tr|
|00002900| 65 65 2e 20 20 41 6c 73 | 6f 20 73 6f 6d 65 20 69 |ee. Als|o some i|
|00002910| 6e 66 6f 72 6d 61 74 69 | 6f 6e 0a 20 2a 20 61 62 |nformati|on. * ab|
|00002920| 6f 75 74 20 74 68 65 20 | 68 6f 6c 64 65 72 20 6f |out the |holder o|
|00002930| 66 20 74 68 65 20 6c 6f | 63 6b 2e 0a 20 2a 2f 0a |f the lo|ck.. */.|
|00002940| 0a 63 72 65 61 74 65 20 | 76 69 65 77 20 42 4c 4f |.create |view BLO|
|00002950| 43 4b 49 4e 47 5f 4c 4f | 43 4b 53 20 61 73 0a 73 |CKING_LO|CKS as.s|
|00002960| 65 6c 65 63 74 20 68 2e | 74 79 70 65 09 09 6c 6f |elect h.|type..lo|
|00002970| 63 6b 5f 74 79 70 65 2c | 0a 09 64 65 63 6f 64 65 |ck_type,|..decode|
|00002980| 28 20 68 2e 6c 6d 6f 64 | 65 2c 20 0a 09 09 30 2c |( h.lmod|e, ...0,|
|00002990| 20 27 4e 4f 4e 45 27 2c | 20 20 20 20 20 20 20 20 | 'NONE',| |
|000029a0| 20 20 20 2f 2a 20 4d 6f | 6e 20 4c 6f 63 6b 20 65 | /* Mo|n Lock e|
|000029b0| 71 75 69 76 61 6c 65 6e | 74 20 2a 2f 0a 20 20 20 |quivalen|t */. |
|000029c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 31 2c 20 | | 1, |
|000029d0| 27 4e 75 6c 6c 20 4d 6f | 64 65 27 2c 20 20 20 20 |'Null Mo|de', |
|000029e0| 20 20 2f 2a 20 4e 20 2a | 2f 0a 09 09 32 2c 20 27 | /* N *|/...2, '|
|000029f0| 52 6f 77 2d 53 20 28 53 | 53 29 27 2c 20 20 20 20 |Row-S (S|S)', |
|00002a00| 20 2f 2a 20 4c 20 2a 2f | 0a 09 09 33 2c 20 27 52 | /* L */|...3, 'R|
|00002a10| 6f 77 2d 58 20 28 53 58 | 29 27 2c 20 20 20 20 20 |ow-X (SX|)', |
|00002a20| 2f 2a 20 52 20 2a 2f 0a | 09 09 34 2c 20 27 53 68 |/* R */.|..4, 'Sh|
|00002a30| 61 72 65 20 28 53 29 27 | 2c 20 20 20 20 20 20 2f |are (S)'|, /|
|00002a40| 2a 20 53 20 2a 2f 0a 09 | 09 35 2c 20 27 53 2f 52 |* S */..|.5, 'S/R|
|00002a50| 6f 77 2d 58 20 28 53 53 | 58 29 27 2c 20 20 2f 2a |ow-X (SS|X)', /*|
|00002a60| 20 43 20 2a 2f 0a 09 09 | 36 2c 20 27 45 78 63 6c | C */...|6, 'Excl|
|00002a70| 75 73 69 76 65 20 28 58 | 29 27 2c 20 20 2f 2a 20 |usive (X|)', /* |
|00002a80| 58 20 2a 2f 0a 09 09 68 | 2e 6c 6d 6f 64 65 29 0a |X */...h|.lmode).|
|00002a90| 09 09 09 6c 6f 63 6b 5f | 6d 6f 64 65 2c 0a 09 68 |...lock_|mode,..h|
|00002aa0| 2e 70 69 64 09 09 6f 72 | 63 6c 5f 70 69 64 2c 20 |.pid..or|cl_pid, |
|00002ab0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002ac0| 20 20 20 20 20 20 2f 2a | 20 6f 72 61 63 6c 65 20 | /*| oracle |
|00002ad0| 70 72 6f 63 65 73 73 20 | 69 64 20 2a 2f 0a 09 73 |process |id */..s|
|00002ae0| 2e 75 73 65 72 6e 61 6d | 65 09 6f 72 63 6c 5f 75 |.usernam|e.orcl_u|
|00002af0| 73 65 72 2c 20 20 20 20 | 20 20 20 20 20 20 20 20 |ser, | |
|00002b00| 20 20 20 20 20 20 20 20 | 20 20 20 2f 2a 20 6f 72 | | /* or|
|00002b10| 61 63 6c 65 20 75 73 65 | 72 20 6e 61 6d 65 20 2a |acle use|r name *|
|00002b20| 2f 0a 09 70 2e 73 70 69 | 64 20 09 09 6f 73 5f 70 |/..p.spi|d ..os_p|
|00002b30| 69 64 2c 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |id, | |
|00002b40| 20 20 20 20 20 20 20 2f | 2a 20 4f 53 20 73 70 65 | /|* OS spe|
|00002b50| 63 69 66 69 63 20 70 72 | 6f 63 65 73 73 20 69 64 |cific pr|ocess id|
|00002b60| 20 2a 2f 0a 09 70 2e 75 | 73 65 72 6e 61 6d 65 20 | */..p.u|sername |
|00002b70| 09 6f 73 5f 75 73 65 72 | 2c 20 20 20 20 20 20 20 |.os_user|, |
|00002b80| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002b90| 20 20 2f 2a 20 4f 53 20 | 73 70 65 63 69 66 69 63 | /* OS |specific|
|00002ba0| 20 6e 61 6d 65 20 2a 2f | 0a 09 70 72 6f 67 72 61 | name */|..progra|
|00002bb0| 6d 2c 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |m, | |
|00002bc0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 2f | | /|
|00002bd0| 2a 20 70 72 6f 67 72 61 | 6d 20 74 68 61 74 20 75 |* progra|m that u|
|00002be0| 73 65 72 20 69 73 20 72 | 75 6e 6e 69 6e 67 20 2a |ser is r|unning *|
|00002bf0| 2f 0a 09 74 65 72 6d 69 | 6e 61 6c 2c 20 20 20 20 |/..termi|nal, |
|00002c00| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002c10| 20 20 20 20 20 20 20 20 | 20 2f 2a 20 74 65 72 6d | | /* term|
|00002c20| 69 6e 61 6c 20 74 68 61 | 74 20 75 73 65 72 20 69 |inal tha|t user i|
|00002c30| 73 20 75 73 69 6e 67 20 | 2a 2f 0a 09 68 2e 69 64 |s using |*/..h.id|
|00002c40| 31 20 72 73 72 63 5f 69 | 64 31 2c 20 20 20 20 2f |1 rsrc_i|d1, /|
|00002c50| 2a 20 74 68 65 20 76 61 | 6c 75 65 20 6f 66 20 74 |* the va|lue of t|
|00002c60| 68 65 73 65 20 64 65 70 | 65 6e 64 73 20 6f 6e 20 |hese dep|ends on |
|00002c70| 74 68 65 20 74 79 70 65 | 20 6f 66 20 6c 6f 63 6b |the type| of lock|
|00002c80| 20 2a 2f 0a 09 68 2e 69 | 64 32 20 72 73 72 63 5f | */..h.i|d2 rsrc_|
|00002c90| 69 64 32 0a 20 20 66 72 | 6f 6d 20 76 24 73 65 73 |id2. fr|om v$ses|
|00002ca0| 73 69 6f 6e 20 73 2c 20 | 76 24 70 72 6f 63 65 73 |sion s, |v$proces|
|00002cb0| 73 20 70 2c 20 61 6c 6c | 5f 6c 6f 63 6b 73 5f 76 |s p, all|_locks_v|
|00002cc0| 69 65 77 20 68 2c 20 61 | 6c 6c 5f 6c 6f 63 6b 73 |iew h, a|ll_locks|
|00002cd0| 5f 76 69 65 77 20 72 0a | 20 77 68 65 72 65 20 20 |_view r.| where |
|00002ce0| 72 2e 72 65 71 75 65 73 | 74 20 20 3e 20 20 31 20 |r.reques|t > 1 |
|00002cf0| 20 20 20 20 2f 2a 20 73 | 6f 6d 65 6f 6e 65 20 69 | /* s|omeone i|
|00002d00| 73 20 77 61 69 74 69 6e | 67 20 66 6f 72 20 28 72 |s waitin|g for (r|
|00002d10| 65 71 75 65 73 74 69 6e | 67 29 20 74 68 65 20 6c |equestin|g) the l|
|00002d20| 6f 63 6b 20 20 2a 2f 0a | 20 20 61 6e 64 20 20 20 |ock */.| and |
|00002d30| 68 2e 6c 6d 6f 64 65 20 | 20 20 20 3e 20 20 31 20 |h.lmode | > 1 |
|00002d40| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002d50| 20 20 20 20 20 20 20 20 | 20 20 20 20 2f 2a 20 68 | | /* h|
|00002d60| 20 69 73 20 68 6f 6c 64 | 69 6e 67 20 74 68 65 20 | is hold|ing the |
|00002d70| 6c 6f 63 6b 20 2a 2f 0a | 20 20 61 6e 64 20 20 20 |lock */.| and |
|00002d80| 68 2e 74 79 70 65 20 20 | 20 20 20 3d 20 20 72 2e |h.type | = r.|
|00002d90| 74 79 70 65 0a 20 20 61 | 6e 64 20 20 20 68 2e 69 |type. a|nd h.i|
|00002da0| 64 31 20 20 20 20 20 20 | 3d 20 20 72 2e 69 64 31 |d1 |= r.id1|
|00002db0| 0a 20 20 61 6e 64 20 20 | 20 68 2e 69 64 32 20 20 |. and | h.id2 |
|00002dc0| 20 20 20 20 3d 20 20 72 | 2e 69 64 32 0a 20 20 61 | = r|.id2. a|
|00002dd0| 6e 64 20 20 20 68 2e 70 | 69 64 20 20 20 20 20 20 |nd h.p|id |
|00002de0| 3d 20 20 70 2e 70 69 64 | 0a 20 20 61 6e 64 20 20 |= p.pid|. and |
|00002df0| 20 70 2e 6c 6f 63 6b 77 | 61 69 74 20 69 73 20 6e | p.lockw|ait is n|
|00002e00| 75 6c 6c 0a 20 20 61 6e | 64 20 20 20 70 2e 6c 61 |ull. an|d p.la|
|00002e10| 74 63 68 77 61 69 74 20 | 69 73 20 6e 75 6c 6c 0a |tchwait |is null.|
|00002e20| 20 20 61 6e 64 20 20 20 | 70 2e 61 64 64 72 20 20 | and |p.addr |
|00002e30| 20 20 20 3d 20 20 20 73 | 2e 70 61 64 64 72 3b 0a | = s|.paddr;.|
|00002e40| 0a 0a 30 37 30 37 30 37 | 30 30 30 34 35 30 30 31 |..070707|00045001|
|00002e50| 30 30 30 33 31 30 30 34 | 34 34 30 30 30 33 31 31 |00031004|44000311|
|00002e60| 30 30 30 30 36 32 30 30 | 30 30 30 31 30 30 30 30 |00006200|00010000|
|00002e70| 30 30 30 34 37 36 34 35 | 37 34 30 35 32 30 30 30 |00047645|74052000|
|00002e80| 30 32 30 30 30 30 30 30 | 30 30 33 30 33 31 61 64 |02000000|003031ad|
|00002e90| 6d 69 6e 2f 62 73 74 61 | 74 2e 73 71 6c 00 72 65 |min/bsta|t.sql.re|
|00002ea0| 6d 0a 72 65 6d 20 24 48 | 65 61 64 65 72 3a 20 62 |m.rem $H|eader: b|
|00002eb0| 73 74 61 74 2e 73 71 6c | 2c 76 20 36 30 30 32 37 |stat.sql|,v 60027|
|00002ec0| 30 30 2e 31 20 38 39 2f | 30 35 2f 32 33 20 30 30 |00.1 89/|05/23 00|
|00002ed0| 3a 33 39 3a 31 33 20 72 | 63 73 20 45 78 70 20 24 |:39:13 r|cs Exp $|
|00002ee0| 20 62 73 74 61 74 2e 73 | 71 6c 20 43 6f 70 79 72 | bstat.s|ql Copyr|
|00002ef0| 20 28 63 29 20 31 39 38 | 39 20 4f 72 61 63 6c 65 | (c) 198|9 Oracle|
|00002f00| 0a 72 65 6d 0a 52 65 6d | 20 43 6f 70 79 72 69 67 |.rem.Rem| Copyrig|
|00002f10| 68 74 20 28 63 29 20 31 | 39 38 38 20 62 79 20 4f |ht (c) 1|988 by O|
|00002f20| 72 61 63 6c 65 20 43 6f | 72 70 6f 72 61 74 69 6f |racle Co|rporatio|
|00002f30| 6e 0a 52 65 6d 20 4e 41 | 4d 45 0a 52 65 6d 20 20 |n.Rem NA|ME.Rem |
|00002f40| 20 20 3c 6e 61 6d 65 3e | 0a 52 65 6d 20 20 46 55 | <name>|.Rem FU|
|00002f50| 4e 43 54 49 4f 4e 0a 52 | 65 6d 20 20 4e 4f 54 45 |NCTION.R|em NOTE|
|00002f60| 53 0a 52 65 6d 20 20 4d | 4f 44 49 46 49 45 44 0a |S.Rem M|ODIFIED.|
|00002f70| 52 65 6d 20 20 20 4c 6f | 61 69 7a 61 20 20 20 20 |Rem Lo|aiza |
|00002f80| 20 30 34 2f 30 34 2f 38 | 39 20 2d 20 66 69 78 20 | 04/04/8|9 - fix |
|00002f90| 72 75 6e 20 64 61 74 65 | 73 20 74 6f 20 6d 69 6e |run date|s to min|
|00002fa0| 75 74 65 73 20 69 6e 73 | 74 65 61 64 20 6f 66 20 |utes ins|tead of |
|00002fb0| 6d 6f 6e 74 68 73 0a 52 | 65 6d 20 20 20 4d 61 72 |months.R|em Mar|
|00002fc0| 74 69 6e 20 20 20 20 20 | 30 32 2f 32 32 2f 38 39 |tin |02/22/89|
|00002fd0| 20 2d 20 43 72 65 61 74 | 69 6f 6e 0a 52 65 6d 20 | - Creat|ion.Rem |
|00002fe0| 20 20 4a 6c 6f 61 69 7a | 61 20 20 20 20 30 32 2f | Jloaiz|a 02/|
|00002ff0| 32 33 2f 38 39 20 2d 20 | 63 68 61 6e 67 65 64 20 |23/89 - |changed |
|00003000| 74 61 62 6c 65 20 6e 61 | 6d 65 73 2c 20 61 64 64 |table na|mes, add|
|00003010| 65 64 20 64 61 74 65 73 | 2c 20 61 64 64 65 64 20 |ed dates|, added |
|00003020| 70 61 72 61 6d 20 64 75 | 6d 70 0a 52 65 6d 0a 73 |param du|mp.Rem.s|
|00003030| 65 74 20 65 63 68 6f 20 | 6f 6e 3b 0a 63 6f 6e 6e |et echo |on;.conn|
|00003040| 65 63 74 20 69 6e 74 65 | 72 6e 61 6c 3b 0a 64 72 |ect inte|rnal;.dr|
|00003050| 6f 70 20 74 61 62 6c 65 | 20 73 74 61 74 73 24 62 |op table| stats$b|
|00003060| 65 67 69 6e 5f 73 74 61 | 74 73 3b 0a 64 72 6f 70 |egin_sta|ts;.drop|
|00003070| 20 74 61 62 6c 65 20 73 | 74 61 74 73 24 62 65 67 | table s|tats$beg|
|00003080| 69 6e 5f 6c 61 74 63 68 | 3b 0a 64 72 6f 70 20 74 |in_latch|;.drop t|
|00003090| 61 62 6c 65 20 73 74 61 | 74 73 24 62 65 67 69 6e |able sta|ts$begin|
|000030a0| 5f 72 6f 6c 6c 3b 0a 64 | 72 6f 70 20 74 61 62 6c |_roll;.d|rop tabl|
|000030b0| 65 20 73 74 61 74 73 24 | 62 65 67 69 6e 5f 66 69 |e stats$|begin_fi|
|000030c0| 6c 65 3b 0a 64 72 6f 70 | 20 74 61 62 6c 65 20 73 |le;.drop| table s|
|000030d0| 74 61 74 73 24 62 65 67 | 69 6e 5f 6b 71 72 73 74 |tats$beg|in_kqrst|
|000030e0| 3b 0a 64 72 6f 70 20 74 | 61 62 6c 65 20 73 74 61 |;.drop t|able sta|
|000030f0| 74 73 24 64 75 61 6c 3b | 0a 64 72 6f 70 20 74 61 |ts$dual;|.drop ta|
|00003100| 62 6c 65 20 73 74 61 74 | 73 24 64 61 74 65 73 3b |ble stat|s$dates;|
|00003110| 0a 64 72 6f 70 20 76 69 | 65 77 20 73 74 61 74 73 |.drop vi|ew stats|
|00003120| 24 66 69 6c 65 5f 76 69 | 65 77 3b 0a 63 72 65 61 |$file_vi|ew;.crea|
|00003130| 74 65 20 76 69 65 77 20 | 73 74 61 74 73 24 66 69 |te view |stats$fi|
|00003140| 6c 65 5f 76 69 65 77 20 | 61 73 0a 20 20 73 65 6c |le_view |as. sel|
|00003150| 65 63 74 20 74 73 2e 6e | 61 6d 65 20 20 20 20 74 |ect ts.n|ame t|
|00003160| 73 2c 0a 20 20 20 20 20 | 20 20 20 20 69 2e 6b 63 |s,. | i.kc|
|00003170| 66 66 69 6e 61 6d 20 6e | 61 6d 65 2c 0a 20 20 20 |ffinam n|ame,. |
|00003180| 20 20 20 20 20 20 78 2e | 6b 63 66 69 6f 70 79 72 | x.|kcfiopyr|
|00003190| 20 70 79 72 2c 0a 20 20 | 20 20 20 20 20 20 20 78 | pyr,. | x|
|000031a0| 2e 6b 63 66 69 6f 70 79 | 77 20 70 79 77 2c 0a 20 |.kcfiopy|w pyw,. |
|000031b0| 20 20 20 20 20 20 20 20 | 78 2e 6b 63 66 69 6f 70 | |x.kcfiop|
|000031c0| 72 74 20 70 72 74 2c 0a | 20 20 20 20 20 20 20 20 |rt prt,.| |
|000031d0| 20 78 2e 6b 63 66 69 6f | 70 77 74 20 70 77 74 2c | x.kcfio|pwt pwt,|
|000031e0| 0a 20 20 20 20 20 20 20 | 20 20 78 2e 6b 63 66 69 |. | x.kcfi|
|000031f0| 6f 70 62 72 20 70 62 72 | 2c 0a 20 20 20 20 20 20 |opbr pbr|,. |
|00003200| 20 20 20 78 2e 6b 63 66 | 69 6f 70 62 77 20 70 62 | x.kcf|iopbw pb|
|00003210| 77 0a 20 20 66 72 6f 6d | 20 78 24 6b 63 66 69 6f |w. from| x$kcfio|
|00003220| 20 78 2c 20 74 73 24 20 | 74 73 2c 20 78 24 6b 63 | x, ts$ |ts, x$kc|
|00003230| 66 66 69 20 69 2c 66 69 | 6c 65 24 20 66 0a 20 77 |ffi i,fi|le$ f. w|
|00003240| 68 65 72 65 20 69 2e 6b | 63 66 66 69 69 64 6e 3d |here i.k|cffiidn=|
|00003250| 66 2e 66 69 6c 65 23 0a | 20 20 20 61 6e 64 20 74 |f.file#.| and t|
|00003260| 73 2e 74 73 23 3d 66 2e | 74 73 23 0a 20 20 20 61 |s.ts#=f.|ts#. a|
|00003270| 6e 64 20 78 2e 6b 63 66 | 69 6f 66 6e 6f 3d 66 2e |nd x.kcf|iofno=f.|
|00003280| 66 69 6c 65 23 3b 0a 63 | 72 65 61 74 65 20 74 61 |file#;.c|reate ta|
|00003290| 62 6c 65 20 73 74 61 74 | 73 24 62 65 67 69 6e 5f |ble stat|s$begin_|
|000032a0| 6c 61 74 63 68 20 61 73 | 20 73 65 6c 65 63 74 20 |latch as| select |
|000032b0| 2a 20 66 72 6f 6d 20 76 | 24 6c 61 74 63 68 3b 0a |* from v|$latch;.|
|000032c0| 63 72 65 61 74 65 20 74 | 61 62 6c 65 20 73 74 61 |create t|able sta|
|000032d0| 74 73 24 62 65 67 69 6e | 5f 72 6f 6c 6c 20 61 73 |ts$begin|_roll as|
|000032e0| 20 0a 20 20 20 20 73 65 | 6c 65 63 74 20 72 6f 77 | . se|lect row|
|000032f0| 6e 75 6d 20 75 6e 64 6f | 23 2c 72 73 73 69 7a 65 |num undo|#,rssize|
|00003300| 2c 67 65 74 73 2c 77 61 | 69 74 73 2c 77 72 69 74 |,gets,wa|its,writ|
|00003310| 65 73 20 66 72 6f 6d 20 | 76 24 72 6f 6c 6c 73 74 |es from |v$rollst|
|00003320| 61 74 3b 0a 63 72 65 61 | 74 65 20 74 61 62 6c 65 |at;.crea|te table|
|00003330| 20 73 74 61 74 73 24 62 | 65 67 69 6e 5f 66 69 6c | stats$b|egin_fil|
|00003340| 65 20 61 73 20 73 65 6c | 65 63 74 20 2a 20 66 72 |e as sel|ect * fr|
|00003350| 6f 6d 20 73 74 61 74 73 | 24 66 69 6c 65 5f 76 69 |om stats|$file_vi|
|00003360| 65 77 3b 0a 63 72 65 61 | 74 65 20 74 61 62 6c 65 |ew;.crea|te table|
|00003370| 20 73 74 61 74 73 24 62 | 65 67 69 6e 5f 6b 71 72 | stats$b|egin_kqr|
|00003380| 73 74 20 61 73 20 73 65 | 6c 65 63 74 20 2a 20 66 |st as se|lect * f|
|00003390| 72 6f 6d 20 78 24 6b 71 | 72 73 74 3b 0a 63 72 65 |rom x$kq|rst;.cre|
|000033a0| 61 74 65 20 74 61 62 6c | 65 20 73 74 61 74 73 24 |ate tabl|e stats$|
|000033b0| 64 75 61 6c 20 28 63 20 | 6e 75 6d 62 65 72 29 3b |dual (c |number);|
|000033c0| 0a 69 6e 73 65 72 74 20 | 69 6e 74 6f 20 73 74 61 |.insert |into sta|
|000033d0| 74 73 24 64 75 61 6c 20 | 76 61 6c 75 65 73 28 31 |ts$dual |values(1|
|000033e0| 29 3b 0a 63 72 65 61 74 | 65 20 74 61 62 6c 65 20 |);.creat|e table |
|000033f0| 73 74 61 74 73 24 64 61 | 74 65 73 20 28 73 74 61 |stats$da|tes (sta|
|00003400| 74 73 5f 67 61 74 68 65 | 72 5f 74 69 6d 65 73 20 |ts_gathe|r_times |
|00003410| 63 68 61 72 28 31 30 30 | 29 29 3b 0a 69 6e 73 65 |char(100|));.inse|
|00003420| 72 74 20 69 6e 74 6f 20 | 73 74 61 74 73 24 64 61 |rt into |stats$da|
|00003430| 74 65 73 20 0a 20 20 20 | 73 65 6c 65 63 74 20 74 |tes . |select t|
|00003440| 6f 5f 63 68 61 72 28 73 | 79 73 64 61 74 65 2c 20 |o_char(s|ysdate, |
|00003450| 27 64 64 2d 6d 6f 6e 2d | 79 79 20 68 68 3a 6d 69 |'dd-mon-|yy hh:mi|
|00003460| 3a 73 73 27 29 20 66 72 | 6f 6d 20 73 74 61 74 73 |:ss') fr|om stats|
|00003470| 24 64 75 61 6c 3b 0a 0a | 63 72 65 61 74 65 20 74 |$dual;..|create t|
|00003480| 61 62 6c 65 20 73 74 61 | 74 73 24 62 65 67 69 6e |able sta|ts$begin|
|00003490| 5f 73 74 61 74 73 20 61 | 73 20 73 65 6c 65 63 74 |_stats a|s select|
|000034a0| 20 2a 20 66 72 6f 6d 20 | 76 24 73 79 73 73 74 61 | * from |v$syssta|
|000034b0| 74 3b 0a 0a 0a 0a 0a 30 | 37 30 37 30 37 30 30 30 |t;.....0|70707000|
|000034c0| 34 35 30 30 31 30 30 30 | 34 31 30 30 34 34 34 30 |45001000|41004440|
|000034d0| 30 30 33 31 31 30 30 30 | 30 36 32 30 30 30 30 30 |00311000|06200000|
|000034e0| 31 30 30 30 30 30 30 30 | 34 37 36 34 35 37 34 30 |10000000|47645740|
|000034f0| 36 36 30 30 30 30 32 32 | 30 30 30 30 30 35 31 35 |66000022|00000515|
|00003500| 31 35 35 61 64 6d 69 6e | 2f 63 61 74 61 6c 6f 67 |155admin|/catalog|
|00003510| 2e 73 71 6c 00 72 65 6d | 0a 72 65 6d 20 24 48 65 |.sql.rem|.rem $He|
|00003520| 61 64 65 72 3a 20 63 61 | 74 61 6c 6f 67 2e 73 71 |ader: ca|talog.sq|
|00003530| 6c 2c 76 20 36 30 30 32 | 37 30 30 2e 31 20 38 39 |l,v 6002|700.1 89|
|00003540| 2f 30 35 2f 32 32 20 31 | 36 3a 35 36 3a 33 30 20 |/05/22 1|6:56:30 |
|00003550| 72 63 73 20 45 78 70 20 | 24 20 63 61 74 61 6c 6f |rcs Exp |$ catalo|
|00003560| 67 2e 73 71 6c 20 43 6f | 70 79 72 20 28 63 29 20 |g.sql Co|pyr (c) |
|00003570| 31 39 38 39 20 4f 72 61 | 63 6c 65 0a 72 65 6d 0a |1989 Ora|cle.rem.|
|00003580| 72 65 6d 20 52 44 42 4d | 53 36 36 30 30 32 37 2c |rem RDBM|S660027,|
|00003590| 44 49 53 4b 24 44 45 56 | 31 3a 5b 56 36 53 4f 55 |DISK$DEV|1:[V6SOU|
|000035a0| 52 43 45 2e 4f 4c 42 2e | 36 30 30 32 37 5d 0a 52 |RCE.OLB.|60027].R|
|000035b0| 65 6d 20 43 6f 70 79 72 | 69 67 68 74 20 28 63 29 |em Copyr|ight (c)|
|000035c0| 20 31 39 38 38 20 62 79 | 20 4f 72 61 63 6c 65 20 | 1988 by| Oracle |
|000035d0| 43 6f 72 70 6f 72 61 74 | 69 6f 6e 0a 52 65 6d 0a |Corporat|ion.Rem.|
|000035e0| 52 65 6d 20 4e 41 4d 45 | 0a 52 65 6d 20 20 20 43 |Rem NAME|.Rem C|
|000035f0| 41 54 41 4c 4f 47 2e 53 | 51 4c 0a 52 65 6d 20 46 |ATALOG.S|QL.Rem F|
|00003600| 55 4e 43 54 49 4f 4e 0a | 52 65 6d 20 20 20 43 72 |UNCTION.|Rem Cr|
|00003610| 65 61 74 65 73 20 64 61 | 74 61 20 64 69 63 74 69 |eates da|ta dicti|
|00003620| 6f 6e 61 72 79 20 76 69 | 65 77 73 2e 0a 52 65 6d |onary vi|ews..Rem|
|00003630| 20 4e 4f 54 45 53 0a 52 | 65 6d 20 20 20 52 65 70 | NOTES.R|em Rep|
|00003640| 6c 61 63 65 73 20 6f 6c | 64 20 43 41 54 41 4c 4f |laces ol|d CATALO|
|00003650| 47 2e 4f 52 41 2e 0a 52 | 65 6d 20 20 20 4d 75 73 |G.ORA..R|em Mus|
|00003660| 74 20 62 65 20 72 75 6e | 20 77 68 65 6e 20 63 6f |t be run| when co|
|00003670| 6e 6e 65 63 74 65 64 20 | 74 6f 20 53 59 53 2e 0a |nnected |to SYS..|
|00003680| 52 65 6d 20 4d 4f 44 49 | 46 49 45 44 0a 52 65 6d |Rem MODI|FIED.Rem|
|00003690| 20 20 20 57 69 6a 61 79 | 61 20 20 20 20 20 30 35 | Wijay|a 05|
|000036a0| 2f 31 31 2f 38 39 20 2d | 20 61 64 64 20 76 24 72 |/11/89 -| add v$r|
|000036b0| 6f 77 63 61 63 68 65 0a | 52 65 6d 20 20 20 4c 6f |owcache.|Rem Lo|
|000036c0| 61 69 7a 61 20 20 20 20 | 20 30 35 2f 30 35 2f 38 |aiza | 05/05/8|
|000036d0| 39 20 2d 20 61 64 64 20 | 69 6e 64 65 78 20 73 74 |9 - add |index st|
|000036e0| 61 74 69 73 74 69 63 73 | 0a 52 65 6d 20 20 20 4d |atistics|.Rem M|
|000036f0| 65 6e 64 65 6c 73 20 20 | 20 20 31 32 2f 31 32 2f |endels | 12/12/|
|00003700| 38 38 20 2d 20 66 69 78 | 20 31 38 36 35 36 3a 20 |88 - fix| 18656: |
|00003710| 75 73 65 20 53 59 53 2f | 50 55 42 4c 49 43 20 61 |use SYS/|PUBLIC a|
|00003720| 73 20 72 6f 6c 6c 62 61 | 63 6b 20 73 65 67 20 6f |s rollba|ck seg o|
|00003730| 77 6e 65 72 0a 52 65 6d | 20 20 20 42 75 6c 63 68 |wner.Rem| Bulch|
|00003740| 61 6e 20 20 20 20 31 30 | 2f 33 31 2f 38 38 20 2d |an 10|/31/88 -|
|00003750| 20 52 65 6d 6f 76 65 20 | 73 70 75 72 69 6f 75 73 | Remove |spurious|
|00003760| 20 27 30 27 0a 52 65 6d | 20 20 20 4d 65 6e 64 65 | '0'.Rem| Mende|
|00003770| 6c 73 20 20 20 20 31 30 | 2f 32 35 2f 38 38 20 2d |ls 10|/25/88 -|
|00003780| 20 6e 6f 74 20 65 78 69 | 73 74 73 20 65 72 72 6f | not exi|sts erro|
|00003790| 72 73 3a 20 61 64 64 20 | 31 34 31 38 2c 20 31 34 |rs: add |1418, 14|
|000037a0| 33 35 2c 20 32 32 38 39 | 3b 20 64 72 6f 70 20 31 |35, 2289|; drop 1|
|000037b0| 37 31 39 0a 52 65 6d 20 | 20 20 42 75 6c 63 68 61 |719.Rem | Bulcha|
|000037c0| 6e 20 20 20 20 31 30 2f | 32 31 2f 38 38 20 2d 20 |n 10/|21/88 - |
|000037d0| 61 64 64 20 76 69 65 77 | 73 20 66 72 6f 6d 20 6d |add view|s from m|
|000037e0| 6f 6e 20 66 69 6c 65 20 | 61 6e 64 20 72 6f 6c 6c |on file |and roll|
|000037f0| 62 61 63 6b 0a 52 65 6d | 20 20 20 57 69 6a 61 79 |back.Rem| Wijay|
|00003800| 61 20 20 20 20 20 31 30 | 2f 31 37 2f 38 38 20 2d |a 10|/17/88 -|
|00003810| 20 69 6d 70 72 6f 76 65 | 20 63 6f 6e 73 74 72 61 | improve| constra|
|00003820| 69 6e 74 20 76 69 65 77 | 73 0a 52 65 6d 20 20 20 |int view|s.Rem |
|00003830| 57 69 6a 61 79 61 20 20 | 20 20 20 31 30 2f 31 31 |Wijaya | 10/11|
|00003840| 2f 38 38 20 2d 20 61 64 | 64 20 54 41 42 4c 45 5f |/88 - ad|d TABLE_|
|00003850| 4e 41 4d 45 20 63 6f 6c | 75 6d 6e 20 74 6f 20 43 |NAME col|umn to C|
|00003860| 4f 4e 53 5f 43 4f 4c 55 | 4d 4e 53 0a 52 65 6d 20 |ONS_COLU|MNS.Rem |
|00003870| 20 20 4d 65 6e 64 65 6c | 73 20 20 20 20 31 30 2f | Mendel|s 10/|
|00003880| 30 37 2f 38 38 20 2d 20 | 66 69 78 20 70 75 62 6c |07/88 - |fix publ|
|00003890| 69 63 20 73 79 6e 6f 6e | 79 6d 20 66 6f 72 20 61 |ic synon|ym for a|
|000038a0| 6c 6c 5f 73 65 71 75 65 | 6e 63 65 73 2c 20 64 62 |ll_seque|nces, db|
|000038b0| 61 5f 61 75 64 69 74 5f | 64 62 61 0a 52 65 6d 20 |a_audit_|dba.Rem |
|000038c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000038d0| 20 20 20 20 20 20 2d 20 | 64 65 6c 65 74 65 20 75 | - |delete u|
|000038e0| 73 65 72 5f 73 79 73 5f | 61 75 64 5f 6f 70 74 73 |ser_sys_|aud_opts|
|000038f0| 0a 52 65 6d 20 20 20 57 | 69 6a 61 79 61 20 20 20 |.Rem W|ijaya |
|00003900| 20 20 31 30 2f 30 35 2f | 38 38 20 2d 20 61 64 64 | 10/05/|88 - add|
|00003910| 20 5b 55 53 45 52 7c 41 | 4c 4c 7c 44 42 41 5d 5f | [USER|A|LL|DBA]_|
|00003920| 43 4f 4e 53 54 52 41 49 | 4e 54 53 20 61 6e 64 0a |CONSTRAI|NTS and.|
|00003930| 52 65 6d 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |Rem | |
|00003940| 20 20 20 20 20 20 20 20 | 20 20 20 20 5b 55 53 45 | | [USE|
|00003950| 52 7c 41 4c 4c 7c 44 42 | 41 5d 5f 43 4f 4e 53 5f |R|ALL|DB|A]_CONS_|
|00003960| 43 4f 4c 55 4d 4e 53 0a | 52 65 6d 20 20 20 42 75 |COLUMNS.|Rem Bu|
|00003970| 6c 63 68 61 6e 20 20 20 | 20 31 30 2f 30 32 2f 38 |lchan | 10/02/8|
|00003980| 38 20 2d 20 4d 61 6b 65 | 20 69 74 20 77 6f 72 6b |8 - Make| it work|
|00003990| 20 69 6e 20 64 62 73 64 | 72 76 0a 52 65 6d 20 20 | in dbsd|rv.Rem |
|000039a0| 20 57 69 6a 61 79 61 20 | 20 20 20 20 30 39 2f 32 | Wijaya | 09/2|
|000039b0| 39 2f 38 38 20 2d 20 72 | 65 6d 6f 76 65 20 41 43 |9/88 - r|emove AC|
|000039c0| 47 52 41 2c 20 55 43 47 | 52 41 2c 20 55 54 43 4f |GRA, UCG|RA, UTCO|
|000039d0| 4d 0a 52 65 6d 20 20 20 | 48 6f 6e 67 20 20 20 20 |M.Rem |Hong |
|000039e0| 20 20 20 30 39 2f 32 34 | 2f 38 38 20 2d 20 66 69 | 09/24|/88 - fi|
|000039f0| 78 20 65 78 70 6f 72 74 | 20 76 69 65 77 0a 52 65 |x export| view.Re|
|00003a00| 6d 20 20 20 57 69 6a 61 | 79 61 20 20 20 20 20 30 |m Wija|ya 0|
|00003a10| 39 2f 32 32 2f 38 38 20 | 2d 20 66 69 78 20 44 41 |9/22/88 |- fix DA|
|00003a20| 54 41 5f 53 43 41 4c 45 | 0a 52 65 6d 20 20 20 4d |TA_SCALE|.Rem M|
|00003a30| 65 6e 64 65 6c 73 20 20 | 20 20 30 39 2f 30 38 2f |endels | 09/08/|
|00003a40| 38 38 20 2d 20 62 75 67 | 20 31 35 31 33 35 20 28 |88 - bug| 15135 (|
|00003a50| 61 64 64 20 61 63 74 69 | 6f 6e 73 20 33 34 2c 34 |add acti|ons 34,4|
|00003a60| 39 20 74 6f 20 61 75 64 | 69 74 5f 61 63 74 69 6f |9 to aud|it_actio|
|00003a70| 6e 73 29 0a 52 65 6d 20 | 20 20 4d 65 6e 64 65 6c |ns).Rem | Mendel|
|00003a80| 73 20 20 20 20 30 38 2f | 33 30 2f 38 38 20 2d 20 |s 08/|30/88 - |
|00003a90| 66 69 78 20 62 75 67 20 | 31 34 37 37 32 20 28 74 |fix bug |14772 (t|
|00003aa0| 61 62 20 72 65 74 75 72 | 6e 73 20 69 6e 64 65 78 |ab retur|ns index|
|00003ab0| 65 73 29 3b 0a 52 65 6d | 20 20 20 20 20 20 20 20 |es);.Rem| |
|00003ac0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003ad0| 20 72 65 6d 6f 76 65 20 | 77 65 69 72 64 20 74 6f | remove |weird to|
|00003ae0| 5f 64 61 74 65 27 73 20 | 69 6e 20 25 5f 6f 62 6a |_date's |in %_obj|
|00003af0| 65 63 74 73 3b 0a 52 65 | 6d 20 20 20 20 20 20 20 |ects;.Re|m |
|00003b00| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003b10| 20 20 72 65 6d 6f 76 65 | 20 73 6f 6d 65 20 75 73 | remove| some us|
|00003b20| 65 6c 65 73 73 20 28 2b | 29 3b 0a 52 65 6d 20 20 |eless (+|);.Rem |
|00003b30| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003b40| 20 20 20 20 20 20 20 77 | 72 6f 6e 67 20 63 6f 6c | w|rong col|
|00003b50| 75 6d 6e 20 6e 61 6d 65 | 20 69 6e 20 73 6f 6d 65 |umn name| in some|
|00003b60| 20 63 6f 6d 6d 65 6e 74 | 73 20 6f 6e 20 63 6f 6c | comment|s on col|
|00003b70| 75 6d 6e 73 3b 0a 52 65 | 6d 20 20 20 20 20 20 20 |umns;.Re|m |
|00003b80| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003b90| 20 20 72 65 6d 6f 76 65 | 20 74 61 62 73 70 61 63 | remove| tabspac|
|00003ba0| 65 73 20 61 6e 64 20 73 | 79 73 74 61 62 73 70 61 |es and s|ystabspa|
|00003bb0| 63 65 73 20 76 69 65 77 | 73 3b 0a 52 65 6d 20 20 |ces view|s;.Rem |
|00003bc0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003bd0| 20 20 20 20 20 20 20 72 | 65 6e 61 6d 65 20 70 61 | r|ename pa|
|00003be0| 73 73 77 6f 72 64 5f 63 | 68 61 6e 67 65 64 20 74 |ssword_c|hanged t|
|00003bf0| 6f 20 65 78 70 69 72 65 | 73 3b 0a 52 65 6d 20 20 |o expire|s;.Rem |
|00003c00| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003c10| 20 20 20 20 20 20 20 66 | 69 78 20 39 39 38 31 3a | f|ix 9981:|
|00003c20| 20 64 65 63 6f 64 65 20 | 74 79 70 65 20 36 39 20 | decode |type 69 |
|00003c30| 61 73 20 72 6f 77 69 64 | 20 69 6e 20 63 6f 6c 3b |as rowid| in col;|
|00003c40| 0a 52 65 6d 20 20 20 4d | 65 6e 64 65 6c 73 20 20 |.Rem M|endels |
|00003c50| 20 20 30 38 2f 30 37 2f | 38 38 20 2d 20 66 69 78 | 08/07/|88 - fix|
|00003c60| 20 61 6c 6c 2f 64 62 61 | 5f 69 6e 64 65 78 65 73 | all/dba|_indexes|
|00003c70| 20 61 6e 64 20 61 6c 6c | 2f 64 62 61 5f 69 6e 64 | and all|/dba_ind|
|00003c80| 5f 63 6f 6c 75 6d 6e 73 | 20 76 69 65 77 73 0a 52 |_columns| views.R|
|00003c90| 65 6d 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |em | |
|00003ca0| 20 20 20 20 20 20 20 20 | 20 20 20 74 6f 20 72 65 | | to re|
|00003cb0| 74 75 72 6e 20 69 6e 64 | 65 78 65 73 20 6f 6e 20 |turn ind|exes on |
|00003cc0| 70 75 62 6c 69 63 20 74 | 61 62 6c 65 73 3b 0a 52 |public t|ables;.R|
|00003cd0| 65 6d 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |em | |
|00003ce0| 20 20 20 20 20 20 20 20 | 20 20 20 66 69 78 20 25 | | fix %|
|00003cf0| 5f 69 6e 64 5f 63 6f 6c | 75 6d 6e 73 20 76 69 65 |_ind_col|umns vie|
|00003d00| 77 73 20 74 6f 20 75 73 | 65 20 63 6f 6c 23 20 6e |ws to us|e col# n|
|00003d10| 6f 74 20 70 6f 73 23 20 | 61 6e 64 0a 52 65 6d 20 |ot pos# |and.Rem |
|00003d20| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003d30| 20 20 20 20 20 20 20 20 | 74 6f 20 72 65 74 75 72 | |to retur|
|00003d40| 6e 20 70 6f 73 23 0a 52 | 65 6d 20 20 20 20 20 20 |n pos#.R|em |
|00003d50| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003d60| 20 20 20 61 64 64 20 25 | 5f 69 6e 64 65 78 65 73 | add %|_indexes|
|00003d70| 20 63 6f 6d 6d 65 6e 74 | 73 20 6f 6e 20 6d 61 78 | comment|s on max|
|00003d80| 5f 65 78 74 65 6e 74 73 | 2e 0a 52 65 6d 20 20 20 |_extents|..Rem |
|00003d90| 42 61 6c 64 77 69 6e 20 | 20 20 20 30 38 2f 30 31 |Baldwin | 08/01|
|00003da0| 2f 38 38 20 2d 20 42 61 | 64 20 74 61 62 6c 65 20 |/88 - Ba|d table |
|00003db0| 6e 61 6d 65 20 69 6e 20 | 61 6c 6c 5f 69 6e 64 5f |name in |all_ind_|
|00003dc0| 63 6f 6c 75 6d 6e 73 2e | 0a 52 65 6d 20 20 20 20 |columns.|.Rem |
|00003dd0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003de0| 20 20 20 20 20 57 72 6f | 6e 67 20 63 6f 6c 20 6e | Wro|ng col n|
|00003df0| 61 6d 65 20 69 6e 20 63 | 6f 6d 6d 65 6e 74 20 6f |ame in c|omment o|
|00003e00| 6e 20 75 73 65 72 5f 63 | 6c 75 73 74 65 72 2e 0a |n user_c|luster..|
|00003e10| 52 65 6d 20 20 20 42 61 | 6c 64 77 69 6e 20 20 20 |Rem Ba|ldwin |
|00003e20| 20 30 37 2f 33 31 2f 38 | 38 20 2d 20 41 64 64 20 | 07/31/8|8 - Add |
|00003e30| 70 61 73 73 77 6f 72 64 | 5f 63 68 61 6e 67 65 20 |password|_change |
|00003e40| 63 6f 6c 20 74 6f 20 75 | 73 65 72 5f 75 73 65 72 |col to u|ser_user|
|00003e50| 20 61 6e 64 20 64 62 61 | 5f 75 73 65 72 2e 0a 52 | and dba|_user..R|
|00003e60| 65 6d 20 20 20 42 61 6c | 64 77 69 6e 20 20 20 20 |em Bal|dwin |
|00003e70| 30 37 2f 32 38 2f 38 38 | 20 2d 20 45 6e 68 61 6e |07/28/88| - Enhan|
|00003e80| 63 65 20 61 75 64 69 74 | 20 74 72 61 69 6c 20 76 |ce audit| trail v|
|00003e90| 69 65 77 73 2e 20 20 0a | 52 65 6d 20 20 20 20 20 |iews. .|Rem |
|00003ea0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003eb0| 20 20 20 20 53 65 65 20 | 6e 6f 74 65 73 24 3a 61 | See |notes$:a|
|00003ec0| 75 64 69 74 5f 76 69 65 | 77 73 2e 74 78 74 2e 0a |udit_vie|ws.txt..|
|00003ed0| 52 65 6d 20 20 20 50 65 | 65 6c 65 72 20 20 20 20 |Rem Pe|eler |
|00003ee0| 20 30 37 2f 32 37 2f 38 | 38 20 2d 20 4d 69 73 73 | 07/27/8|8 - Miss|
|00003ef0| 69 6e 67 20 27 20 69 6e | 20 75 73 65 72 5f 74 61 |ing ' in| user_ta|
|00003f00| 62 5f 63 6f 6c 75 6d 6e | 73 2c 20 61 63 63 65 73 |b_column|s, acces|
|00003f10| 73 69 62 6c 65 5f 63 6f | 6c 75 6d 6e 73 2e 0a 52 |sible_co|lumns..R|
|00003f20| 65 6d 20 20 20 42 75 6c | 63 68 61 6e 20 20 20 20 |em Bul|chan |
|00003f30| 30 37 2f 32 32 2f 38 38 | 20 2d 20 41 64 64 20 76 |07/22/88| - Add v|
|00003f40| 5f 24 73 67 61 20 73 74 | 75 66 66 0a 52 65 6d 20 |_$sga st|uff.Rem |
|00003f50| 20 20 50 65 65 6c 65 72 | 20 20 20 20 20 30 37 2f | Peeler| 07/|
|00003f60| 32 31 2f 38 38 20 2d 20 | 63 6c 65 61 6e 75 70 20 |21/88 - |cleanup |
|00003f70| 76 61 72 69 6f 75 73 20 | 62 75 67 73 20 69 6e 20 |various |bugs in |
|00003f80| 64 65 66 69 6e 69 74 69 | 6f 6e 73 0a 52 65 6d 20 |definiti|ons.Rem |
|00003f90| 20 20 57 69 6a 61 79 61 | 20 20 20 20 20 30 36 2f | Wijaya| 06/|
|00003fa0| 32 31 2f 38 38 20 2d 20 | 61 64 64 20 50 55 42 4c |21/88 - |add PUBL|
|00003fb0| 49 43 20 73 79 6e 6f 6e | 79 6d 73 2f 76 69 65 77 |IC synon|yms/view|
|00003fc0| 73 20 66 6f 72 20 66 69 | 78 65 64 20 76 69 65 77 |s for fi|xed view|
|00003fd0| 73 0a 52 65 6d 20 20 20 | 4d 6f 6f 72 65 20 20 20 |s.Rem |Moore |
|00003fe0| 20 20 20 30 36 2f 31 36 | 2f 38 38 20 2d 20 66 69 | 06/16|/88 - fi|
|00003ff0| 78 20 6d 69 73 73 69 6e | 67 20 27 20 61 6e 64 20 |x missin|g ' and |
|00004000| 61 73 73 6f 72 74 65 64 | 20 6f 74 68 65 72 20 67 |assorted| other g|
|00004010| 6f 6f 64 69 65 73 0a 52 | 65 6d 20 20 20 4d 6f 6f |oodies.R|em Moo|
|00004020| 72 65 20 20 20 20 20 20 | 30 36 2f 31 36 2f 38 38 |re |06/16/88|
|00004030| 20 2d 20 61 64 64 20 73 | 79 6e 6f 6e 79 6d 20 66 | - add s|ynonym f|
|00004040| 6f 72 20 64 75 61 6c 0a | 52 65 6d 20 20 20 4d 6f |or dual.|Rem Mo|
|00004050| 6f 72 65 20 20 20 20 20 | 20 30 36 2f 30 32 2f 38 |ore | 06/02/8|
|00004060| 38 20 2d 20 61 64 64 20 | 63 6f 6d 6d 65 6e 74 73 |8 - add |comments|
|00004070| 20 74 6f 20 61 75 64 69 | 74 20 76 69 65 77 73 20 | to audi|t views |
|00004080| 28 54 47 52 41 59 53 4f | 4e 29 0a 52 65 6d 20 20 |(TGRAYSO|N).Rem |
|00004090| 20 4d 6f 6f 72 65 20 20 | 20 20 20 20 30 35 2f 33 | Moore | 05/3|
|000040a0| 31 2f 38 38 20 2d 20 61 | 64 64 20 56 35 20 61 75 |1/88 - a|dd V5 au|
|000040b0| 64 69 74 20 76 69 65 77 | 73 0a 52 65 6d 20 20 20 |dit view|s.Rem |
|000040c0| 4d 6f 6f 72 65 20 20 20 | 20 20 20 30 35 2f 31 38 |Moore | 05/18|
|000040d0| 2f 38 38 20 2d 20 69 6e | 74 65 67 72 61 74 65 20 |/88 - in|tegrate |
|000040e0| 6e 65 77 20 73 65 67 6d | 65 6e 74 20 76 69 65 77 |new segm|ent view|
|000040f0| 73 20 28 64 62 61 2c 75 | 73 65 72 29 0a 52 65 6d |s (dba,u|ser).Rem|
|00004100| 20 20 20 57 69 6a 61 79 | 61 20 20 20 20 20 30 34 | Wijay|a 04|
|00004110| 2f 32 39 2f 38 38 20 2d | 20 66 69 78 20 63 6f 6d |/29/88 -| fix com|
|00004120| 6d 65 6e 74 73 0a 52 65 | 6d 20 20 20 4b 61 62 63 |ments.Re|m Kabc|
|00004130| 65 6e 65 6c 6c 20 20 30 | 33 2f 32 31 2f 38 38 20 |enell 0|3/21/88 |
|00004140| 2d 20 64 62 61 5f 65 78 | 70 5f 66 69 6c 65 73 2e |- dba_ex|p_files.|
|00004150| 64 62 61 5f 65 78 70 5f | 76 65 72 73 69 6f 6e 20 |dba_exp_|version |
|00004160| 2d 3e 20 65 78 70 5f 76 | 65 72 73 69 6f 6e 0a 52 |-> exp_v|ersion.R|
|00004170| 65 6d 20 20 20 47 72 61 | 79 73 6f 6e 20 20 20 20 |em Gra|yson |
|00004180| 30 33 2f 32 31 2f 38 38 | 20 2d 20 43 72 65 61 74 |03/21/88| - Creat|
|00004190| 69 6f 6e 0a 0a 0a 72 65 | 6d 61 72 6b 0a 72 65 6d |ion...re|mark.rem|
|000041a0| 61 72 6b 20 20 46 41 4d | 49 4c 59 20 22 41 55 44 |ark FAM|ILY "AUD|
|000041b0| 49 54 22 0a 72 65 6d 61 | 72 6b 20 20 56 69 65 77 |IT".rema|rk View|
|000041c0| 73 20 66 6f 72 20 69 6e | 73 70 65 63 74 69 6e 67 |s for in|specting|
|000041d0| 20 74 68 65 20 61 75 64 | 69 74 20 74 72 61 69 6c | the aud|it trail|
|000041e0| 2e 0a 72 65 6d 61 72 6b | 20 20 46 6f 72 20 76 69 |..remark| For vi|
|000041f0| 65 77 73 20 6f 66 20 74 | 68 65 20 61 75 64 69 74 |ews of t|he audit|
|00004200| 20 6f 70 74 69 6f 6e 73 | 20 73 65 65 20 74 68 65 | options| see the|
|00004210| 20 66 61 6d 69 6c 69 65 | 73 3a 20 74 61 62 5f 61 | familie|s: tab_a|
|00004220| 75 64 69 74 5f 6f 70 74 | 73 2c 0a 72 65 6d 61 72 |udit_opt|s,.remar|
|00004230| 6b 20 20 73 79 73 5f 61 | 75 64 69 74 5f 6f 70 74 |k sys_a|udit_opt|
|00004240| 73 2c 20 61 6e 64 20 64 | 65 66 5f 61 75 64 69 74 |s, and d|ef_audit|
|00004250| 5f 6f 70 74 73 2e 0a 72 | 65 6d 61 72 6b 0a 72 65 |_opts..r|emark.re|
|00004260| 6d 61 72 6b 20 20 55 73 | 65 72 27 73 20 61 72 65 |mark Us|er's are|
|00004270| 20 6e 6f 74 20 61 6c 6c | 6f 77 65 64 20 74 6f 20 | not all|owed to |
|00004280| 73 65 65 20 61 75 64 69 | 74 20 69 6e 66 6f 20 66 |see audi|t info f|
|00004290| 6f 72 20 6f 74 68 65 72 | 20 70 65 6f 70 6c 65 27 |or other| people'|
|000042a0| 73 0a 72 65 6d 61 72 6b | 20 20 6f 62 6a 65 63 74 |s.remark| object|
|000042b0| 73 2c 20 73 6f 20 74 68 | 65 72 65 20 61 72 65 20 |s, so th|ere are |
|000042c0| 6e 6f 20 61 6c 6c 5f 20 | 6d 65 6d 62 65 72 73 20 |no all_ |members |
|000042d0| 69 6e 20 74 68 69 73 20 | 66 61 6d 69 6c 79 2e 0a |in this |family..|
|000042e0| 72 65 6d 61 72 6b 20 20 | 55 73 65 72 73 20 63 61 |remark |Users ca|
|000042f0| 6e 20 73 65 65 20 61 75 | 64 69 74 20 69 6e 66 6f |n see au|dit info|
|00004300| 20 66 6f 72 20 6f 62 6a | 65 63 74 73 20 74 68 65 | for obj|ects the|
|00004310| 79 20 6f 77 6e 2e 0a 72 | 65 6d 61 72 6b 20 20 20 |y own..r|emark |
|00004320| 20 20 20 20 20 20 20 20 | 20 20 20 20 0a 2f 0a 72 | | ./.r|
|00004330| 65 6d 61 72 6b 20 20 0a | 72 65 6d 61 72 6b 20 20 |emark .|remark |
|00004340| 41 55 44 49 54 5f 41 43 | 54 49 4f 4e 53 20 6d 61 |AUDIT_AC|TIONS ma|
|00004350| 70 73 20 61 6e 20 61 63 | 74 69 6f 6e 20 6e 75 6d |ps an ac|tion num|
|00004360| 62 65 72 20 74 6f 20 74 | 68 65 20 61 63 74 69 6f |ber to t|he actio|
|00004370| 6e 20 6e 61 6d 65 2e 0a | 72 65 6d 61 72 6b 20 20 |n name..|remark |
|00004380| 54 68 65 20 74 61 62 6c | 65 20 69 73 20 61 63 63 |The tabl|e is acc|
|00004390| 65 73 73 69 62 6c 65 20 | 74 6f 20 70 75 62 6c 69 |essible |to publi|
|000043a0| 63 2e 0a 72 65 6d 61 72 | 6b 20 20 0a 2f 0a 64 72 |c..remar|k ./.dr|
|000043b0| 6f 70 20 74 61 62 6c 65 | 20 41 55 44 49 54 5f 41 |op table| AUDIT_A|
|000043c0| 43 54 49 4f 4e 53 0a 2f | 0a 63 72 65 61 74 65 20 |CTIONS./|.create |
|000043d0| 74 61 62 6c 65 20 41 55 | 44 49 54 5f 41 43 54 49 |table AU|DIT_ACTI|
|000043e0| 4f 4e 53 28 0a 20 20 61 | 63 74 69 6f 6e 20 6e 75 |ONS(. a|ction nu|
|000043f0| 6d 62 65 72 20 6e 6f 74 | 20 6e 75 6c 6c 2c 20 6e |mber not| null, n|
|00004400| 61 6d 65 20 63 68 61 72 | 28 32 37 29 20 6e 6f 74 |ame char|(27) not|
|00004410| 20 6e 75 6c 6c 29 0a 2f | 0a 63 6f 6d 6d 65 6e 74 | null)./|.comment|
|00004420| 20 6f 6e 20 74 61 62 6c | 65 20 41 55 44 49 54 5f | on tabl|e AUDIT_|
|00004430| 41 43 54 49 4f 4e 53 20 | 69 73 0a 27 44 65 73 63 |ACTIONS |is.'Desc|
|00004440| 72 69 70 74 69 6f 6e 20 | 74 61 62 6c 65 20 66 6f |ription |table fo|
|00004450| 72 20 61 75 64 69 74 20 | 74 72 61 69 6c 20 61 63 |r audit |trail ac|
|00004460| 74 69 6f 6e 20 74 79 70 | 65 20 63 6f 64 65 73 2e |tion typ|e codes.|
|00004470| 20 20 4d 61 70 73 20 61 | 63 74 69 6f 6e 20 74 79 | Maps a|ction ty|
|00004480| 70 65 20 6e 75 6d 62 65 | 72 73 20 74 6f 20 61 63 |pe numbe|rs to ac|
|00004490| 74 69 6f 6e 20 74 79 70 | 65 20 6e 61 6d 65 73 27 |tion typ|e names'|
|000044a0| 0a 2f 0a 63 6f 6d 6d 65 | 6e 74 20 6f 6e 20 63 6f |./.comme|nt on co|
|000044b0| 6c 75 6d 6e 20 41 55 44 | 49 54 5f 41 43 54 49 4f |lumn AUD|IT_ACTIO|
|000044c0| 4e 53 2e 41 43 54 49 4f | 4e 20 69 73 0a 27 4e 75 |NS.ACTIO|N is.'Nu|
|000044d0| 6d 65 72 69 63 20 61 75 | 64 69 74 20 74 72 61 69 |meric au|dit trai|
|000044e0| 6c 20 61 63 74 69 6f 6e | 20 74 79 70 65 20 63 6f |l action| type co|
|000044f0| 64 65 27 0a 2f 0a 63 6f | 6d 6d 65 6e 74 20 6f 6e |de'./.co|mment on|
|00004500| 20 63 6f 6c 75 6d 6e 20 | 41 55 44 49 54 5f 41 43 | column |AUDIT_AC|
|00004510| 54 49 4f 4e 53 2e 4e 41 | 4d 45 20 69 73 0a 27 4e |TIONS.NA|ME is.'N|
|00004520| 61 6d 65 20 6f 66 20 74 | 68 65 20 74 79 70 65 20 |ame of t|he type |
|00004530| 6f 66 20 61 75 64 69 74 | 20 74 72 61 69 6c 20 61 |of audit| trail a|
|00004540| 63 74 69 6f 6e 27 0a 2f | 0a 69 6e 73 65 72 74 20 |ction'./|.insert |
|00004550| 69 6e 74 6f 20 61 75 64 | 69 74 5f 61 63 74 69 6f |into aud|it_actio|
|00004560| 6e 73 20 76 61 6c 75 65 | 73 20 28 30 2c 20 27 55 |ns value|s (0, 'U|
|00004570| 4e 4b 4e 4f 57 4e 27 29 | 3b 0a 69 6e 73 65 72 74 |NKNOWN')|;.insert|
|00004580| 20 69 6e 74 6f 20 61 75 | 64 69 74 5f 61 63 74 69 | into au|dit_acti|
|00004590| 6f 6e 73 20 76 61 6c 75 | 65 73 20 28 31 2c 20 27 |ons valu|es (1, '|
|000045a0| 43 52 45 41 54 45 20 54 | 41 42 4c 45 27 29 3b 0a |CREATE T|ABLE');.|
|000045b0| 69 6e 73 65 72 74 20 69 | 6e 74 6f 20 61 75 64 69 |insert i|nto audi|
|000045c0| 74 5f 61 63 74 69 6f 6e | 73 20 76 61 6c 75 65 73 |t_action|s values|
|000045d0| 20 28 32 2c 20 27 49 4e | 53 45 52 54 27 29 3b 0a | (2, 'IN|SERT');.|
|000045e0| 69 6e 73 65 72 74 20 69 | 6e 74 6f 20 61 75 64 69 |insert i|nto audi|
|000045f0| 74 5f 61 63 74 69 6f 6e | 73 20 76 61 6c 75 65 73 |t_action|s values|
|00004600| 20 28 33 2c 20 27 53 45 | 4c 45 43 54 27 29 3b 0a | (3, 'SE|LECT');.|
|00004610| 69 6e 73 65 72 74 20 69 | 6e 74 6f 20 61 75 64 69 |insert i|nto audi|
|00004620| 74 5f 61 63 74 69 6f 6e | 73 20 76 61 6c 75 65 73 |t_action|s values|
|00004630| 20 28 34 2c 20 27 43 52 | 45 41 54 45 20 43 4c 55 | (4, 'CR|EATE CLU|
|00004640| 53 54 45 52 27 29 3b 0a | 69 6e 73 65 72 74 20 69 |STER');.|insert i|
|00004650| 6e 74 6f 20 61 75 64 69 | 74 5f 61 63 74 69 6f 6e |nto audi|t_action|
|00004660| 73 20 76 61 6c 75 65 73 | 20 28 35 2c 20 27 41 4c |s values| (5, 'AL|
|00004670| 54 45 52 20 43 4c 55 53 | 54 45 52 27 29 3b 0a 69 |TER CLUS|TER');.i|
|00004680| 6e 73 65 72 74 20 69 6e | 74 6f 20 61 75 64 69 74 |nsert in|to audit|
|00004690| 5f 61 63 74 69 6f 6e 73 | 20 76 61 6c 75 65 73 20 |_actions| values |
|000046a0| 28 36 2c 20 27 55 50 44 | 41 54 45 27 29 3b 0a 69 |(6, 'UPD|ATE');.i|
|000046b0| 6e 73 65 72 74 20 69 6e | 74 6f 20 61 75 64 69 74 |nsert in|to audit|
|000046c0| 5f 61 63 74 69 6f 6e 73 | 20 76 61 6c 75 65 73 20 |_actions| values |
|000046d0| 28 37 2c 20 27 44 45 4c | 45 54 45 27 29 3b 0a 69 |(7, 'DEL|ETE');.i|
|000046e0| 6e 73 65 72 74 20 69 6e | 74 6f 20 61 75 64 69 74 |nsert in|to audit|
|000046f0| 5f 61 63 74 69 6f 6e 73 | 20 76 61 6c 75 65 73 20 |_actions| values |
|00004700| 28 38 2c 20 27 44 52 4f | 50 20 43 4c 55 53 54 45 |(8, 'DRO|P CLUSTE|
|00004710| 52 27 29 3b 0a 69 6e 73 | 65 72 74 20 69 6e 74 6f |R');.ins|ert into|
|00004720| 20 61 75 64 69 74 5f 61 | 63 74 69 6f 6e 73 20 76 | audit_a|ctions v|
|00004730| 61 6c 75 65 73 20 28 39 | 2c 20 27 43 52 45 41 54 |alues (9|, 'CREAT|
|00004740| 45 20 49 4e 44 45 58 27 | 29 3b 0a 69 6e 73 65 72 |E INDEX'|);.inser|
|00004750| 74 20 69 6e 74 6f 20 61 | 75 64 69 74 5f 61 63 74 |t into a|udit_act|
|00004760| 69 6f 6e 73 20 76 61 6c | 75 65 73 20 28 31 30 2c |ions val|ues (10,|
|00004770| 20 27 44 52 4f 50 20 49 | 4e 44 45 58 27 29 3b 0a | 'DROP I|NDEX');.|
|00004780| 69 6e 73 65 72 74 20 69 | 6e 74 6f 20 61 75 64 69 |insert i|nto audi|
|00004790| 74 5f 61 63 74 69 6f 6e | 73 20 76 61 6c 75 65 73 |t_action|s values|
|000047a0| 20 28 31 31 2c 20 27 41 | 4c 54 45 52 20 49 4e 44 | (11, 'A|LTER IND|
|000047b0| 45 58 27 29 3b 0a 69 6e | 73 65 72 74 20 69 6e 74 |EX');.in|sert int|
|000047c0| 6f 20 61 75 64 69 74 5f | 61 63 74 69 6f 6e 73 20 |o audit_|actions |
|000047d0| 76 61 6c 75 65 73 20 28 | 31 32 2c 20 27 44 52 4f |values (|12, 'DRO|
|000047e0| 50 20 54 41 42 4c 45 27 | 29 3b 0a 69 6e 73 65 72 |P TABLE'|);.inser|
|000047f0| 74 20 69 6e 74 6f 20 61 | 75 64 69 74 5f 61 63 74 |t into a|udit_act|
|00004800| 69 6f 6e 73 20 76 61 6c | 75 65 73 20 28 31 33 2c |ions val|ues (13,|
|00004810| 20 27 43 52 45 41 54 45 | 20 53 45 51 55 45 4e 43 | 'CREATE| SEQUENC|
|00004820| 45 27 29 3b 0a 69 6e 73 | 65 72 74 20 69 6e 74 6f |E');.ins|ert into|
|00004830| 20 61 75 64 69 74 5f 61 | 63 74 69 6f 6e 73 20 76 | audit_a|ctions v|
|00004840| 61 6c 75 65 73 20 28 31 | 34 2c 20 27 41 4c 54 45 |alues (1|4, 'ALTE|
|00004850| 52 20 53 45 51 55 45 4e | 43 45 27 29 3b 0a 69 6e |R SEQUEN|CE');.in|
|00004860| 73 65 72 74 20 69 6e 74 | 6f 20 61 75 64 69 74 5f |sert int|o audit_|
|00004870| 61 63 74 69 6f 6e 73 20 | 76 61 6c 75 65 73 20 28 |actions |values (|
|00004880| 31 35 2c 20 27 41 4c 54 | 45 52 20 54 41 42 4c 45 |15, 'ALT|ER TABLE|
|00004890| 27 29 3b 0a 69 6e 73 65 | 72 74 20 69 6e 74 6f 20 |');.inse|rt into |
|000048a0| 61 75 64 69 74 5f 61 63 | 74 69 6f 6e 73 20 76 61 |audit_ac|tions va|
|000048b0| 6c 75 65 73 20 28 31 36 | 2c 20 27 44 52 4f 50 20 |lues (16|, 'DROP |
|000048c0| 53 45 51 55 45 4e 43 45 | 27 29 3b 0a 69 6e 73 65 |SEQUENCE|');.inse|
|000048d0| 72 74 20 69 6e 74 6f 20 | 61 75 64 69 74 5f 61 63 |rt into |audit_ac|
|000048e0| 74 69 6f 6e 73 20 76 61 | 6c 75 65 73 20 28 31 37 |tions va|lues (17|
|000048f0| 2c 20 27 47 52 41 4e 54 | 20 4f 42 4a 45 43 54 27 |, 'GRANT| OBJECT'|
|00004900| 29 3b 0a 69 6e 73 65 72 | 74 20 69 6e 74 6f 20 61 |);.inser|t into a|
|00004910| 75 64 69 74 5f 61 63 74 | 69 6f 6e 73 20 76 61 6c |udit_act|ions val|
|00004920| 75 65 73 20 28 31 38 2c | 20 27 52 45 56 4f 4b 45 |ues (18,| 'REVOKE|
|00004930| 20 4f 42 4a 45 43 54 27 | 29 3b 0a 69 6e 73 65 72 | OBJECT'|);.inser|
|00004940| 74 20 69 6e 74 6f 20 61 | 75 64 69 74 5f 61 63 74 |t into a|udit_act|
|00004950| 69 6f 6e 73 20 76 61 6c | 75 65 73 20 28 31 39 2c |ions val|ues (19,|
|00004960| 20 27 43 52 45 41 54 45 | 20 53 59 4e 4f 4e 59 4d | 'CREATE| SYNONYM|
|00004970| 27 29 3b 0a 69 6e 73 65 | 72 74 20 69 6e 74 6f 20 |');.inse|rt into |
|00004980| 61 75 64 69 74 5f 61 63 | 74 69 6f 6e 73 20 76 61 |audit_ac|tions va|
|00004990| 6c 75 65 73 20 28 32 30 | 2c 20 27 44 52 4f 50 20 |lues (20|, 'DROP |
|000049a0| 53 59 4e 4f 4e 59 4d 27 | 29 3b 0a 69 6e 73 65 72 |SYNONYM'|);.inser|
|000049b0| 74 20 69 6e 74 6f 20 61 | 75 64 69 74 5f 61 63 74 |t into a|udit_act|
|000049c0| 69 6f 6e 73 20 76 61 6c | 75 65 73 20 28 32 31 2c |ions val|ues (21,|
|000049d0| 20 27 43 52 45 41 54 45 | 20 56 49 45 57 27 29 3b | 'CREATE| VIEW');|
|000049e0| 0a 69 6e 73 65 72 74 20 | 69 6e 74 6f 20 61 75 64 |.insert |into aud|
|000049f0| 69 74 5f 61 63 74 69 6f | 6e 73 20 76 61 6c 75 65 |it_actio|ns value|
|00004a00| 73 20 28 32 32 2c 20 27 | 44 52 4f 50 20 56 49 45 |s (22, '|DROP VIE|
|00004a10| 57 27 29 3b 0a 69 6e 73 | 65 72 74 20 69 6e 74 6f |W');.ins|ert into|
|00004a20| 20 61 75 64 69 74 5f 61 | 63 74 69 6f 6e 73 20 76 | audit_a|ctions v|
|00004a30| 61 6c 75 65 73 20 28 32 | 33 2c 20 27 56 41 4c 49 |alues (2|3, 'VALI|
|00004a40| 44 41 54 45 20 49 4e 44 | 45 58 27 29 3b 0a 69 6e |DATE IND|EX');.in|
|00004a50| 73 65 72 74 20 69 6e 74 | 6f 20 61 75 64 69 74 5f |sert int|o audit_|
|00004a60| 61 63 74 69 6f 6e 73 20 | 76 61 6c 75 65 73 20 28 |actions |values (|
|00004a70| 32 36 2c 20 27 4c 4f 43 | 4b 27 29 3b 0a 69 6e 73 |26, 'LOC|K');.ins|
|00004a80| 65 72 74 20 69 6e 74 6f | 20 61 75 64 69 74 5f 61 |ert into| audit_a|
|00004a90| 63 74 69 6f 6e 73 20 76 | 61 6c 75 65 73 20 28 32 |ctions v|alues (2|
|00004aa0| 37 2c 20 27 55 4e 44 45 | 46 49 4e 45 44 27 29 3b |7, 'UNDE|FINED');|
|00004ab0| 0a 69 6e 73 65 72 74 20 | 69 6e 74 6f 20 61 75 64 |.insert |into aud|
|00004ac0| 69 74 5f 61 63 74 69 6f | 6e 73 20 76 61 6c 75 65 |it_actio|ns value|
|00004ad0| 73 20 28 32 38 2c 20 27 | 52 45 4e 41 4d 45 27 29 |s (28, '|RENAME')|
|00004ae0| 3b 0a 69 6e 73 65 72 74 | 20 69 6e 74 6f 20 61 75 |;.insert| into au|
|00004af0| 64 69 74 5f 61 63 74 69 | 6f 6e 73 20 76 61 6c 75 |dit_acti|ons valu|
|00004b00| 65 73 20 28 32 39 2c 20 | 27 43 4f 4d 4d 45 4e 54 |es (29, |'COMMENT|
|00004b10| 27 29 3b 0a 69 6e 73 65 | 72 74 20 69 6e 74 6f 20 |');.inse|rt into |
|00004b20| 61 75 64 69 74 5f 61 63 | 74 69 6f 6e 73 20 76 61 |audit_ac|tions va|
|00004b30| 6c 75 65 73 20 28 33 30 | 2c 20 27 41 55 44 49 54 |lues (30|, 'AUDIT|
|00004b40| 20 4f 42 4a 45 43 54 27 | 29 3b 0a 69 6e 73 65 72 | OBJECT'|);.inser|
|00004b50| 74 20 69 6e 74 6f 20 61 | 75 64 69 74 5f 61 63 74 |t into a|udit_act|
|00004b60| 69 6f 6e 73 20 76 61 6c | 75 65 73 20 28 33 31 2c |ions val|ues (31,|
|00004b70| 20 27 4e 4f 41 55 44 49 | 54 20 4f 42 4a 45 43 54 | 'NOAUDI|T OBJECT|
|00004b80| 27 29 3b 0a 69 6e 73 65 | 72 74 20 69 6e 74 6f 20 |');.inse|rt into |
|00004b90| 61 75 64 69 74 5f 61 63 | 74 69 6f 6e 73 20 76 61 |audit_ac|tions va|
|00004ba0| 6c 75 65 73 20 28 33 32 | 2c 20 27 43 52 45 41 54 |lues (32|, 'CREAT|
|00004bb0| 45 20 44 41 54 41 42 41 | 53 45 20 4c 49 4e 4b 27 |E DATABA|SE LINK'|
|00004bc0| 29 3b 0a 69 6e 73 65 72 | 74 20 69 6e 74 6f 20 61 |);.inser|t into a|
|00004bd0| 75 64 69 74 5f 61 63 74 | 69 6f 6e 73 20 76 61 6c |udit_act|ions val|
|00004be0| 75 65 73 20 28 33 33 2c | 20 27 44 52 4f 50 20 44 |ues (33,| 'DROP D|
|00004bf0| 41 54 41 42 41 53 45 20 | 4c 49 4e 4b 27 29 3b 0a |ATABASE |LINK');.|
|00004c00| 69 6e 73 65 72 74 20 69 | 6e 74 6f 20 61 75 64 69 |insert i|nto audi|
|00004c10| 74 5f 61 63 74 69 6f 6e | 73 20 76 61 6c 75 65 73 |t_action|s values|
|00004c20| 20 28 33 34 2c 20 27 43 | 52 45 41 54 45 20 44 41 | (34, 'C|REATE DA|
|00004c30| 54 41 42 41 53 45 27 29 | 3b 0a 69 6e 73 65 72 74 |TABASE')|;.insert|
|00004c40| 20 69 6e 74 6f 20 61 75 | 64 69 74 5f 61 63 74 69 | into au|dit_acti|
|00004c50| 6f 6e 73 20 76 61 6c 75 | 65 73 20 28 33 35 2c 20 |ons valu|es (35, |
|00004c60| 27 41 4c 54 45 52 20 44 | 41 54 41 42 41 53 45 27 |'ALTER D|ATABASE'|
|00004c70| 29 3b 0a 69 6e 73 65 72 | 74 20 69 6e 74 6f 20 61 |);.inser|t into a|
|00004c80| 75 64 69 74 5f 61 63 74 | 69 6f 6e 73 20 76 61 6c |udit_act|ions val|
|00004c90| 75 65 73 20 28 33 36 2c | 20 27 43 52 45 41 54 45 |ues (36,| 'CREATE|
|00004ca0| 20 52 4f 4c 4c 42 41 43 | 4b 20 53 45 47 27 29 3b | ROLLBAC|K SEG');|
|00004cb0| 0a 69 6e 73 65 72 74 20 | 69 6e 74 6f 20 61 75 64 |.insert |into aud|
|00004cc0| 69 74 5f 61 63 74 69 6f | 6e 73 20 76 61 6c 75 65 |it_actio|ns value|
|00004cd0| 73 20 28 33 37 2c 20 27 | 41 4c 54 45 52 20 52 4f |s (37, '|ALTER RO|
|00004ce0| 4c 4c 42 41 43 4b 20 53 | 45 47 27 29 3b 0a 69 6e |LLBACK S|EG');.in|
|00004cf0| 73 65 72 74 20 69 6e 74 | 6f 20 61 75 64 69 74 5f |sert int|o audit_|
|00004d00| 61 63 74 69 6f 6e 73 20 | 76 61 6c 75 65 73 20 28 |actions |values (|
|00004d10| 33 38 2c 20 27 44 52 4f | 50 20 52 4f 4c 4c 42 41 |38, 'DRO|P ROLLBA|
|00004d20| 43 4b 20 53 45 47 27 29 | 3b 0a 69 6e 73 65 72 74 |CK SEG')|;.insert|
|00004d30| 20 69 6e 74 6f 20 61 75 | 64 69 74 5f 61 63 74 69 | into au|dit_acti|
|00004d40| 6f 6e 73 20 76 61 6c 75 | 65 73 20 28 33 39 2c 20 |ons valu|es (39, |
|00004d50| 27 43 52 45 41 54 45 20 | 54 41 42 4c 45 53 50 41 |'CREATE |TABLESPA|
|00004d60| 43 45 27 29 3b 0a 69 6e | 73 65 72 74 20 69 6e 74 |CE');.in|sert int|
|00004d70| 6f 20 61 75 64 69 74 5f | 61 63 74 69 6f 6e 73 20 |o audit_|actions |
|00004d80| 76 61 6c 75 65 73 20 28 | 34 30 2c 20 27 41 4c 54 |values (|40, 'ALT|
|00004d90| 45 52 20 54 41 42 4c 45 | 53 50 41 43 45 27 29 3b |ER TABLE|SPACE');|
|00004da0| 0a 69 6e 73 65 72 74 20 | 69 6e 74 6f 20 61 75 64 |.insert |into aud|
|00004db0| 69 74 5f 61 63 74 69 6f | 6e 73 20 76 61 6c 75 65 |it_actio|ns value|
|00004dc0| 73 20 28 34 31 2c 20 27 | 44 52 4f 50 20 54 41 42 |s (41, '|DROP TAB|
|00004dd0| 4c 45 53 50 41 43 45 27 | 29 3b 0a 69 6e 73 65 72 |LESPACE'|);.inser|
|00004de0| 74 20 69 6e 74 6f 20 61 | 75 64 69 74 5f 61 63 74 |t into a|udit_act|
|00004df0| 69 6f 6e 73 20 76 61 6c | 75 65 73 20 28 34 32 2c |ions val|ues (42,|
|00004e00| 20 27 41 4c 54 45 52 20 | 53 45 53 53 49 4f 4e 27 | 'ALTER |SESSION'|
|00004e10| 29 3b 0a 69 6e 73 65 72 | 74 20 69 6e 74 6f 20 61 |);.inser|t into a|
|00004e20| 75 64 69 74 5f 61 63 74 | 69 6f 6e 73 20 76 61 6c |udit_act|ions val|
|00004e30| 75 65 73 20 28 34 33 2c | 20 27 41 4c 54 45 52 20 |ues (43,| 'ALTER |
|00004e40| 55 53 45 52 27 29 3b 0a | 69 6e 73 65 72 74 20 69 |USER');.|insert i|
|00004e50| 6e 74 6f 20 61 75 64 69 | 74 5f 61 63 74 69 6f 6e |nto audi|t_action|
|00004e60| 73 20 76 61 6c 75 65 73 | 20 28 34 39 2c 20 27 41 |s values| (49, 'A|
|00004e70| 4c 54 45 52 20 53 59 53 | 54 45 4d 27 29 3b 0a 69 |LTER SYS|TEM');.i|
|00004e80| 6e 73 65 72 74 20 69 6e | 74 6f 20 61 75 64 69 74 |nsert in|to audit|
|00004e90| 5f 61 63 74 69 6f 6e 73 | 20 76 61 6c 75 65 73 20 |_actions| values |
|00004ea0| 28 36 30 2c 20 27 4c 4f | 47 4f 4e 27 29 3b 0a 69 |(60, 'LO|GON');.i|
|00004eb0| 6e 73 65 72 74 20 69 6e | 74 6f 20 61 75 64 69 74 |nsert in|to audit|
|00004ec0| 5f 61 63 74 69 6f 6e 73 | 20 76 61 6c 75 65 73 20 |_actions| values |
|00004ed0| 28 36 31 2c 20 27 4c 4f | 47 4f 46 46 27 29 3b 0a |(61, 'LO|GOFF');.|
|00004ee0| 69 6e 73 65 72 74 20 69 | 6e 74 6f 20 61 75 64 69 |insert i|nto audi|
|00004ef0| 74 5f 61 63 74 69 6f 6e | 73 20 76 61 6c 75 65 73 |t_action|s values|
|00004f00| 20 28 36 32 2c 20 27 43 | 4c 45 41 4e 55 50 27 29 | (62, 'C|LEANUP')|
|00004f10| 3b 0a 69 6e 73 65 72 74 | 20 69 6e 74 6f 20 61 75 |;.insert| into au|
|00004f20| 64 69 74 5f 61 63 74 69 | 6f 6e 73 20 76 61 6c 75 |dit_acti|ons valu|
|00004f30| 65 73 20 28 36 33 2c 20 | 27 53 45 53 53 49 4f 4e |es (63, |'SESSION|
|00004f40| 27 29 3b 0a 69 6e 73 65 | 72 74 20 69 6e 74 6f 20 |');.inse|rt into |
|00004f50| 61 75 64 69 74 5f 61 63 | 74 69 6f 6e 73 20 76 61 |audit_ac|tions va|
|00004f60| 6c 75 65 73 20 28 36 34 | 2c 20 27 41 55 44 49 54 |lues (64|, 'AUDIT|
|00004f70| 20 53 59 53 54 45 4d 27 | 29 3b 0a 69 6e 73 65 72 | SYSTEM'|);.inser|
|00004f80| 74 20 69 6e 74 6f 20 61 | 75 64 69 74 5f 61 63 74 |t into a|udit_act|
|00004f90| 69 6f 6e 73 20 76 61 6c | 75 65 73 20 28 36 35 2c |ions val|ues (65,|
|00004fa0| 20 27 4e 4f 41 55 44 49 | 54 20 53 59 53 54 45 4d | 'NOAUDI|T SYSTEM|
|00004fb0| 27 29 3b 0a 69 6e 73 65 | 72 74 20 69 6e 74 6f 20 |');.inse|rt into |
|00004fc0| 61 75 64 69 74 5f 61 63 | 74 69 6f 6e 73 20 76 61 |audit_ac|tions va|
|00004fd0| 6c 75 65 73 20 28 36 36 | 2c 20 27 41 55 44 49 54 |lues (66|, 'AUDIT|
|00004fe0| 20 44 45 46 41 55 4c 54 | 27 29 3b 0a 69 6e 73 65 | DEFAULT|');.inse|
|00004ff0| 72 74 20 69 6e 74 6f 20 | 61 75 64 69 74 5f 61 63 |rt into |audit_ac|
|00005000| 74 69 6f 6e 73 20 76 61 | 6c 75 65 73 20 28 36 37 |tions va|lues (67|
|00005010| 2c 20 27 4e 4f 41 55 44 | 49 54 20 44 45 46 41 55 |, 'NOAUD|IT DEFAU|
|00005020| 4c 54 27 29 3b 0a 69 6e | 73 65 72 74 20 69 6e 74 |LT');.in|sert int|
|00005030| 6f 20 61 75 64 69 74 5f | 61 63 74 69 6f 6e 73 20 |o audit_|actions |
|00005040| 76 61 6c 75 65 73 20 28 | 36 38 2c 20 27 47 52 41 |values (|68, 'GRA|
|00005050| 4e 54 20 53 59 53 54 45 | 4d 27 29 3b 0a 69 6e 73 |NT SYSTE|M');.ins|
|00005060| 65 72 74 20 69 6e 74 6f | 20 61 75 64 69 74 5f 61 |ert into| audit_a|
|00005070| 63 74 69 6f 6e 73 20 76 | 61 6c 75 65 73 20 28 36 |ctions v|alues (6|
|00005080| 39 2c 20 27 52 45 56 4f | 4b 45 20 53 59 53 54 45 |9, 'REVO|KE SYSTE|
|00005090| 4d 27 29 3b 0a 69 6e 73 | 65 72 74 20 69 6e 74 6f |M');.ins|ert into|
|000050a0| 20 61 75 64 69 74 5f 61 | 63 74 69 6f 6e 73 20 76 | audit_a|ctions v|
|000050b0| 61 6c 75 65 73 20 28 37 | 30 2c 20 27 43 52 45 41 |alues (7|0, 'CREA|
|000050c0| 54 45 20 50 55 42 4c 49 | 43 20 53 59 4e 4f 4e 59 |TE PUBLI|C SYNONY|
|000050d0| 4d 27 29 3b 0a 69 6e 73 | 65 72 74 20 69 6e 74 6f |M');.ins|ert into|
|000050e0| 20 61 75 64 69 74 5f 61 | 63 74 69 6f 6e 73 20 76 | audit_a|ctions v|
|000050f0| 61 6c 75 65 73 20 28 37 | 31 2c 20 27 44 52 4f 50 |alues (7|1, 'DROP|
|00005100| 20 50 55 42 4c 49 43 20 | 53 59 4e 4f 4e 59 4d 27 | PUBLIC |SYNONYM'|
|00005110| 29 3b 0a 69 6e 73 65 72 | 74 20 69 6e 74 6f 20 61 |);.inser|t into a|
|00005120| 75 64 69 74 5f 61 63 74 | 69 6f 6e 73 20 76 61 6c |udit_act|ions val|
|00005130| 75 65 73 20 28 37 32 2c | 20 27 43 52 45 41 54 45 |ues (72,| 'CREATE|
|00005140| 20 50 55 42 4c 49 43 20 | 44 41 54 41 42 41 53 45 | PUBLIC |DATABASE|
|00005150| 20 4c 49 4e 4b 27 29 3b | 0a 69 6e 73 65 72 74 20 | LINK');|.insert |
|00005160| 69 6e 74 6f 20 61 75 64 | 69 74 5f 61 63 74 69 6f |into aud|it_actio|
|00005170| 6e 73 20 76 61 6c 75 65 | 73 20 28 37 33 2c 20 27 |ns value|s (73, '|
|00005180| 44 52 4f 50 20 50 55 42 | 4c 49 43 20 44 41 54 41 |DROP PUB|LIC DATA|
|00005190| 42 41 53 45 20 4c 49 4e | 4b 27 29 3b 0a 69 6e 73 |BASE LIN|K');.ins|
|000051a0| 65 72 74 20 69 6e 74 6f | 20 61 75 64 69 74 5f 61 |ert into| audit_a|
|000051b0| 63 74 69 6f 6e 73 20 76 | 61 6c 75 65 73 20 28 38 |ctions v|alues (8|
|000051c0| 30 2c 20 27 55 53 45 52 | 20 43 4f 4d 4d 45 4e 54 |0, 'USER| COMMENT|
|000051d0| 27 29 3b 0a 63 6f 6d 6d | 69 74 3b 0a 63 72 65 61 |');.comm|it;.crea|
|000051e0| 74 65 20 75 6e 69 71 75 | 65 20 69 6e 64 65 78 20 |te uniqu|e index |
|000051f0| 61 75 64 61 63 74 24 75 | 69 64 20 6f 6e 20 61 75 |audact$u|id on au|
|00005200| 64 69 74 5f 61 63 74 69 | 6f 6e 73 28 61 63 74 69 |dit_acti|ons(acti|
|00005210| 6f 6e 2c 6e 61 6d 65 29 | 20 6e 6f 63 6f 6d 70 72 |on,name)| nocompr|
|00005220| 65 73 73 0a 2f 0a 64 72 | 6f 70 20 70 75 62 6c 69 |ess./.dr|op publi|
|00005230| 63 20 73 79 6e 6f 6e 79 | 6d 20 41 55 44 49 54 5f |c synony|m AUDIT_|
|00005240| 41 43 54 49 4f 4e 53 0a | 2f 0a 63 72 65 61 74 65 |ACTIONS.|/.create|
|00005250| 20 70 75 62 6c 69 63 20 | 73 79 6e 6f 6e 79 6d 20 | public |synonym |
|00005260| 41 55 44 49 54 5f 41 43 | 54 49 4f 4e 53 20 66 6f |AUDIT_AC|TIONS fo|
|00005270| 72 20 41 55 44 49 54 5f | 41 43 54 49 4f 4e 53 0a |r AUDIT_|ACTIONS.|
|00005280| 2f 0a 67 72 61 6e 74 20 | 73 65 6c 65 63 74 20 6f |/.grant |select o|
|00005290| 6e 20 41 55 44 49 54 5f | 41 43 54 49 4f 4e 53 20 |n AUDIT_|ACTIONS |
|000052a0| 74 6f 20 70 75 62 6c 69 | 63 0a 2f 0a 0a 72 65 6d |to publi|c./..rem|
|000052b0| 61 72 6b 20 20 0a 72 65 | 6d 61 72 6b 20 20 55 53 |ark .re|mark US|
|000052c0| 45 52 5f 41 55 44 49 54 | 5f 54 52 41 49 4c 0a 72 |ER_AUDIT|_TRAIL.r|
|000052d0| 65 6d 61 72 6b 20 20 54 | 68 65 20 72 61 77 20 61 |emark T|he raw a|
|000052e0| 75 64 69 74 20 74 72 61 | 69 6c 20 6f 66 20 61 6c |udit tra|il of al|
|000052f0| 6c 20 69 6e 66 6f 72 6d | 61 74 69 6f 6e 20 72 65 |l inform|ation re|
|00005300| 6c 61 74 65 64 20 74 6f | 20 74 68 65 20 75 73 65 |lated to| the use|
|00005310| 72 0a 72 65 6d 61 72 6b | 20 20 6f 72 20 74 68 65 |r.remark| or the|
|00005320| 20 6f 62 6a 65 63 74 73 | 20 6f 77 6e 65 64 20 62 | objects| owned b|
|00005330| 79 20 74 68 65 20 75 73 | 65 72 2e 20 20 53 6f 6d |y the us|er. Som|
|00005340| 65 20 63 6f 6c 75 6d 6e | 73 20 61 72 65 20 6f 6e |e column|s are on|
|00005350| 6c 79 20 66 69 6c 6c 65 | 64 0a 72 65 6d 61 72 6b |ly fille|d.remark|
|00005360| 20 20 69 6e 20 62 79 20 | 63 65 72 74 61 69 6e 20 | in by |certain |
|00005370| 73 74 61 74 65 6d 65 6e | 74 73 20 28 65 2e 67 2e |statemen|ts (e.g.|
|00005380| 2c 20 6f 6e 6c 79 20 72 | 65 6e 61 6d 65 20 75 73 |, only r|ename us|
|00005390| 65 73 20 6e 65 77 5f 6e | 61 6d 65 29 2e 0a 72 65 |es new_n|ame)..re|
|000053a0| 6d 61 72 6b 20 20 0a 72 | 65 6d 61 72 6b 20 20 44 |mark .r|emark D|
|000053b0| 42 41 5f 41 55 44 49 54 | 5f 54 52 41 49 4c 20 69 |BA_AUDIT|_TRAIL i|
|000053c0| 73 20 69 6d 70 6c 65 6d | 65 6e 74 65 64 20 61 73 |s implem|ented as|
|000053d0| 20 61 20 73 79 6e 6f 6e | 79 6d 20 66 6f 72 20 75 | a synon|ym for u|
|000053e0| 73 65 72 5f 61 75 64 69 | 74 5f 74 72 61 69 6c 2e |ser_audi|t_trail.|
|000053f0| 0a 72 65 6d 61 72 6b 20 | 20 54 68 69 73 20 6d 65 |.remark | This me|
|00005400| 61 6e 73 20 74 68 61 74 | 20 75 73 65 72 73 20 77 |ans that| users w|
|00005410| 69 74 68 20 64 62 61 20 | 70 72 69 76 69 6c 65 67 |ith dba |privileg|
|00005420| 65 20 68 61 76 65 20 61 | 20 68 61 72 64 20 74 69 |e have a| hard ti|
|00005430| 6d 65 20 76 69 65 77 69 | 6e 67 0a 72 65 6d 61 72 |me viewi|ng.remar|
|00005440| 6b 20 20 74 68 65 20 61 | 75 64 69 74 20 69 6e 66 |k the a|udit inf|
|00005450| 6f 20 66 6f 72 20 6a 75 | 73 74 20 74 68 65 20 6f |o for ju|st the o|
|00005460| 62 6a 65 63 74 73 20 74 | 68 65 79 20 6f 77 6e 20 |bjects t|hey own |
|00005470| 62 65 63 61 75 73 65 20 | 74 68 65 79 20 61 6c 77 |because |they alw|
|00005480| 61 79 73 0a 72 65 6d 61 | 72 6b 20 20 73 65 65 20 |ays.rema|rk see |
|00005490| 61 6c 6c 20 74 68 65 20 | 61 75 64 69 74 20 69 6e |all the |audit in|
|000054a0| 66 6f 2e 20 20 53 69 6d | 70 6c 69 66 79 69 6e 67 |fo. Sim|plifying|
|000054b0| 20 74 68 65 20 69 6d 70 | 6c 65 6d 65 6e 74 61 74 | the imp|lementat|
|000054c0| 69 6f 6e 20 61 6e 64 0a | 72 65 6d 61 72 6b 20 20 |ion and.|remark |
|000054d0| 6d 61 69 6e 74 61 6e 65 | 6e 63 65 20 6f 66 20 74 |maintane|nce of t|
|000054e0| 68 65 73 65 20 76 69 65 | 77 73 20 73 65 65 6d 73 |hese vie|ws seems|
|000054f0| 20 6d 6f 72 65 20 69 6d | 70 6f 72 74 61 6e 74 2e | more im|portant.|
|00005500| 0a 72 65 6d 61 72 6b 20 | 20 41 20 75 73 65 72 20 |.remark | A user |
|00005510| 77 69 74 68 20 64 62 61 | 20 70 72 69 76 69 6c 65 |with dba| privile|
|00005520| 67 65 20 73 65 65 73 20 | 61 6c 6c 20 65 6e 74 72 |ge sees |all entr|
|00005530| 69 65 73 2e 0a 72 65 6d | 61 72 6b 20 20 0a 2f 0a |ies..rem|ark ./.|
|00005540| 64 72 6f 70 20 76 69 65 | 77 20 55 53 45 52 5f 41 |drop vie|w USER_A|
|00005550| 55 44 49 54 5f 54 52 41 | 49 4c 0a 2f 0a 63 72 65 |UDIT_TRA|IL./.cre|
|00005560| 61 74 65 20 76 69 65 77 | 20 55 53 45 52 5f 41 55 |ate view| USER_AU|
|00005570| 44 49 54 5f 54 52 41 49 | 4c 0a 20 20 20 20 20 20 |DIT_TRAI|L. |
|00005580| 20 20 28 0a 20 20 20 20 | 20 20 20 20 20 75 73 65 | (. | use|
|00005590| 72 6e 61 6d 65 2c 20 75 | 73 65 72 68 6f 73 74 2c |rname, u|serhost,|
|000055a0| 20 74 65 72 6d 69 6e 61 | 6c 2c 20 74 69 6d 65 73 | termina|l, times|
|000055b0| 74 61 6d 70 2c 0a 20 20 | 20 20 20 20 20 20 20 6f |tamp,. | o|
|000055c0| 77 6e 65 72 2c 20 6f 62 | 6a 5f 6e 61 6d 65 2c 0a |wner, ob|j_name,.|
|000055d0| 20 20 20 20 20 20 20 20 | 20 61 63 74 69 6f 6e 2c | | action,|
|000055e0| 20 61 63 74 69 6f 6e 5f | 6e 61 6d 65 2c 0a 20 20 | action_|name,. |
|000055f0| 20 20 20 20 20 20 20 6e | 65 77 5f 6e 61 6d 65 2c | n|ew_name,|
|00005600| 0a 20 20 20 20 20 20 20 | 20 20 70 72 69 76 69 6c |. | privil|
|00005610| 65 67 65 2c 20 67 72 61 | 6e 74 65 65 2c 0a 20 20 |ege, gra|ntee,. |
|00005620| 20 20 20 20 20 20 20 73 | 65 73 5f 61 63 74 69 6f | s|es_actio|
|00005630| 6e 73 2c 0a 20 20 20 20 | 20 20 20 20 20 6c 6f 67 |ns,. | log|
|00005640| 6f 66 66 5f 74 69 6d 65 | 2c 20 6c 6f 67 6f 66 66 |off_time|, logoff|
|00005650| 5f 6c 72 65 61 64 2c 20 | 6c 6f 67 6f 66 66 5f 70 |_lread, |logoff_p|
|00005660| 72 65 61 64 2c 20 6c 6f | 67 6f 66 66 5f 6c 77 72 |read, lo|goff_lwr|
|00005670| 69 74 65 2c 20 6c 6f 67 | 6f 66 66 5f 64 6c 6f 63 |ite, log|off_dloc|
|00005680| 6b 2c 0a 20 20 20 20 20 | 20 20 20 20 63 6f 6d 6d |k,. | comm|
|00005690| 65 6e 74 5f 74 65 78 74 | 2c 0a 20 20 20 20 20 20 |ent_text|,. |
|000056a0| 20 20 20 73 65 73 73 69 | 6f 6e 69 64 2c 20 65 6e | sessi|onid, en|
|000056b0| 74 72 79 69 64 2c 20 73 | 74 61 74 65 6d 65 6e 74 |tryid, s|tatement|
|000056c0| 69 64 2c 20 72 65 74 75 | 72 6e 63 6f 64 65 0a 20 |id, retu|rncode. |
|000056d0| 20 20 20 20 20 20 20 29 | 0a 20 61 73 20 0a 20 20 | )|. as . |
|000056e0| 73 65 6c 65 63 74 20 75 | 73 65 72 69 64 2c 20 75 |select u|serid, u|
|000056f0| 73 65 72 68 6f 73 74 2c | 20 74 65 72 6d 69 6e 61 |serhost,| termina|
|00005700| 6c 2c 20 74 69 6d 65 73 | 74 61 6d 70 2c 0a 20 20 |l, times|tamp,. |
|00005710| 20 20 20 20 20 20 20 74 | 2e 6f 62 6a 24 63 72 65 | t|.obj$cre|
|00005720| 61 74 6f 72 2c 20 74 2e | 6f 62 6a 24 6e 61 6d 65 |ator, t.|obj$name|
|00005730| 2c 0a 20 20 20 20 20 20 | 20 20 20 74 2e 61 63 74 |,. | t.act|
|00005740| 69 6f 6e 2c 20 61 63 74 | 2e 6e 61 6d 65 2c 0a 20 |ion, act|.name,. |
|00005750| 20 20 20 20 20 20 20 20 | 6e 65 77 24 6e 61 6d 65 | |new$name|
|00005760| 2c 0a 20 20 20 20 20 20 | 20 20 20 61 75 74 68 24 |,. | auth$|
|00005770| 70 72 69 76 69 6c 65 67 | 65 73 2c 20 61 75 74 68 |privileg|es, auth|
|00005780| 24 67 72 61 6e 74 65 65 | 2c 0a 20 20 20 20 20 20 |$grantee|,. |
|00005790| 20 20 20 73 65 73 24 61 | 63 74 69 6f 6e 73 2c 0a | ses$a|ctions,.|
|000057a0| 20 20 20 20 20 20 20 20 | 20 6c 6f 67 6f 66 66 24 | | logoff$|
|000057b0| 74 69 6d 65 2c 20 6c 6f | 67 6f 66 66 24 6c 72 65 |time, lo|goff$lre|
|000057c0| 61 64 2c 0a 20 20 20 20 | 20 20 20 20 20 6c 6f 67 |ad,. | log|
|000057d0| 6f 66 66 24 70 72 65 61 | 64 2c 20 6c 6f 67 6f 66 |off$prea|d, logof|
|000057e0| 66 24 6c 77 72 69 74 65 | 2c 0a 20 20 20 20 20 20 |f$lwrite|,. |
|000057f0| 20 20 20 6c 6f 67 6f 66 | 66 24 64 65 61 64 2c 0a | logof|f$dead,.|
|00005800| 20 20 20 20 20 20 20 20 | 20 63 6f 6d 6d 65 6e 74 | | comment|
|00005810| 24 74 65 78 74 2c 0a 20 | 20 20 20 20 20 20 20 20 |$text,. | |
|00005820| 73 65 73 73 69 6f 6e 69 | 64 2c 20 65 6e 74 72 79 |sessioni|d, entry|
|00005830| 69 64 2c 20 73 74 61 74 | 65 6d 65 6e 74 2c 20 72 |id, stat|ement, r|
|00005840| 65 74 75 72 6e 63 6f 64 | 65 0a 20 20 66 72 6f 6d |eturncod|e. from|
|00005850| 20 73 79 73 2e 61 75 64 | 24 20 74 2c 20 61 75 64 | sys.aud|$ t, aud|
|00005860| 69 74 5f 61 63 74 69 6f | 6e 73 20 61 63 74 0a 20 |it_actio|ns act. |
|00005870| 20 77 68 65 72 65 20 74 | 2e 61 63 74 69 6f 6e 20 | where t|.action |
|00005880| 3d 20 61 63 74 2e 61 63 | 74 69 6f 6e 0a 20 20 20 |= act.ac|tion. |
|00005890| 20 61 6e 64 20 28 28 74 | 2e 6f 62 6a 24 63 72 65 | and ((t|.obj$cre|
|000058a0| 61 74 6f 72 20 3d 20 75 | 73 65 72 29 0a 20 20 20 |ator = u|ser). |
|000058b0| 20 20 20 20 20 20 6f 72 | 20 28 74 2e 6f 62 6a 24 | or| (t.obj$|
|000058c0| 63 72 65 61 74 6f 72 20 | 69 73 20 6e 75 6c 6c 20 |creator |is null |
|000058d0| 61 6e 64 20 74 2e 75 73 | 65 72 69 64 20 3d 20 75 |and t.us|erid = u|
|000058e0| 73 65 72 29 0a 20 20 20 | 20 20 20 20 20 20 6f 72 |ser). | or|
|000058f0| 20 65 78 69 73 74 73 0a | 20 20 20 20 20 20 20 20 | exists.| |
|00005900| 20 20 20 20 28 73 65 6c | 65 63 74 20 6e 75 6c 6c | (sel|ect null|
|00005910| 20 66 72 6f 6d 20 73 79 | 73 2e 75 73 65 72 24 0a | from sy|s.user$.|
|00005920| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005930| 20 20 77 68 65 72 65 20 | 75 73 65 72 23 20 3d 20 | where |user# = |
|00005940| 75 69 64 20 61 6e 64 20 | 64 62 61 24 20 3d 20 31 |uid and |dba$ = 1|
|00005950| 29 0a 20 20 20 20 20 20 | 20 20 20 29 0a 2f 0a 63 |). | )./.c|
|00005960| 6f 6d 6d 65 6e 74 20 6f | 6e 20 74 61 62 6c 65 20 |omment o|n table |
|00005970| 55 53 45 52 5f 41 55 44 | 49 54 5f 54 52 41 49 4c |USER_AUD|IT_TRAIL|
|00005980| 20 69 73 0a 27 41 75 64 | 69 74 20 74 72 61 69 6c | is.'Aud|it trail|
|00005990| 20 65 6e 74 72 69 65 73 | 20 72 65 6c 65 76 61 6e | entries| relevan|
|000059a0| 74 20 74 6f 20 74 68 65 | 20 75 73 65 72 27 0a 2f |t to the| user'./|
|000059b0| 0a 63 6f 6d 6d 65 6e 74 | 20 6f 6e 20 63 6f 6c 75 |.comment| on colu|
|000059c0| 6d 6e 20 55 53 45 52 5f | 41 55 44 49 54 5f 54 52 |mn USER_|AUDIT_TR|
|000059d0| 41 49 4c 2e 55 53 45 52 | 4e 41 4d 45 20 69 73 0a |AIL.USER|NAME is.|
|000059e0| 27 4e 61 6d 65 20 28 6e | 6f 74 20 49 44 20 6e 75 |'Name (n|ot ID nu|
|000059f0| 6d 62 65 72 29 20 6f 66 | 20 74 68 65 20 75 73 65 |mber) of| the use|
|00005a00| 72 20 77 68 6f 73 65 20 | 61 63 74 69 6f 6e 73 20 |r whose |actions |
|00005a10| 77 65 72 65 20 61 75 64 | 69 74 65 64 27 0a 2f 0a |were aud|ited'./.|
|00005a20| 63 6f 6d 6d 65 6e 74 20 | 6f 6e 20 63 6f 6c 75 6d |comment |on colum|
|00005a30| 6e 20 55 53 45 52 5f 41 | 55 44 49 54 5f 54 52 41 |n USER_A|UDIT_TRA|
|00005a40| 49 4c 2e 55 53 45 52 48 | 4f 53 54 20 69 73 0a 27 |IL.USERH|OST is.'|
|00005a50| 4e 75 6d 65 72 69 63 20 | 69 6e 73 74 61 6e 63 65 |Numeric |instance|
|00005a60| 20 49 44 20 66 6f 72 20 | 74 68 65 20 4f 72 61 63 | ID for |the Orac|
|00005a70| 6c 65 20 69 6e 73 74 61 | 6e 63 65 20 66 72 6f 6d |le insta|nce from|
|00005a80| 20 77 68 69 63 68 20 74 | 68 65 20 75 73 65 72 20 | which t|he user |
|00005a90| 69 73 20 61 63 63 65 73 | 73 69 6e 67 20 74 68 65 |is acces|sing the|
|00005aa0| 20 64 61 74 61 62 61 73 | 65 2e 20 20 55 73 65 64 | databas|e. Used|
|00005ab0| 20 6f 6e 6c 79 20 69 6e | 20 65 6e 76 69 72 6f 6e | only in| environ|
|00005ac0| 6d 65 6e 74 73 20 77 69 | 74 68 20 64 69 73 74 72 |ments wi|th distr|
|00005ad0| 69 62 75 74 65 64 20 66 | 69 6c 65 20 73 79 73 74 |ibuted f|ile syst|
|00005ae0| 65 6d 73 20 61 6e 64 20 | 73 68 61 72 65 64 20 64 |ems and |shared d|
|00005af0| 61 74 61 62 61 73 65 20 | 66 69 6c 65 73 20 28 65 |atabase |files (e|
|00005b00| 2e 67 2e 2c 20 63 6c 75 | 73 74 65 72 65 64 20 4f |.g., clu|stered O|
|00005b10| 72 61 63 6c 65 20 6f 6e | 20 44 45 43 20 56 41 58 |racle on| DEC VAX|
|00005b20| 2f 56 4d 53 20 63 6c 75 | 73 74 65 72 73 29 27 0a |/VMS clu|sters)'.|
|00005b30| 2f 0a 63 6f 6d 6d 65 6e | 74 20 6f 6e 20 63 6f 6c |/.commen|t on col|
|00005b40| 75 6d 6e 20 55 53 45 52 | 5f 41 55 44 49 54 5f 54 |umn USER|_AUDIT_T|
|00005b50| 52 41 49 4c 2e 54 45 52 | 4d 49 4e 41 4c 20 69 73 |RAIL.TER|MINAL is|
|00005b60| 0a 27 49 64 65 6e 74 69 | 66 69 65 72 20 66 6f 72 |.'Identi|fier for|
|00005b70| 20 74 68 65 20 75 73 65 | 72 27 27 73 20 74 65 72 | the use|r''s ter|
|00005b80| 6d 69 6e 61 6c 27 0a 2f | 0a 63 6f 6d 6d 65 6e 74 |minal'./|.comment|
|00005b90| 20 6f 6e 20 63 6f 6c 75 | 6d 6e 20 55 53 45 52 5f | on colu|mn USER_|
|00005ba0| 41 55 44 49 54 5f 54 52 | 41 49 4c 2e 54 49 4d 45 |AUDIT_TR|AIL.TIME|
|00005bb0| 53 54 41 4d 50 20 69 73 | 0a 27 54 69 6d 65 73 74 |STAMP is|.'Timest|
|00005bc0| 61 6d 70 20 66 6f 72 20 | 74 68 65 20 63 72 65 61 |amp for |the crea|
|00005bd0| 74 69 6f 6e 20 6f 66 20 | 74 68 65 20 61 75 64 69 |tion of |the audi|
|00005be0| 74 20 74 72 61 69 6c 20 | 65 6e 74 72 79 20 28 54 |t trail |entry (T|
|00005bf0| 69 6d 65 73 74 61 6d 70 | 20 66 6f 72 20 74 68 65 |imestamp| for the|
|00005c00| 20 75 73 65 72 27 27 73 | 20 6c 6f 67 6f 6e 20 66 | user''s| logon f|
|00005c10| 6f 72 20 65 6e 74 72 69 | 65 73 20 63 72 65 61 74 |or entri|es creat|
|00005c20| 65 64 20 62 79 20 41 55 | 44 49 54 20 43 4f 4e 4e |ed by AU|DIT CONN|
|00005c30| 45 43 54 29 27 0a 2f 0a | 63 6f 6d 6d 65 6e 74 20 |ECT)'./.|comment |
|00005c40| 6f 6e 20 63 6f 6c 75 6d | 6e 20 55 53 45 52 5f 41 |on colum|n USER_A|
|00005c50| 55 44 49 54 5f 54 52 41 | 49 4c 2e 4f 57 4e 45 52 |UDIT_TRA|IL.OWNER|
|00005c60| 20 69 73 0a 27 43 72 65 | 61 74 6f 72 20 6f 66 20 | is.'Cre|ator of |
|00005c70| 6f 62 6a 65 63 74 20 61 | 66 66 65 63 74 65 64 20 |object a|ffected |
|00005c80| 62 79 20 74 68 65 20 61 | 63 74 69 6f 6e 27 0a 2f |by the a|ction'./|
|00005c90| 0a 63 6f 6d 6d 65 6e 74 | 20 6f 6e 20 63 6f 6c 75 |.comment| on colu|
|00005ca0| 6d 6e 20 55 53 45 52 5f | 41 55 44 49 54 5f 54 52 |mn USER_|AUDIT_TR|
|00005cb0| 41 49 4c 2e 4f 42 4a 5f | 4e 41 4d 45 20 69 73 0a |AIL.OBJ_|NAME is.|
|00005cc0| 27 4e 61 6d 65 20 6f 66 | 20 74 68 65 20 6f 62 6a |'Name of| the obj|
|00005cd0| 65 63 74 20 61 66 66 65 | 63 74 65 64 20 62 79 20 |ect affe|cted by |
|00005ce0| 74 68 65 20 61 63 74 69 | 6f 6e 27 0a 2f 0a 63 6f |the acti|on'./.co|
|00005cf0| 6d 6d 65 6e 74 20 6f 6e | 20 63 6f 6c 75 6d 6e 20 |mment on| column |
|00005d00| 55 53 45 52 5f 41 55 44 | 49 54 5f 54 52 41 49 4c |USER_AUD|IT_TRAIL|
|00005d10| 2e 41 43 54 49 4f 4e 20 | 69 73 0a 27 4e 75 6d 65 |.ACTION |is.'Nume|
|00005d20| 72 69 63 20 61 63 74 69 | 6f 6e 20 74 79 70 65 20 |ric acti|on type |
|00005d30| 63 6f 64 65 2e 20 20 54 | 68 65 20 63 6f 72 72 65 |code. T|he corre|
|00005d40| 73 70 6f 6e 64 69 6e 67 | 20 6e 61 6d 65 20 6f 66 |sponding| name of|
|00005d50| 20 74 68 65 20 61 63 74 | 69 6f 6e 20 74 79 70 65 | the act|ion type|
|00005d60| 20 28 43 52 45 41 54 45 | 20 54 41 42 4c 45 2c 20 | (CREATE| TABLE, |
|00005d70| 49 4e 53 45 52 54 2c 20 | 65 74 63 2e 29 20 69 73 |INSERT, |etc.) is|
|00005d80| 20 69 6e 20 74 68 65 20 | 63 6f 6c 75 6d 6e 20 41 | in the |column A|
|00005d90| 43 54 49 4f 4e 5f 4e 41 | 4d 45 27 0a 2f 0a 63 6f |CTION_NA|ME'./.co|
|00005da0| 6d 6d 65 6e 74 20 6f 6e | 20 63 6f 6c 75 6d 6e 20 |mment on| column |
|00005db0| 55 53 45 52 5f 41 55 44 | 49 54 5f 54 52 41 49 4c |USER_AUD|IT_TRAIL|
|00005dc0| 2e 41 43 54 49 4f 4e 5f | 4e 41 4d 45 20 69 73 0a |.ACTION_|NAME is.|
|00005dd0| 27 4e 61 6d 65 20 6f 66 | 20 74 68 65 20 61 63 74 |'Name of| the act|
|00005de0| 69 6f 6e 20 74 79 70 65 | 20 63 6f 72 72 65 73 70 |ion type| corresp|
|00005df0| 6f 6e 64 69 6e 67 20 74 | 6f 20 74 68 65 20 6e 75 |onding t|o the nu|
|00005e00| 6d 65 72 69 63 20 63 6f | 64 65 20 69 6e 20 41 43 |meric co|de in AC|
|00005e10| 54 49 4f 4e 27 0a 2f 0a | 63 6f 6d 6d 65 6e 74 20 |TION'./.|comment |
|00005e20| 6f 6e 20 63 6f 6c 75 6d | 6e 20 55 53 45 52 5f 41 |on colum|n USER_A|
|00005e30| 55 44 49 54 5f 54 52 41 | 49 4c 2e 4e 45 57 5f 4e |UDIT_TRA|IL.NEW_N|
|00005e40| 41 4d 45 20 69 73 0a 27 | 54 68 65 20 6e 65 77 20 |AME is.'|The new |
|00005e50| 6e 61 6d 65 20 6f 66 20 | 61 6e 20 6f 62 6a 65 63 |name of |an objec|
|00005e60| 74 20 72 65 6e 61 6d 65 | 64 20 62 79 20 61 20 52 |t rename|d by a R|
|00005e70| 45 4e 41 4d 45 20 73 74 | 61 74 65 6d 65 6e 74 27 |ENAME st|atement'|
|00005e80| 0a 2f 0a 63 6f 6d 6d 65 | 6e 74 20 6f 6e 20 63 6f |./.comme|nt on co|
|00005e90| 6c 75 6d 6e 20 55 53 45 | 52 5f 41 55 44 49 54 5f |lumn USE|R_AUDIT_|
|00005ea0| 54 52 41 49 4c 2e 50 52 | 49 56 49 4c 45 47 45 20 |TRAIL.PR|IVILEGE |
|00005eb0| 69 73 0a 27 50 72 69 76 | 69 6c 65 67 65 73 20 67 |is.'Priv|ileges g|
|00005ec0| 72 61 6e 74 65 64 2f 72 | 65 76 6f 6b 65 64 20 62 |ranted/r|evoked b|
|00005ed0| 79 20 61 20 47 52 41 4e | 54 2f 52 45 56 4f 4b 45 |y a GRAN|T/REVOKE|
|00005ee0| 20 73 74 61 74 65 6d 65 | 6e 74 27 0a 2f 0a 72 65 | stateme|nt'./.re|
|00005ef0| 6d 61 72 6b 20 20 54 68 | 65 72 65 20 69 73 20 6f |mark Th|ere is o|
|00005f00| 6e 65 20 61 75 64 69 74 | 20 65 6e 74 72 79 20 66 |ne audit| entry f|
|00005f10| 6f 72 20 65 61 63 68 20 | 67 72 61 6e 74 65 65 2e |or each |grantee.|
|00005f20| 0a 2f 0a 63 6f 6d 6d 65 | 6e 74 20 6f 6e 20 63 6f |./.comme|nt on co|
|00005f30| 6c 75 6d 6e 20 55 53 45 | 52 5f 41 55 44 49 54 5f |lumn USE|R_AUDIT_|
|00005f40| 54 52 41 49 4c 2e 47 52 | 41 4e 54 45 45 20 69 73 |TRAIL.GR|ANTEE is|
|00005f50| 0a 27 54 68 65 20 6e 61 | 6d 65 20 6f 66 20 74 68 |.'The na|me of th|
|00005f60| 65 20 67 72 61 6e 74 65 | 65 20 73 70 65 63 69 66 |e grante|e specif|
|00005f70| 69 65 64 20 69 6e 20 61 | 20 47 52 41 4e 54 2f 52 |ied in a| GRANT/R|
|00005f80| 45 56 4f 4b 45 20 73 74 | 61 74 65 6d 65 6e 74 27 |EVOKE st|atement'|
|00005f90| 0a 2f 0a 63 6f 6d 6d 65 | 6e 74 20 6f 6e 20 63 6f |./.comme|nt on co|
|00005fa0| 6c 75 6d 6e 20 55 53 45 | 52 5f 41 55 44 49 54 5f |lumn USE|R_AUDIT_|
|00005fb0| 54 52 41 49 4c 2e 53 45 | 53 5f 41 43 54 49 4f 4e |TRAIL.SE|S_ACTION|
|00005fc0| 53 20 69 73 0a 27 53 65 | 73 73 69 6f 6e 20 73 75 |S is.'Se|ssion su|
|00005fd0| 6d 6d 61 72 79 2e 20 20 | 41 20 73 74 72 69 6e 67 |mmary. |A string|
|00005fe0| 20 6f 66 20 31 31 20 63 | 68 61 72 61 63 74 65 72 | of 11 c|haracter|
|00005ff0| 73 2c 20 6f 6e 65 20 66 | 6f 72 20 65 61 63 68 20 |s, one f|or each |
|00006000| 61 63 74 69 6f 6e 20 74 | 79 70 65 2c 20 69 6e 20 |action t|ype, in |
|00006010| 74 68 69 73 20 6f 72 64 | 65 72 3a 20 41 6c 74 65 |this ord|er: Alte|
|00006020| 72 2c 20 41 75 64 69 74 | 2c 20 43 6f 6d 6d 65 6e |r, Audit|, Commen|
|00006030| 74 2c 20 44 65 6c 65 74 | 65 2c 20 47 72 61 6e 74 |t, Delet|e, Grant|
|00006040| 2c 20 49 6e 64 65 78 2c | 20 49 6e 73 65 72 74 2c |, Index,| Insert,|
|00006050| 20 4c 6f 63 6b 2c 20 52 | 65 6e 61 6d 65 2c 20 53 | Lock, R|ename, S|
|00006060| 65 6c 65 63 74 2c 20 55 | 70 64 61 74 65 2e 20 20 |elect, U|pdate. |
|00006070| 56 61 6c 75 65 73 3a 20 | 20 22 2d 22 20 3d 20 4e |Values: | "-" = N|
|00006080| 6f 6e 65 2c 20 22 53 22 | 20 3d 20 53 75 63 63 65 |one, "S"| = Succe|
|00006090| 73 73 2c 20 22 46 22 20 | 3d 20 46 61 69 6c 75 72 |ss, "F" |= Failur|
|000060a0| 65 2c 20 22 42 22 20 3d | 20 42 6f 74 68 27 0a 2f |e, "B" =| Both'./|
|000060b0| 0a 72 65 6d 61 72 6b 20 | 20 41 20 73 69 6e 67 6c |.remark | A singl|
|000060c0| 65 20 61 75 64 69 74 20 | 65 6e 74 72 79 20 64 65 |e audit |entry de|
|000060d0| 73 63 72 69 62 65 73 20 | 62 6f 74 68 20 74 68 65 |scribes |both the|
|000060e0| 20 6c 6f 67 6f 6e 20 61 | 6e 64 20 6c 6f 67 6f 66 | logon a|nd logof|
|000060f0| 66 2e 0a 72 65 6d 61 72 | 6b 20 20 54 68 65 20 6c |f..remar|k The l|
|00006100| 6f 67 6f 66 66 5f 2a 20 | 63 6f 6c 75 6d 6e 73 20 |ogoff_* |columns |
|00006110| 61 72 65 20 6e 75 6c 6c | 20 77 68 69 6c 65 20 61 |are null| while a|
|00006120| 20 75 73 65 72 20 69 73 | 20 6c 6f 67 67 65 64 20 | user is| logged |
|00006130| 69 6e 2e 0a 2f 0a 63 6f | 6d 6d 65 6e 74 20 6f 6e |in../.co|mment on|
|00006140| 20 63 6f 6c 75 6d 6e 20 | 55 53 45 52 5f 41 55 44 | column |USER_AUD|
|00006150| 49 54 5f 54 52 41 49 4c | 2e 4c 4f 47 4f 46 46 5f |IT_TRAIL|.LOGOFF_|
|00006160| 54 49 4d 45 20 69 73 0a | 27 54 69 6d 65 73 74 61 |TIME is.|'Timesta|
|00006170| 6d 70 20 66 6f 72 20 75 | 73 65 72 20 6c 6f 67 6f |mp for u|ser logo|
|00006180| 66 66 27 0a 2f 0a 63 6f | 6d 6d 65 6e 74 20 6f 6e |ff'./.co|mment on|
|00006190| 20 63 6f 6c 75 6d 6e 20 | 55 53 45 52 5f 41 55 44 | column |USER_AUD|
|000061a0| 49 54 5f 54 52 41 49 4c | 2e 4c 4f 47 4f 46 46 5f |IT_TRAIL|.LOGOFF_|
|000061b0| 4c 52 45 41 44 20 69 73 | 0a 27 4c 6f 67 69 63 61 |LREAD is|.'Logica|
|000061c0| 6c 20 72 65 61 64 73 20 | 66 6f 72 20 74 68 65 20 |l reads |for the |
|000061d0| 73 65 73 73 69 6f 6e 27 | 0a 2f 0a 63 6f 6d 6d 65 |session'|./.comme|
|000061e0| 6e 74 20 6f 6e 20 63 6f | 6c 75 6d 6e 20 55 53 45 |nt on co|lumn USE|
|000061f0| 52 5f 41 55 44 49 54 5f | 54 52 41 49 4c 2e 4c 4f |R_AUDIT_|TRAIL.LO|
|00006200| 47 4f 46 46 5f 50 52 45 | 41 44 20 69 73 0a 27 50 |GOFF_PRE|AD is.'P|
|00006210| 68 79 73 69 63 61 6c 20 | 72 65 61 64 73 20 66 6f |hysical |reads fo|
|00006220| 72 20 74 68 65 20 73 65 | 73 73 69 6f 6e 27 0a 2f |r the se|ssion'./|
|00006230| 0a 63 6f 6d 6d 65 6e 74 | 20 6f 6e 20 63 6f 6c 75 |.comment| on colu|
|00006240| 6d 6e 20 55 53 45 52 5f | 41 55 44 49 54 5f 54 52 |mn USER_|AUDIT_TR|
|00006250| 41 49 4c 2e 4c 4f 47 4f | 46 46 5f 4c 57 52 49 54 |AIL.LOGO|FF_LWRIT|
|00006260| 45 20 69 73 0a 27 4c 6f | 67 69 63 61 6c 20 77 72 |E is.'Lo|gical wr|
|00006270| 69 74 65 73 20 66 6f 72 | 20 74 68 65 20 73 65 73 |ites for| the ses|
|00006280| 73 69 6f 6e 27 0a 2f 0a | 63 6f 6d 6d 65 6e 74 20 |sion'./.|comment |
|00006290| 6f 6e 20 63 6f 6c 75 6d | 6e 20 55 53 45 52 5f 41 |on colum|n USER_A|
|000062a0| 55 44 49 54 5f 54 52 41 | 49 4c 2e 4c 4f 47 4f 46 |UDIT_TRA|IL.LOGOF|
|000062b0| 46 5f 44 4c 4f 43 4b 20 | 69 73 0a 27 44 65 61 64 |F_DLOCK |is.'Dead|
|000062c0| 6c 6f 63 6b 73 20 64 65 | 74 65 63 74 65 64 20 64 |locks de|tected d|
|000062d0| 75 72 69 6e 67 20 74 68 | 65 20 73 65 73 73 69 6f |uring th|e sessio|
|000062e0| 6e 27 0a 2f 0a 63 6f 6d | 6d 65 6e 74 20 6f 6e 20 |n'./.com|ment on |
|000062f0| 63 6f 6c 75 6d 6e 20 55 | 53 45 52 5f 41 55 44 49 |column U|SER_AUDI|
|00006300| 54 5f 54 52 41 49 4c 2e | 43 4f 4d 4d 45 4e 54 5f |T_TRAIL.|COMMENT_|
|00006310| 54 45 58 54 20 69 73 0a | 27 54 65 78 74 20 63 6f |TEXT is.|'Text co|
|00006320| 6d 6d 65 6e 74 20 6f 6e | 20 74 68 65 20 61 75 64 |mment on| the aud|
|00006330| 69 74 20 74 72 61 69 6c | 20 65 6e 74 72 79 27 0a |it trail| entry'.|
|00006340| 2f 0a 63 6f 6d 6d 65 6e | 74 20 6f 6e 20 63 6f 6c |/.commen|t on col|
|00006350| 75 6d 6e 20 55 53 45 52 | 5f 41 55 44 49 54 5f 54 |umn USER|_AUDIT_T|
|00006360| 52 41 49 4c 2e 53 45 53 | 53 49 4f 4e 49 44 20 69 |RAIL.SES|SIONID i|
|00006370| 73 0a 27 4e 75 6d 65 72 | 69 63 20 49 44 20 66 6f |s.'Numer|ic ID fo|
|00006380| 72 20 65 61 63 68 20 4f | 72 61 63 6c 65 20 73 65 |r each O|racle se|
|00006390| 73 73 69 6f 6e 27 0a 2f | 0a 63 6f 6d 6d 65 6e 74 |ssion'./|.comment|
|000063a0| 20 6f 6e 20 63 6f 6c 75 | 6d 6e 20 55 53 45 52 5f | on colu|mn USER_|
|000063b0| 41 55 44 49 54 5f 54 52 | 41 49 4c 2e 45 4e 54 52 |AUDIT_TR|AIL.ENTR|
|000063c0| 59 49 44 20 69 73 0a 27 | 4e 75 6d 65 72 69 63 20 |YID is.'|Numeric |
|000063d0| 49 44 20 66 6f 72 20 65 | 61 63 68 20 61 75 64 69 |ID for e|ach audi|
|000063e0| 74 20 74 72 61 69 6c 20 | 65 6e 74 72 79 20 69 6e |t trail |entry in|
|000063f0| 20 74 68 65 20 73 65 73 | 73 69 6f 6e 27 0a 2f 0a | the ses|sion'./.|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.
