Warnings about Oracle scripts

Even though Oracle and third-party vendors build GUI tools to interface with the Oracle data dictionary, there are millions of possible dictionary reports to help manage a complex Oracle database.

Oracle provides dozens of x$ and v$ tables to allow us to view the internal machinations of Oracle, a Godsend to the savvy DBA who needs to understand the details of Oracle.

However, there is a downside to Oracle scripts, especially for the beginner.  Oracle scripts can be very powerful, and many neophytes will cut-and-paste scripts without understand their functions.  While this makes the DBA appear to be knowledgeable beyond their real experience, it can be extremely dangerous.

Some of the most sophisticated Oracle script collections ( see http://www.dba-oracle.com/oracle_scripts.htm ) include warnings, but they can still be abused.

Itís a disturbing trend today that fakers and wannabees are capturing pre-written Oracle scripts over the web, and in some cases, running them to see what they do!

Statistically, the Oracle DBA is responsible for more unplanned outages than hardware failure, and Oracle scripts are increasing this problem.  I work in emergency Oracle support, and one more than one occasion Iíve been called-in to fix a DBA induced problem from a beginner running a script that they do not understand.

Itís a problem that can only be remedied through training, but the temptation is always there to take shortcuts, especially for Oracle DBAís who do not possess the required aptitude and educational background to function effectively as a DBA.

Click below to read more about the power of Oracle scripts:



Need a Health Check?

Oracle is the worlds most complex and robust database and there are hundreds of sub-optimal setting that can cripple your database performance.

Burleson Consulting has a great Oracle health check where we identify all database bottlenecks to ensure that your mission-critical system is running at optimal speeds.

Just call 800-766-1884 to schedule your health check.


Need Oracle Training?

The very best Oracle training comes from Burleson Consulting, where you get an on-site visit by an experienced Oracle expert and author.  Whether it's one-on-one mentoring or getting a customized on-site Oracle training class, there is no substitute for BC Oracle training.  Just call 800-766-1884 for details, and check-out our on-site Oracle training catalog at the following link: