[skarri]

this are the interview question(i culd not answer):
1.he asked me to tell a stored procedure for find the first three timetaking stored procedures in the database
2. how to calculate the size of a given table space?
3. can we call a stored procedure thru a cursor?
i said yes..
any answer plz

[iinfi]

2. find the size of your database
select sum(bytes)/1048576 MB from dba_segments;
find the size of your tablespace
select sum(bytes)/1048576 MB from dba_segments where tablespace_name = 'TBS1';

[LKBrwn_DBA]

1) statspack.snap