how many tablespaces

From: Vissu <vissuyk_at_yahoo.com>
Date: 3 Mar 2004 20:12:44 -0800
Message-ID: <2bedd6a7.0403032012.2899a4a6_at_posting.google.com>

Hi ,

We will have about 50 tables. Some tables will be huge (severel million rows) and some are small but most of them will have about a million rows. For best performance of the database, how many tablespace should I have. I was thinking of using Locally Managed tablespaces (uniform extents) for both data and indexes.

Can anyone share some experiences? Any other tips on layout of the database will be appreciated. Thanks

Vissu Received on Thu Mar 04 2004 - 05:12:44 CET

This message: [ Message body ]
Next message: Niy: "is there any future to learn Oracle?"
Previous message: Mark C. Stock: "Re: Finding first saturday of month"
Next in thread: Jim Kennedy: "Re: how many tablespaces"
Reply: Jim Kennedy: "Re: how many tablespaces"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message