This discussion is archived
9 Replies Latest reply: Nov 15, 2012 9:51 AM by Jonathan Lewis RSS

Dump - BMB

user12215372 Newbie
Currently Being Moderated
Hi everyone,

I have made a dump of my segment and i got it:

grep "Freeness" PRDSID_ora_11281.trc
Freeness Status: nf1 0 nf2 0 nf3 0 nf4 0
Freeness Status: nf1 0 nf2 0 nf3 0 nf4 0
Freeness Status: nf1 0 nf2 0 nf3 0 nf4 62

My question is if the value of 64 (nf4) means that i have 62 data blocks of 75-100% free space or it is 0-25% or i am wrong in both cases?

Thank you if somebody can help me.
  • 1. Re: Dump - BMB
    sb92075 Guru
    Currently Being Moderated
    post complete results from following SQL

    SELECT * FROM V$VERSION;
    user12215372 wrote:
    Hi everyone,

    I have made a dump of my segment and i got it:

    grep "Freeness" PRDSID_ora_11281.trc
    Freeness Status: nf1 0 nf2 0 nf3 0 nf4 0
    Freeness Status: nf1 0 nf2 0 nf3 0 nf4 0
    Freeness Status: nf1 0 nf2 0 nf3 0 nf4 62

    My question is if the value of 64 (nf4) means that i have 62 data blocks of 75-100% free space or it is 0-25% or i am wrong in both cases?

    Thank you if somebody can help me.
    I give up.
    what exactly was done to produce PRDSID_ora_11281.trc


    How do I ask a question on the forums?
    SQL and PL/SQL FAQ



    Handle:     user12215372
    Status Level:     Newbie
    Registered:     Mar 8, 2010
    Total Posts:     121
    Total Questions:     68 (40 unresolved)
  • 2. Re: Dump - BMB
    user12215372 Newbie
    Currently Being Moderated
    I am sorry,

    The version is:

    SQL> SELECT * FROM V$VERSION;


    BANNER
    --------------------------------------------------------------------------------
    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
    PL/SQL Release 11.2.0.3.0 - Production
    CORE 11.2.0.3.0 Production
    TNS for Linux: Version 11.2.0.3.0 - Production
    NLSRTL Version 11.2.0.3.0 - Production

    It is in Red Hat 5.7 in 32 bits.

    I did it: alter system dump datafile 6 block min 256 block max 384;

    Thank you.

    Edited by: user12215372 on 14/11/2012 06:36 PM
  • 3. Re: Dump - BMB
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    block min 256 block max 384;
    You should have needed to dump only the segment header, not 129 blocks !

    Hemant K Chitale
  • 4. Re: Dump - BMB
    user12215372 Newbie
    Currently Being Moderated
    Hi,

    Please, could you give a few more of detail.

    Thank you very much.
  • 5. Re: Dump - BMB
    PavanKumar Guru
    Currently Being Moderated
    Hi,

    Please through the referred to get an idea of it
    https://blogs.oracle.com/sysdba/entry/how_to_dump_oracle_data_block
    http://lianggang.wordpress.com/2009/07/07/data-block-dump-in-oracle-part-1-how-to-dump/

    - Pavan Kumar N
  • 6. Re: Dump - BMB
    user12215372 Newbie
    Currently Being Moderated
    Hi, thank you for the info.
    I reviewed it, but i am looking for the answer to my question, i only need to know if this value is the total of data blocks of 75-100% free space.

    Thank you really.
  • 7. Re: Dump - BMB
    Jonathan Lewis Oracle ACE Director
    Currently Being Moderated
    user12215372 wrote:
    Hi everyone,

    I have made a dump of my segment and i got it:

    grep "Freeness" PRDSID_ora_11281.trc
    Freeness Status: nf1 0 nf2 0 nf3 0 nf4 0
    Freeness Status: nf1 0 nf2 0 nf3 0 nf4 0
    Freeness Status: nf1 0 nf2 0 nf3 0 nf4 62
    Since you have the trace fille and can access it with grep, why not use vi to edit it and search for "Freeness", then look at the rest of the dump of that block to see if it gives you more details.
    The entry comes from level 1 bitmaps, by the way, not the segment header as suggested by someone else.

    Regards
    Jonathan Lewis
  • 8. Re: Dump - BMB
    user12215372 Newbie
    Currently Being Moderated
    Hi Jonathan, thank you for your time.

    I did a dump since the header segment until segment header + # blocks (this information i got of the dba_segments).

    I did a vi editor before and i saw as legend titles as: 0: Dictionary, and 75%, but never i saw 0-25%, 25-50%,50-75% as the theory says about the data block in ASSM.

    I can't find some information in internet about my question, i look for a lot of pages but nothing.

    Regards.
  • 9. Re: Dump - BMB
    Jonathan Lewis Oracle ACE Director
    Currently Being Moderated
    user12215372 wrote:
    Hi Jonathan, thank you for your time.

    I did a dump since the header segment until segment header + # blocks (this information i got of the dba_segments).

    I did a vi editor before and i saw as legend titles as: 0: Dictionary, and 75%, but never i saw 0-25%, 25-50%,50-75% as the theory says about the data block in ASSM.
    I've just created a table, inserted some data into it, and dumped the first few blocks of the first couple of extents.
    After doing that I opened the file with a text editor looking for a line holding the word Freeness, and a non-zero "nf" entry, which happened to look like this:
       Freeness Status:  nf1 0      nf2 0      nf3 0      nf4 16     
    Going up a few lines, and then down a couple of dozen lines, I found the following text:
    Dump of First Level Bitmap Block
     --------------------------------
       nbits : 4 nranges: 1         parent dba:  0x01400182   poffset: 2     
       unformatted: 35      total: 64        first useful block: 2      
       owning instance : 1
       instance ownership changed at 11/07/2012 09:03:00
       Last successful Search 11/07/2012 09:03:00
       Freeness Status:  nf1 0      nf2 0      nf3 0      nf4 16     
     
       Extent Map Block Offset: 4294967295 
       First free datablock : 13     
       Bitmap block lock opcode 0
       Locker xid:     :  0x0000.000.00000000
       Inc #: 0 Objd: 112932 
      HWM Flag: HWM Set
          Highwater::  0x01400240  ext#: 1      blk#: 64     ext size: 128   
      #blocks in seg. hdr's freelists: 0     
      #blocks below: 192   
      mapblk  0x00000000  offset: 1     
      --------------------------------------------------------
      DBA Ranges :
      --------------------------------------------------------
       0x01400200  Length: 64     Offset: 0      
      
       0:Metadata   1:Metadata   2:FULL   3:FULL
       4:FULL   5:FULL   6:FULL   7:FULL
       8:FULL   9:FULL   10:FULL   11:FULL
       12:FULL   13:unformatted   14:unformatted   15:unformatted
       16:unformatted   17:unformatted   18:unformatted   19:unformatted
       20:unformatted   21:unformatted   22:unformatted   23:unformatted
       24:unformatted   25:unformatted   26:unformatted   27:unformatted
       28:unformatted   29:unformatted   30:unformatted   31:unformatted
       32:75-100% free   33:75-100% free   34:75-100% free   35:75-100% free
       36:75-100% free   37:75-100% free   38:75-100% free   39:75-100% free
       40:75-100% free   41:75-100% free   42:75-100% free   43:75-100% free
       44:75-100% free   45:75-100% free   46:75-100% free   47:75-100% free
       48:unformatted   49:unformatted   50:unformatted   51:unformatted
       52:unformatted   53:unformatted   54:unformatted   55:unformatted
       56:unformatted   57:unformatted   58:unformatted   59:unformatted
       60:unformatted   61:unformatted   62:unformatted   63:unformatted
      --------------------------------------------------------
    Looking at all the available clues, I think you should be able to see that nf4 refers to 75-100% free (and that "unformatted" and "FULL" don't result in "nf" entries).

    Regards
    Jonathan Lewis

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points