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