Analyze oracle 9i
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: Analyze oracle 9i

  1. #1
    Join Date
    Jan 2003
    Posts
    40

    Lightbulb Analyze oracle 9i

    Hi everione, In my bd I have 3 partitioned tables, I try to analyze them and it takes a long time for each partition , more than 20 minutes.
    Can anybody help me??
    Thank you
    Sonia.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    use dbms_stats

    go tahiti.oracle.com

  3. #3
    Join Date
    Jan 2003
    Posts
    40

    Unhappy

    Using this package I haven´t to delete last analyzed of partitions???

  4. #4
    Join Date
    Jan 2003
    Posts
    40

    Podemos continuar en español?

    Se puede continuar en español?

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    dbms_stats lets you to analyze in parallel

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447

    Re: Podemos continuar en español?

    Originally posted by salvareztur
    Se puede continuar en español?
    of coz not

  7. #7
    Join Date
    Jan 2003
    Posts
    40

    Unhappy

    Este pl analiza tablas enteras no?? yo sólo quiero analizar algunas particiones de mis tablas, se le pasa el nombre de la partición como parámetro y ya o hay que pasarle otros parámetros??

  8. #8
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    sorry this is an English forum as you might have noticed from my previous reply

  9. #9
    Join Date
    Jan 2003
    Posts
    40

    Red face

    Sorry, I don´t understand you, sorry sorry.
    Well I try to continue in English.
    This PL analyze full tables or also can analyze partitions of one table.
    I only want to analyze some partitions of my partitionated tables.

  10. #10
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well if you looked my thread and go to tahiti.oracle.com you would see how this package works

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