|
Home | News | Products | Library | Contacts | Links | Feedback | E-Mail |Oriole Themes:-
Oriole "Dumb Agent" monitoring. Full September 1998 "Relate" article in the Library "Zipped" collection of shell and sql scripts only 12.2KB download Most Oracle databases have to run in places where no expert DBA is resident - errors are usually reported by users, not always in a very helpful way, either to a DBA who may be asleep in a different time zone or a local System Engineer who painfully installed Oracle in the first place and has to call in some outside expertise Being aware of problems before users, is, for many DBAs, like dreaming the impossible dream. Oriole Corporation provides gratis, a number of useful - and efficient - queries to check most meaningful indicators. Moreover, Oriole Corporation sells DUMBAGNT.zip.
The fine art of tuning an Oracle database has always been a highly interesting topic. The founders of Oriole Corporation have devoted much of their time to boosting the performance of bogged down systems - most often successfully. Our experts will share with you their experience and toolboxes>
One of our most promising current product developments is precisely in this field.
So stay tuned!
A DBA's job often boils down to an endless fight against the dimensions of space and time. Space because users keep on inserting lines and time because nights are always too short for the maintenance window.
You will find here a number of free scripts for mastering space management together with PDQOUT, a fine product which will allow you, in combination with sqlldr, to do a number of common operations in a very short time.
Reorganizations, copying production data to the test database through a UNIX pipe, stuffing data in the datawarehouse - a task that
PDQOUT is especially suited for, as it can unload views as fast as tables, which makes any aggregation post-processing unnecessary.
Security is one of the least well understood aspects of Oracle administration.
It's often a two-sided affair, with security loopholes to plug and, on the other hand useful tricks which allow you to perform tasks even a DBA can't do.
become.sql
Putting aside all the hype around object orientation, the most interesting features in Oracle8 revolve around its ability, at last, to handle very large databases - such as incremental physical backup and, on the faster-queries side, the use of partitioned tables.
Unfortunately, if you want your datawarehouse to take advantage of partitioned tables, running the
migrate.bsq script will not be enough - you'll have to recreate the tables, the really big ones at least, which implies moving the data in these huge tables of yours out and in again - better to forget about imp, unless all your users are ready to take their holidays together for a few weeks. It's time to consider the PDQOUT and sqlldr combination!
A number of quite useful tools don't fall neatly into any of the other categories; documentation tools, useful shell scripts such as
admmenu which provides a simple yet handy framework for running sql scripts - those which you may have downloaded from this or other sites and those which you may have written - thus allowing you to provide a first-aid toolkit for non-DBAs, C code ...
|
TOP | News | Products | Library | Contacts | Links | Feedback | E-Mail | Sunday, 05-Feb-2012 05:01:20 CET