May 262009
 

iostat (input/output statistics) an utility that shows Report Central Processing Unit (CPU) statistics and input/output statistics for devices and partitions. The iostat command is used for monitoring system input/output device loading by observing the time the devices are active in relation to their average transfer rates. The iostat command generates reports that can be used to change system configuration to better balance the input/output load between physical disks.

May 202009
 

ps (process status) is an utility that reports a snapshot of the current processes. By default, ps selects all processes with the same effective user ID (euid=EUID) as the current user and associated with the same terminal as the invoker. It displays the process ID (pid=PID), the terminal associated with the process (tname=TTY), the cumulated CPU time in [dd-]hh:mm:ss format (time=TIME), and the executable name (ucmd=CMD). Below is sample default output, which is unsorted.

May 142009
 

The Lite Onboard Monitor (LTOM) is a java program designed as a real-time diagnostic platform for deployment to a customer site. LTOM differs from other support tools, as it is proactive rather than reactive. LTOM provides real-time automatic problem detection and data collection.

May 132009
 

OS Watcher (OSW) is a collection of UNIX shell scripts intended to collect and archive operating system and network metrics to aid support in diagnosing performance issues. OSW operates as a set of background processes on the server and gathers OS data on a regular basis, invoking such Unix utilities as vmstat, netstat and iostat.

May 132009
 

Preparing a Linux server to install oracle has been made easy with the help of oracle-validated rpm package. Install of oracle-validated automates the download and install of all required RPMs including dependencies, setup of Linux kernel parameters, creation of oracle user (Linux user) and dba, oinstall groups I have been thinking of trying out oracle-validated [...]

May 112009
 

One of my all time favorite analytical functions are the LAG (look back) and LEAD (look ahead) functions, which were first introduced in Oracle 8i. It provides access to more than one row of a table at the same time without a self join. Given a series of rows returned from a query and a [...]

May 112009
 

You can now find my HTML version of below Oracle Installation guides under cookbook section – Install Oracle Database 8i (8.1.7) on Red Hat Linux 7.3 (Kernel 2.4.18-3 i386 32 Bit) Install Oracle Database 9i (9.2.0.6) on Red Hat Enterprise Linux 4 / CentOS 4 (2.6.9-5.0.3.EL i386 32 Bit) Install Oracle Database 9i (9.2.0.8) on Red [...]

May 082009
 

In the calendar year 2006 and 2007, a number of countries have altered the dates on which they observe Daylight Savings Time (DST). The earliest of these changes will occur on March 26, 2006 for those observing Australian DST and in certain parts of the state of Indiana (USA). (Reference: http://aa.usno.navy.mil/faq/docs/daylight_time.html )

© 2002-2011 Beautiful Data | Terms of Use