Yong Huang's Computer Page
Freeware
-
pio and topio for Solaris, Windows, and
HP-UX © 2002-2006
UNIX top command sorts processes by CPU or memory usage, but not by I/O. My pio and topio programs fill the gap.
- pstats for Windows © 2004
Windows Task Manager process list cannot list processes on a remote computer. My pstats program makes up for this shortcoming.
- Windows oerr for Oracle © 2000-2006
Windows version of the well-known oerr program previously only available in UNIX
- HPL and HCPL © 1998-2006
Helps you track books checked out of Houston Public Library and Harris County Public Library
- ckweb © 2000-2004
Checks web site availability, unique in that it allows you to easily extend its functionality to the limit of your understanding of HTTP protocol, as long as you know the Expect programming language
- DOSCSR © 1996
Enables use of mouse in DOS, written in assembly when most people were still using Windows3.1 or DOS
Some simple utility programs are in my script archive. Recent additions include a script that makes network connections specifying IP and port on the client.
Oracle Database
-
Miscellaneous Oracle Notes
© 1999-2008
![[new]](image/new.gif)
My own study notes. Files are named with the most relevant word at beginning (like a book index). Lines in files may not be wrapped. If you use IE, View Source can launch Notepad where you can wrap lines.
-
Process-Oriented Perfmon
© 2008
![[new]](image/new.gif)
Do you agree system-level performance data is not as important or useful as process-level data?
- Oracle Regular Expressions © 2003,2006
Go no further than your existing installation. Oracle does offer regular expression pattern match capability before 10g.
-
Oracle Q&As © 2002,2003
My answers to questions posted to comp.databases.oracle.server newsgroup, which I like to browse in spare time. If a message archived here differs from the one posted to the group, trust this one instead. Newer messages are not archived.
-
Oracle Idiosyncrasies
© 2000-2007
Some of Oracle's strange but generally harmless behaviors. Mostly short items. Long items are separate articles, such as
Old work
Oracle Executables
© 2002-2008
List of executable programs under $ORACLE_HOME/bin directory with descriptions and comments.
Oracle X$ Tables
© 2000-2008
If you're interested in Oracle internals, you may be interested in this summary of some Oracle X$ tables' common usage.
Delayed Logging Block Cleanout
© 2002
There's too much confusion about this Oracle 7.3 - 8.0.6 initialization parameter.
Oracle and Perl
© 2001,2002
Actually not limited to Perl, this article discusses two methodologies for a programming language to access Oracle database.
How to Get Sequence Next or "Current" Value Without Side Effect?
© 2001,2005
Want to know the next value of a sequence but don't want to increment it?
How Oracle Stores Integers
© 2000
A number 123 is not stored as 123 in the datafile; instead it's c2 2 18. This article tells you how to interpret this part of your datafile dump and its practical implication.
Semantically Dependent Attributes
© 2000
A.k.a Arc Relationship. Discusses several strategies to implement this design.
Two Types of Oracle Deadlocks
© 1999-2003
Description of two types of Oracle deadlocks and how to resolve them.
First Normal Form Compliant Bad Design
© 1999
A verbose, possibly useless, pure academic talk about a common misconception of First Normal Form.
Which Count Is Faster?
© 2000
Which runs faster? Count(*), count(1), count(PK) or count(rowid)?
Miscellaneous
- Running Process Environment
© 2005,2006
A general software troubleshooting tip.
- Solaris mdb, adb, crash Command Examples
© 2002-2004
Command examples from other sources (plus a script to print adb macros that don't need symbols). Only through these examples will you learn to do Solaris system debugging. Currently I haven't caught up with mdb dcmds yet.
- Tips on Handling Log Files
© 2002
A new way to get notification on errors in server log files; tips on handling large log files.
- Some Perl Benchmark Results
© 1999
Do you know substr is much faster than split?...etc
- "URL is Password" Security Strategy
© 1999
A fair review of this common Web security strategy.
- How to Fight Spam
© 1998,2005
This article may help you read email headers so you can identify the true origin. Spammers hide their originating point in all sorts of ways.
-
How to Buy Computer Books
© 1999,2007
Where to buy cheap, how to know if it's good
- How to Find a Computer Job Without a Computer Degree?
© 1997-2001
Greatly inspired some of my friends, and myself even today.
- HTML character entities 1-3680
© 1997,2003
Generated by a Perl script char.pl, this character entity chart tells you how your browser displays &#some_number. You can vary the $i in char.pl to get a full chart of characters. Interesting character ranges may be found in Unicode allocation areas or the subdivided blocks. Many characters are not displayed in current browsers yet. Definitely not ready in IE are numbers above 65536, i.e. characters beyond Basic Multilingual Plane in ISO/IEC 10646 standard. For a full list of characters, see Unicode Code Charts and each character's description.
To my Homepage