Re: Should we Cluster Tables?

jarv_at_coho.halcyon.com (Jason Edwards) writes:
: We have a couple of large tables ( 500000 & 1000000 records ) that are
: frequently joined for large reports and queries. There is also quite
: a bit of activity ( insert, update - no deletes ) within the most
: recent 1000 records at any time. We are adding about 10000 to 20000
: records a day to these tables.
:
: They are not currently clustered.
:
: Should we consider clustering these tables? we have no past experience
: with clusters - documentation is very slight, and the only reference
: we found in an oracle FAQ was that it's really not worth the trouble.
:
: Any recommendations, horror stories, references, etc. would be greatly
: appreciated.
:
: Thanks!
:
: Please respond here or by e-mail to: jarv_at_halcyon.com
: +-------------------------------+----------------------+
: | Jason Edwards | TRAMCO |
: | System Administrator | 11323 30th Ave W. |
: | jarv_at_halcyon.com | Everett, WA 98204 |
: | | (206) 347-3030 x2384 |
: +-------------------------------+----------------------+
:

It is NOT necessary to re-install Oracle. The same set of software can be used for multiple instances. You most likelly created the database manually, hence all of the b base tables for the products were not installed.

The easiest way to create multiple databases on Oracle7 is simply ensure that you have set ORACLE_SID(on Unix), and run ORAINST. Select CREATE NEW DATABASE OBJECTS, and select the RDBMS, plus each product which you will be wanting to use while connected to that db.

It will create the database, with a pre-set number of tablespaces and rollback segments. It will create all new datafiles, using unique names, which incorporate the SID, so you will not overwrite existing datafiles belonging to other databases. It will also install any tables required into the database that are required by the tools which you selected.

--
regards,
Carl
+-----------------------------------------------------------------------------+
Carl Gohringer, 
Oracle UK, The Oracle Centre, The Ring, Bracknell, Berkshire, England, RG121BW
Internet   : cgohring_at_uk.oracle.com    
+-----------------------------------------------------------------------------+