9 Replies Latest reply: Nov 15, 2012 11:51 AM by Jonathan Lewis RSS

    Dump - BMB

    user12215372
      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
          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
            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
              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
                Hi,

                Please, could you give a few more of detail.

                Thank you very much.
                • 5. Re: Dump - BMB
                  Pavan Kumar
                  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
                    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
                      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
                        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
                          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