Re: Save query and statistics automatic

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 12 Feb 2007 16:08:26 -0800
Message-ID: <1171325304.998363@bubbleator.drizzle.com>

Steve Robin wrote:
> On Feb 11, 11:24 pm, DA Morgan <damor..._at_psoug.org> wrote:

>> 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
>> damor..._at_x.washington.edu
>> (replace x with u to respond)
>> Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -
>>
>> - Show quoted text -

>
> I apologise for incomplete information.
> Oracle Database : 9.2.0.8
> Operating System : Windows XP SP2
>
> I am going to test it in Development database, where I do query
> optimization and performance review first then I will think about
> production.
> About statspack, it does but not I my case. As I told I need full
> query with there time, no. of rows etc. Statspack provide me queries
> with bind variable plus it doesnot provide time taken by query.
> Please provide me any suggestion.

In response to your last statement ...

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

You've written a lot of words but not a single sentence that states a business case for dragging a system to it's knees.

-- 
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 Mon Feb 12 2007 - 18:08:26 CST