Message-Id: <10554.111565@fatcity.com> From: Alex Hillman Date: Sun, 9 Jul 2000 14:00:22 -0400 Subject: RE: Table with Long datatypes? This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFE9CF.8FC27240 Content-Type: text/plain; charset="iso-8859-1" Your reply assumes that you have additional spindle for the files of the new tablespace. Chained blocks are for the object, not for the tablespace, so if you do not have additional spindle I do not see any benefits. Alex Hillman -----Original Message----- Sent: Wednesday, June 28, 2000 1:57 PM To: Multiple recipients of list ORACLE-L Yes and Yes. In the first case a LONG, LOB or CLOB is tha type of data object that will most likely span your block size. This means chained blocks almost all the time which can become a performance problem. In the case of the large tables, having them away from the smaller tables makes for less head activity in that tablespace thereby improving throughput. Dick Goulet ____________________Reply Separator____________________ Author: Eric Fang Date: 6/27/00 4:39 PM There are lots of questions regarding tables with long tables. When I read the Oracle Performance Tuning manual, it says "All tables that contain LONG or LOB datatypes, should be placed into a separate tablespace". My question, what's the advantage? Also in my application, among the 100 tables, 5 of them are big tables(close to 2GB). Is it better to put them in a separate table space? Thanks in advance. Eric Fang Best Consulting __________________________________________________ Do You Yahoo!? Get Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/ -- Author: Eric Fang INET: eric_fang@yahoo.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@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). -- Author: INET: dgoulet@vicr.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@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). ------_=_NextPart_001_01BFE9CF.8FC27240 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Table with Long datatypes?

Your reply assumes that you have additional spindle = for the files of the new tablespace. Chained blocks are for the object, = not for the tablespace, so if you do not have additional spindle I do = not see any benefits.

Alex Hillman

-----Original Message-----
From: dgoulet@vicr.com [mailto:dgoulet@vicr.com]
Sent: Wednesday, June 28, 2000 1:57 PM
To: Multiple recipients of list ORACLE-L
Subject: Re:Table with Long datatypes?


Yes and Yes.  In the first case a LONG, LOB or = CLOB is tha type of data object
that will most likely span your block size.  = This means chained blocks almost
all the time which can become a performance = problem.  In the case of the large
tables, having them away from the smaller tables = makes for less head activity in
that tablespace thereby improving throughput.

Dick Goulet

____________________Reply = Separator____________________
Author: Eric Fang <eric_fang@yahoo.com>
Date:       6/27/00 = 4:39 PM

There are lots of questions regarding tables with = long
tables. When I read the Oracle Performance = Tuning
manual, it says "All tables that contain LONG = or LOB
datatypes, should be placed into a separate
tablespace". My question, what's the advantage? = Also
in my application, among the 100 tables, 5 of them = are
big tables(close to 2GB). Is it better to put them = in
a separate table space?
Thanks in advance.

Eric Fang
Best Consulting

__________________________________________________
Do You Yahoo!?
Get Yahoo! Mail - Free email you can access from = anywhere!
http://mail.yahoo.com/
--
Author: Eric Fang
  INET: eric_fang@yahoo.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@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).
--
Author:
  INET: dgoulet@vicr.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@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 =