Re: Viewing the hidden _{Parameters}

Its a one-time dump (cued by the 'immediate') After the first few thousand lines you get to sections like:

CHAIN: 0 LOC: 0xc4a59cf8 HEAD: [c4a38040,c49a4e48]

    BH #4431 (0xc4a38028) file#: 1 rdba: 0x00403cd1 (1/15569) class 1 ba: 0xc43a
4000

      set: 1, dbwrid: 0
      hash: [c49a4e48,c4a59cf8], lru: [c4a37fa8,c4a380b8]
      LRU flags: moved_to_tail
      ckptq: [NULL] fileq: [NULL]
      st: XCURRENT, md: NULL, rsop: 0x0, tch: 3
      flags: only_sequential_access
      L:[0x0.0.0] H:[0x0.0.0] R:[0x0.0.0]
      buffer tsn: 0 rdba: 0x00403cd1 (1/15569)
      scn: 0x0000.0001ef5d seq: 0x01 flg: 0x06 tail: 0xef5d0601
      frmt: 0x02 chkval: 0x3aff type: 0x06=trans data

This is CHAIN 0 (aka bucket 0),
On chain 0, we have buffer 4431

Note that chains count from zero, so the last chain in the file will be numbered one short of the expected prime number.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison-Wesley

Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Rob K wrote in message ...


>after i do the dump how did you find the hash chains listed

>also is this a one time dump or do I need to reset the system events?

>

>thanks rob

>"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message

>news:992639363.18992.0.nnrp-10.9e984b29_at_news.demon.co.uk...

>>

>> Dump Completed -

>> 72019 hash chains listed

>>

>>