| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> PCT_USED/PCT_FREE : Storage of 32mb images
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
--
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 Mar 06 2002 - 11:53:34 CST
 |
 |