Skip to Main Content
  • Questions
  • Number of Execution per snapshot too high for rman sql

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Saurabh.

Asked: August 08, 2016 - 2:50 pm UTC

Last updated: August 09, 2016 - 3:21 am UTC

Version: 11.2.0.4

Viewed 1000+ times

You Asked

Hi Team,

I have been seeing many executions of below query in our database.

begin sys.dbms_backup_restore.createRmanOutputRow( l0row_id => :l0row_id, l0row_stamp => :l0row_stamp, row_id => :row_id, row_stamp =>:row_stamp, txt=> :txt, sameline => :i_sameline);

Sometimes, these executions go beyond 1K/half an hour(sometimes 5K or more), though buffergets and other stats seem quiet normal.

SQL_ID PLAN_HASH_VALUE SNAP_ID DT EXECUTIONS CPU_TIME CPUms/Esec ELAPSED_TIME ET(ms)/Esec BUFFER_GETS BGETS/Esec IO(ms)/Esec APP(ms)/Esec CC(ms)/Esec DISK_READS DISK_READs/Esec ROWS_Procs ROWS_PPRO/Esec Parses
------------- --------------- ---------- ------------------------------ ---------------- ---------- ---------- ------------ ----------- ----------- ---------- ----------- ------------ ----------- ---------- --------------- ---------- -------------- ----------
ch4y9zz79b9tv 0 32546 07-AUG-16 21:30 530 .05 .09 .04 .08 0 0 0 0 0 0 0 530 1 530
ch4y9zz79b9tv 0 32548 07-AUG-16 22:30 1,193 .1 .08 .1 .08 0 0 0 0 0 0 0 1193 1 1193
.
.
.
.
ch4y9zz79b9tv 0 32593 08-AUG-16 21:00 931 .09 .1 .08 .09 0 0 0 0 0 0 0 931 1 931
ch4y9zz79b9tv 0 32594 08-AUG-16 21:30 262 .02 .06 .02 .07 0 0 0 0 0 0 0 262 1 262
ch4y9zz79b9tv 0 32596 08-AUG-16 22:30 1,122 .08 .07 .09 .08 0 0 0 0 0 0 0 1122 1 1122
ch4y9zz79b9tv 0 32598 08-AUG-16 23:30 1,223 .08 .07 .1 .08 0 0 0 0 0 0 0 1223 1 1223

Pls let me know what this sql is doing in database and is there a way to bring down number of executions/snapshot.

Regards,
Saurabh

and Connor said...

This routine puts a row into the V$RMAN_OUTPUT view.

Are you doing an excessive amount of RMAN operations ?

Is this answer out of date? If it is, please let us know via a Comment

More to Explore

Backup/Recovery

Check out the complete guide to all of the Backup & Recovery techniques in the Oracle Database.