Tips

Tips

• Retrieving OS/network username for audit trail

  This tip is helpful in logging situations where the database login is not the same as the network/OS login.  Continue Reading

• Use autonomous transactions to record to logs

  Use autonomous transactions to record to logs regardless of the state of the parent transaction.  Continue Reading

• Weighing centralized, distributed data centers

  Client/servers vs. mainframes in the data center.  Continue Reading

• Determining the hit ratio of Oracle databases

  This script is useful for determining the hit ratio of your Oracle database.  Continue Reading

• Hot backup and recovery with Perl

  This script is useful for DBAs who want to use Perl for doing hot backups.  Continue Reading

• Getting the last inserted sequence value

  This function will return the last generated sequence value for a given table.  Continue Reading

• Browsing OS files from TOAD or SQL*Plus

  This tip describes the process required to browse operating system files from a PC application like TOAD or SQL*Plus.  Continue Reading

• Find who is executing what command using DECODE

  Find who is executing what command using DECODE.  Continue Reading

• Five myths of data mining

  Many successful companies have discovered is that the myths that have grown up around data mining are just that: myths.  Continue Reading

• Joining tables in SQL queries

  Discusses how to join tables in SQL Server queries.  Continue Reading

• Find what each Oracle process is doing

  Here is a handy script that will correlate the operating system process with the Oracle process.  Continue Reading

• Truncate tables using PL/SQL

  This tip truncates data from tables using PL/SQL for Oracle8i.  Continue Reading

• Growing up, and out: Opportunities expand for people willing to put time and effort into learning ne

  Hot skills include knowledge of operating environments, people skills, networking smarts and Web-ifying the mainframe.  Continue Reading

• Duplicate Oracle installation

  A procedure to install a duplicate Oracle database when typical installation via CD-ROM is not possible.  Continue Reading

• Script to include users in the PRODUCT_USER_PROFILE table

  This script generates a script that includes users in the table PRODUCT_USER_PROFILE table.  Continue Reading