ASSM的L1 L2 L3

最新推荐文章于 2024-07-23 17:52:34 发布
最新推荐文章于 2024-07-23 17:52:34 发布
阅读量141 收藏
点赞数
文章标签： 数据库

SQL> drop tablespace demo including contents and datafiles;

Tablespace dropped.

SQL> create tablespace demo datafile '/u01/app/oracle/oradata/shujukuai/demo01.dbf ' size 5m EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;

Tablespace created.

SQL> create table demotab ( x number ) tablespace demo storage (initial 1000K);

Table created.

SQL> select t.table_name,t.initial_extent,t.next_extent,t.pct_free,t.pct_used from user_tables t where t.table_name = 'DEMOTAB';

TABLE_NAME                     INITIAL_EXTENT NEXT_EXTENT   PCT_FREE   PCT_USED
------------------------------ -------------- ----------- ---------- ----------
DEMOTAB                               1024000                     10


SQL> set serveroutput on
SQL> exec show_space('DEMOTAB');
Unformatted Blocks .....................               0
FS1 Blocks (0-25) ......................               0
FS2 Blocks (25-50) .....................               0
FS3 Blocks (50-75) .....................               0
FS4 Blocks (75-100).....................               0
Full Blocks ............................               0
Total Blocks............................             128
Total Bytes.............................       1,048,576
Total MBytes............................               1
Unused Blocks...........................             125
Unused Bytes............................       1,024,000
Last Used Ext FileId....................               8
Last Used Ext BlockId...................               9
Last Used Block.........................               3

PL/SQL procedure successfully completed.

SQL> col segment_name for a20
SQL> select t.segment_name,t.extent_id,t.block_id from dba_extents t where t.segment_name = 'DEMOTAB';

SEGMENT_NAME          EXTENT_ID   BLOCK_ID
-------------------- ---------- ----------
DEMOTAB                       0          9
DEMOTAB                       1         17
DEMOTAB                       2         25
DEMOTAB                       3         33
DEMOTAB                       4         41
DEMOTAB                       5         49
DEMOTAB                       6         57
DEMOTAB                       7         65
DEMOTAB                       8         73
DEMOTAB                       9         81
DEMOTAB                      10         89

SEGMENT_NAME          EXTENT_ID   BLOCK_ID
-------------------- ---------- ----------
DEMOTAB                      11         97
DEMOTAB                      12        105
DEMOTAB                      13        113
DEMOTAB                      14        121
DEMOTAB                      15        129

16 rows selected.

SQL> oradebug setmypid
Statement processed.
SQL> alter system dump datafile 8 block 9;

System altered.

SQL> alter system dump datafile 8 block 10;

System altered.

SQL> alter system dump datafile 8 block 11;

System altered.

SQL> oradebug tracefile_name
/u01/app/oracle/admin/shujukuai/udump/shujukuai_ora_16798.trc
SQL> host vi /u01/app/oracle/admin/shujukuai/udump/shujukuai_ora_16798.trc
/u01/app/oracle/admin/shujukuai/udump/shujukuai_ora_16798.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1
System name:    Linux
Node name:      RHEL5.4
Release:        2.6.18-164.el5
Version:        #1 SMP Tue Aug 18 15:51:48 EDT 2009
Machine:        x86_64
Instance name: shujukuai
Redo thread mounted by this instance: 1
Oracle process number: 20
Unix process pid: 16798, image: oracle@RHEL5.4 (TNS V1-V3)

*** 2010-06-06 01:56:08.783
*** ACTION NAME:() 2010-06-06 01:56:08.783
*** MODULE NAME:(sqlplus@RHEL5.4 (TNS V1-V3)) 2010-06-06 01:56:08.783
*** SERVICE NAME:(SYS$USERS) 2010-06-06 01:56:08.783
*** SESSION ID:(136.2337) 2010-06-06 01:56:08.783
Start dump data blocks tsn: 9 file#: 8 minblk 9 maxblk 9
buffer tsn: 9 rdba: 0x02000009 (8/9)
scn: 0x0000.000ca54b seq: 0x01 flg: 0x04 tail: 0xa54b2001
frmt: 0x02 chkval: 0x5e5e type: 0x20=FIRST LEVEL BITMAP BLOCK                                    L1位图管理16个块
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x0000000018208600 to 0x000000001820A600
018208600 0000A220 02000009 000CA54B 04010000  [ .......K.......]
018208610 00005E5E 00000000 00000000 00000000  [^^..............]
018208620 00000000 00000000 00000000 00000000  [................]
        Repeat 1 times
018208640 00000000 00000000 00000000 00000004  [................]
018208650 FFFFFFFF 0000000D 00000003 00000010  [................]
018208660 00010002 00000000 00000000 00000000  [................]
018208670 00000000 00000003 00000000 00000000  [................]
018208680 00000000 00000000 00000000 00000000  [................]
018208690 0200000A 00000000 00000000 00000003  [................]
0182086A0 00000008 0200000C 00000000 00000000  [................]
0182086B0 00000000 00000000 00000000 00000001  [................]
0182086C0 0000CA6C 00000000 00000000 02000009  [l...............]
0182086D0 00000008 00000000 02000011 00000008  [................]
0182086E0 00000008 00000000 00000000 00000000  [................]
0182086F0 00000000 00000000 00000000 00000000  [................]
        Repeat 8 times
018208780 00000000 00000000 00000000 00001011  [................]
018208790 00000000 00000000 00000000 00000000  [................]
        Repeat 485 times
01820A5F0 00000000 00000000 00000000 A54B2001  [............. K.]
Dump of First Level Bitmap Block
 --------------------------------
   nbits : 4 nranges: 2         parent dba:  0x0200000a   poffset: 0
   unformatted: 13      total: 16        first useful block: 3
   owning instance : 1
   instance ownership changed at
   Last successful Search
   Freeness Status:  nf1 0      nf2 0      nf3 0      nf4 0

   Extent Map Block Offset: 4294967295
   First free datablock : 3
   Bitmap block lock opcode 0
   Locker xid:     :  0x0000.000.00000000
   Inc #: 0 Objd: 51820
  HWM Flag: HWM Set
      Highwater::  0x0200000c  ext#: 0      blk#: 3      ext size: 8
  #blocks in seg. hdr's freelists: 0
  #blocks below: 0
  mapblk  0x00000000  offset: 0
  --------------------------------------------------------
  DBA Ranges :
  --------------------------------------------------------
   0x02000009  Length: 8      Offset: 0
   0x02000011  Length: 8      Offset: 8

   0:Metadata   1:Metadata   2:Metadata   3:unformatted
   4:unformatted   5:unformatted   6:unformatted   7:unformatted
   8:unformatted   9:unformatted   10:unformatted   11:unformatted
   12:unformatted   13:unformatted   14:unformatted   15:unformatted
  --------------------------------------------------------
End dump data blocks tsn: 9 file#: 8 minblk 9 maxblk 9
Start dump data blocks tsn: 9 file#: 8 minblk 10 maxblk 10
buffer tsn: 9 rdba: 0x0200000a (8/10)
scn: 0x0000.000ca56d seq: 0x01 flg: 0x04 tail: 0xa56d2101
frmt: 0x02 chkval: 0x4d41 type: 0x21=SECOND LEVEL BITMAP BLOCK                             L2位图管理L1位图
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x0000000018208600 to 0x000000001820A600
018208600 0000A221 0200000A 000CA56D 04010000  [!.......m.......]
018208610 00004D41 00000000 00000000 00000000  [AM..............]
018208620 00000000 00000000 00000000 00000000  [................]
        Repeat 1 times
018208640 00000000 00000000 00000000 0200000B  [................]
018208650 00000008 00000008 00000000 00000000  [................]
018208660 00000000 00000000 0000CA6C 00000001  [........l.......]
018208670 00000000 02000009 00010005 02000019  [................]
018208680 00010005 02000029 00010005 02000039  [....).......9...]
018208690 00010005 02000049 00010005 02000059  [....I.......Y...]
0182086A0 00010005 02000069 00010005 02000079  [....i.......y...]
0182086B0 00010005 00000000 00000000 00000000  [................]
0182086C0 00000000 00000000 00000000 00000000  [................]
        Repeat 498 times
01820A5F0 00000000 00000000 00000000 A56D2101  [.............!m.]
Dump of Second Level Bitmap Block
   number: 8       nfree: 8       ffree: 0      pdba:     0x0200000b
   Inc #: 0 Objd: 51820
  opcode:0
 xid:
  L1 Ranges :
  --------------------------------------------------------
   0x02000009  Free: 5 Inst: 1
   0x02000019  Free: 5 Inst: 1
   0x02000029  Free: 5 Inst: 1
   0x02000039  Free: 5 Inst: 1
   0x02000049  Free: 5 Inst: 1
   0x02000059  Free: 5 Inst: 1
   0x02000069  Free: 5 Inst: 1
   0x02000079  Free: 5 Inst: 1

  --------------------------------------------------------
End dump data blocks tsn: 9 file#: 8 minblk 10 maxblk 10
Start dump data blocks tsn: 9 file#: 8 minblk 11 maxblk 11
buffer tsn: 9 rdba: 0x0200000b (8/11)
scn: 0x0000.000ca572 seq: 0x01 flg: 0x04 tail: 0xa5722301
frmt: 0x02 chkval: 0x6315 type: 0x23=PAGETABLE SEGMENT HEADER                               

Hex dump of block: st=0, typ_found=1
Dump of memory from 0x0000000018208600 to 0x000000001820A600
018208600 0000A223 0200000B 000CA572 04010000  [#.......r.......]
018208610 00006315 00000000 00000000 00000000  [.c..............]
018208620 00000000 00000010 00000080 00000A9C  [................]
018208630 00000000 00000003 00000008 0200000C  [................]
018208640 00000000 00000000 00000000 00000000  [................]
        Repeat 1 times
018208660 00000003 00000008 0200000C 00000000  [................]
018208670 00000000 00000000 00000000 02000009  [................]
018208680 02000009 00000000 00000000 00000000  [................]
018208690 00000000 00000000 00000000 00000000  [................]
        Repeat 3 times
0182086D0 00000001 00002000 00000000 00001434  [..... ......4...]
0182086E0 00000000 0200000A 00000001 02000079  [............y...]
0182086F0 0200000A 00000000 00000000 00000000  [................]
018208700 00000000 00000000 00000010 00000000  [................]
018208710 0000CA6C 10000000 02000009 00000008  [l...............]
018208720 02000011 00000008 02000019 00000008  [................]
018208730 02000021 00000008 02000029 00000008  [!.......).......]
018208740 02000031 00000008 02000039 00000008  [1.......9.......]
018208750 02000041 00000008 02000049 00000008  [A.......I.......]
018208760 02000051 00000008 02000059 00000008  [Q.......Y.......]
018208770 02000061 00000008 02000069 00000008  [a.......i.......]
018208780 02000071 00000008 02000079 00000008  [q.......y.......]
018208790 02000081 00000008 00000000 00000000  [................]
0182087A0 00000000 00000000 00000000 00000000  [................]
        Repeat 144 times
0182090B0 02000009 0200000C 02000009 02000011  [................]
0182090C0 02000019 0200001A 02000019 02000021  [............!...]
0182090D0 02000029 0200002A 02000029 02000031  [)...*...)...1...]
0182090E0 02000039 0200003A 02000039 02000041  [9...:...9...A...]
0182090F0 02000049 0200004A 02000049 02000051  [I...J...I...Q...]
018209100 02000059 0200005A 02000059 02000061  [Y...Z...Y...a...]
018209110 02000069 0200006A 02000069 02000071  [i...j...i...q...]
018209120 02000079 0200007A 02000079 02000081  [y...z...y.......]
018209130 00000000 00000000 00000000 00000000  [................]
        Repeat 144 times
018209A40 00000000 00000000 0200000A 00000000  [................]
018209A50 00000000 00000000 00000000 00000000  [................]
        Repeat 185 times
01820A5F0 00000000 00000000 00000000 A5722301  [.............#r.]
  Extent Control Header
  -----------------------------------------------------------------
  Extent Header:: spare1: 0      spare2: 0      #extents: 16     #blocks: 128
                  last map  0x00000000  #maps: 0      offset: 2716
      Highwater::  0x0200000c  ext#: 0      blk#: 3      ext size: 8
  #blocks in seg. hdr's freelists: 0
  #blocks below: 0
  mapblk  0x00000000  offset: 0
                   Unlocked
  --------------------------------------------------------
  Low HighWater Mark :
      Highwater::  0x0200000c  ext#: 0      blk#: 3      ext size: 8
  #blocks in seg. hdr's freelists: 0
  #blocks below: 0
  mapblk  0x00000000  offset: 0
  Level 1 BMB for High HWM block: 0x02000009
  Level 1 BMB for Low HWM block: 0x02000009
  --------------------------------------------------------
 mapblk  0x00000000  offset: 0
                   Unlocked
  --------------------------------------------------------
  Low HighWater Mark :
      Highwater::  0x0200000c  ext#: 0      blk#: 3      ext size: 8
  #blocks in seg. hdr's freelists: 0
  #blocks below: 0
  mapblk  0x00000000  offset: 0
  Level 1 BMB for High HWM block: 0x02000009
  Level 1 BMB for Low HWM block: 0x02000009
  --------------------------------------------------------
  Segment Type: 1 nl2: 1      blksz: 8192   fbsz: 0
  L2 Array start offset:  0x00001434
  First Level 3 BMB:  0x00000000
  L2 Hint for inserts:  0x0200000a
  Last Level 1 BMB:  0x02000079
  Last Level II BMB:  0x0200000a
  Last Level III BMB:  0x00000000
     Map Header:: next  0x00000000  #extents: 16   obj#: 51820  flag: 0x10000000
  Inc # 0
  Extent Map
  -----------------------------------------------------------------
   0x02000009  length: 8
   0x02000011  length: 8
   0x02000019  length: 8
   0x02000021  length: 8
   0x02000029  length: 8
   0x02000031  length: 8
   0x02000039  length: 8
   0x02000041  length: 8
   0x02000049  length: 8
   0x02000051  length: 8
   0x02000059  length: 8
   0x02000061  length: 8
   0x02000069  length: 8
   0x02000071  length: 8
   0x02000079  length: 8
   0x02000081  length: 8

  Auxillary Map
  --------------------------------------------------------
   Extent 0     :  L1 dba:  0x02000009 Data dba:  0x0200000c
   Extent 1     :  L1 dba:  0x02000009 Data dba:  0x02000011
   Extent 2     :  L1 dba:  0x02000019 Data dba:  0x0200001a
   Extent 3     :  L1 dba:  0x02000019 Data dba:  0x02000021
   Extent 4     :  L1 dba:  0x02000029 Data dba:  0x0200002a
   Extent 5     :  L1 dba:  0x02000029 Data dba:  0x02000031
   Extent 6     :  L1 dba:  0x02000039 Data dba:  0x0200003a
   Extent 7     :  L1 dba:  0x02000039 Data dba:  0x02000041
   Extent 8     :  L1 dba:  0x02000049 Data dba:  0x0200004a
   Extent 9     :  L1 dba:  0x02000049 Data dba:  0x02000051
   Extent 10    :  L1 dba:  0x02000059 Data dba:  0x0200005a
   Extent 11    :  L1 dba:  0x02000059 Data dba:  0x02000061
   Extent 12    :  L1 dba:  0x02000069 Data dba:  0x0200006a
   Extent 13    :  L1 dba:  0x02000069 Data dba:  0x02000071
   Extent 14    :  L1 dba:  0x02000079 Data dba:  0x0200007a
   Extent 15    :  L1 dba:  0x02000079 Data dba:  0x02000081
  --------------------------------------------------------

   Second Level Bitmap block DBAs
 --------------------------------------------------------
   DBA 1:   0x0200000a

End dump data blocks tsn: 9 file#: 8 minblk 11 maxblk 11

 
EYGLE画的图。借过来用一下
 

SQL> insert into demotab select 123345 from dba_objects;

50047 rows created.

SQL> insert into demotab select 123345 from dba_objects;

50047 rows created.

SQL> insert into demotab select 123345 from dba_objects;

50047 rows created.

SQL> insert into demotab select 123345 from dba_objects;

50047 rows created.

SQL> insert into demotab select 123345 from dba_objects;

50047 rows created.

SQL> insert into demotab select 123345 from dba_objects;

50047 rows created.


SQL> commit;

Commit complete.

SQL> select count(*) from demotab ;

  COUNT(*)
----------
    300282

SQL> exec show_space('DEMOTAB');
Unformatted Blocks .....................               0
FS1 Blocks (0-25) ......................               1
FS2 Blocks (25-50) .....................               0
FS3 Blocks (50-75) .....................               0
FS4 Blocks (75-100).....................              41
Full Blocks ............................             454
Total Blocks............................             512
Total Bytes.............................       4,194,304
Total MBytes............................               4
Unused Blocks...........................               0
Unused Bytes............................               0
Last Used Ext FileId....................               8
Last Used Ext BlockId...................             393
Last Used Block.........................             128

PL/SQL procedure successfully completed.

SQL> oradebug setmypid
Statement processed.
SQL> alter system dump datafile 8 block 9;

System altered.

SQL> alter system dump datafile 8 block 10;

System altered.

SQL> alter system dump datafile 8 block 11;

System altered.

SQL> oradebug tracefile_name
/u01/app/oracle/admin/shujukuai/udump/shujukuai_ora_19148.trc
SQL> host vi /u01/app/oracle/admin/shujukuai/udump/shujukuai_ora_19148.trc
/u01/app/oracle/admin/shujukuai/udump/shujukuai_ora_19148.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1
System name:    Linux
Node name:      RHEL5.4
Release:        2.6.18-164.el5
Version:        #1 SMP Tue Aug 18 15:51:48 EDT 2009
Machine:        x86_64
Instance name: shujukuai
Redo thread mounted by this instance: 1
Oracle process number: 19
Unix process pid: 19148, image: oracle@RHEL5.4 (TNS V1-V3)

*** 2010-06-06 06:47:45.912
*** ACTION NAME:() 2010-06-06 06:47:45.912
*** MODULE NAME:(sqlplus@RHEL5.4 (TNS V1-V3)) 2010-06-06 06:47:45.912
*** SERVICE NAME:(SYS$USERS) 2010-06-06 06:47:45.912
*** SESSION ID:(136.2339) 2010-06-06 06:47:45.912
Start dump data blocks tsn: 9 file#: 8 minblk 9 maxblk 9
buffer tsn: 9 rdba: 0x02000009 (8/9)
scn: 0x0000.000caec0 seq: 0x02 flg: 0x04 tail: 0xaec02002
frmt: 0x02 chkval: 0x4c57 type: 0x20=FIRST LEVEL BITMAP BLOCK
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x00000000183BA600 to 0x00000000183BC600
0183BA600 0000A220 02000009 000CAEC0 04020000  [ ...............]
0183BA610 00004C57 00000000 00000000 00000000  [WL..............]
0183BA620 00000000 00000000 00000000 00000000  [................]
        Repeat 1 times
0183BA640 00000000 00000000 00000000 00000004  [................]
0183BA650 FFFFFFFF 00000000 00000003 00000010  [................]
0183BA660 00010002 00000000 00000000 00000000  [................]
0183BA670 00000000 00000010 4C0B3BB7 4C0B3BB7  [.........;.L.;.L]
0183BA680 00000000 00000000 00000000 00000000  [................]
0183BA690 0200000A 00000000 00000000 00000000  [................]
0183BA6A0 00000000 00000000 00000000 00000000  [................]
        Repeat 1 times
0183BA6C0 0000CA6C 00000000 00000000 02000009  [l...............]
0183BA6D0 00000008 00000000 02000011 00000008  [................]
0183BA6E0 00000008 00000000 00000000 00000000  [................]
0183BA6F0 00000000 00000000 00000000 00000000  [................]
        Repeat 8 times
0183BA780 00000000 00000000 00000000 11111111  [................]
0183BA790 11111111 00000000 00000000 00000000  [................]
0183BA7A0 00000000 00000000 00000000 00000000  [................]
        Repeat 484 times
0183BC5F0 00000000 00000000 00000000 AEC02002  [............. ..]
Dump of First Level Bitmap Block
 --------------------------------
   nbits : 4 nranges: 2         parent dba:  0x0200000a   poffset: 0
   unformatted: 0       total: 16        first useful block: 3
   owning instance : 1
   instance ownership changed at 06/06/2010 02:09:59
   Last successful Search 06/06/2010 02:09:59
   Freeness Status:  nf1 0      nf2 0      nf3 0      nf4 0

   Extent Map Block Offset: 4294967295
   First free datablock : 16
   Bitmap block lock opcode 0
   Locker xid:     :  0x0000.000.00000000
   Inc #: 0 Objd: 51820
  --------------------------------------------------------
  DBA Ranges :
  --------------------------------------------------------
   0x02000009  Length: 8      Offset: 0
   0x02000011  Length: 8      Offset: 8

   0:Metadata   1:Metadata   2:Metadata   3:FULL
   4:FULL   5:FULL   6:FULL   7:FULL
   8:FULL   9:FULL   10:FULL   11:FULL
   12:FULL   13:FULL   14:FULL   15:FULL
  --------------------------------------------------------
End dump data blocks tsn: 9 file#: 8 minblk 9 maxblk 9
Start dump data blocks tsn: 9 file#: 8 minblk 10 maxblk 10
buffer tsn: 9 rdba: 0x0200000a (8/10)
scn: 0x0000.000caf68 seq: 0x04 flg: 0x04 tail: 0xaf682104
frmt: 0x02 chkval: 0x4d44 type: 0x21=SECOND LEVEL BITMAP BLOCK
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x00000000183BA600 to 0x00000000183BC600
0183BA600 0000A221 0200000A 000CAF68 04040000  [!.......h.......]
0183BA610 00004D44 00000000 00000000 00000000  [DM..............]
0183BA620 00000000 00000000 00000000 00000000  [................]
        Repeat 1 times
0183BA640 00000000 00000000 00000000 0200000B  [................]
0183BA650 0000000E 00000001 0000000D 00000000  [................]
0183BA660 00000000 00000000 0000CA6C 00000001  [........l.......]
0183BA670 00000000 02000009 00010001 02000019  [................]
0183BA680 00010001 02000029 00010001 02000039  [....).......9...]
0183BA690 00010001 02000049 00010001 02000059  [....I.......Y...]
0183BA6A0 00010001 02000069 00010001 02000079  [....i.......y...]
0183BA6B0 00010001 02000089 00010001 0200008A  [................]
0183BA6C0 00010001 02000109 00010001 0200010A  [................]
0183BA6D0 00010001 02000189 00010001 0200018A  [................]
0183BA6E0 00010005 00000000 00000000 00000000  [................]
0183BA6F0 00000000 00000000 00000000 00000000  [................]
        Repeat 495 times
0183BC5F0 00000000 00000000 00000000 AF682104  [.............!h.]
Dump of Second Level Bitmap Block
   number: 14      nfree: 1       ffree: 13     pdba:     0x0200000b
   Inc #: 0 Objd: 51820
  opcode:0
 xid:
  L1 Ranges :
  --------------------------------------------------------
   0x02000009  Free: 1 Inst: 1                                                                    free=1表示已经使用了
   0x02000019  Free: 1 Inst: 1
   0x02000029  Free: 1 Inst: 1
   0x02000039  Free: 1 Inst: 1
   0x02000049  Free: 1 Inst: 1
   0x02000059  Free: 1 Inst: 1
   0x02000069  Free: 1 Inst: 1
   0x02000079  Free: 1 Inst: 1
   0x02000089  Free: 1 Inst: 1
   0x0200008a  Free: 1 Inst: 1
   0x02000109  Free: 1 Inst: 1
   0x0200010a  Free: 1 Inst: 1
   0x02000189  Free: 1 Inst: 1
   0x0200018a  Free: 5 Inst: 1                                                                          L2块已经由8块增加到了12块

  --------------------------------------------------------
End dump data blocks tsn: 9 file#: 8 minblk 10 maxblk 10
Start dump data blocks tsn: 9 file#: 8 minblk 11 maxblk 11
buffer tsn: 9 rdba: 0x0200000b (8/11)
scn: 0x0000.000caf6d seq: 0x02 flg: 0x04 tail: 0xaf6d2302
frmt: 0x02 chkval: 0x611d type: 0x23=PAGETABLE SEGMENT HEADER
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x00000000183BA600 to 0x00000000183BC600
0183BA600 0000A223 0200000B 000CAF6D 04020000  [#.......m.......]
0183BA610 0000611D 00000000 00000000 00000000  [.a..............]
0183BA620 00000000 00000013 00000200 00000A9C  [................]
0183BA630 00000012 00000080 00000080 02000209  [................]
0183BA640 00000000 00000012 00000000 000001F0  [................]
0183BA650 00000000 00000000 00000000 00000012  [................]
0183BA660 00000080 00000080 02000209 00000000  [................]
0183BA670 00000012 00000000 00000200 0200018A  [................]
0183BA680 0200018A 00000000 00000000 00000000  [................]
0183BA690 00000000 00000000 00000000 00000000  [................]
        Repeat 3 times
0183BA6D0 00000001 00002000 00000000 00001434  [..... ......4...]
0183BA6E0 00000000 0200000A 00000001 0200018A  [................]
0183BA6F0 0200000A 00000000 00000000 00000000  [................]
0183BA700 00000000 00000000 00000013 00000000  [................]
0183BA710 0000CA6C 10000000 02000009 00000008  [l...............]
0183BA720 02000011 00000008 02000019 00000008  [................]
0183BA730 02000021 00000008 02000029 00000008  [!.......).......]
0183BA740 02000031 00000008 02000039 00000008  [1.......9.......]
0183BA750 02000041 00000008 02000049 00000008  [A.......I.......]
0183BA760 02000051 00000008 02000059 00000008  [Q.......Y.......]
0183BA770 02000061 00000008 02000069 00000008  [a.......i.......]
0183BA780 02000071 00000008 02000079 00000008  [q.......y.......]
0183BA790 02000081 00000008 02000089 00000080  [................]
0183BA7A0 02000109 00000080 02000189 00000080  [................]
0183BA7B0 00000000 00000000 00000000 00000000  [................]
        Repeat 143 times
0183BB0B0 02000009 0200000C 02000009 02000011  [................]
0183BB0C0 02000019 0200001A 02000019 02000021  [............!...]
0183BB0D0 02000029 0200002A 02000029 02000031  [)...*...)...1...]
0183BB0E0 02000039 0200003A 02000039 02000041  [9...:...9...A...]
0183BB0F0 02000049 0200004A 02000049 02000051  [I...J...I...Q...]
0183BB100 02000059 0200005A 02000059 02000061  [Y...Z...Y...a...]
0183BB110 02000069 0200006A 02000069 02000071  [i...j...i...q...]
0183BB120 02000079 0200007A 02000079 02000081  [y...z...y.......]
0183BB130 02000089 0200008B 02000109 0200010B  [................]
0183BB140 02000189 0200018B 00000000 00000000  [................]
0183BB150 00000000 00000000 00000000 00000000  [................]
        Repeat 142 times
0183BBA40 00000000 00000000 0200000A 00000000  [................]
0183BBA50 00000000 00000000 00000000 00000000  [................]
        Repeat 185 times
0183BC5F0 00000000 00000000 00000000 AF6D2302  [.............#m.]
  Extent Control Header
  -----------------------------------------------------------------
  Extent Header:: spare1: 0      spare2: 0      #extents: 19     #blocks: 512
                  last map  0x00000000  #maps: 0      offset: 2716
      Highwater::  0x02000209  ext#: 18     blk#: 128    ext size: 128
  #blocks in seg. hdr's freelists: 0
  #blocks below: 496
  mapblk  0x00000000  offset: 18
                   Unlocked
  --------------------------------------------------------
      Highwater::  0x02000209  ext#: 18     blk#: 128    ext size: 128
  #blocks in seg. hdr's freelists: 0
  #blocks below: 512
  mapblk  0x00000000  offset: 18
  Level 1 BMB for High HWM block: 0x0200018a
  Level 1 BMB for Low HWM block: 0x0200018a
  --------------------------------------------------------
  Segment Type: 1 nl2: 1      blksz: 8192   fbsz: 0
  L2 Array start offset:  0x00001434
  First Level 3 BMB:  0x00000000
  L2 Hint for inserts:  0x0200000a
  Last Level 1 BMB:  0x0200018a
  Last Level II BMB:  0x0200000a
  Last Level III BMB:  0x00000000
     Map Header:: next  0x00000000  #extents: 19   obj#: 51820  flag: 0x10000000
  Inc # 0
  Extent Map
  -----------------------------------------------------------------
   0x02000009  length: 8
   0x02000011  length: 8
   0x02000019  length: 8
   0x02000021  length: 8
   0x02000029  length: 8
   0x02000031  length: 8
   0x02000039  length: 8
   0x02000041  length: 8
   0x02000049  length: 8
   0x02000051  length: 8
   0x02000059  length: 8
   0x02000061  length: 8
   0x02000069  length: 8
   0x02000071  length: 8
   0x02000079  length: 8
   0x02000081  length: 8
   0x02000089  length: 128
   0x02000109  length: 128
   0x02000189  length: 128

  Auxillary Map
  --------------------------------------------------------
   Extent 0     :  L1 dba:  0x02000009 Data dba:  0x0200000c
   Extent 1     :  L1 dba:  0x02000009 Data dba:  0x02000011
   Extent 2     :  L1 dba:  0x02000019 Data dba:  0x0200001a
   Extent 3     :  L1 dba:  0x02000019 Data dba:  0x02000021
   Extent 4     :  L1 dba:  0x02000029 Data dba:  0x0200002a
   Extent 5     :  L1 dba:  0x02000029 Data dba:  0x02000031
   Extent 6     :  L1 dba:  0x02000039 Data dba:  0x0200003a
   Extent 7     :  L1 dba:  0x02000039 Data dba:  0x02000041
   Extent 8     :  L1 dba:  0x02000049 Data dba:  0x0200004a
   Extent 9     :  L1 dba:  0x02000049 Data dba:  0x02000051
   Extent 10    :  L1 dba:  0x02000059 Data dba:  0x0200005a
   Extent 11    :  L1 dba:  0x02000059 Data dba:  0x02000061
   Extent 12    :  L1 dba:  0x02000069 Data dba:  0x0200006a
   Extent 13    :  L1 dba:  0x02000069 Data dba:  0x02000071
   Extent 14    :  L1 dba:  0x02000079 Data dba:  0x0200007a
   Extent 15    :  L1 dba:  0x02000079 Data dba:  0x02000081
   Extent 16    :  L1 dba:  0x02000089 Data dba:  0x0200008b
   Extent 17    :  L1 dba:  0x02000109 Data dba:  0x0200010b
   Extent 18    :  L1 dba:  0x02000189 Data dba:  0x0200018b
  --------------------------------------------------------

   Second Level Bitmap block DBAs
   --------------------------------------------------------
   DBA 1:   0x0200000a

End dump data blocks tsn: 9 file#: 8 minblk 11 maxblk 11

其余省略

 

这里看到自动段管理的时候，默认创建了L1 L2 L3位图。L1位图默认是管理16块。但是后面填满后，L1位图都管理了64块

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/21158541/viewspace-668435/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21158541/viewspace-668435/

cuanyileng9226
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
ASSM与L3、L2、L1块的意义
cowboy90的专栏
04-11 583
Oracle内核技术揭密_吕海波 学习笔记 ASSM的整体结构是3层位图块+数据块，共4层的树状结构。 第一层位图块称为L3块，一个L3块中可以存放多个L2块的地址，一个L2块可以存放多个L1块地址，一个L1块可以存放多个数据块地址。 第一个L3块一般是段头，如果段头中存放太多L2块的信息，就会空间不足，这时oracle会再分配第二个L3块。如果第二个L3块空间用完了，就会分配第三个L...
assm的结构_oracle的ASSM小结
weixin_36435829的博客
01-13 138
段头 & L3Extent control: 存储HHWM信息Header control: 记录三级位图的基本信息，其中L2 hint for insert为搜索可用空间的起始位置Extent table/Auxillary extent map: 维护extent map信息buffer tsn: 115 rdba: 0x11227ca3 (68/2260131)scn: 0x0860...
assm的结构_Oracle ASSM三级位图块结构
weixin_39987138的博客
12-22 236
Oracle ASSM三级位图块结构前几天Piner发布了一个悬赏：寻找ASSM三级位图块的文章，同时给出了对于ASSM结构的猜想。Piner猜想的结构和我想像的不同，我认为ASSM的结构应该如下图所示：也就是说我认为BMB的结构应该是均衡的，同时段头的PAGETABLE SEGMENT HEADER同时充当了第0个3级位图块的角色。在PAGETABLE SEGMENT HEADER中实际上我们可...
oracle自管理段,Oracle 自动段空间管理(ASSM:auto segment space management)
weixin_39616348的博客
04-02 506
让我们看看位图freelist是如何实现的。从使用区段空间管理自动参数创建tablespace开始：create tablespace demodatafile ''/ora01/oem/demo01.dbf ''size 5mEXTENT MANAGEMENT LOCAL -- Turn on LMTSEGMENT SPACE MANAGEMENT AUTO -- Turn on ASSM;一旦...
Oracle PCTfree assm,Oracle 12C LMT & ASSM 完美测试
weixin_31179927的博客
04-03 229
本帖最后由 sunyunyi 于 2017-9-7 17:35 编辑目前服务于电力行业，致力于帮助客户解决生产过程中出现的问题，提高生产效率, 爱好书法，周易！愿结交志同道合之士！共同进步！ 微信号：sunyunyi_sunversion： 12.2.0.1.0需要测试的表空间信息：DBMS_METADATA.GET_DDL('TABLESPACE','DATA_01')-------------...
ASSM数据并发插入测试
cowboy90的专栏
04-15 411
Oracle内核技术揭密_吕海波 学习笔记 创建一个区大小为1M的表空间TEM_TBS1，在它里面建表ma.t64，插入一笔资料后可以看到为此表分配的第一个区的区间是从第128号块开始的共128个数据块，段头(L3块)为131号块。通过dump数据块的信息可以知道131号块为L3块，130号块为L2块，128、129号块为L1块(dump步骤查看通过dump数据块信息，追溯三层结构位图信息)，...
Oracle ASSM表空间存储结构
conghe6716的博客
02-21 738
从Oracle 11gR2开始，每个数据文件的前128个块被Oracle留用，其中0-1号块为文件头，2-127号块是位图块，记录表空间中区的分配情况。 test表空间是一个新建的表空间，里面有一张表ms1 SQ...
oracle空间管理-区段管理信息
oradbm的博客
08-20 175
文章转自 （oracle内核技术揭秘）一书 1 每个数据文件的前8个或者128个 local extent management管理区，即为数据文件头信息（包含检查点scn，数据文件大小，绝对文件号和相对文件号等元数据）。 select dbms_rowid.rowid_relative_fno(rowid),dbms_rowid.rowid_block_number(rowid) from ...
Oracle数据库中利用ASSM改善分段存储
03-03
表格空间增强了自动分段空间管理（ASSM），ASSM的tablespace是通过将SEGMENT SPACE MANAGEMENT AUTO子句添加到tablespace的定义句法里而实现的。通过使用位图freelist取代传统单向的链接列表freelist，ASSM的...
oracle-dmt-lmt-mssm-assm
12-21
dmt,lmt是管理segment中的extent的，而mssm和assm是管理extent中的block的。 需要说明的时不论在dmt还时lmt下都可以使用mssm，而在dmt下只能使用mssm，而下面要介绍的assm只在lmt下才支持。
Assm.rar_SIC ASSEMBLER_ob_sic_two-pass assembler
09-22
《SIC汇编器：双通道汇编过程详解》 SIC（Stanford Instruction Set Computer）汇编器是计算机科学领域中的一个经典教学工具，它用于将程序员编写的高级语言代码转换为机器可理解的二进制指令。...
assm-2014-10-20.zip_单片机开发_Visual_C++_
08-11
【标题】"assm-2014-10-20.zip" 是一个压缩文件，其中包含了关于单片机开发的项目资料，使用的开发工具是Visual C++。这个文件可能是一个教学或作业资源，发布于2014年10月20日。 【描述】"Assigment 1 bk_2014Chu ...
assm.rar_Micro Mechanical_level set_level set模拟_水平集_水平集 三维
09-20
《三维Level Set模拟在硅基微机械湿法刻蚀中的应用》 在现代微电子机械系统（Micro-Electro-...通过对"assm.rar"中的源码进行深入研究和实践，我们可以更深入地掌握这一技术，并将其应用于实际的微机械设计与制造中。
基于JSP的高校信息资源共享平台
heye0910032的博客
07-22 670
高校信息资源共享平台的开发和实现，为高校信息资源的管理和共享提供了一个有效的解决方案。通过使用JSP技术和MySQL数据库，本系统实现了一个稳定、安全、易用的高校信息资源管理平台。虽然在开发过程中遇到了一些技术挑战，但通过不断学习和实践，最终完成了一个能够满足用户需求的系统。未来，我们将继续优化系统功能，提升用户体验，以期达到更高的应用价值和社会效益。高校信息资源共享平台的开发和实现，为高校信息资源的管理和共享提供了一个有效的解决方案。
04-用户画像+sqoop使用
weixin_46567476的博客
07-21 563
sqoop的作用是实现数据的导入和导出，主要是对数据库和数据仓库之间的操作。qoop脚本就是将sqoop指令写入shell文件 后缀是 .sh。只要是支持jdbc连接的数据库都可以使用sqoop操作。
redis常用指令
m0_62289159的博客
07-22 778
redis常用指令
Django cursor()增删改查和shell环境执行脚本
人生苦短，何妨一试
07-21 472
在Django中，cursor()方法是DatabaseWrapper对象（由django.db.connectio提供）的一个方法，用于创建一个游标对象。这个游标对象可以用来执行SQL命令，从而实现对数据库的增删改查操作。使用cursor.execute()方法执行SQL查询语句，可以获取数据库中的数据。查询your_table表中的所有记录。执行查询后，你可以使用cursor.fetchall()或cursor.fetchone()等方法来获取查询结果。
sqlalchemy使用json_unquote函数的mysql like查询
最新发布
ithongchou的博客
07-23 1148
为您自己的数据库连接信息，并根据实际表结构修改模型类。函数查询MySQL JSON字段可以通过使用。下面是一个示例，假设有一个名为。请确保替换示例代码中的数据库连接字符串(在SQLAlchemy中使用。的表，其中包含一个名为。
oracle ASSM是什麽？有什麽作用？
07-15
Oracle ASSM（Automatic Segment Space Management）是一种用于管理数据库段空间的自动化机制。在传统的分段管理（Manual Segment Space Management）中，需要手动管理和分配段空间，而ASSM则通过自动管理和分配空间来简化这一过程。 ASSM的主要作用是优化数据库的空间利用和性能。它通过以下方式实现： 1. 动态空间分配：ASSM会根据数据块的使用情况，自动分配和释放段空间。这样可以避免手动管理时出现的空间浪费或不足的问题。 2. 自动调整数据块大小：ASSM可以根据数据块中的行数和大小自动调整数据块的大小，以提高数据库的空间利用率。 3. 减少碎片化：ASSM使用一种称为HOT（High-Order-Transaction）插入算法，它能够减少段内的空闲空间碎片。这样可以提高数据的存取效率，并减少存储碎片对数据库性能的影响。 4. 提高并发性能：使用ASSM可以减少数据块之间的竞争，提高并发性能。它采用多版本并发控制（Multi-Version Concurrency Control）技术，可以避免因为行锁竞争而导致的性能瓶颈。 总而言之，Oracle ASSM是一种自动化的数据库段空间管理机制，它可以优化数据库的空间利用和性能，减少空间碎片和竞争，并提高并发性能。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值