One minor caveat about setting timed_os_statistics. On Solaris, if you set
timed_os_statistics to non-zero, microstate accounting at the OS level is
enabled for the server process. Common practice is to leave it off for
performance reason. But I've never seen experimental data proving the negative
has to say.
> >
> > From: Wolfgang Breitling <[EMAIL PROTECTED]>
> > Date: 2003/12/30 Tue PM 12:09:33 EST
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Subject: Re: help with estimate row count from asktom
> >
> > v$sql_plan_stat
lt;[EMAIL PROTECTED]>
> Date: 2003/12/30 Tue PM 01:29:25 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: Re: help with estimate row count from asktom
>
> Don't be afraid to access v$ views, just beware of the bug that throws a o
> Subject: Re: help with estimate row count from asktom
>
> v$sql_plan_statistics (and consequently v$sql_plan_statistics_all) only
> have data to show if statistics_level is set to ALL. You can set that at
> the session level.
> Has anyone done measurements on a busy system to eval
; functionality. It's built-in to Intermedia.
-Mark
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tue 12/30/2003 1:19 PM
To: Multiple recipients of list ORACLE-L
Cc:
Subject: Re: Re: help with estimate row count from asktom
im concerned
Don't be afraid to access v$ views, just beware of the bug that throws a ora-600 when
selecting 'filter_predicates' and 'access_predicates' under 9202. As a workaround,
don't select those two columns. If I were you, I'd make sure that users are *very*
clear that the number you are going to get
:09:33 EST
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: help with estimate row count from asktom
>
> v$sql_plan_statistics (and consequently v$sql_plan_statistics_all) only
> have data to show if statistics_level is set to ALL. You can set that a
v$sql_plan_statistics (and consequently v$sql_plan_statistics_all) only
have data to show if statistics_level is set to ALL. You can set that at
the session level.
Has anyone done measurements on a busy system to evaluate what the impact
is of setting that system-wide. The impression I have is t
I have a very strict SLA and I posted a question on asktom about the best way to get
the 'estimate' of rows and return it to the user. Im getting 'no data found'. anyone
have ideas? Im on 9.2, tables are analyzed, and Im in a DBA account.
my question is at the bottom.
http://asktom.oracle.com/