Triger, SP and tablespaces(p23)

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 ?


Ans1:

They can only go in the system tablespace, mores the pity. with regards to the
size dba_source will show you the size of the source code the executable code
size can be computed from the sum of IDL_UB1$  IDL_CHAR$  IDL_UB2$ IDL_SB4$
data dictionary tables.

hope this helps

  Tim L


Ans2:

Well, it may not be recommended by Oracle, but you can actually intercept sql.bsq and put in the pl/sql-based tables into a sensible tablespace.
 
 

Hosted by www.Geocities.ws

1