TDMS- TEST DATA MIGRATION SERVER — PRESTEPS

SAP Test Data Migration Server (SAP TDMS) is a high-speed data tool that transfers business data from your SAP production system to your development, test, quality training system. By enabling the transfer of just the relevant set of application data from the SAP production system, SAP TDMS allows you to create a lean and consistent non-production system. Recommended system settings for TDMS Refer to OSS Note 890797 for the recommended settings for Control / Central / Sender / Receiver systems. Some of the required system settings are given below: Central system:  Dialog work processes – 15 (minimum 6)  ……

HOW TO CHANGE SCHEMA PASSWORD FROM BRTOOLS

PASSWORD CHANGE FROM BRTOOLS: Please follow similar steps as below: Open brtools >> brtools BR0651I BRTOOLS 7.20 (33) BR0280I BRTOOLS time stamp: 2013-08-05 12.28.27 BR0656I Choice menu 1 – please make a selection ——————————————————————————- BR*Tools main menu 1 = Instance management 2 – Space management 3 – Segment management 4 – Backup and database copy 5 – Restore and recovery 6 – Check and verification 7 – Database statistics 8 – Additional functions 9 – Exit program Standard keys: c – cont, b – back, s – stop, r – refr, h – help ——————————————————————————- BR0662I Enter your choice: 8 ……

HOW TO CHECK ORACLE TABLESAPCE USAGE

OPEN SQLPLUS — sqlplus / as sysdba Execute below query : select a.TABLESPACE_NAME, round(total,1) Total_M, round(free) Free_M, round(100*(1-free/total),1) Usage from (select TABLESPACE_NAME,sum(BYTES)/(1024*1024) total from dba_data_files group by TABLESPACE_NAME) a ,(select TABLESPACE_NAME,sum(BYTES)/(1024*1024) free from dba_free_space group by TABLESPACE_NAME) b where a.TABLESPACE_NAME=b.TABLESPACE_NAME(+) order by 4 DESC; Output will show all tablesapce usages :

Oracle Database Query Important -Blog1

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 sp , DBA_TABLESPACES dt WHERE tsu.tablespace_id= ts.ts# AND tsu.snap_id = sp.snap_id AND ts.tsname = dt.tablespace_name AND ts.tsname NOT IN (‘SYSAUX’,’SYSTEM’) and sp.begin_interval_time > sysdate -16 and ts.tsname=’PSAPSR3′ GROUP BY TO_CHAR (sp.begin_interval_time,’DD-MM-YYYY’), ts.tsname ORDER BY ts.tsname, days; list out Active session in db   SELECT a.sid,a.serial#, ……