Oracle Database Appliance X5-2 nodes each contain 2 CPUs and each CPU has 18 cores. When you deploy Oracle Database Appliance X5-2, all 72 cores (36 cores in each server) are active with hyper-threading enabled by default. Below show processor showing each node having two processors and each with 18 cores i.e. Node 0:...
Continue reading...October 2018
RMAN backup details, Display last 5 days
Following query can be used to get rman backup job details for last 5 days. set lines 220 col output_bytes_display for a30 col time_taken_display for a30 select session_key,input_type,status, to_char(start_time,’yyyy-mm-dd hh24:mi’) start_time, to_char(end_time,’yyyy-mm-dd hh24:mi’) end_time, output_bytes_display, time_taken_display from v$rman_backup_job_details where END_TIME > sysdate-5 order by session_key asc;
Continue reading...
Recent Comments