Re: statistics_level in another session
- From: Yong Huang <yong321@xxxxxxxxx>
- To: Rich <richa03@xxxxxxxxx>
- Date: Wed, 3 Mar 2010 09:00:54 -0800 (PST)
Rich,
If you just need "plan execution statistics", you can set it with
exec dbms_system.set_bool_param_in_session(<sid>, <serial#>,
'_rowsource_execution_statistics', true)
It's a boolean type parameter, fortunately.
Yong Huang
--- On Wed, 3/3/10, Rich <richa03@xxxxxxxxx> wrote:
From: Rich <richa03@xxxxxxxxx>
Subject: Re: statistics_level in another session
To: "Yong Huang" <yong321@xxxxxxxxx>
Date: Wednesday, March 3, 2010, 10:47 AM
Hi Yong Huang,
Thanks for your response.
I would like "plan execution statistics" for a specific sql_id.
We are having intermittent performance problems with this SQL - the
plans are not mutating.
I think it's due to cardinality issues with one of the indexes,
however, I can't prove it without the plan stats.
Thanks again,
Rich
On Wed, Mar 3, 2010 at 8:39 AM, Yong Huang <yong321@xxxxxxxxx>
wrote:
> Rich,
>
> What feature or parmeter specifically do you want to
set in another session? The list of features controlled by
statistics_level is documented in my article:
>
> http://yong321.freeshell.org/computer/ParameterDependencyAndStatistics.doc
>
> As discussed recently, Oracle never provided a way to
set a string value in another session. We can only set
number or boolean value for another session using the
procedures in dbms_system.
>
> Yong Huang
>
> -----Original message-----
>
> Sorry - this is 64-bit 10.2.0.4 on RHEL 5.1
>
> On Tue, Mar 2, 2010 at 3:37 PM, Rich <richa03@xxxxxxxxx>
wrote:
>> Hi list,
>> Is there any way to set statistics_level in
another session without
>> access to the code?
>>
>> Will:
>> oradebug setospid xxxxxx
>> alter session set statistics_level=all;
>> do it?
>>
>> Also, how can I determine what the value(s) of
parameter settings are
>> for another session?
>>
>> TIA,
>> Rich
--
//www.freelists.org/webpage/oracle-l
Other related posts:
