I am in the process of storing 32Mb image files into a 8.1.7 database, I have set pct_free to 0, but I left pct_used at 90 and the tablespace is locally managed with a uniform extent of 32Mb. The database has a db_block_size of 8k. I am considering moving it to 16k, as opposed to 32k, as it has a mix of smaller files ( > 8k, < 7Mb) and then the larger tables ( 32 Mb).
When I loaded 4 images (to create one image), and analyzed the tables, I received the following output. Size (numrow*avg_row_len) = 115,437,005 Bytes (Segments) = 167,772,160 Blocks = 20,480 Extents = 5 As you can see, I am wasting 50Mbs of space for 4 images. I realize that if I add another image to the larger one, I most likely only waste 18 Mbs. I have figured out that this wastage is due to the pct_used parameter. After re-re-re-reading the documents, I should have set the pct_used higher then 90. Question : Should I set pct_used to 100 or 99 ? Once these images are loaded,the tablespace will be set to READONLY. No updates will occur. 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).
