RE: LOB Storage Characteristics

uh - Stripe And Mirror Everything.
what's a tablespace?
add more NVRAM (cache).
 

he he he he ... its going to be another late one ...
 

sales critter.

-----Original Message-----
Sent: Monday, June 11, 2001 9:51 PM
To: Multiple recipients of list ORACLE-L

Greetings All,

I am using Oracle 81630 on Solaris 7 and I have a table which contains a LOB (CLOB actually).  The DDL statement is as follows ...

My question is one related to data access for the table, lobsegment and lobindex.  Would there be any I/O performance benefit in having the table, lobsegment and lobindex located in different tablespaces (which would be located on different physical drives)?

As you can see I can split the table and lobsegment/lobindex into separate tablespaces.  I have tried to split the lobsegment and lobindex up into separate tablespaces but according to the 816 documentation this is no longer supported under 8i (depracation of the LOB_index_clause). According to Metalink the lobsegment and lobindex are co-located in 8i for a specific reason - but I cannot find what that is!

Thanks

Glen

-- 

Glen Mitchell                   NZ Phone: +64 9 3730400

Energy Research Lab             URL: http://www.peace.com <http://www.peace.com>

Peace Software                  Email: glen.mitchell_at_peace.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Drake
  INET: drake_at_psscorp.com

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).