Author: Jared Still

Tracking ASM Metrics

Collecting ASM IO Metrics If you are an Oracle DBA, then it is quite likely that Oracle ASM is used as the storage management for at least some of the databases you manage. Eventually you will want to see ASM…

Read More >

Alter session kill on steroids

Learn how you can use the IMMEDIATE option of the Oracle command ALTER SYSTEM KILL SESSION and stop using kill -9.

Read More >

Room for Improvement – Using DBMS_REDEFINITION with Spatial Data

Using DBMS_REDEFINITION to reconfigure a table can be a simple way to modify table structure. But that is not always the case. Consider this example of what is necessary to modify a table when Spatial data is included in the table.

Read More >

When RMAN Validate Creates New Files

The RMAN VALIDATE RECOVERY FILES command is a simple way to validate all backups, or so I thought.
In some versions it is broken, and in the versions where the bug has been fixed, it is even more broken.

Read More >

Options for Tracing Oracle dbms_stats

Sometimes autotask statistics gathering does not work as expected. A couple of things complicate troubleshooting:
1) DBMS_STATS is an Oracle supplied package
2) Autotask jobs seem to defy some of the accepted tracing methods.
This article details how to get useful tracing from DBMS_STATS
<a href="”> Read More…

Read More >

Linux Patching and Oracle: Detect RPM conflicts before they happen

While Oracle does supply a list of RPMs that must be installed on a Linux system, that information does not help you in determining which Oracle files are dependent on the RPMs in question. If the list of RPMs to be updated is small, it may even be that that few, if any of the Oracle files on a server may be affected. Here’s how that can be determined.

Read More >

Applying External Timing Data to Untimed Events

If you are familiar with debugging ssh connections you are probably familiar with the ‘-v’ option that directs ssh to output verbose comments stating which operation is currently taking place. You can add up to three -v options on the command line, increasing the verbosity with each one. An example follows.

Read More >
Page 4 of 41234