|
|
| Feature Code Archive
Schema
Comparison Utility
Author: Tom Niderost, Tom@TEMPUS.COM
I have created a tool called OraCompare
that we use in-house for schema comparison. It is a beta product, and it has
been posted for free download and use.
OraCompare
will compare objects in two different schemas. The schemas can reside on
different servers or be on the same database. It has been tested with Oracle
8 and 8i only. At this time it does not compare Types and Type Bodies.
It is designed to run on a Win9x/WinNT/Win2K
client. This is a work in progress, and more features will eventually be
added. The application was written in
Delphi, with "Direct Oracle Access" components used to communicate
directly to the OCI. Click
Here to download the application.
|
Tips of the Month
DB2 Tip of the Month
Use
LOBs with User-Defined Distinct Types
|
| Discussions of the Month
RevealNet's "Pipe Talk" forums are rich in technical discussions.
Each month, we review the conferences for especially interesting discussion
topics. Log on to "Pipe Talk" to view discussions and share
technical ideas with your colleagues around the world.
- Oracle DBA Pipeline
- "Standby Database" in the Replication Conference.
Pipeliners discuss methods for creating standby databases.
- PL/SQL Pipeline
- "How to Create User-Encrypting Passwords" in the Advanced
PL/SQL Programming Conference. Pipeliners discuss a seemingly common
problem with no "obvious" answers.
|
| Pipeliner of the Month:
K. Gopalakrishnan
K. Gopalakrishnan has been one of the most
active members of RevealNet's Pipeline communities - with over 1,700 message
posts since January, 1999. He lives in Bangalore, India and enjoys
reading, swimming, listening to music, and playing with Oracle. His website
is full of useful information and links. |
Humor:
"Not a Genuine Press Release"
By
Steven FeuersteinSteven
Feuerstein posted a humorous (yet bogus) press release about the future
direction of book titles published by O'Reilly & Associates.
Click Here for the fictitious (yet really funny) press release. |
| Call for
Articles
We would like to express our sincere thanks
to everyone who has recently submitted articles for publication in the
Pipeline Newsletter. It's great to see our readers actively
participating in this newsletter.
Part or our mission at RevealNet is to
encourage the sharing of technical information among database professionals
worldwide. If you have a technical article, tip or coding solution you
wish to share, please email your submission to cwhite@revealnet.com.
As a humble gesture of our thanks, we will acknowledge the author or each
accepted article, and mail him/her a "stylin'" RevealNet baseball
cap. |
| Random
Notes
Thank you for visiting with us at Oracle
Open World 2000! It was a smashing success and we were swamped! Thanks to everyone who stopped by to visit with us.
If you stopped by, your free gift and trial CDs are being processed and
mailed. Expect delivery within the next few weeks.
As a follow-up to last month's article by
Jody Wisecup on "Oracle HTML Database Information Reports", we
received a note from Stewart McGlaughlin, author of OraSnap,
a free utility that formats over 100 database information reports for HTML
display. Use this tool to get a general overview of your
databases. It has also proven to be very handy when tracking down
database performance issues.
We've Moved! Due to expansion, the
new address for our sales office is:
RevealNet Sales Department
18401 Woodfield Road, Suite G
Gaithersburg, MD 20879
Tel: 800-738-3254 Toll-Free US
Tel: 301-947-7744 International
Fax: 301-947-9610
Email: info@revealnet.com
|
| About
RevealNet
RevealNet develops Knowledge Bases and Development Tools for
Oracle and DB2 professionals. Our Knowledge Bases are designed to anticipate the daily challenges of DBAs and Developers -
providing the background information, syntax and examples you need to apply solutions immediately. Our Oracle development tools
help you write far less code, improve code maintainability and achieve development excellence.
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. Subscribe a Friend!
Do you know someone who would like to receive the RevealNet Pipeline Newsletter? If so, please enter their email address in the box below and click SUBMIT.
|
|
|
 | Fifteen
Terrific PL/SQL Tuning Tips - As Presented at Oracle Open World 2000
By Steven Feuerstein, O'Reilly,
RevealNet,
HALO |
You
can spend all day tuning your SQL statements. You can apply any one of
a number of fantastic first-party (Oracle) and third party analysis tools to
the SQL side of your application. You can bring in an Oracle tuning
specialist. Yes, you can tune and tune and tune -- and still your
PL/SQL-based programs can run very inefficiently. It is difficult to
find detailed, comprehensive recommendations for tuning the PL/SQL side of
one's Oracle applications. After spending 12 years learning, using and
writing about Oracle's PL/SQL language, Steven Feuerstein has assembled
1,247 tuning tips for PL/SQL developers. He has selected the top 200
most terrific of these tips for this presentation. Well, maybe
15. Format: Microsoft PowerPoint, 168K.
oow2000.ppt |
| Streamlining
DB2 Databases
A Strategy for Realizing
Major Performance, Availability and Cost Benefits
By
Steve Gerrard, Princeton
Softech |
New eBusiness applications demand 100%
availability, along with scalable, reliable access to enterprise data.
But corporate databases are becoming so large that just maintaining
traditional service levels is almost impossible. Because larger
databases take more time to load, unload, search, reorganize, index and
optimize, the performance of mission-critical applications often
deteriorates when database size increases relentlessly. Response times
get longer. Getting to decision-making information becomes more
difficult. Service levels decrease. Click Here for the paper.
|
| Putting
Methods to Work in Oracle8
By
David A. Anstley, Galderma Laboratories; Mike Ault, RevealNet |
By this time, most of us have been introduced
to the object-oriented features included in Oracle8. While many may be
conversationally familiar with the new functionality that the object
extensions to Oracle8 have introduced, far fewer have taken advantage of
this exciting departure from conventional relational design. While it
is recognized that the first deployment of object-oriented methodology, most
of the key elements are covered. One of the most exciting of these key
elements is the support for methods. Click Here for the story.
|
RevealNet Product
Focus
|
|
During the course of an average workday, DBAs
run scripts to manipulate data, check and maintain the health of their
databases. The licensed version of the Oracle Administration Knowledge
Base includes InstantScripts, a utility containing over 200 tested scripts
that cover all aspects of day-to-day Oracle Administration.Need
a script to get redo log statistics? Check for Index Browning?
Check for Latch Contention? These are some of the scripts available to
you. InstantScripts is only available in the fully licensed version of
the Oracle Administration Knowledge Base. The listing of scripts can
be viewed in the 30-day trial version, but the scripts themselves cannot be
accessed. Click Here
for more information about InstantScripts.
The Oracle
Administration Knowledge Base is available directly from RevealNet, and
is also integrated with database tools from Computer Associates, Embarcadero
Technologies, Quest Software Savant Corporation, Sylvain Faust, Intl.
|
Partner
Focus: Savant Corporation
|
|
Blending
Database Diagnostics with Expertise
Avoiding Database Problems
with Savant & RevealNet |
In a
survey last year of almost 2,000 DBAs, RevealNet learned that DBAs far
prefer being proactive in preventing database performance and availability
problems from happening, than reacting to problems after they occur.
The Savant Enterprise - Oracle EditionTM
is an industry-recognized solution that enables customers to anticipate and
proactively manage all database performance and availability issues.
The RevealNet Oracle
Administration Knowledge Base anticipates the daily
responsibilities of DBAs, providing 3,300 technical topics with 25,000 error
messages and 200 DBA scripts. Together, these products work in harmony
to provide the diagnostic and performance metrics you need, combined with
the technical expertise required to prevent problems from happening before
they occur. Click
Here for more news about this partnership.
|
 | Recent
Partner Headlines |
Did you know RevealNet Knowledge Bases and Development Tools are tightly integrated with products from these companies? Click on each logo below for more information. Software
Developers
Reseller Partners
|
| Past
Issues of the Pipeline Newsletter |
|
| |
Current Product Releases