Originally Posted by PAVB
Don't take it wrong, I trust what you say but it's really hard to believe reinstallation of Oracle binaries has something to do with getting better performance.
As per previous postings who have said you already tried exp/imp with no success.
Lets try to take Oracle binaries out of the equation. Could you please do the following two tests?
++ Test #1
1-- Shutdown your database
2-- Reboot your server
3-- Startup your database
4-- Check performance... how is it now?
IF performance is better either Oracle services recycle or O/S
recycling fixed it.
If Test #1 does not does the trick...try test #2...
++ Test #2
1-- Export your erp database (just in case)
2-- Uninstall Oracle software
3-- Reinstall Oracle software
4-- Create your erp database pointing to the old datafiles
5-- DO NOT IMPORT the data, lets Oracle work with the old data
6-- Startup your database and check performance... how is it now?