Re: Checking Size of the Stored procedures

  select c.obj#, o.name, sum(c.bytes)
  from sys.code_pieces c, sys.obj$ o
  where c.obj# = o.obj#
  group by c.obj#, o.name

This will give you the size of all stored procedures and packages

Søren Klintrup wrote:

> I'm a newly started DBA, i've just attended the oracle DBA course .. a Great
> course...
>
> The next monday i started to look at our database (wich was set up by the
> guy before me who knew nothing about oracle, as me :).
> And in all my horror i see that the System tablespace spans 1.7 Gigabyte!!!
> (yup that is 1700 Megabytes)..
>
> At the course i was told that 60 megabytes should be more than enough for
> most systems ... and 300 megabytes for a developers system .... ok .. i
> would have gone for 300-400 megs ... but 1.7 Gigabytes ??
>
> it seems that the stored procedures takes a lot of the space, but i'm not
> sure ... that is what i want to check ...
>
> I just did a full export of the database and the stored procedures took over
> 95% of the export time ..
>
> The database is not in production yet, so i can close it as much as i want
> .... but as far as i've been told theres still some data that has been
> transferred to the database ..
>
> How do i check the size of the Stored Procedures ??
> How do i check how which Stored Procuderes is installed ?
> How do i check the size of the tables in the system tablespace ?
> If none of this helps .. how do i check whats making the system tablespace
> so large ..
>
> /Søren
Received on Tue Apr 06 1999 - 12:19:27 CDT