Oracle space Estimation

From: <ac_sekhar_at_hotmail.com>
Date: Fri, 22 May 1998 13:14:30 GMT
Message-ID: <6k3tnm$e30$1@nnrp1.dejanews.com>

Hi all

I am working with space estimation for schema objects.

A formula is given to find the required space for a Non clustered table.

DB_BLOCK_SIZE – KCBH – UB4 – KTBBH – (INITRANS – 1) * KTBIT – KDBH In which KCBH,UB4,KTBBH are constants which can be obtained from V$TYPE_SIZE table.
I want to know how these constants are updated into that view. Is oracle itself updated the table depending upon the OS.

TIA ACS -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri May 22 1998 - 08:14:30 CDT