|
|
 | This pocket reference provides quick-reference information that will help you use Oracle's PL/SQL language, including the newest Oracle8i features. |
|
| Feature Code Archive
"Unix to Oracle Date Conversion"
By Giovanni Jaramillo
This archive contains a function enabling the user to quickly convert a Unix date to an Oracle date. This function will work for every timezone.
|
Tips of the Month
|
| Discussions of the Month
Visit RevealNet's Pipelines for "Pipe Talk" - active discussions with your colleagues from around the world.
- DBA Pipeline - "SGA sizing tips" in the Configuration Management section
- PL/SQL Pipeline - "Asserting Purity of Functions" in the General PL/SQL Discussions section.
|
| About the Newsletter
This newsletter is distributed to RevealNet customers, prospects and friends who have subscribed to it from our website. If you would like to unsubscribe, please send a note to info@revealnet.com and we will make every effort to remove you from our list. |
|
|
 | Database Tuning Methodology
By Mike Ault |
There is probably no more complex region of database management than that of tuning. A properly tuned database shows good hit ratios (db block buffer, library, etc.), low contention (db block, latch, lock, redo, undo) and good query performance.
Many times to tune one area of the database, another has to take a back seat and compromises must be made. Sometimes we can get everything to work harmoniously together, but not often enough. Let's look at a tuning methodology and discuss some particular areas wher tuning is important. Format: zip
DBTune.zip |
 | RevealNet Launches "Active PL/SQL Knowledge Base" |
RevealNet is pleased to announce the availability of the "Active PL/SQL Knowledge Base" - a new product that helps developers fully utilize and extend the functionality of the PL/SQL language.
The Active PL/SQL Knowledge Base combines a complete PL/SQL Knowledge Base with an extensive PL/SQL Code Library. This powerful combination delivers leading-edge technical expertise, coupled with a vast library of production-ready procedures and functions. At just $295 per developer, this product answers 70-80% of your daily questions and saves countless hours of research, coding and implementation time. Click Here for more information.
|
 | Embarcadero Technologies Integrates Knowledge Bases with DBArtisan & Rapid SQL |
ROCKVILLE, MD - January 31, 2000 -- RevealNet, developer of knowledge-based solutions, and Embarcadero Technologies, Inc., developer of award winning database lifecycle management tools, today announced the integration of RevealNet's Oracle and IBM DB2 Knowledge Bases with Embardcadero's DBArtisan and Rapid SQL software.
"Now Embarcadero's Oracle and IBM DB2 users can readily access the highest quality technical knowledge from top industry experts," said Ellen Taylor, president and CEO of Embarcadero. Click Here for more information. |
|
Current Product Releases