Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: datafiles tablespace and stored procedures

Re: datafiles tablespace and stored procedures

From: <tlondon_at_my-dejanews.com>
Date: Fri, 23 Apr 1999 14:31:08 GMT
Message-ID: <7fq07c$t8h$1@nnrp1.dejanews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US