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

Thread: Database Reorg.

  1. #1
    Join Date
    Mar 2001
    Posts
    36
    I have been assigned to reorg our production database and so far I have no idea how to get it done. Oracle Database version is 7.3, and the size of database is 800GB. How can I do this? Please help

  2. #2
    Join Date
    Aug 2001
    Posts
    267
    Can you give us more details about ...

    You want to go for new versions . or you are trying recreate indexes/blah ... trying to tune the database etc.,
    Raghu

  3. #3
    Join Date
    Mar 2001
    Posts
    36
    I don't want to upgrade database.

  4. #4
    Join Date
    Jun 2001
    Posts
    15
    exp/imp will get rid of database fragmentation, if that's your concern...

  5. #5
    Join Date
    Mar 2001
    Posts
    36
    I want to know what are the tables needs to be reorg...?
    and also which tablespace table needs to reorg...?
    Can I got tables reorg. infomation without analyze....?

    [Edited by pinakpatel on 03-13-2002 at 04:33 PM]

  6. #6
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    You're going to need to help us out a little more...

    When you say "reorg" what exactly do you mean?

    A "reorg" is done to recover space and help performance by rebuilding the table or index.

    Is that what you want to do?

    -Ken

  7. #7
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Are you saying you want fragmentation information?

  8. #8
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    This is a perfect example of "Don't feel stupid if you ask a question."

    Ask your boss what he/she meant. Ask why they think the database needs to be re-orged.
    Jeff Hunter

  9. #9
    Join Date
    Mar 2001
    Posts
    36
    We need reorg Database Due to performance problem...
    Also more than 10 tables having size between 20-40 GB.

  10. #10
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Large tables doesn't equate to poor performance...

    First check the performance of the queries running against the database. 9 times out of 10, that'll make you the hero.

    Also, look into rebuilding your indexes.

    Chances are that your tables are fine.

    -Ken

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