pando boss -

first part of question i didnt get -

second part of question i am posting the output
SQL> select INITIAL_EXTENT,NEXT_EXTENT,MIN_EXTENTS,MAX_EXTENTS,PCT_INCREASE,STATUS from dba_tablespaces where tablespace_name='PRONTOMSP';

INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE STATUS
-------------- ----------- ----------- ----------- ------------ ---------
10485760 10485760 1 249 50 ONLINE