Darren,
Are these 4 images in separate tables?
Why an extent size of 32 meg?
Jared
"Browett, Darren" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/06/02 09:53 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: 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
----------------------------------------------------------------------------
----------------------------------------------
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
