Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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 ...Received on Thu Jun 14 2001 - 17:31:50 CDT
>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
>>
>>