Server:
Windows 2008 R2 x64
Oracle Database 11g Release 11.2.0.1.0 Standard Edition
I recently applied the Oracle® Database Server Version 11.2.0.1 Patch 16
I have several databases running on this box with the same application.
Since then I've had lots of customers complaining about slow systems. The server has plenty of RAM available
I also have several other servers all on the same versions, same patch, running the same application with no issues.
Looking at v$session there are often lots of active sessions that have a sql_address of "00". I've never seen this before and I regularly look at v$session, as you can see for below these have been running for a while. The sessions do drop off but I am at a loss as to what is happening, any ideas?
select username, last_call_et, sid, serial#, user#, status, sql_address, sql_hash_value
from v$session
where username is not null and status = 'ACTIVE'
order by last_call_et desc, sid
SQL> /
USERNAME LAST_CALL_ET SID SERIAL# USER# STATUS SQL_ADDRESS SQL_HASH_VALUE
------------------------------ ------------ ---------- ---------- ---------- -------- ---------------- --------------
E_AGENT_DATA 27 16 334 296 ACTIVE 000007FF25D3EED0 3993603298
E_AGENT_SITE_PUBLIC 12 165 158 299 ACTIVE 000007FF1F741B60 2663972719
DYERE 2 166 387 324 ACTIVE 00 0
SANSONG 2 172 388 334 ACTIVE 00 0
E_AGENT_DATA 0 171 279 296 ACTIVE 000007FF0F8F5CA8 211585558
ONEILLK 112 37 370 300 ACTIVE 000007FF1F6CD5E8 3631311537
HOADE 17 18 335 339 ACTIVE 00 0
ONEILLK 17 34 560 300 ACTIVE 00 0
OLIVERC 17 38 221 301 ACTIVE 00 0
NEWSTEADN 17 140 515 307 ACTIVE 00 0
BURTE 17 149 562 336 ACTIVE 00 0
WHITEK 17 161 376 333 ACTIVE 00 0
E_AGENT_SITE_PUBLIC 16 165 158 299 ACTIVE 00 0
E_AGENT_DATA 0 171 279 296 ACTIVE 000007FF0F8F5CA8 211585558