Oracle Commands/Tips

Active SQL running Run AWR Report Run ADDM Report Run ASH Report — Enter value for begin_time: Format is MM/DD/YY HH24:SS — Enter value for duration: <number in Minutes> Database info on logon to confirm environment Capture password Hash Shrink DataFile to High Water Mark Using Logminer Example Flashback query example Find all db links … Continue reading Oracle Commands/Tips