Adding a comment regarding Snapper runtime:
This is a RAC database, when using Snapper without the @instance_number
syntax, it uses V$SESSION and other V$ views, for example:
@snapper all 5 1 *SID*
@snapper all 5 1 username=BLAH
When using Snapper with @instance_number syntax, it uses GV$ views:
@snapper all 5 1 *SID*@2
@snapper all 5 1 username=BLAH@2
Depending on the filter conditions (@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
https://blog.tanelpoder.com/seminar/
On Mon, May 20, 2019 at 7:01 AM Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>
wrote:
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.