-
Poor performance after database reorganization (8.1.7.0)
Hi! I need help please!! Sorry for my poor english.
I created two new tablespaces (one for tables and one for indexes).
I used "alter table ... move tablespace " and "alter index ... rebuild tablespace " for some objects. I executed "alter table ... move tablespace " and "alter index ... rebuild" to reorganize the objects.
After that, the database shows a POOR performance. I found some ORA-0600 in alert.log, related to compressed index. Following Metalink recomendations, I rebuilt the indexes with nocompress option. The error disapears, but performance problems continues. I analyzed the objects (the optimizer_mode is CHOOSE), but slow problem continues.
Please let me know if anybody had a similar problem or what to do!!!!
Thanks!!!
Natalia
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
|