-
Automatic coalesce of all tablespaces
This Korn shell script will coalesce all tablespaces.
-
Change in the air for outsourced staffs
If you're among the outsourced, expect some big changes in how you do your job.
-
Squeeze size of files in tablespace
This script lets you squeeze all the files in a tablespace at once.
-
Getting the last row from a table
How to get the last row of a table when you don't know how many rows there are.
-
Database integration
When managing complex database environments, IT vendors and buyers agree on the three top priorities.
-
Quicker way to drop tables and views
These procedures allow multiple sessions to drop tables and views simultaneously to speed up ERP application drop sessions.
-
Move tables between tablespaces
Here is a script that moves tables from one tablespace to another.
-
Brick and blade servers
Bricks, blades not a cure-all, but they offer power, save space
-
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.
-
Using autonomous transactions
Use autonomous transactions to record to logs regardless of the state of the parent transaction.
-
Weighing centralized, distributed data centers
Client/servers vs. mainframes in the data center.
-
Determining the hit ratio
This script is useful for determining the hit ratio of your Oracle database.
-
Hot backup and recovery with Perl
This script is useful for DBAs who want to use Perl for doing hot backups.
-
Find who is executing what command
Find who is executing what command using DECODE.
-
Getting last inserted sequence value
This function will return the last generated sequence value for a given table.
-
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.
-
Browsing OS files from TOAD, SQL*Plus
This tip describes the process required to browse operating system files from a PC application like TOAD or SQL*Plus.
-
Joining tables in SQL queries
Discusses how to join tables in SQL Server queries.
-
Find what each Oracle process is doing
Here is a handy script that will correlate the operating system process with the Oracle process.
-
Truncate tables using PL/SQL
This tip truncates data from tables using PL/SQL for Oracle8i.
-
Script writing rules for Hyperion Financial Management
Accountants hate having to play with scripts. In this tip, TopDown Consulting explains how to build script rules so that accountants don't have to.
-
Domain-specific Oracle master data management
Oracle master data management products are starting to merge various data management hubs, which is a help in particular vertical industries.
-
The basics of Oracle database availability
Database expert Jeff McCormick introduces some basic Oracle database availability concepts such as uptime and mean time between failures.
-
Oracle application performance management done right
Being proactive with your Oracle application performance management is crucial to stemming system slowdowns, according to this tip.