Monitor during statistics [message #358171] |
Mon, 10 November 2008 00:04 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
balaji1482
Messages: 312 Registered: July 2007 Location: INDIA
|
Senior Member |
![YES](/forum/theme/orafaq/images/yahoo.png)
|
|
Hi all,
While running the schema/table statistics in oracle 9i, do we have to monitor temp tablespace??
Can anybody tell me what are the things we need to monitor in database while running statistics .
OS -- windows 2000
With Regards,
Balaji
|
|
|
|
|
|
|
|
|
Re: Monitor during statistics [message #358275 is a reply to message #358235] |
Mon, 10 November 2008 08:18 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68679 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
It depends how you analyze (analyze or dbsm_stats) and which level, your oracle version and so on.
The best is to test it.
Have a look at statistics like '%direct%', gather statistics, and query again the previous statistics and see the differences.
Regards
Michel
|
|
|