Re: Outrage that OCP exams are now unproctored - Comments?

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Wed, 1 Jan 2003 22:34:15 -0000
Message-ID: <3e136ce1$0$234$cc9e4d1f@news.dial.pipex.com>

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:_rAQ9.14176$jM5.38187_at_newsfeeds.bigpond.com...
> Personally, if a person doesn't know how to do a block dump and interpret
> the results properly, s/he shouldn't call himself/herself a DBA. And if
> there's one thing you won't learn on any OCP-based Oracle training course,
> it's how to do a block dump.

Methinks that goes a little far, I'm not entirely sure (from a day to day DBA view point) how often one would need the information in the dump below (not original cause it was filched from Jonathan but it will boost that OCR rating!)

Wed Jan 6 14:13:15 1999
Start dump data blocks tsn: 4 file#: 5 minblk 604 maxblk 604 buffer tsn: 4 rdba: 0x0140025c (5/604)
scn:0x0000.00060e9a seq:0x03 flg:0x00 tail:0x0e9a1703

       frmt:0x02 chkval:0x0000 type:0x17=BITMAPPED DATA SEGMENT HEADER    Extent Control Header

---

  Extent Header:: spare1: 0      tsn: 4      #extents: 18     #blocks: 93
                  last map rdba: 0x00000000  #maps: 0      offset: 1056
      Highwater:: rdba: 0x0140023e  ext#: 17     blk#: 5      ext size: 5

  #blocks in seg. hdr's freelists: 0
  #blocks below: 93
  mapblk rdba: 0x00000000 offset: 17

                   Unlocked
     Map Header:: next rdba: 0x00000000  #extents: 18   obj#: 16068  flag:

0x40000000
  Extent Map

---

  rdba: 0x0140025e  length: 8
  rdba: 0x014000bb  length: 5
  rdba: 0x01400084  length: 5
  rdba: 0x01400106  length: 5
  rdba: 0x01400057  length: 5
  rdba: 0x01400020  length: 5
  rdba: 0x014000d4  length: 5
  rdba: 0x01400257  length: 5
  rdba: 0x014000c0  length: 5
  rdba: 0x014000f7  length: 5
  rdba: 0x0140004d  length: 5
  rdba: 0x014000b6  length: 5
  rdba: 0x0140023e  length: 5
  rdba: 0x014000a7  length: 5
  rdba: 0x01400101  length: 5
  rdba: 0x0140010b  length: 5
  rdba: 0x014000ed  length: 5
  rdba: 0x01400239  length: 5

   block size = 2024, nfb = 2, type = 3
  fatblk = 1, states = 2
End dump data blocks tsn: 4 file#: 5 minblk 604 maxblk 604 Received on Wed Jan 01 2003 - 16:34:15 CST