Re: Determine wich procedure is used to update optimiser statistics

select TABLE_NAME, LAST_ANALYZED
from DBA_TABLES
where OWNER = upper('&1')
order by TABLE_NAME;

or

select TABLE_NAME, LAST_ANALYZED
from USER_TABLES
order by TABLE_NAME;

or ... or ... or

"rjp" <rjp.l_at_laposte.net> schrieb im Newsbeitrag news:9b7a7215.0402250919.5fc91e52_at_posting.google.com...
> Hi,
>
> How could I determine the way of statistics update is used for a 9iR2
> production database ?
> I have performance problems and I don't know if the statistics are
> updates by 'DBMS_UTILITY.SCHEMA' or 'analyze table' or
> 'DBMS_STATS'(the last one seems to be preferable to the two others
> way).
>
> TYIA
> RJP
Received on Wed Feb 25 2004 - 13:19:45 CST