DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Question on the analyze command

  1. 05-11-2005, 10:43 AM #1
    Chintz
    Chintz is offline Member
    Join Date
    Dec 1999
    Posts
    217

    Question on the analyze command

    What is the process running within the Oracle database engine when a "analyze table" command is run. Are tables locked,etc?

    Chintzs
    Reply With Quote Reply With Quote
  2. 05-11-2005, 10:47 AM #2
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    the process is the server process

    tables are not locked
    Reply With Quote Reply With Quote
  3. 05-11-2005, 11:12 AM #3
    Chintz
    Chintz is offline Member
    Join Date
    Dec 1999
    Posts
    217
    So, what does happen at the backend while a analyze command is running?

    CHintzs
    Reply With Quote Reply With Quote
  4. 05-11-2005, 11:14 AM #4
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    scanning the objects?
    Reply With Quote Reply With Quote
  5. 05-11-2005, 04:39 PM #5
    Chintz
    Chintz is offline Member
    Join Date
    Dec 1999
    Posts
    217
    Thanks.
    Reply With Quote Reply With Quote
  6. 05-11-2005, 04:53 PM #6
    KenEwald's Avatar
    KenEwald
    KenEwald is offline Senior Advisor
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Here's a little sample. RTM.

    It samples data, collects statistics, counts rows.

    'validate structure' checks for corrupted blocks and in the process creates undo.
    Last edited by KenEwald; 05-11-2005 at 04:56 PM.
    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