| oracle 10g analyze table temporary segments [message #298160] |
Tue, 05 February 2008 03:24  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
