My Learning

First of all alter the system or edit the parameter file for this entry Alter system set resource_limit = true After that create a profile with the required options Assign these profiles to the users whoever you want to restrict Create profile test_profile Limit session_per_user 2 idle_time 2 ; Assign this profile to users Alter user scott Profile test_profile;

Swap space configuration Between 513 MB and 2048 MB 1.5 times the size of RAM Between 2049 MB and 8192 MB Equal to the size of RAM check swap space # grep SwapTotal /proc/meminfo check free memory free Disk Space Requirements Between 150 and 200 MB of disk space the /tmp directory df -k /tmp (this will give in kb if you want in larger size give -h) Maximum space requirement for enterprise installation 1.5 GB Checking the Software Requirements Operating system Requirements Red Hat Enterprise Linux 5.0 Determining distribution and version of Linux # cat /etc/issue For installation purpose edit the following file to make the release as 4 Even though oracle 10g is certified on 5 oracle is recommending changing this to 4 to pass the os checking (oracle release notes for 10g on linux) On Oracle Enterprise Linux 5 and Red Hat Enterprise Linux 5, the installation passes the operating system prerequisite checks if you change each 5 to 4 in the /etc/redhat-release file. Ensur

http://t13n.googlecode.com/svn/trunk/blet/docs/help_ml.html

Lost updates happen in multi user environment quite normally if the application is not well built. It happens when you have multiple users and some of them are trying to update same data around same time. User’s action from query to update: - Data is retrieved to user's memory, make the necessary changes and puts the data back to the database. Data is read from the database to the users’ machine around the same time, session one makes required changes and saves, by this time the other session also does some changes and saves. If there is no checking the second session will overwrite the first session's changes. Let’s take an application to explain This is an application which will be used by users for booking for programmes. The current situation is that only one seat is available but two users are querying the system for booking at the same time. User_1 queries the system and gets the status of booking “open” only for one person User_2 queries the system and ge