持續更新,檢視dump oracle資料塊檢視
alter system dump datafile 8 block 2523;
Block dump from disk:
buffer tsn: 87 rdba: 0x160dd924 (88/907556)
scn: 0x0d5e.326709f3 seq: 0x01 flg: 0x06 tail: 0x09f30601
frmt: 0x02 chkval: 0x85a7 type: 0x06=trans data
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x0000000034FD7000 to 0x0000000034FD9000
034FD7000 0000A206 160DD924 326709F3 06010D5E [....$.....g2^...]
034FD7010 000085A7 000B0002 000220EF 32670991 [......... ....g2]
034FD7020 1FE80D5E 00321F02 160DC086 00030009 [^.....2.........]
034FD7030 001A9606 00C00329 0001EBE5 0D5EE000 [....).........^.]
034FD7040 32074F49 00100008 0009BD19 00C09379 [IO.2........y...]
034FD7050 00117014 00002001 326709F3 00000000 [.p... ....g2....]
034FD7060 00000000 02800000 00000001 01C800D2 [................]
034FD7070 0ED810A0 00000000 15868B76 15402ABB [........v....*@.]
034FD7080 12CE1400 0F691F64 11421130 10C41154 [....d.i.0.B.T...]
034FD7090 10B21166 118A1178 11AE119C 11D211C0 [f...x...........]
034FD70A0 11F611E4 121A1208 123E122C 125010D6 [........,.>...P.]
034FD70B0 12741262 12981286 12BC12AA 12E012CE [b.t.............]
034FD70C0 130412F2 13281316 134C133A 1370135E [......(.:.L.^.p.]
034FD70D0 13941382 13B813A6 13DC13CA 140013EE [................]
034FD70E0 14241412 14481436 146C145A 1490147E [..$.6.H.Z.l.~...]
034FD70F0 14B414A2 14C610A0 14EA14D8 14FC110C [................]
034FD7100 1520150E 15441532 15681556 158C157A [.. .2.D.V.h.z...]
034FD7110 15B0159E 15D415C2 15F815E6 161C160A [................]
034FD7120 1640162E 16641652 16881676 16AC169A [..@.R.d.v.......]
034FD7130 16D016BE 16F416E2 17181706 173C172A [............*.<.]
034FD7140 1760174E 17841772 17A81796 17CC17BA [N.`.r...........]
034FD7150 17F017DE 18141802 18381826 185C184A [........&.8.J.\.]
034FD7160 1880186E 18A41892 18C818B6 111E18DA [n...............]
034FD7170 18FE18EC 19221910 19461934 196A1958 [......".4.F.X.j.]
034FD7180 198E197C 19B219A0 19D619C4 19FA19E8 [|...............]
034FD7190 1A1E1A0C 1A421A30 1A661A54 1A8A1A78 [....0.B.T.f.x...]
034FD71A0 1AAE1A9C 1AD21AC0 1AF61AE4 1B1A1B08 [................]
034FD71B0 1B3E1B2C 1B621B50 1B861B74 1BAA1B98 [,.>.P.b.t.......]
034FD71C0 1BCE1BBC 1BE010E8 1C041BF2 1C281C16 [..............(.]
034FD71D0 1C4C1C3A 1C701C5E 1C941C82 1CB81CA6 [:.L.^.p.........]
034FD71E0 1CDC1CCA 1D001CEE 1D241D12 1D481D36 [..........$.6.H.]
034FD71F0 1D6C1D5A 1D901D7E 1DB41DA2 1DD81DC6 [Z.l.~...........]
034FD72B0 A3BA2829 2E29C5D0 FF34706D 74689AFF [)(....).mp4...ht]
034FD7300 31333131 34373338 31353035 28293428 [113183745051(4)(]
034FD7310 4358C1D4 3530304A 34342829 31303039 [..XCJ005)(449001]
034FD7320 30303030 32303030 31303938 29342829 [000000028901)(4)]
034FD7330 29313028 28293128 29303030 32373028 [(01)(1)(000)(072]
034FD7340 32302829 292D2829 34383128 BA282935 [)(02)(-)(1845)(.]
034FD7350 29C5D0A3 67706A2E 3101FFFF 01737807 [...).jpg...1.xs.]
034FD7360 3026130F FFFFFFFF FFFFFFFF FFFFFFFF [..&0............]
034FD7370 FFFFFFFF FFFFFFFF FFFFFFFF FFFFFFFF [................]
034FD7380 FFFFFFFF 3001FFFF 2042022C 66616138 [.......0,.B 8aaf]
034FD7390 66383437 65636134 30343737 61343130 [748f4ace7740014a]
034FD73A0 62643265 65356562 62373434 04323002 [e2dbbe5e447b.02.]
034FD73B0 4C72668F 01737807 2A26130D 32363104 [.frL.xs...&*.162]
034FD73C0 37380C35 31303130 30313030 CB1C3030 [5.870101001000..]
034FD73D0 C7C2B5B3 BDFAC1F8 BBC4CEAD C1B7C2AA [................]
034FD73E0 D6ADBDFA C2A7D1D0 0CDABFB7 30393434 [............4490]
034FD73F0 30303130 30303030 31013101 39343412 [01000000.1.1.449]
034FD7400 30313030 30303030 30313030 01393631 [001000000010169.]
034FD7410 6F780731 01010108 01800101 01800132 [1.xo........2...]
034FD7690 29282935 29282928 C3D0D628 4A2E29CB [5)()()()(....).J]
034FD76A0 FFFF4750 78073201 0A0E0173 FFFF0216 [PG...2.xs.......]
034FD76B0 FFFFFFFF FFFFFFFF FFFFFFFF FFFFFFFF [................]
在dump檔案中可以看到此塊中的大致內容,在問題排查中起到了一定的作用。
Block dump from disk:
buffer tsn: 87 rdba: 0x160dd924 (88/907556)
scn: 0x0d5e.326709f3 seq: 0x01 flg: 0x06 tail: 0x09f30601
frmt: 0x02 chkval: 0x85a7 type: 0x06=trans data
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x0000000034FD7000 to 0x0000000034FD9000
034FD7000 0000A206 160DD924 326709F3 06010D5E [....$.....g2^...]
034FD7010 000085A7 000B0002 000220EF 32670991 [......... ....g2]
034FD7020 1FE80D5E 00321F02 160DC086 00030009 [^.....2.........]
034FD7030 001A9606 00C00329 0001EBE5 0D5EE000 [....).........^.]
034FD7040 32074F49 00100008 0009BD19 00C09379 [IO.2........y...]
034FD7050 00117014 00002001 326709F3 00000000 [.p... ....g2....]
034FD7060 00000000 02800000 00000001 01C800D2 [................]
034FD7070 0ED810A0 00000000 15868B76 15402ABB [........v....*@.]
034FD7080 12CE1400 0F691F64 11421130 10C41154 [....d.i.0.B.T...]
034FD7090 10B21166 118A1178 11AE119C 11D211C0 [f...x...........]
034FD70A0 11F611E4 121A1208 123E122C 125010D6 [........,.>...P.]
034FD70B0 12741262 12981286 12BC12AA 12E012CE [b.t.............]
034FD70C0 130412F2 13281316 134C133A 1370135E [......(.:.L.^.p.]
034FD70D0 13941382 13B813A6 13DC13CA 140013EE [................]
034FD70E0 14241412 14481436 146C145A 1490147E [..$.6.H.Z.l.~...]
034FD70F0 14B414A2 14C610A0 14EA14D8 14FC110C [................]
034FD7100 1520150E 15441532 15681556 158C157A [.. .2.D.V.h.z...]
034FD7110 15B0159E 15D415C2 15F815E6 161C160A [................]
034FD7120 1640162E 16641652 16881676 16AC169A [..@.R.d.v.......]
034FD7130 16D016BE 16F416E2 17181706 173C172A [............*.<.]
034FD7140 1760174E 17841772 17A81796 17CC17BA [N.`.r...........]
034FD7150 17F017DE 18141802 18381826 185C184A [........&.8.J.\.]
034FD7160 1880186E 18A41892 18C818B6 111E18DA [n...............]
034FD7170 18FE18EC 19221910 19461934 196A1958 [......".4.F.X.j.]
034FD7180 198E197C 19B219A0 19D619C4 19FA19E8 [|...............]
034FD7190 1A1E1A0C 1A421A30 1A661A54 1A8A1A78 [....0.B.T.f.x...]
034FD71A0 1AAE1A9C 1AD21AC0 1AF61AE4 1B1A1B08 [................]
034FD71B0 1B3E1B2C 1B621B50 1B861B74 1BAA1B98 [,.>.P.b.t.......]
034FD71C0 1BCE1BBC 1BE010E8 1C041BF2 1C281C16 [..............(.]
034FD71D0 1C4C1C3A 1C701C5E 1C941C82 1CB81CA6 [:.L.^.p.........]
034FD71E0 1CDC1CCA 1D001CEE 1D241D12 1D481D36 [..........$.6.H.]
034FD71F0 1D6C1D5A 1D901D7E 1DB41DA2 1DD81DC6 [Z.l.~...........]
034FD72B0 A3BA2829 2E29C5D0 FF34706D 74689AFF [)(....).mp4...ht]
034FD7300 31333131 34373338 31353035 28293428 [113183745051(4)(]
034FD7310 4358C1D4 3530304A 34342829 31303039 [..XCJ005)(449001]
034FD7320 30303030 32303030 31303938 29342829 [000000028901)(4)]
034FD7330 29313028 28293128 29303030 32373028 [(01)(1)(000)(072]
034FD7340 32302829 292D2829 34383128 BA282935 [)(02)(-)(1845)(.]
034FD7350 29C5D0A3 67706A2E 3101FFFF 01737807 [...).jpg...1.xs.]
034FD7360 3026130F FFFFFFFF FFFFFFFF FFFFFFFF [..&0............]
034FD7370 FFFFFFFF FFFFFFFF FFFFFFFF FFFFFFFF [................]
034FD7380 FFFFFFFF 3001FFFF 2042022C 66616138 [.......0,.B 8aaf]
034FD7390 66383437 65636134 30343737 61343130 [748f4ace7740014a]
034FD73A0 62643265 65356562 62373434 04323002 [e2dbbe5e447b.02.]
034FD73B0 4C72668F 01737807 2A26130D 32363104 [.frL.xs...&*.162]
034FD73C0 37380C35 31303130 30313030 CB1C3030 [5.870101001000..]
034FD73D0 C7C2B5B3 BDFAC1F8 BBC4CEAD C1B7C2AA [................]
034FD73E0 D6ADBDFA C2A7D1D0 0CDABFB7 30393434 [............4490]
034FD73F0 30303130 30303030 31013101 39343412 [01000000.1.1.449]
034FD7400 30313030 30303030 30313030 01393631 [001000000010169.]
034FD7410 6F780731 01010108 01800101 01800132 [1.xo........2...]
034FD7690 29282935 29282928 C3D0D628 4A2E29CB [5)()()()(....).J]
034FD76A0 FFFF4750 78073201 0A0E0173 FFFF0216 [PG...2.xs.......]
034FD76B0 FFFFFFFF FFFFFFFF FFFFFFFF FFFFFFFF [................]
在dump檔案中可以看到此塊中的大致內容,在問題排查中起到了一定的作用。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29135257/viewspace-1978474/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle相關資料字典檢視Oracle
- 檢視Oracle各組成部份(如資料塊頭)的大小Oracle
- 檢視oracle資料庫的連線數以及使用者檢視Oracle資料庫
- 檢視oracle資料庫真實大小Oracle資料庫
- Oracle普通檢視和物化檢視的區別Oracle
- 資料庫檢視資料庫
- 檢視資料字典
- 資料庫-檢視資料庫
- EXcel 資料檢視Excel
- Oracle OCP(24):檢視Oracle
- CommMonitor Dump檢視有什麼功能特性?
- Oracle OCP(27):使用資料字典檢視管理物件Oracle物件
- ORACLE資料庫檢視ACQ(ACTIVE CHECKPOINT QUEUE)資訊Oracle資料庫
- laravel 檢視資料共享Laravel
- 檢視oracle臨時表空間佔用率的檢視Oracle
- oracle 檢視錶空間Oracle
- 11、Oracle中的檢視Oracle
- 例項演示oracle資料塊狀態檢視v$bh的用法一 獲取oracle物件所佔用的資料塊Oracle物件
- oracle 統計資訊檢視與收集Oracle
- 資料庫的物化檢視資料庫
- openGausspostgreSQL資料庫效能檢視SQL資料庫
- 資料庫檢視的作用資料庫
- 資料庫檢視的使用資料庫
- 2.12 資料庫資料字典檢視資料庫
- Oracle BLOB型別的資料如何檢視和下載?Oracle型別
- oracle資料庫檢視鎖表的sql語句整理Oracle資料庫SQL
- oracle 歷史檢視檢視,看這一篇就夠了Oracle
- 【TUNE_ORACLE】檢視錶的總塊數SQL參考OracleSQL
- Oracle檢視歷史TOP SQLOracleSQL
- oracle檢視物件DDL語句Oracle物件
- 檢視ORACLE中鎖定物件Oracle物件
- 11 UML中的邏輯檢視、程序檢視、實現檢視、部署檢視
- [Django REST framework - 檢視元件之檢視基類、檢視擴充套件類、檢視子類、檢視集]DjangoRESTFramework元件套件
- vue2.0資料更新,重新渲染檢視的三種方法Vue
- windows10更新記錄檢視方法_win10檢視歷史更新怎麼操作WindowsWin10
- C++檢視資料型別C++資料型別
- sql大資料 基礎(檢視)SQL大資料
- mysql binlog檢視指定資料庫MySql資料庫
- 什麼是資料庫檢視?資料庫