TEMP Tablespace - Analyze
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: TEMP Tablespace - Analyze

  1. #1
    Join Date
    Oct 2000
    Posts
    449
    When Analyze is going on, I guess Temp TS is working right. Is there anyway to see that if the analyze is currently working. The reason being, I have run analyze query on a table that has about 15 million rows and its response is hanging till it finishes.. (sine 30 minutes)
    I queried the dba_free_space for the temp tablespace and all 500mb is free.. confirmed with dba_data_files (bytes)
    By the way, I dont have to worry if my TS are locally managed with autoextend ON right.. I mean, if not, I want to extend my Temp TS with another 500M..
    Please confirm. thanks

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    It is very difficult to analyze a table that has 15M rows.
    Why don't you analyze 5% of the data initially, then slowly increase the %.

    Query from V$SORT_SEGMENT for usage of the TEMP tablespace.

  3. #3
    Join Date
    Oct 2000
    Posts
    449
    Thanks Tamil: How should I do it in parts vs increase in the % and do a full 100%.. Pl.explain.

  4. #4
    Join Date
    Jan 2001
    Posts
    2
    Estimate the statistics instead of computing them

  5. #5
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    analyze table EMP estimate statistics for all columns sample 10 percent;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width