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

Thread: Analyze oracle 9i

  1. 01-14-2003, 07:03 AM #1
    salvareztur
    salvareztur is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  2. 01-14-2003, 07:05 AM #2
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    use dbms_stats

    go tahiti.oracle.com
    Reply With Quote Reply With Quote
  3. 01-14-2003, 07:30 AM #3
    salvareztur
    salvareztur is offline Junior Member
    Join Date
    Jan 2003
    Posts
    40

    Unhappy

    Using this package I haven´t to delete last analyzed of partitions???
    Reply With Quote Reply With Quote
  4. 01-14-2003, 07:31 AM #4
    salvareztur
    salvareztur is offline Junior Member
    Join Date
    Jan 2003
    Posts
    40

    Podemos continuar en español?

    Se puede continuar en español?
    Reply With Quote Reply With Quote
  6. 01-14-2003, 07:32 AM #5
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    dbms_stats lets you to analyze in parallel
    Reply With Quote Reply With Quote
  7. 01-14-2003, 07:34 AM #6
    pando
    pando is offline Pando & Company
    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
    Reply With Quote Reply With Quote
  8. 01-14-2003, 07:36 AM #7
    salvareztur
    salvareztur is offline Junior Member
    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??
    Reply With Quote Reply With Quote
  9. 01-14-2003, 07:39 AM #8
    pando
    pando is offline Pando & Company
    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
    Reply With Quote Reply With Quote
  11. 01-14-2003, 07:43 AM #9
    salvareztur
    salvareztur is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  12. 01-14-2003, 07:47 AM #10
    pando
    pando is offline Pando & Company
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width