Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: datafiles tablespace and stored procedures
In article <7fpsk8$pno$1_at_nnrp1.dejanews.com>,
alexman_at_icis-corp.com wrote:
> 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 ?
>
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
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Apr 23 1999 - 09:31:08 CDT