-
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
-
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
-
I don't want to upgrade database.
-
exp/imp will get rid of database fragmentation, if that's your concern...
-
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]
-
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
-
Are you saying you want fragmentation information?
-
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
-
We need reorg Database Due to performance problem...
Also more than 10 tables having size between 20-40 GB.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|