datafiles tablespace and stored procedures

From: <alexman_at_icis-corp.com>
Date: Fri, 23 Apr 1999 13:29:49 GMT
Message-ID: <7fpsk8$pno$1@nnrp1.dejanews.com>

I have been spending time sizing a database ( tables and indexes ) and planning a layout of new tablespaces and datafiles. I intend to split the data files from the indexes for speed. The database I am planning to re-map has a large amount of stored procedures and functions, as well as triggers. I need to know size and location of these existing objects to size tablespaces accordingly at split time. I also would like to know if there is a recommended placement strategy for these objects

TRIGGERS PROCEDURES FUNCTIONS where they are ?
how big they are ?

where they should be stored (table space ? ) in a well planned database ?

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Apr 23 1999 - 08:29:49 CDT