dear all,
kenapa ya, saya coba gather statistics per schema tiap malam, tapi pada
kenyatannya statisticnya nggak uptodate....
SQL> select last_analyzed from dba_tables where owner='XXXX' and table_name='XX;
LAST_ANAL
---------
05-OCT-05
[EMAIL PROTECTED] oracle]$ cat get_stat.sql
begin
dbms_stats.gather_schema_stats(
ownname => 'XXXX',
options => 'GATHER AUTO',
estimate_percent => dbms_stats.auto_sample_size,
method_opt => 'for all columns size repeat',
degree => 2);
end;
pake degree 2, asumsi tidak ada user lain yg connect, so gak ada process
lainnya.
regards
--ujang
http://blog.faaza.info
[Non-text portions of this message have been removed]
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
