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
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.
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
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 at
the session level.
Has anyone done measurements
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
. 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 about hitting the v
anyone have a better way to do this? im going to post what you said wolfgang on asktom
and see what he 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
: 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 ora-600
when selecting 'filter_predicates' and 'access_predicates' under
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_statistics (and consequently v$sql_plan_statistics_all) only
have data to show if statistics_level