Chapter 16 Tuning RMAN. Background. One of the hardest chapters to develop material for Tuning RMAN can sometimes be difficult Authors tried to capture repeatable techniques for performance tuning. Why Tune RMAN. Backups taking too long
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
1. Identify measurable business performance requirements.
2. Collect data and measure performance.
3. Identify bottlenecks.
4. Make adjustments that will alleviate the worst bottleneck.
5. Repeat steps 1–4 until your performance goals are achieved.
SQL> SELECT b.sid, b.serial#, a.spid, b.client_info
FROM v$process a, v$session b
WHERE a.addr = b.paddr
AND b.client_info LIKE '%rman%';
SQL> SELECT session_recid, input_bytes_per_sec_display,
ORDER BY end_time;
SQL> select sid, serial#, sofar, totalwork, opname,
round(sofar/totalwork*100,2) "% Complete"
where opname LIKE 'RMAN%'
and opname NOT LIKE '%aggregate%'
and totalwork != 0
and sofar <> totalwork;
SQL> SELECT sid, serial, filename, type, elapsed_time, effective_bytes_per_second
WHERE close_time > sysdate – 7;
1. Ensure statistics_level is set to TYPICAL (the default) or ALL
2. Set sga_target to an appropriate nonzero value for your database not exceeding the sga_max_size
3. Set the following initialization parameters to zero:
RMAN> recover database parallel 4;
1. Disable the initialization parameters that interfere with fast_start_mttr_target
2. Determine the lower bound for fast_start_mttr_target
3. Determine the upper bound for fast_start_mttr_target
4. Select a value within the upper and lower bounds
5. Monitor and adjust
RMAN> configure device type
disk parallelism 4;
RMAN> show channel;