Monday, April 24, 2023

user level export and import

expdp parfile=PLCT170.par oracle@uslp123sd7dfcvxsza > more PLCT050.par userid= "/ as sysdba" dumpfile=T050.dmp logfile=expdpT050.log schemas=WWSRPLawedxCT050 compression=all directory=SCRIPTS1 reuse_dumpfiles=yes impdp parfile=IMPPLCT170.par oracle@uslp123sd7dfcvxsza >more IMPPLCT050.par userid= "/ as sysdba" dumpfile=T050.dmp logfile=imp_T050.log schemas=WWSRzaswedcvbPLCT050 directory=SCRIPTS1 table_exists_action=REPLACE

SQL executions based on AWR

SQL exection per day SELECT TO_CHAR(s.BEGIN_INTERVAL_TIME, 'YYYY-MM-DD') AS execution_date, ss.SQL_ID, SUM(ss.EXECUT...