Re: Performance issue on table queries on increasing size of unrelated tables

I wouldn't jump into the conclusion that these 2 are related. On one side, you have a problem of increased execution time. On the other, you have some unrelated tables growing in size.

How do you know they are related? To me these are merely 2 separate observations.

If this is true then we can attribute all DB performance issues to "some tables growing in size" as almost every single database in the world has some tables always "growing in size".

I think they are most likely irrelevent and suggest you should look into v$session_event or trace the questioned session to find out how it spends its time.

Your problem may not even be in the database at all. Just because your execution time from the Apps becomes longer does not mean they all wind up in DB time. Received on Tue May 31 2005 - 15:57:50 CDT