Re: Oracle connection debugging (was Re: [pcp] Handling Oracle PMDA Latencies)

[Nathan Scott <nathans@xxxxxxxxxx>]

----- Original Message -----
> ----- Original Message -----
> > On 2016-05-20 09:46, Nathan Scott wrote:
> > > ----- Original Message -----
> > >> [...]
> > I think this is one of the larger setups tested so far. I mentioned that
> > e.g. for oracle.object_cache the select query returned over 220k rows
> > here, how many rows it returns on your test setup?
> 
> I no longer have access to the large system from the perf folk here.  But,
> on my laptop with a default Oracle install, there's ~8K rows there - when
> fetching that it takes 0.05 seconds (elapsed time).  So yep its definitely
> feasible that 220k will take ~1.3 seconds (approx linear).

(Oops, I mixed up the times from your earlier mail ... so, not linear)

>> - oracle.file takes ~1.3s with ~1k rows
>> - oracle.object_cache takes ~3.2s with ~225k rows

cheers.

--
Nathan