Home » RDBMS Server » Server Administration » Monitor during statistics (Oracle 9i,Windows 2000)
Monitor during statistics [message #358171] Mon, 10 November 2008 00:04 Go to next message
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 #358188 is a reply to message #358171] Mon, 10 November 2008 00:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
while running statistics

What do you mean?

Regards
Michel
Re: Monitor during statistics [message #358203 is a reply to message #358188] Mon, 10 November 2008 01:40 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

I mean during schema/table analyze which is used to gather statistics of the tables, what are the things we need to monitor at that time in database??

Re: Monitor during statistics [message #358210 is a reply to message #358203] Mon, 10 November 2008 02:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is the purpose of your monitoring?

Regards
Michel
Re: Monitor during statistics [message #358222 is a reply to message #358210] Mon, 10 November 2008 03:12 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

Actually,i just want to know whther we need to monitor anything in database like tablespace,lock,CPU utilization etc...
during analyzing the table(DBMS_STATS)


Regards,
Balaji
Re: Monitor during statistics [message #358229 is a reply to message #358222] Mon, 10 November 2008 03:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why do you want to monitor something?

Regards
Michel
Re: Monitor during statistics [message #358235 is a reply to message #358229] Mon, 10 November 2008 04:33 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

can you tell me ,Will the temp tablespace used in schema analyze??

Re: Monitor during statistics [message #358275 is a reply to message #358235] Mon, 10 November 2008 08:18 Go to previous message
Michel Cadot
Messages: 64103
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
Previous Topic: Archive log transfer...
Next Topic: Why size od sysaux datafile is limited to 16383MB
Goto Forum:
  


Current Time: Sun Dec 04 21:01:46 CST 2016

Total time taken to generate the page: 0.04269 seconds