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:[EMAIL PROTECTED] ---------------------------------------------------------------------------- ----------------------------------------------- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
