Home / 2013 / October

Monthly Archives: October 2013

CRONTAB Basics

A crontab file has six fields:        Minute 0-59        Hour 0-23        Day of month 1-31        Month 1 – 12        Day of Week 0 – 6, with 0 = Sunday        Unix Command or Shell Scripts To edit a crontab file, type: Crontab -e   To view a crontab file, type: Crontab -l 0  4 * * …

Read More »

Script to check tablespace usage.

This script checks for tablespace usage. If tablespace is 10 percent free,  it will send an alert e-mail. ##################################################################### ## ck_tbsp.sh ## ##################################################################### #!/bin/ksh sqlplus -s <<! oracle/$1@$2 set feed off set linesize 100 set pagesize 200 spool tablespace.alert SELECT F.TABLESPACE_NAME, TO_CHAR ((T.TOTAL_SPACE – F.FREE_SPACE),’999,999′) “USED (MB)”, TO_CHAR (F.FREE_SPACE, ‘999,999’) “FREE (MB)”, TO_CHAR (T.TOTAL_SPACE, ‘999,999’) “TOTAL (MB)”, TO_CHAR ((ROUND ((F.FREE_SPACE/T.TOTAL_SPACE)*100)),’999′)||’ …

Read More »

hubiC offers 25Gb online storage space for free

Last months I was looking for a good online storage from a European provider. I found very few available and none to meet my requirements. Today I found Hubic a Cloud storage provider from Europe and their prices are really good. Hubic Cloud is provided by OVH an independent European company based in Roubaix, France           If …

Read More »