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

Ahh, I love doing interviews.

I always ask the DBA if they know how to take a dump . . .

Anyway, that is an intriguing idea about Government-sponsored certification.

Here is the USA, certification bodies require a Graduate College Degree for

1 - Bar certification (law)
2 - Medical certification (board certified MD) 3 – Engineering (Civil and EE)

Can you imagine the brouhaha if Oracle Corporation required OCPs to have a formal education?

DB

"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message news:<3e136ce1$0$234$cc9e4d1f_at_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 - 20:37:06 CST