Re: Save query and statistics automatic

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 11 Feb 2007 10:24:40 -0800
Message-ID: <1171218279.481747@bubbleator.drizzle.com>

Steve Robin wrote:

> On Feb 10, 10:59 pm, bdurrettc..._at_yahoo.com wrote:

>> On Feb 10, 9:26 am, "Steve Robin" <ocma..._at_gmail.com> wrote:
>>
>>> Hi All,
>>> Is it possible to store, query with username, who is executing it,
>>> with osuser, with time taken by that query plus number rows processes.
>>> Actually I want to store each query with right literals not bind
>>> variable, which are store in v$sqlarea(including query executes twice
>>> with two different stats), which is executed by user between 8 PM to 9
>>> PM in a table. Is it possible to store it with details.
>>> Please help.
>> You could turn on 10046 level 12 tracing on all of the sessions that
>> you need to monitor and then dig through the trace files afterward.
>> That will store the values of your bind variables.
>>
>> - Bobby

> 
> Thank you for your reply Bobby.
> But I want to store these queries in table with values I mentioned
> above. Is it possible.

It is possible and it is going to have a negative impact on the system.

What is the business case. And a business case does not begin with "I want to."

Also, as MTNorman asks, what version?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Sun Feb 11 2007 - 12:24:40 CST