sqlnet contention

[cravi]

Hi All,

Previously the concurrent users are 44 and a few days back it increase to 520. The Library cache, Dictionary cache hit ratios, Database buffers and SGA are perfect. But the users are telling the performance is slow. There is something we tune the sqlnet.ora or Tnsnames.ora. I guess the problem is In networking area. Is there anything we can tune in sqlnet or in tnsnames to achieve the good performance.

Please let me know in detail!!!!

Thanks
Ravi

[Shestakov]

Need information about:
type of OS
type of network protocols
ur db works thru firewalls or not...
type of client's application (C/S, WEB, terminals ...)
A lot of questions.

[cravi]

Hi,

Here is the Info.:

3-Tier :

The OS : Windows 2000 advanced server

Database : Oracle 8.1.7.2

Application : Siebel 7.0.4

Concurrent users : 520

Network Protocol : TCP

Database is NOT working through Firewalls

Client Applications : Through WEB.

If you need any specific Info please do let me know. I will provide all that.

Thanks for the reply.
Ravi

[Shestakov]

Uuuuu...
U have many points of potential problems with perfomance :

web_server(1) --(2)-->app_server(3) --(4)-->oracle_server(5)
------------------------------------------------
1) perfomance of Web server with 520 connections
2) traffiic between web and application server
3) perfomance of App server with 520 connections (probably one of Java app server)
4) traffiic between app and oracle server
5) perfomance of oracle server with 520 connections
------------------------------------------------
Try to implement following seq of actions:
-- check terminal access (sqlplus) from db server box (u exclude sqlnet)
then
-- check terminal access (sqlplus) from application server box (u include traffic
between Siebel application BOX ONLY and oracle server)
and so on...
------------------------------------------------
I don't thing that u have problems with sqlnet only.