| Monitor during statistics [message #358171] |
Mon, 10 November 2008 00:04  |
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
|
Senior Member |
|
|
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  |
 |
Michel Cadot
Messages: 68666
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
