Oracle-L: Extent Math

From: Browett, Darren <dbrowett_at_city.coquitlam.bc.ca>
Date: Wed, 24 Apr 2002 15:33:21 -0800
Message-ID: <F001.0044EA34.20020424153321@fatcity.com>

I am in the process of loading some image data, and would like to "pack" the data as best I can.

Version 8.1.7.2.0
Locally managed tablespace with a 3Mb extent. pctfree=1
pctused=95

After I do an analyze table I get the following results

num_rows*avg_row_len=28896420
bytes by segment=34603008
number of blocks = 2112
number of extents = 11

If I was to divide the bytes by segement by numrow*avg_row_len I get 83 %. which is nowhere near the 95% that I specified. Even though it is an average, I thought
it would be closer to 95%.

It appears to me that I am wasting 5+ Mb per image, and after 50+ images, could add upto
250+ Mb.

I am totally wrong in my understanding of the numbers, and if so, what kind of parameters
do I need to "pack" the data.

Thanks

Darren

Darren Browett P.Eng This message
was transmitted
Data Administrator using 100%
recycled electrons
Information and Communication Technology City of Coquitlam
P:(604)927 - 3614
E:dbrowett_at_city.coquitlam.bc.ca

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Browett, Darren
INET: dbrowett_at_city.coquitlam.bc.ca

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Apr 24 2002 - 18:33:21 CDT