Results 1 to 4 of 4

Thread: Analyze Schema

  1. #1
    Join Date
    Jan 2004
    Posts
    84

    Unanswered: Analyze Schema

    I am running
    exec dbms_stats.gather_schema_stats(ownname=>'CDWPROD', degree=>2,cascade=>TRUE);

    and it has taken 6 hrs to complete.
    It has data of around 20GB

  2. #2
    Join Date
    Jan 2004
    Posts
    84

    Re: Analyze Schema

    Is there any particular reason why analyze could take so long?

  3. #3
    Join Date
    Jul 2003
    Posts
    2,296
    well, you are doing complete analyzing on indexes and tables in that schema. Everything depends on the size of the objects in that schema.

    You might want to try ESTIMATE option.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  4. #4
    Join Date
    Jan 2004
    Posts
    84
    Hi,
    I used ESTIMATE as 33 %.
    The tables are populated using comple delete and then insert ( not incrementally). The performance of inserting into that today was bad .
    It is a 25000 records table and would normally take 5 mins but today it took 2 hrs. Was it because it was not a complete analyze but 'estimate'

Posting Permissions

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