OraFAQ Forum: Networking and Gateways » How to Increase Oracle SQL*Net Performance

Home » RDBMS Server » Networking and Gateways » How to Increase Oracle SQL*Net Performance (Windows 2008 Server, Oracle 10,2,0.3, MOD_PLSQL,)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to Increase Oracle SQL*Net Performance [message #532947]

Fri, 25 November 2011 09:53

BBMamun
Messages: 94
Registered: February 2010
Location: Dhaka, Bangladesh

Member

Hi

One of my MOD_PLSQL based Oracle APEX Application is running on the web. I have almost 1000 web users to access the Application where at least 250-300 users are always on line. In Oracle EM web interface When run ADDM I see suggestions "Investigate the cause of SQL*Net more data to client" or something like this. and I am getting complains about poor server response. Here are my configuration of the system:

Database Server Host: DBServer (Oracle Database 10.2.0.3)
HTTP Server Host: OraHTTP (Oracle Companion CD 10g)

DADS.conf HTTP Server configuration
MOD_PLSQL database access for web clients.

How can I increase database connection performance? Please post your helps.

Regards

Hasan Al Mamun
Programmer
Bangladesh Bank
Dhaka, Bangladesh

Report message to a moderator

Re: How to Increase Oracle SQL*Net Performance [message #532958 is a reply to message #532947]

Fri, 25 November 2011 10:52

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

or something like this

There are several events of about the same name. Each one requires a different approach, so be accurate.

Quote:

How can I increase database connection performance?

First investigate if there is any network problem.
What is your ftp rate?

Regards
Michel

Report message to a moderator

Re: How to Increase Oracle SQL*Net Performance [message #533001 is a reply to message #532958]

Sat, 26 November 2011 07:41

BBMamun
Messages: 94
Registered: February 2010
Location: Dhaka, Bangladesh

Member

I don't know what can be the actual question which can pin point my requirements so that an expert can answer what I really want, that's why I have mentioned my application's setup and my client. It is an OLTP system. Almost 1000 web client enter data it the system,no ftp operation is there all are HTTP based data entry even no file up/down load is there. Huge network traffic is there, both in and out ward. And I think if I can meet ADDM suggestions I can solve the problem. But don't know how to. Please suggest.

Hasan Al Mamun

Report message to a moderator

Re: How to Increase Oracle SQL*Net Performance [message #533003 is a reply to message #533001]

Sat, 26 November 2011 09:25

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

Hasan, you need to be more precise. Saying "....or something like this" isn't good enough. It is probably best if you post the ADDM report that you are looking at, also an AWR report for the same period.
And as for FTP, the idea is that you should see how well your network is performing. What transfer speeds do you get between the database server machine and the HTTP server machine?

Rgds, John.

Report message to a moderator

Re: How to Increase Oracle SQL*Net Performance [message #533050 is a reply to message #533003]

Sun, 27 November 2011 21:49

BBMamun
Messages: 94
Registered: February 2010
Location: Dhaka, Bangladesh

Member

Hi, here is the full ADDM Suggestion:

Investigate the cause for high "SQL*Net more data to client" waits. Refer to Oracle's "Database Reference" for the description of this wait event. Use given SQL for further investigation.

Hasan AL Mamun

Report message to a moderator

Re: How to Increase Oracle SQL*Net Performance [message #533051 is a reply to message #533050]

Sun, 27 November 2011 21:57

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://blog.tanelpoder.com/2008/02/10/sqlnet-message-to-client-vs-sqlnet-more-data-to-client/

Report message to a moderator

Re: How to Increase Oracle SQL*Net Performance [message #533839 is a reply to message #532947]

Thu, 01 December 2011 08:35

BBMamun
Messages: 94
Registered: February 2010
Location: Dhaka, Bangladesh

Member

Hi, I have kind of managed (cannot say solved) the situation with multiple actions is Oracle Database and Since the application is developed in Oracle Apex, I had to do something in Apex and HTTP Server as well.

1. In Oracle sqlnet.ora, listener.ora file I have configured SDU (Session Data Unit), Send/receive buffer and restarted the listener. http://docs.oracle.com/cd/B14117_01/network.101/b10775/performance.htm

2. Moved All images, CSS and .js files to HTTP Server and referenced them with ...#IMAGE_PREFIX#/file_location/cssfile.css.. at Apex page header.

3. In my main DML Pages Replaced List item and LOV with text fields and using item level computation and ajax for corresponding actions.

Now performance is better.and ADDM is not giving the above suggestion.

Regards

Hasan Al Mamun

[Updated on: Thu, 01 December 2011 08:40]

Report message to a moderator

Previous Topic:	connecting Oracle to SQL server
Next Topic:	Listner start failed after configuring

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 13:15:23 CDT 2025