The FREE Online
  IT Magazine
 
 Home My Account Products Contact Us Register
 Search our Site
Search for
 
Advanced Search
Registered Users
Email:
Password:
  Remember My Info
Athens/Institution Login
Not a Subscriber?
Forgotten Password?
A CRCnetBASE Product
 Products
Select a Publication from the list below
  •  
  • AIMS Online
  •  
  • Information Strategy
  •  
  • Information Systems Management
  •  
  • EDPACS
  •  
  • IT Today
  •  
  • Oracle Internals
  •  
  • Data Management Handbook
  •  
  • Code Depot
  •  
  • E-Commerce Practitioner
  •  
  • Information Systems Security
  •  
  • IT Performance Improvement
  •  
  • Business Resumption Planning
  •  
  • Call Center Continuity Planning
  •  
  • Information Security Management Handbook
  •  
  • A Standard for Auditing Computer Applications
  •  
  • Information Security Policies & Procedures
  •  
  • PDCA/Test
     Publish with Us!
    If you have a new idea for an article or a new book, Click Here.
     Need Help?
    Check out our FAQ Page
    This page contains answers to some of our most Frequently Asked Questions.
     CRC Press Online
    Leading Publishers of Essential Information for the Professional and Technical Communities Worldwide!
    CRC Press.

    Oracle Internals: Code Depot
    Tracing Sessions with Shared Server
    This script is Exhibit 1 from the article "Using Sharer Server (MTS) in Atypical Environments," from the June 2003 issue of Oracle Internals. This Perl script searches all the shared server trace files for a session's trace output and put it together in a single file.
    [Read Article...]


    Internals of Oracle Bottleneck Performance Analysis
    Here are scripts from the above article in the October 2002 issue of Oracle Internals.
    [Read Article...]


    Table Maintenance Made Easy Using Oracle 9i Online Table Redefinitions
    This script is Exhibit 1 from the article "Table Maintenance Made Easy Using Oracle 9i Online Table Redefinitions," from the September 2002 issue of Oracle Internals.
    [Read Article...]


    Don's Hot Tip: A Script to Check the Frequency of Log Switches
    Not many DBAs are aware of the v$log_history view, and how it can be used to plot the frequency of online redo log switches. You can run the following script from the July 2002 issue of Oracle Internals to provide a complete log history.
    [Read Article...]


    Extending STATSPACK for Oracle Application Concurrent Manager Monitoring
    This is Exhibit 1 from "Extending STATSPACK for Oracle Application Concurrent Manager Monitoring," which appeared in the June 2002 issue of Oracle Internals.
    [Read Article...]


    Extending Statspack: Performance Reports and Analysis from a Central Database
    Scripts from "Extending Statspack: Performance Reports and Analysis from a Central Database by Joe Bernens from May 2002 issue of Oracle Internals.
    [Read Article...]


    Extending STATSPACK: Performance Reports and Analysis from a Central Database
    Correction: Figure 2 from "Extending Statspack: Performance Reports and Analysis from a Central Database" from Oracle Internals, May 2002.
    [Read Article...]


    Locating Locked Rows and Serializing Transactions
    Exhibits from "Locating Locked Rows and Serializing Transactions" in Oracle Internals, October 2001
    [Read Article...]


    Using Cursor Varibles
    Exhibits from "Using Cursor Varibles" from Oracle Internals, August 2001
    [Read Article...]


    Text Messaging from Oracle Applications Made Easy
    Exhibits from "Text Messaging from Oracle Applications Made Easy" in Oracle Internals, September 2001
    [Read Article...]


    Using Cursor Variables with Oracle's Report Builder
    Exhibits from "Using Cursor Variables with Oracle's Report Builder" in Oracle Internals, September 2001
    [Read Article...]


    Registering a Metadata Schema
    The following accompany the article "Registering a Metadata Schema," which appeared in the September 2000 issue of Oracle Internals.
    [Read Article...]


    How I Reorganized a Large Database
    The following scripts accompany the article "How I Reorganized a Large Database,"
    written by Biju Thomas. The article appeared in the August 2000 issue of Oracle Internals.

    [Read Article...]


    The Supporting GROUPS (July 2000)
    This article first appeared in the July 2000 issue of Oracle Internals.
    [Read Article...]


    The TO_FORMAT Function
    This code is from an article that appeared in the June 2000 issue of Oracle Internals.
    [Read Article...]


    Oracle Session Monitoring
    Text was excerpted and scripts taken from the May 2000 issue of Oracle Internals
    [Read Article...]


    Strategies for an Archives Management Program
    Conclusion of "Strategies for an Archives Management Program from the May 2000 issue of Oracle Internals.
    [Read Article...]


    Tips and Scripts for Implementing RMAN
    The following scripts accompany the article "Tips and Scripts for Implementing RMAN," which was published in the April 2000 issue of Oracle Internals
    [Read Article...]


    Enforcing Column Naming Standards Using Designer 2000
    The following scripts appeared in the April 2000 issue of Oracle Internals.
    [Read Article...]


    Alert Mechanisms for RMAN Backups
    The following script accompanies the article "Alert Mechanisms for RMAN Backups," which was published in the March 2000 issue of Oracle Internals.
    [Read Article...]


    Enterprise Transformation and Data Management
    The complete article from the March 2000 issue of Oracle Internals.
    [Read Article...]


    Undocumented Express
    From the February 2000 issue of Oracle Internals, a description of a series of undocumented Express tips and functions that take advantage of Express’ flexibility.
    [Read Article...]


    Building a Java Applet for Monitoring Oracle
    These scripts are taken from the two-part article, "Building a Java Applet For Monitoring Oracle," which appeared in Oracle Internals in February and March 2000.
    [Read Article...]


    UNIX Scripts for Oracle Administration
    These scripts appeared in the December 1999 issue of Oracle Internals.
    [Read Article...]


    Getting a Quick Start with Oracle8i
    This article and code first appeared in Oracle Internals in November 1999.
    [Read Article...]


    UTL_HTTP: Request Methods and Templates
    The following is from "An Introduction to UTL_HTTP," which was published in Oracle Internals in November 1999.
    [Read Article...]


    Top DBA Scripts for Web Developers
    The scripts were taken from the October 1999 issue of Oracle Internals.
    [Read Article...]


    Managing Row Level Security in Oracle8i
    The following code segments were taken from the October 1999 issue of Oracle Internals.
    [Read Article...]


    Oracle Express Development in the Enterprise
    From the September 1999 issue of Oracle Internals, here's a short example of some Express 4GL code that loops through a list of Express instances that in turn establish connections to relational databases and update these remote Express databases with data from the relational databases.
    [Read Article...]


    Setting PCTFREE, PCTUSED on the Basis of Average
    The following is an excerpt from the article, "Managing Oracle Table Freelists: Part 1," which appeared in the September 1999 issue of Oracle Internals.
    [Read Article...]


    Creating a View to Externalize X$BH Information
    The following is an excerpt from the article "Investigating the Multiple Buffer Pool Feature of Oracle8," which originally appeared in the August 1999 issue of Oracle Internals.
    [Read Article...]


    Problems with Application Scaling and Some Remedies
    The following is excerpted from "An Approach to Load Analysis and Stress Testing," in the August 1999 issue of Oracle Internals.
    [Read Article...]


    Determining the Table Rebuild Ratio for Oracle Tables
    From the July 1999 issue of Oracle Internals are three scripts in complete SQL, Oracle 7 version, to report rebuild ratio.
    [Read Article...]


    Partition and Conquer
    Code examples from "Partition and Conquer" in the July 1999 issue of Oracle Internals.
    [Read Article...]


    Diving Into the Shared Pool
    Here are scripts from "Diving Into the Shared Pool," by Michael Ault, in the April 1999 issue of Oracle Internals.
     

    [Read Article...]


    Calling UTL_HTTP Directly from Oracle
    This is the template from "Calling UTL_HTTP Directly from Oracle" by Bradley D. Brown in the April 1999 issue of Oracle Internals.
    [Read Article...]


    Using the DBMS_LOCK Built-In Package
    Scripts from "Using the DBMS_LOCK Built-In Package" by John Beresniewicz in the April 1999 issue of Oracle Internals.
    [Read Article...]


    Don Burleson's Hot Tips:
    Using the UNIX iostat Utility to Find Disk Bottlenecks

    One little-used free UNIX utility can be very valuable for identifying disk I/O bottlenecks. The utility is iostat and here is the command.
    [Read Article...]


    Don Burleson's Hot Tips:
    Dumping a Segment Header

    It is sometimes very interesting to look inside Oracle data blocks and see the contents on the data block. The following script will allow you to do this.
    [Read Article...]


    Don's Hot Tip:
    An Alert for Table Space Growth

    Here is a great script to alert a DBA whenever a tablespace grows beyond 95% full. This script can be run with a Unix cron every ten minutes, and send a pager alert to a DBA whenever a data file is needed for a tablespace.
    [Read Article...]


    EAI: Synchronizing Oracle Applications with PeopleSoft
    The following scripts accompany the article "EAI: Synchronizing Oracle Applications with PeopleSoft," which was published in the July 2001 issue of Oracle Internals.
    [Read Article...]


    Populating Oracle Form Hierarchies Incrementally At Run Time
    This script accompanies the article "Populating Oracle Form Hierarchies Incrementally At Run Time," which appeared in the November 2000 issue of Oracle Internals.
    [Read Article...]


    Library Cache and Shared Pool Testing Script
    This script accompanies the article "Piranhas in the Pool: Investigations into Literal SQL and Oracle Shared Pool Performance," which appeared in the November 2000 issue of Oracle Internals.
    [Read Article...]


    File Exchange Solutions: SQL*Loader, PL/SQL, and Proc*C
    This script accompanies the article "File Exchange Solutions: SQL*Loader, PL/SQL, and Proc*C," which appeared in the October 2000 issue of Oracle Internals.
    [Read Article...]


    The Fast Track to Java with Oracle
    This code accompanies the article "The Fast Track to Java with Oracle," which appeared in the Sepember 2000 issue of Oracle Internals.
    [Read Article...]




    A CRCnetBASE Product