-
Hi All
I have a database server which is used by a java application. I have reported by java people that there is connection timeout error sometimes. This happens once in a day. there are hardly 5 machines accessing my database then why this problem is coming? I have also incresed the parameter values for 'PROCESSES' and 'OPEN_CURSORS'. Still this is happening. What can be the problem and whats the solution for it. I am sending the output of my query to V$SESSION.
select sid, spid as thread, osuser, s.program
from sys.v_$process p, sys.v_$session s
where p.addr = s.paddr;
SID THREAD OSUSER PROGRAM
---------- --------- ------------------------------ ---------------
1 213 SYSTEM ORACLE.EXE
2 214 SYSTEM ORACLE.EXE
3 148 SYSTEM ORACLE.EXE
4 97 SYSTEM ORACLE.EXE
5 91 SYSTEM ORACLE.EXE
6 218 SYSTEM ORACLE.EXE
7 223
8 224
9 225
10 226
11 302 NTSERVER\pravin SQLPLUSW.EXE
12 288 jdbcuser JDBC-1.0-Client
18 344 jdbcuser JDBC-1.0-Client
16 361 jdbcuser JDBC-1.0-Client
22 339 jdbcuser JDBC-1.0-Client
15 358 jdbcuser JDBC-1.0-Client
54 161 jdbcuser JDBC-1.0-Client
SID THREAD OSUSER PROGRAM
---------- --------- ------------------------------ ---------------
14 279 jdbcuser JDBC-1.0-Client
19 87 NTSERVER\anita Toad.exe
55 351 jdbcuser JDBC-1.0-Client
33 266 jdbcuser JDBC-1.0-Client
36 160 jdbcuser JDBC-1.0-Client
37 198 jdbcuser JDBC-1.0-Client
35 271 jdbcuser JDBC-1.0-Client
32 253 jdbcuser JDBC-1.0-Client
53 320 jdbcuser JDBC-1.0-Client
49 366 jdbcuser JDBC-1.0-Client
52 356 jdbcuser JDBC-1.0-Client
31 255 NTSERVER\amol SQLPLUSW.EXE
43 304 jdbcuser JDBC-1.0-Client
Please let me know whats the problem and whts the soln.
-
you peeps have to read what is this forum about, it says
"TIPS & TRICKS"
your post seems like has nothing to do at all with this forum's title
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|