1).To find the top 10 larger files in the Directory $ls -lrt | awk ‘{print $5,$9}’ | sort -nr head | xargs ls -lrt 2) To find the access and Modification details of a file $istat *This command is available for AIX only 3).To remove file which are older then say 7 days $find . [...]
Impacts of kernel parameter on oracle server ? On SGA(Shared Global area) on oracle server Impacts on the total number of users and files in the database Impacts the number of users and the ability to use some optional features. To see all kernel parameters value on your system . execute the following command. su [...]
To monitor background jobs on UNIX, you can use the following commands : jobs ps jobs command jobs command will list all the jobs running in the background as follows: [1] – 12427 Running test.pl [2] + 12540 Stopped myprog.pl The value within “[]” is the job number. By this number you can control our [...]
UNIX job monitoring and control facilities allows you to monitor the jobs executed on background and bring the jobs on foreground . Here I like to described different command used to control your jobs on background as well as foreground. Commands to control your jobs on UNIX systems jobs - This command check the status [...]
Is your background jobs on Unix impact on System Performance? Yes, but it depends upon the priority of the job and how much RAM they require to run. Large jobs like you are downloading a huge file from the web, can consume immense amount of RAM which can be very painful for your system performance [...]
In some scenarios , my database may be hung and as a DBA ,I have terminate all Oracle processes associated with my hung database. Steps to kill oracle process and release memory associated by oracle server 1. Kill all Oracle processes associated with the ORACLE_SID Executing following command we can check all oracle process associated [...]
There are different ways to kill oracle sessions From SQL*PLUS From UNIX From Windows Killing Oracle Session from SQL*PLUS Executing ALTER SYSTEM KILL SESSION command from SQL*PLUS prompt , we can kill oracle session. Before going to kill oracle session , we have to identify those using the following DDL statement. SELECT sid, serial#, osuser, [...]
