RE: Locally Managed Tablespaces

Yes, use LMT's

Try to choose a small number of extent sizes. Best if you can separate large from small.

Read the SAME Algorithm paper.

More than a few hundred extents are not bad - read Oracle Perf. Tuning 101 and the myriad of other statements from experienced Oracle dba's about this myth - that multiple extents are bad. They are not! The advantages of LMT's and uniform extents and a small number of extent sizes are many. =20

=20

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Smith, Ron L. Sent: Thursday, January 20, 2005 2:48 PM To: oracle-l_at_freelists.org
Subject: Locally Managed Tablespaces

We are upgrading an application that uses an external database to = set=3D20
initial table create parameters. =3D20 I would like to use Locally = Manages
tablespaces and Uniform extent=3D20 sizes, instead of the table create parameters.=3D20

My question is, will Locally Manages tablespaces cause Oracle to ignore=3D20 the table create parameters? (I hope)=3D20 And, if I have = some
tables that are empty, and some that have a million=3D20 rows, what do I use for an initial extent size?=3D20 Do I allocate them all small and = let
the large tables go into extents?=3D20

I don't have the luxury of putting large tables in a separate=3D20 tablespace. Everything is in one schema and one tablespace.=3D20

Hope this is clear.=3D20

Thanks!=3D20
Ron=3D20

Important Notice!!
If you are not the intended recipient of this e-mail message, any use, =
=3D

distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received =3D this message by mistake, then delete the e-mail message. Thank you.

--
http://www.freelists.org/webpage/oracle-l


BEGIN-ANTISPAM-VOTING-LINKS
------------------------------------------------------
Teach CanIt if this mail (ID 21836544) is spam:
Spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D21836544&m=3D1e95=
9aeb2
78f
Not spam:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D21836544&m=3D1e95=
9aeb2
78f
Forget vote:
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D21836544&m=3D1e95=
9aeb2
78f
------------------------------------------------------
END-ANTISPAM-VOTING-LINKS

--
http://www.freelists.org/webpage/oracle-l