Re: Checking Size of the Stored procedures

From: Ivan Bajon <iba_at_no_spam@post1.tele.dk>
Date: Tue, 6 Apr 1999 11:01:11 +0200
Message-ID: <7ecigs$i7h$1@news.inet.tele.dk>

Hej Søren

>How do i check the size of the Stored Procedures ??

I'm not sure you can. At least, I don't know how to.

>How do i check how which Stored Procuderes is installed ?
select object_type, object_name from dba_objects where object_type in ('PACKAGE', 'PACKAGE BODY', 'PROCEDURE'); or

select object_type, object_name from dba_objects where object_type in ('PACKAGE', 'PACKAGE BODY', 'PROCEDURE') and owner != 'SYS';

>How do i check the size of the tables in the system tablespace ?
select segment_name, sum(bytes) from dba_segments where segment_type='TABLE' and tablespace_name='SYSTEM'
group by segment_name;

>If none of this helps .. how do i check whats making the system tablespace
so large ..
select segment_name, sum(bytes) segment_size from dba_segments

where tablespace_name='SYSTEM'
group by segment_name
order by segment_size desc;

Regards,
Ivan Bajon Received on Tue Apr 06 1999 - 04:01:11 CDT