SAP BLOGS and TUTORIALS

How to change archive to no archive-log Mode shutdown db and follow below steps >startup mount; >alter database noarchivelog; >alter databse open; select log_mode from v$database;   tablespace growth history SELECT TO_CHAR (sp.begin_interval_time,’DD-MM-YYYY’) days , ts.tsname , max(round((tsu.tablespace_size* dt.block_size )/(1024*1024*1024),2) ) cur_size_GB , max(round((tsu.tablespace_usedsize* dt.block_size )/(1024*1024*1024),2)) usedsize_GB FROM DBA_HIST_TBSPC_SPACE_USAGE tsu , DBA_HIST_TABLESPACE_STAT ts , DBA_HIST_SNAPSHOT…