Relation between indexes and performance!
741747Oct 4 2010 — edited Oct 22 2010Hello guys,
i am pretty new to this world. I am developer and DB responsable of a small software house. We use .Net 2.0 and Ora 11gR1/2 with the proper drivers.
Here the problem: we go to the client to install our 11gr2+sw. At the start the system is really responding. After 1/2 month of usage the whole db turns slow. Ok i khnow there are a lot of more items in the db after 2 months, but i can't believe oracle has these performance.
I saw one thing: rebuilding all the indexes solves (partially) the problem. I go back at good performance (even if not so good as in a fresh installation). I am reading docs and staff: many times i read that rebuilding indexes isn't always the best way to boost performance. Btw now i have scheduled a batch file calling a PL/SQL procedure that rebuild indexes every night. Can some expert of you spend some word about this topic?
Moreover: The performnace feature of the oracle console can help me? Could i see nice results with this staff. When i implement the suggestions (like move from this to this execution plan for this query) the console suggests i shoud expect i.e. 80% performance boost implementing this or that plan but i really can't see the difference while using the sw.
Any help or link is appreciated of course
Frank
Thanks