Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Collecting table statistics
Hi,
That would be the new 'monitoring' option (as in , alter table <tablename>
monitoring, default is nomonitoring).
I have not used it yet, but remember reading about it..
- Kirti
> -----Original Message-----
> From: Chuck Hamilton [SMTP:chuck_hamilton_at_yahoo.com]
> Sent: Friday, July 21, 2000 1:57 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Collecting table statistics
>
> Some time ago I thought I saw something on the list about 8i having the
> ability to automatically collecet statistics on tables with needing to
> issue the ANALYZE TABLE command. Can someone tell me how this works or
> point me to a document that describes it? Is this what the MONITORING
> clause of ALTER/CREATE table is for?
>
>
>
>
>
> _____
>
> Do You Yahoo!?
> Get Yahoo! Mail <http://mail.yahoo.com/> - Free email you can access from
Received on Fri Jul 21 2000 - 13:24:11 CDT
![]() |
![]() |