Messaggio del 28-07-2004 alle ore 17:28:46

---

....noia ...

Messaggio del 28-07-2004 alle ore 17:28:20

---

JUN

Messaggio del 28-07-2004 alle ore 17:06:32

---

publico il mio codice su lanciano.it !!!!


#
#
# (c) 2002-2003, Antonio Dell'elce
#
#

[ -z "$SYBASE" ] && export SYBASE=/home/sybase
[ -z "$DSQUERY" ] && export DSQUERY=SYB
[ -z "$DB_USER" ] && export DB_USER=sa
[ -z "$DB_PASSWORD" ] && export DB_PASSWORD=sybpw

######################### is_a_num #########################

is_a_num ()
{
typeset c
[ -z "$1" ] && return 1

typeset ARG=$1

( let c="$(( $ARG - 1 ))"; ) 2>/dev/null;

return $?
}


######################### objusage #########################

objusage ()
{
typeset PROG_NAME=objusage
typeset ROW_COUNT=0

while [ ! -z "$1" ]
do

case $1 in

### Sort order

-o)

shift

[ -z "$1" ] &&
{
echo "${PROG_NAME}: Empty order type."
return 1
}

ORDER_ROW=$1

;;

### Number of Rows

-r)

shift
[ -z "$1" ] &&
{
echo "${PROG_NAME}: Empty row number."
return 1
}

is_a_num $1

[ "$?" -eq 1 ] &&
{
echo "${PROG_NAME}: $1 is not a number. Will show all tables."
ROW_COUNT=0
} ||
{
ROW_COUNT=$1
}

;;

### Show Date & Time

-D)

typeset SHOW_DATE=1
;;

### Default argument

*)

typeset FIRST_CHAR=$(echo $1 | cut -b1)

[ "${FIRST_CHAR}" = "-" ] &&
{
echo "${PROG_NAME}: Unknown option: $1"
} ||
{
# Should we verify was already set???

DB_NAME=$1
}
;;

esac # End of Switch statement


shift
done

typeset ORDER_ROW=${ORDER_ROW:-unused}
typeset EXCLUDE_SYSTEM_TABLES='delete from #objects where name like "sys%"'

[ -z "$DB_NAME" ] &&
{
echo "${PROG_NAME} [ -o order ] [ -D ] [ -r row_number ] database"
return 1
}

[ "$SHOW_DATE" -eq 1 ] &&
{
echo
echo "Database Objects Space Allocation --- $(date)"
echo
}

CSV_SEP=

$SYBASE/bin/isql -n -w4000 -U${DB_USER} -P${DB_PASSWORD} 0
order by
${ORDER_ROW}
desc

-- This could be useless...

drop table #objects
drop table #pagecounts
drop table #pagecounts2

go

EOF

echo

}

#### Main ####


objusage $*


################################# End of File #################################

Messaggio del 28-07-2004 alle ore 17:00:40

---

spiacente, ho solo suggeri-nasi...

Messaggio del 28-07-2004 alle ore 16:59:22

---

ufff .. sto in questo mega open-space e non ho niente
da fare... suggerimenti ?

Messaggio del 28-07-2004 alle ore 16:57:53

---

ke punto ?

Messaggio del 28-07-2004 alle ore 16:56:49

---

SAMU80

Messaggio del 28-07-2004 alle ore 16:56:21

---

è proprio questo il punto


.

Messaggio del 28-07-2004 alle ore 16:55:41

---

SPAMMMMMMMMMMMMMMMMMMM


NIRVANA GIRL

Messaggio del 28-07-2004 alle ore 16:54:21

---

:spam: