Home » RDBMS Server » Performance Tuning » oracle 10g analyze table temporary segments (oracle 10g)
oracle 10g analyze table temporary segments [message #298160] Tue, 05 February 2008 03:24 Go to next message
vipull.sayal
Messages: 4
Registered: February 2008
Junior Member
Hi,

I am facing a performance problem in oracle 10g. When I use 'Anylyze table' command in oracle 10g, it creates the temporary segments in the database.
Normally, temporary segments are created in temporary tablespace when the sql commands like SELECT, ANALYZE, TRUNCATE etc fall short of memory. So even oracle 9i does the same thing that it creats the temporary segments, but I guess afterwards the temp segments are cleaned up when the optimizer doesn't need the extra memory anymore.

Anyone has an idea how the same thing can be implemented in oracle 10g?? could there be any other reason except what I am guessing?? Any solution if you can propose..

Regards,
Vipull
Re: oracle 10g analyze table temporary segments [message #298166 is a reply to message #298160] Tue, 05 February 2008 03:40 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't use "analyze table" use dbms_stats.

Regards
Michel
Previous Topic: db job
Next Topic: Incremental logic on a complex query
Goto Forum:
  


Current Time: Sun Dec 11 04:10:05 CST 2016

Total time taken to generate the page: 0.15650 seconds