RE: Manty tablepsaces in a small database

From: Satar Naghshineh <Satar.Naghshineh_at_irvine.mellesgriot.com>
Date: Mon, 23 Oct 2000 10:47:20 -0700
Message-Id: <10658.119988@fatcity.com>

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_01C03D19.4ACF5050
Content-Type: text/plain;

charset="iso-8859-1"

Too add to Rodney's point, if for anything, organize and create your database so it makes logical sense and provides for organization. As a consultant, I walked into a few organizations in which the core of their problems stemed from the previous DBA not putting much thought into the organizational structure of their database.

Regards,
Satar

> -----Original Message-----
> From: Holman, Rodney [SMTP:rodney.holman_at_lodgenet.com]
> Sent: Monday, October 23, 2000 5:36 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Manty tablepsaces in a small database
>
> You, keep stating that this is a small system. Is it going to stay small?
> What are the prospects for growth?
> When the users see what great wonders they can do with your system are
> they
> going to want more from it? If you can answer no/none/no to all of these
> then one your one mount point and one tablespace (two actually - do
> separate
> indexes) system will probably work OK. However, if it starts to grow
> migrating it to a scalable platform requires scalable design at the base
> level. You can migrate a system such as you described, but it takes alot
> more work than just plugging in another array, setting up an LV and moving
> the appropriate datafile(s). Consider this before you lock yourself into
> a
> "only a small system" design.
>
>
> Rodd Holman
> Enterprise Data Systems Engineer
> LodgeNet Entertainment Corporation
> rodney.holman_at_lodgenet.com
> Comments made are my own opinions and views. They do not represent views,
> policies, or procedures of LodgeNet Entertainment Corporation
>
> -----Original Message-----
> Sent: Monday, October 23, 2000 10:36 AM
> To: Multiple recipients of list ORACLE-L
>
>
> so, maybe you don't need much tablespaces...
>
> ... I mean, The reading of a table using a index, if it's separate in
> another tablespace and you use several mount points, then there can be a
> increase in the results' speed. That's clear, but if you only have one
> mount
> point... who knows!... maybe you need someday to set up free space and
> you
> can drop a entire tablespace.
>
> ;-)
> (a bored dba, too...)
>
> -----Mensaje original-----
> De: paquette stephane [mailto:stephane_paquette_at_yahoo.com]
> Enviado el: lunes 23 de octubre de 2000 15:01
> Para: Multiple recipients of list ORACLE-L
> Asunto: Manty tablepsaces in a small database
>
>
> Hi,
>
> I've been caught in this small database project.
> My question is do you create many tablespaces to
> separate tables, indexes, the different repositories
> stored in the db,... For now, there is more trouble
> than any gain.
>
> For example, this a dss system with fact and dimension
> tables. Usually the fact tables are huge and have
> their own tablespaces or each partition has its own
> tablespace. This time, I can put everything in 1
> tablespace.
> Also, since it's small, I do not have many independant
> mount points so what is the gain of using many
> tablepsaces ?
>
> A bored dba
> TIA
>
>
>
>
> =====
> Stephane Paquette
> DBA Oracle
> stephane_paquette_at_yahoo.com
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Messenger - Talk while you surf! It's FREE.
> http://im.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?paquette=20stephane?=
> INET: stephane_paquette_at_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_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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Javier Morales
> INET: Javier_at_infojobs.net
>
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Holman, Rodney
> INET: rodney.holman_at_lodgenet.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).

------_=_NextPart_001_01C03D19.4ACF5050
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3DUS-ASCII">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">

<TITLE>RE: Manty tablepsaces in a small database</TITLE>
</HEAD>
<BODY>

Too add to Rodney's = point, if for anything, organize and create your database so it makes = logical sense and provides for organization. As a consultant, I walked = into a few organizations in which the core of their problems stemed = from the previous DBA not putting much thought into the organizational = structure of their database.

Regards, Satar

</P>
<UL>
<P><FONT SIZE=3D1 FACE=3D"Arial">-----Original Message-----</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"Arial">From:&nbsp;&nbsp;</FONT></B> <FONT =

SIZE=3D1 FACE=3D"Arial">Holman, Rodney = [SMTP:rodney.holman_at_lodgenet.com] Sent:   Monday, October 23, 2000 5:36 PM To:     Multiple recipients of list ORACLE-L Subject:       = RE: Manty tablepsaces in a small = database

You, keep stating that this is a small = system.  Is it going to stay small? What are the prospects for = growth?
 When the users see what great wonders = they can do with your system are they going to want more from it?  If = you can answer no/none/no to all of these then one your one mount point and one = tablespace (two actually - do separate indexes) system will probably work = OK.  However, if it starts to grow migrating it to a scalable platform = requires scalable design at the base level.  You can migrate a system = such as you described, but it takes alot more work than just plugging in = another array, setting up an LV and moving the appropriate datafile(s).  = Consider this before you lock yourself into a "only a small system" = design.

Rodd Holman Enterprise Data Systems = Engineer
 LodgeNet Entertainment = Corporation
 rodney.holman_at_lodgenet.com Comments made are my own opinions and = views. They do not represent views, policies, or procedures of LodgeNet = Entertainment Corporation

-----Original Message----- Sent: Monday, October 23, 2000 10:36 = AM
 To: Multiple recipients of list = ORACLE-L

so, maybe you don't need much = tablespaces...

... I mean, The reading of a table = using a index, if it's separate in another tablespace and you use = several mount points, then there can be a increase in the results' speed. = That's clear, but if you only have one mount point...   who knows!... = maybe you need someday to set up free space and you can drop a entire tablespace.

<P><FONT SIZE=3D2 FACE=3D"Arial">;-)</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">(a bored dba, too...)</FONT>
</P>

-----Mensaje original----- De: paquette stephane = [<A = HREF=3D"mailto:stephane_paquette_at_yahoo.com">mailto:stephane_paquette_at_yah= oo.com</A>] Enviado el: lunes 23 de octubre de = 2000 15:01
 Para: Multiple recipients of list = ORACLE-L
 Asunto: Manty tablepsaces in a small = database

Hi,

I've been caught in this small = database project. 
 My question is do you create many = tablespaces to
 separate tables, indexes, the = different repositories

<BR><FONT SIZE=3D2 FACE=3D"Arial">stored in the db,...&nbsp; For now, =
there is&nbsp; more trouble</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">than any gain.</FONT>

For example, this a dss system with = fact and dimension
 tables. Usually the fact tables are = huge and have
 their own tablespaces or each = partition has its own
 tablespace. This time, I can put = everything in 1
 tablespace. Also, since it's small, I do not have = many independant
 mount points so what is the gain of = using many
 tablepsaces ?

<P><FONT SIZE=3D2 FACE=3D"Arial">A bored dba</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">TIA</FONT>
</P>
<BR>
<BR>
<BR>

<P><FONT SIZE=3D2 FACE=3D"Arial">=3D=3D=3D=3D=3D</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Stephane Paquette</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">DBA Oracle</FONT>

stephane_paquette_at_yahoo.com

<FONT SIZE=3D2 =

FACE=3D"Arial">__________________________________________________</FONT>=

Do You Yahoo!? Yahoo! Messenger - Talk while you = surf!  It's FREE.
 <A = HREF=3D"http://im.yahoo.com/" =
TARGET=3D"_blank">http://im.yahoo.com/</A>

<BR><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Please see the official ORACLE-L =
FAQ:</FONT><U> <FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial"><A =

HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A> -- Author: = =3D?iso-8859-1?q?paquette=3D20stephane?=3D   INET: = stephane_paquette_at_yahoo.com

Fat City Network = Services    -- (858) 538-5051  FAX: (858) = 538-5051
 San Diego, = California        -- Public Internet = access / Mailing Lists
 <FONT SIZE=3D2 =

FACE=3D"Arial">---------------------------------------------------------=

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

<BR><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Please see the official ORACLE-L =
FAQ:</FONT><U> <FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial"><A =

HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A>

<BR><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Author: Javier Morales</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp; INET: =

Javier_at_infojobs.net

FACE=3D"Arial">---------------------------------------------------------=

<BR><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Please see the official ORACLE-L =
FAQ:</FONT><U> <FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial"><A =

HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A>

<BR><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Author: Holman, Rodney</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp; INET: =

rodney.holman_at_lodgenet.com

FACE=3D"Arial">---------------------------------------------------------=