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: [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Drake
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).