Hi : I am analyzing all tables for a particular tablespace i.e., about 50 tables and maximum of GB space. For some reason after a certain stage, at one table it is hanging for a long time(say 1 hour)..
How can I make sure if oracle is doing something or simply hanging or how to go about solving it..
Hi Tamil: I added another 500MB to temp space(altogether 1GB) and all free when i started the query again..
This table has 21 million rows of each row avg of upto 250 bytes.. No OLTP is going on this table.. still since 20 minutes it is going on and since morning i have used up close to 3 hours of time on this.. i have a few more tables like this..
what is the best way out?? Thanks..
Jeff: I still have to do that ctablock.sql. Do you have any docs on the same, so i know what i am doing?
You can read about catblock.sql at ( [url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76956/manproc.htm#11735[/url] ). I've found that you can just get more information looking at the script...
You can also try dbms_stats.gather_table_stats() to compute the statistics in parallel (see [url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a76936/dbms_st2.htm#1003993[/url] )