Re: Slow running Delete query for same data volume

From: Pap <oracle.developer35_at_gmail.com>
Date: Tue, 6 Apr 2021 00:07:34 +0530
Message-ID: <CAEjw_fhTmUwZ6Bdgw2q_jgGRtmKMtznX5MNaQb2s5uykZ=7Y2g_at_mail.gmail.com>



Thank you. It seems like some program which moves backups to tape but still putting load on storage cell IO performance. I will check the timing with backup admin if that day it ran in some odd time causing such Io slowness.

On Sun, Apr 4, 2021 at 11:49 PM Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> To tell you the truth, I don't know much about Veeam. I used to work for
> Commvault and Veeam was a competitor. It looks strange. Usually,
> database agent maps libobk.so provided by the 3rd party tool like
> Commvault into rman address space and what you see is an rman
> executable. What I see here are 2 processes, none of which is rman.
> Judging by the diagram:
>
>
> https://helpcenter.veeam.com/docs/backup/plugins/hiw_rman_plugin.html?ver=110
>
> The "vn-vn" program must be "data mover". You will have to ask your
> backup admin about the schedule. However "Backup MML commit" is a dead
> giveaway that this is some kind of backup.
>
> On 4/3/21 2:12 AM, Pap wrote:
> > Thank you Mladen. I have not heard of Veam backup in the past. Is
> > this file system backup but not DB backup? And how can I see the
> > schedule of this backup. Is there any View just like
> > v$rman_backup_job_detail which i can query to see the file
> > system backup schedule and can then confirm if that day(31st march)
> > the schedule changed causing the slow IO and thus application job were
> > impacted just that specific day?
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
> https://dbwhisperer.wordpress.com
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Apr 05 2021 - 20:37:34 CEST

Original text of this message