-
Tuning the operating system for Weblogic
Tune the Operating System Each operating system sets default tuning parameters differently. For Windows platforms, the default settings are usually sufficient. However, the UNIX and Linux operating systems usually need to be tuned appropriately. UNIX Tuning Parameters Use the following guidelines when tuning UNIX operating systems supported by WebLogic Server. Solaris TCP Tuning Parameters For…
-
Script to work out yesterdays date on unix
# Set the current month day and year. typeset -Z2 month=`date +%m` typeset -Z2 day=`date +%d` year=`date +%Y` # Add 0 to month. This is a # trick to make month an unpadded integer. month=`expr $month + 0` # Subtract one from the current day. day=`expr $day – 1` # If the day is 0…
-
Check Oracle datapump job status
Checking Status of datapump jobs You can attach to a running job at any time to check the status. To attach to an export job, issue an expdp command, using the ATTACH parameter to specify the job name ie: expdp gennick/bramell attach=TEST shows an attach to the TEST job. When you attach to a job,…
-
Query Oracle Schema Size
To query Oracle to find the schema size run the following sql: select owner,sum(bytes) from dba_segments group by owner; If you do not have dba privs then use the table user_segments instead of dba_segments.
-
DB2 Deadlocks Event Monitor and how to investigate
DB2 by default will have a event monitor running which detects and logs details on deadlocks events. Normally you can access the deadlock event monitor via the IBM command centre but occasionally it does not show as a listed monitor (a bug!). The output of deadlocks is written to the event log log file which…