Re: Simple Insert - very slow
From: Tanel Poder <tanel_at_tanelpoder.com>
Date: Mon, 20 May 2019 21:44:07 -0400
Message-ID: <CAMHX9JJ=VQKLLGaemAYS3fNC=hr1WXrrp6JUy_=4Mf+SGT+scg_at_mail.gmail.com>
Date: Mon, 20 May 2019 21:44:07 -0400
Message-ID: <CAMHX9JJ=VQKLLGaemAYS3fNC=hr1WXrrp6JUy_=4Mf+SGT+scg_at_mail.gmail.com>
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 https://blog.tanelpoder.com/seminar/ On Mon, May 20, 2019 at 7:01 AM Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote:Received on Tue May 21 2019 - 03:44:07 CEST
>
> 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.
>
>
-- http://www.freelists.org/webpage/oracle-l