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.

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

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 : ulimits

By Martin | June 5, 2009

To view current settings, run command:
ulimit -a

To set it to a new value for this running session, which takes effect immediately, run command:
ulimit -n 8800
ulimit -n -1 // for unlimited; recommended if server isn’t shared

Alternatively, if you want the changes to survive reboot, do the following:

- Exit all shell sessions for the user you want to change limits on.
- As root, edit the file /etc/security/limits.conf and add these two lines toward the end:
oracle soft nofile 16000
oracle hard nofile 20000
** the two lines above changes the max number of file handles – nofile – to new settings.
- Save the file.
- Login as the user1 again. The new changes will be in effect.

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: Uncategorized | No Comments »

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

Comments

You must be logged in to post a comment.