Re: Gathering of Statistics
From: Á¶µ¿¿í <ukja.dion_at_gmail.com>
Date: Sun, 27 Jan 2008 11:48:19 +0900
Message-ID: <43c2e3d60801261848t13c8b6c3l97f8d0a61875179b@mail.gmail.com>
Date: Sun, 27 Jan 2008 11:48:19 +0900
Message-ID: <43c2e3d60801261848t13c8b6c3l97f8d0a61875179b@mail.gmail.com>
>
> All stats gathered using following procedures are preserved for upto 30
> days by Oracle automatically.
>
> DBMS_STATS.GATHER_SCHEMA_STATS
> DBMS_STATS.GATHER_DATABASE_STATS
>
Table statsitics collected by dbms_stats.gather_table_stats are also stored and restoreable.
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Jan 26 2008 - 20:48:19 CST