Re: Simple Insert - very slow

From: Tanel Poder <>
Date: Mon, 20 May 2019 21:44:07 -0400
Message-ID: <>

Adding a comment regarding Snapper runtime:

This is a RAC database, when using Snapper without the _at_instance_number syntax, it uses V$SESSION and other V$ views, for example:

_at_snapper all 5 1 *SID*
_at_snapper all 5 1 username=BLAH

When using Snapper with _at_instance_number syntax, it uses GV$ views:

_at_snapper all 5 1 *SID*_at_2
_at_snapper all 5 1 username=BLAH_at_2

Depending on the filter conditions (_at_RAC instance syntax and not looking just for one SID) may make the data collection GV$ queries somewhat more complicated and they make take some time. Btw, usually I run snapper for 5 seconds (or more)...

Tanel Poder

On Mon, May 20, 2019 at 7:01 AM Jonathan Lewis <>

> Sanjay,
> I don't use snapper often enough to be sure of exactly how it works, but
> your figures for a "1 second single snapshot" suggest that it took nearly 2
> seconds to do a one second snapshot - which could indicate that the machine
> is overloaded and work outside the work you are doing is impacting in your
> attempt to load data.
Received on Tue May 21 2019 - 03:44:07 CEST

Original text of this message