Yong Huang's Computer Page
Oracle session statistic watcher © 2013,2014
A tool to watch all Oracle sessions for a given statistic.
pio and topio for Solaris, Windows, HP-UX, and Linux © 2002-2011
UNIX top command sorts processes by CPU or memory usage, but not by I/O. My pio and topio programs fill the gap.
Windows oerr for Oracle © 2000-2009,2013
Windows version of the well-known oerr program previously only available in UNIX
pstats for Windows © 2004
Windows Task Manager process list cannot list processes on a remote computer. My pstats program makes up for this shortcoming.
HPL and HCPL © 1998-2008
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.
Delayed Logging Block Cleanout
Miscellaneous Oracle Notes
My own study notes. Files are named with the most relevant word at beginning (like a book index).
List of executable programs under $ORACLE_HOME/bin directory with descriptions and comments. Updated to 220.127.116.11.
Managing Shared Database Environment
Tips on managing a database that hosts data for many disparate applications. Slightly modified version published in IOUG's SELECT Journal. [Update 2013-07] Oracle 12c multitenancy has addressed many issues discussed in this article.
Shared Pool Purging
Various methods of purging objects from shared pool. Also published by All China Oracle User Group.
Uncommon Sense About Common Objects
Published in IOUG's SELECT Journal. Review of DBA_OBJECTS and other views, with significant expansion of what's already published.
Parameter Dependency and the STATISTICS_LEVEL Parameter (PDF version)
Published in IOUG's SELECT Journal. Dependency between initialization parameters, and statistics_level as an example.
Oracle Viewed from OS
Presentation given at M. D. Anderson Cancer Center UNIX Users Group and at Houston Oracle Users Group. Currently, OS'es are Linux and Solaris.
Do you agree system-level performance data is not as important or useful as process-level data?
Oracle X$ Tables
If you're interested in Oracle internals, you may be interested in this summary of some Oracle X$ tables' common usage. The list is updated to 18.104.22.168.
- Oracle Regular Expressions © 2003,2006,2009
How to use regular expressions 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.
Some of Oracle's strange but generally harmless behaviors. Mostly short items. Long items are separate articles, such as
There's too much confusion about this Oracle 7.3 - 8.0.6 initialization parameter.
Oracle and Perl
Actually not limited to Perl, this article discusses two methodologies for a programming language to access the Oracle database.
How to Get Sequence Next or "Current" Value Without Side Effect?
Want to know the next value of a sequence but don't want to increment it?
How Oracle Stores Integers
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
A.k.a Arc Relationship. Discusses several strategies to implement this design.
Two Types of Oracle Deadlocks
Description of two types of Oracle deadlocks and how to resolve them.
First Normal Form Compliant Bad Design
A verbose, possibly useless, pure academic talk about a common misconception of First Normal Form.
Which Count Is Faster?
Which runs faster? Count(*), count(1), count(PK) or count(rowid)?
How to read multipath -l; script to check failed paths and alert
- Cron Jobs: Best Practice and Troubleshooting
First published in IOUG Tips & Best Practices Booklet, 2013 ed.
- Running Process Environment
A general software troubleshooting tip.
- Solaris adb and crash Command Examples
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. I have no plan to study mdb dcmds. Sorry.
- Tips on Handling Log Files
A new way to get notification on errors in server log files; tips on handling large log files.
- Some Perl Benchmark Results
Do you know substr is much faster than split?...etc
- "URL is Password" Security Strategy
A fair review of this common Web security strategy.
- How to Fight Spam
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
Where to buy cheap, how to know if it's good
- How to Find a Computer Job Without a Computer Degree?
Greatly inspired some of my friends, and myself even today.
- HTML character entities 1-3680
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