Question: Is there a way to find out how
much storage is backed up completed in any timeframe by RMAN?
Answer: The RMAN catalog tables (rc_backupset_summary
and rc_backup_set) provide metadata details on
the amount of storage consumed by an RMAN backup.
You can also query the v$session_longops view to see the
amount of size while an RMAN backup is running.
alter session set nls_date_format='dd.mm.yyyy
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.