Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Analyze table function
On 16 Dec 2001 23:43:20 -0800, damian.gonsalves_at_skye.co.za (Damian
Gonsalves) wrote:
>ganesh_at_gtfs-gulf.com (Ganesh Raja) wrote in message news:<a8aed4.0112142145.50831be4_at_posting.google.com>...
>> damian.gonsalves_at_skye.co.za (Damian Gonsalves) wrote in message news:<42adb2bb.0112140650.686bb31f_at_posting.google.com>...
>> > Hi there
>> >
>> > Can anyone tell me if there is a way to determine if a table needs to
>> > be re-analyzed. For instance to check if a spatial index is fragmented
>> > or out of balance you can run the SDO_TUNE.ANALYZE_RTREE function
>> > which will recommend whether to rebuild the index or not.
>> >
>> > So is there a way to determine if a table needs to be re-analyzed by
>> > looking at the stats or something like that. I already know how to
>> > check if a table has been analyzed.
>> >
>> > Any feedback will be greatly appreciated.
>> > Damian Gonsalves
>>
>> Hi,
>>
>> Monitor the table that will tell you when u need to Analyze the table.
>>
>> For more info u can try the documentation Libary.
>>
>> HTH
>>
>> Regards,
>> Ganesh R
>
>Hi Ganesh
>
>What is the name of this table that you can monitor to let you know
>when to re-analyze the table?
>
>Thanks
>Damian
I believe he is referring to the MONITORING keyword in the ALTER/CREATE TABLE statement.
Check it out in the SQL Reference.
Brian Received on Thu Dec 20 2001 - 07:41:01 CST