Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Analyze table function

Re: Analyze table function

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Thu, 20 Dec 2001 13:41:01 GMT
Message-ID: <3c21ea22.2675627921@news.alt.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US