D
dbeavon
Guest
Thanks for the reply. We use OEE ("free" version) and it has some very minimal features for monitoring a database. The main things we'd like to see are locks, and user sessions, and possibly the table activity for individual user numbers. The version of OE we are on is 11.6.3.013. That is the version that is demonstrating performance issues on both of the HP-UX environments where we have tried to get OEE running . As soon as we start using the "User Details" views, it sends some work off to the "admin server" java process and it consumes quite a lot of CPU. I'm not doing much more than just clicking on a single client user number (17 or whatever) and seeing the details for it. That alone is enough to swamp CPU on two cores for a couple minutes. It seems to be gathering a couple parts of the page asynchronously (eg. the "Table Activity" and "Index Activity" for the user 17). Even if you click away to a different page, the CPU continues to be pegged on the server and slows down subsequent U/I interaction as well. I'm not sure why this takes so long, or why there is so much CPU-intensive work within a java-related admin server process ... instead of in the _dbagent itself, or why none of these performance issues were occurring in Windows. I'd also like to know whether there are preferences to *disable* these types of OEE behaviors that are consuming so much CPU on the server. There are quite a lot of benefits in having some visibility on the database in OEE... however we don't want the use of this to generate an entirely new set of problems for us. If I had to guess, I'd say that the java admin server process is waiting on data from _dbagent and is passing the time in an extremely high CPU-spinning loop. Would you please click on one of the connections in the "Database Connections" tab and see if it caps out your CPU on the server's java process for long periods of time? As I said, my Windows installation is better behaved, and it is possible that I'm dealing with yet another instance of HP-UX-specific problems that don't affect the more common OE platforms like Windows and Linux.
Continue reading...
Continue reading...