DBA CITY

When you are facing large size trace file generation in oracle database then further space lack possible to occur. To limit size of trace file generation you need to modify this oracle parameter - Set max_dump_file_size parameter to a lower value as - SQL> show parameter dump_file NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ max_dump_file_size string unlimited SQL> alter system set max_dump_file_size='500M' scope=both sid='*'; System altered. SQL> show parameter dump_file NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ max_dump_file_size string 500M

When we simply delete  some rows from a table having multiple lob datatype columns  the no space released from the data file. To reclaim space of delete lob datatype columns we need to use shrink  as follows- select 'alter table TABLE_NAME modify lob ('||column_name||') (SHRINK SPACE);' from user_tab_columns where table_name='TABLE_NAME' and data_type='BLOB'; Put your table name on above query and it will generate a script to shrink space occupied by lob segment.