About bearparc

A software development blog for the qualified developer

Blogroll

Application Server (24)
Business Intelligence (13)
Business Logic Layer (6)
C (2)
C++ (3)
CMMI (4)
Data Mining (3)
DataMart (11)
DataWarehouse (11)
ETL (7)
FAQ – Troubleshooting (8)
Framework (4)
Hardware (10)
Informatica Powercenter (6)
Investition (2)
J2ee (8)
Java (6)
JBoss (1)
Liferay (11)
LINUX (11)
objektorientiertes Design (2)
OLAP (7)
Oracle (48)
Projektmanagement (5)
Prozeßmodelle (4)
Software (33)
SQL (24)
Uncategorized (31)
Web 2.0 (5)
Weblogic (17)
wordpress (5)
XML (2)

WP-Cumulus by Roy Tanck and Luke Morton requires Flash Player 9 or better.

nowait ¤ system ¤ workflow ¤ ora-00845 ¤ acquire ¤ 8024402c ¤ supported ¤ this ¤ to_integer ¤ resource ¤ with ¤ busy ¤ oracle ¤ informatica ¤ memory_target ¤ specified ¤ ora-00054: ¤ zeilen ¤ linux ¤
ora-00054 ¤ informatica workflow ¤ ora-00845 linux ¤ ora-00845 ¤ ora-00845: memory_target not supported on this system ¤ ora-00054: resource busy and acquire with nowait specified ¤

www.brokerbase.ch network

Search



Add to Technorati Favorites Blogverzeichnis - Blog Verzeichnis bloggerei.de Deutsches Blog Verzeichnis blogoscoop Add to Google http://www.wikio.de
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...

« | Main | »

Linux Oracle tuning parameter : Tune TCP

By Martin | June 5, 2009

To view current TCP settings, run command:
sysctl net.ipv4.tcp_keepalive_time
net.ipv4.tcp_keepalive_time = 7200 // 2 hours
where net.ipv4.tcp_keepalive_time is a TCP tuning parameter.

To set a TCP parameter to a value, run command:
sysctl -w net.ipv4.tcp_keepalive_time=1800

A list of recommended TCP parameters, values, and their meanings:

Tuning Parameter Tuning Value Description of impact
——————————————————————————
net.ipv4.tcp_tw_reuse
net.ipv4.tcp_tw_recycle 1 Reuse sockets in the time-wait state

net.core.wmem_max 8388608 Increase the maximum write buffer queue size

net.core.rmem_max 8388608 Increase the maximum read buffer queue size

net.ipv4.tcp_rmem 4096 87380 8388608 Set the minimum, initial, and maximum sizes for the
read buffer. Note that this maximum should be less
than or equal to the value set in net.core.rmem_max.

net.ipv4.tcp_wmem 4096 87380 8388608 Set the minimum, initial, and maximum sizes for the
write buffer. Note that this maximum should be less
than or equal to the value set in net.core.wmem_max.

timeout_timewait echo 30 > /proc/sys/net/ipv4/tcp_fin_timeout Determines the time that must elapse before
TCP/IP can release a closed connection and reuse its resources.
This interval between closure and release is known as the TIME_WAIT
state or twice the maximum segment lifetime (2MSL) state.
During this time, reopening the connection to the client and
server cost less than establishing a new connection. By reducing the
value of this entry, TCP/IP can release closed connections faster, providing
more resources for new connections. Adjust this parameter if the running application
requires rapid release, the creation of new connections, and a low throughput
due to many connections sitting in the TIME_WAIT state.

Social Bookmark These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Faves
  • LinkedIn
  • MisterWong
  • MySpace
  • Reddit
  • Technorati
  • Wikio
  • YahooBuzz
  • Ask
  • Google Bookmarks
  • Linkarena
  • Live-MSN
  • Newstube
  • seekXL
  • TwitThis
  • Webnews
  • Webride
  • Wikio DE
  • Y!GG
  • YahooMyWeb

Topics: LINUX, Oracle | No Comments »

Trackback URL for this post: http://www.bearparc.info/2009/06/05/linux-oracle-tuning-parameter-tune-tcp/trackback/

Comments

You must be logged in to post a comment.