Monday, November 27, 2006

PC/MSWindows Utilities

system info as wallpaper
BgInfo is now a Microsoft product. There is install program, so place the executable where you won't lose it.

folder size
http://foldersize.sourceforge.net/

mother board monitor
http://www.pcworld.com/downloads/file/fid,7309-order,1-page,1-c,systemresourcestuneup/description.html

control what programs automatically start up
http://www.pcworld.com/downloads/file/fid,7976-order,1-page,1-c,desktop/description.html

intel application accelerator. replaces ata driver.
http://support.intel.com/support/chipsets/iaa/

Intel® Chipset Identification Utility
http://downloadfinder.intel.com/scripts-df-external/Product_Filter.aspx?ProductID=861

Tuesday, November 14, 2006

Tuning Secure File Copy For Performance

When scp is too slow, and rdist over scp is more functionality than you need, look at sftp.

The sftp command set will be familiar to anyone who has used ftp.
Sftp allows use of a batch file, and it has a tunable buffer size. The -B flag controls the tunable buffer size and is useful when copying files over wide links that have latency. Tests over a DS3 have shown 20% throughput increases simply by increasing the default buffer of 32K. There are limits, and you can experiment on your platforms. Choosing a value too high will result in a message such as, "Outbound message too long 262169".

Wednesday, November 08, 2006

Release Tuxedo Connections

If the MAXWSCLIENTS had been reached, additional users can not log in to Tuxedo. One way to release connections in Tuxedo is to kill the WSH processes, then use the tmadmin bbclean command.

$ ps -ef|grep WSH | head
arbor 8133 19874 1 12:09:09 ? 0:00 WSH -c 11 -d /dev/tcp -i 21 -s 647181 -p 2048 -P 65535
arbor 16042 19875 0 Nov 6 ? 0:08 WSH -c 11 -d /dev/tcp -i 2 -s 647182 -p 2048 -P 65535
arbor 18303 19874 0 09:21:09 ? 0:00 WSH -c 11 -d /dev/tcp -i 46 -s 647181 -p 2048 -P 65535
arbor 19369 19874 0 09:28:38 ? 0:00 WSH -c 11 -d /dev/tcp -i 47 -s 647181 -p 2048 -P 65535
arbor 3754 19874 0 11:29:54 ? 0:00 WSH -c 11 -d /dev/tcp -i 8 -s 647181 -p 2048 -P 65535
arbor 5840 19874 0 11:42:43 ? 0:00 WSH -c 11 -d /dev/tcp -i 2 -s 647181 -p 2048 -P 65535
arbor 10810 19874 0 12:55:25 ? 0:01 WSH -c 11 -d /dev/tcp -i 44 -s 647181 -p 2048 -P 65535
arbor 10565 19874 0 Nov 6 ? 0:04 WSH -c 11 -d /dev/tcp -i 15 -s 647181 -p 2048 -P 65535
arbor 19989 19874 0 Nov 5 ? 0:04 WSH -c 11 -d /dev/tcp -i 0 -s 647181 -p 2048 -P 65535
arbor 7109 19874 2 Nov 6 ? 0:04 WSH -c 11 -d /dev/tcp -i 33 -s 647181 -p 2048 -P 65535

$ $ kill -kill 19989

$ tmadmin
tmadmin - Copyright (c) 1996-1999 BEA Systems, Inc.
Portions * Copyright 1986-1997 RSA Data Security, Inc.
All Rights Reserved.
Distributed under license by BEA Systems, Inc.
Tuxedo is a registered trademark.

> bbclean
Cleaning the bulletin board on machine FX.

> quit


Count the current tuxedo connections (including the internal users)
$ tuxedo8.0/bin/tmadmin 2>/dev/null << EOF | /usr/bin/grep ^FX | /usr/bin/wc -l
printclient
quit
EOF

Monday, November 06, 2006

Capture and Transfer Oracle Statistics

The dbms_stats Oracle-supplied package makes it easy to back up and restore statistics.

Create the table where statistics will be captured. dbms_stats.create_stat_table
SQL> exec dbms_stats.create_stat_table('SCHEMAOWNER', 'STATTAB')
PL/SQL procedure successfully completed.


dbms_stats.export_schema_stats
This requires a table name where the statistics will be stored. This table can be exported (like any other table) and imported into a development database.

dbms_stats.import_schema_stats


Example of capturing and transferring statistics:
SQL> exec dbms_stats.export_schema_stats('SCHEMAOWNER','STATTAB')
PL/SQL procedure successfully completed.


$ exp file=stattab.dmp tables=SCHEMAOWNER.stattab compress=n

About to export specified tables via Conventional Path...
Current user changed to SCHEMAOWNER
. . exporting table STATTAB
8701 rows exported
Export terminated successfully without warnings.


>>> Copy export file and change ORACLE_SID as appropriate.


$ sqlplus SCHEMAOWNER@qa
SQL> delete from stattab;


$ imp file=stattab.dmp fromuser=SCHEMAOWNER touser=SCHEMAOWNER ignore=y

Export file created by EXPORT:V09.02.00 via conventional path
import done in UTF8 character set and AL16UTF16 NCHAR character set
. importing SCHEMAOWNER's objects into SCHEMAOWNER
. . importing table "STATTAB"
8701 rows imported
Import terminated successfully without warnings.


$ sqlplus SCHEMAOWNER@qa
SQL> exec dbms_stats.import_schema_stats('SCHEMAOWNER','STATTAB')
PL/SQL procedure successfully completed.

Friday, November 03, 2006

Vista Upgrade Advisor

This tool can help determine if legacy equipment will support Windows Vista.

I ran the tools on a laptop purchased this year, and the tool says I would need a TV tuner card to run the home premium version of Vista.

"TV Tuner card
Make sure you have an approved TV tuner card No compatible TV tuner was detected. Upgrade Advisor did not detect a TV tuner card in your current system. To watch TV on your computer, you need an approved USB-based TV tuner or TV tuner card. Contact your computer manufacturer for more information.
"