Jerry,

Large objects are normally maintained in separate tablespaces in
separate disk drives. If it is already followed, I don't think merely
partitioning your table will make any difference.

Partitioning is done to load balance the disk IO and ease of space
management. If your table is accessed by different sessions based on the
"VALUE" column which contains the number of bytes in the BLOB in a
mutually exclusive manner, then only partitioning may contribute to
enhance the performance...


Thanks & Regards,
Manash Pratim Baruah | Tech Mahindra Ltd.
Sharda Centre, Off Karve Road, Pune - 411004, India.
www.techmahindra.com



-----Original Message-----
From: Jerry Friedman
[mailto:oracledba-ezmlmshield-x68995020.[Email address protected]
Sent: Tuesday, October 09, 2007 8:31 PM
To: LazyDBA Discussion
Subject: RE: partitioning blobs

It is a value_length. a number showing the number of bytes for the
blob.

I wish I had a date, but I don't. It is a third party COTS product.

So, how should I partition this table?

Thanks.

Jerry



________________________________

From: Manash Baruah [mailto:[Email address protected]
Sent: Tue 10/9/2007 10:33 AM
To: Jerry Friedman
Subject: RE: partitioning blobs



**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text



Hi Jerry,

Could you please tell what is stored in value and its significance...??


Thanks & Regards,
Manash Pratim Baruah | Tech Mahindra Ltd.
Sharda Centre, Off Karve Road, Pune - 411004, India.
www.techmahindra.com



-----Original Message-----
From: Jerry Friedman
[Email address protected]
Sent: Tuesday, October 09, 2007 7:52 PM
To: LazyDBA Discussion
Subject: partitioning blobs

Hi all,

I have a table with 3 columns, no dates.

Only the blob, blob_id (random number but unique PK) and value.

How would you suggest I partition the blob?

TIA,

Jerry


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



========================================================================
====================================================


Disclaimer:

This message and the information contained herein is proprietary and
confidential and subject to the Tech Mahindra policy statement, you may
review the policy at <a
href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahind
ra.com/Disclaimer.html</a> externally and <a
href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahind
ra.com/Disclaimer.html</a> internally within Tech Mahindra.

========================================================================
====================================================






---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



============================================================================================================================


Disclaimer:

This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.

============================================================================================================================

Oracle LazyDBA home page