RAC - DB change 2 - continue
DB: Oracle 11.2.03 with ASM Linux: Red Hat Enterprise Linux Server release 6.4
Node: 5
How would I find out my database change rate for a given day? not for a table but the entire database.
QUESTION 1: I ran the following query on node #1. since this is Five nodes RAC and we use two nodes to run RMAN backup, do you need to run this query on two nodes and add both figures for output bytes ?
SELECT command_id,start_time,end_time,status,input_type, input_bytes_display,output_bytes_display,
FROM v$rman_backup_job_details
order by start_time desc
Node: 5
How would I find out my database change rate for a given day? not for a table but the entire database.
QUESTION 1: I ran the following query on node #1. since this is Five nodes RAC and we use two nodes to run RMAN backup, do you need to run this query on two nodes and add both figures for output bytes ?
SELECT command_id,start_time,end_time,status,input_type, input_bytes_display,output_bytes_display,
FROM v$rman_backup_job_details
order by start_time desc
0