Hi!
Statistics level ALL means TYPICAL + row source execution stats +
timed_os_statistics.
If you want to switch to ALL for performance reasons, you can switch only
row source stats on with parameter setting _rowsource_execution_statistics
to true (on session level).
But I doubt it'll help in cur
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
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 estim
; 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
im concerned about hitting the v$views in production. we have 30,000 users. its either
that or do counts. Its a requirement from the users.
not sure what to do. doesnt tom kyte do this on asktom?
>
> From: Wolfgang Breitling <[EMAIL PROTECTED]>
> Date: 2003/12/30 Tue PM 12:09:33 EST
> To: Multi
