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
Messages: 4
Registered: February 2008
Junior Member

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..

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: 65085
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't use "analyze table" use dbms_stats.

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

Current Time: Mon Jul 24 19:51:09 CDT 2017

Total time taken to generate the page: 0.06365 seconds