Auditing Successful queries

From: John Roberts <robertsj_at_netcomuk.co.uk>
Date: Thu, 4 Jun 1998 09:17:17 +0100
Message-ID: <6l5l1f$9rc$1@taliesin.netcom.net.uk>

HI,

we run a data warehouse on a 26 instance data, with a large number of queries started each day, both serial and parallel. The problem is that we don't know how many queries started and returned an answer, as opposed to started but didn't actually run because the query could not get the required number of query slaves.

Does anyone have a technique for recording the number of queries run per instance, without turning on auditing ? Alternatively, if auditing is the easy option, does anyone have rela figures about the cost of turning it on - both in terms of the server performance hit, and in DBA time to administer ?

Thanks in advance

John Roberts Received on Thu Jun 04 1998 - 03:17:17 CDT