+4Hi all, after a failed update we rolled back the servers and they have went from around 10% to 100% and sitting at this constantly. has anyone else had this issue and if so what was the fix?
Support just told us to upgrade our hardware… but that doesn't explain why it jumped so much.
i have noticed there is some stuck threads, but unsure what is causing these.
Thanks
+18Hi
It’s completely normal to have stuck threads in your system. But eventually, they should get resolved. If not, then that’s a problem. Have you tried a complete server restart?
+4Hi
They have been there for around 2 weeks and not shifted, and yes a complete server restart has been done a couple times.
Thanks
+30It looks like this is the DB server (or is the database and middleware running on the same server?). can you check one of the “V$” DBA views in Oracle to see what is running? I am not an Oracle expert so I do not know what query to run, but you should be able to see things from the database server’s point of view and maybe get an understanding of what is running…
JoeK
+4Hi
I can run a statspack and see whats running from the server, and yes this is the DB server, the Middleware is separate.
Thanks
+18
It seems like it’s the Oracle RDBMS server that is spiking. It’s better to check the resources.
+16Hello
It is better to check the TOP consumers after generating a statspack report. Also, it seems there are multiple DB instances are running in this VM. So, most probably this might be a resource limitation issue. Please go through the following article as well.
Cheers!
+4Hi
I have just ran the stats pack and I cant see Top Consumers, I can only see Top Timed events?
also there should only be the one Instance on this server, I am going to look at that now.
Thanks
+4
just checked and the other instances that are running are for PSOCDB and TASCDB that are fine and are using minimal resource.
Thanks
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
