For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Dear Sir/Madam,
I am strongly willing to learn java, from anywhere um not getting the chance to work on this. but I am trying to learn. Please help me learn live projects
select bytes, s.segment_name,s.segment_type from dba_segments s where s.segment_name='FAX_MGMT'; 65536 FAX_MGMT TABLE 65536 FAX_MGMT TABLE 65536 FAX_MGMT TABLE 196608 FAX_MGMT TABLE 393216 FAX_MGMT TABLE 393216 FAX_MGMT TABLE 7340032 FAX_MGMT TABLE
select sum(bytes), s.segment_name, s.segment_type from dba_lobs l, dba_segments s where s.segment_type = 'LOBSEGMENT' and l.table_name = 'FAX_MGMT' and s.segment_name = l.segment_name group by s.segment_name,s.segment_type; 2097152 SYS_LOB0000076179C00007$$ LOBSEGMENT 65536 SYS_LOB0000137128C00007$$ LOBSEGMENT 18874368 SYS_LOB0000108312C00007$$ LOBSEGMENT 4032823296 SYS_LOB0000153767C00007$$ LOBSEGMENT 141557760 SYS_LOB0000109608C00007$$ LOBSEGMENT 143654912 SYS_LOB0000132039C00007$$ LOBSEGMENT 16777216 SYS_LOB0000086960C00007$$ LOBSEGMENT