Re: STATS$SQL_SUMMARY.executions

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 03 Jul 2002 22:42:59 +0100
Message-ID: <3D236FE3.6514@yahoo.com>

Epicentre Team B Annecy wrote:
>
> Hi
>
> What is the signification of STATS$SQL_SUMMARY.executions ?
> why 0 ? why 1 ? ou more ?
>
> --
> Celine Armanet
> EPICENTRE
> carmanet_at_epicentre.fr
> Tel. : +33 04 50 09 7000

'executions' - how many times a particular SQL was executed. Its worth knowing because even an efficient tuned piece of SQL could be a 'problem' if you are running millions and billions of times per day.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."

Received on Wed Jul 03 2002 - 16:42:59 CDT