I have some question below
1.what is rowid in oracle.
2.what are the oracle statistics.
3.how can we find last 5 successful backups in Rman.
please help me with your valuable answers.
thanks in advance.
1. Oracle uses rowid to uniquely identify a row. SQL> select rowid from emp where empno=100; O/P : ROWID:AAAPECAAFAAAABSAAA
2. Stats are nothing but the information collected about your db objects. optimizer uses the stats to generate execution plan. Hence it is advisable to have the stats gathered on regular basis to get good performance.
3. Use this View V$RMAN_BACKUP_JOB_DETAILS or v$rman_status where status='COMPLETED'.
Sign up for STechies
Ask Question From Our Experts