Community

Community

Which indexes require a re-build?

By Danny Mohar – This script is used to determine which indexes require a re-build to assist with system performance. A ratio of 10-20% deleted lf rows to lf rows may be candidates. The script will attempt the used of dynamic SQL to execute the DDL commands required to execute the analyze table comm

Community

Storing Your Data in Oracle

by Joe Lax – Compared to SQL Server, Oracle allows a DBA to go much further under the hood to properly manage data space requirements. However, space allocation in Oracle is complicated. Learn how locally managed tablespaces can let the database engine make most of the decisions for you.

Community

Web Services Interoperability

by James Snell – In this article, I give a brief picture that highlights exactly what interoperability in Web services means. To do so, I am going to pull an example out of O'Reilly's recently published Programming Web Services with SOAP, which I coauthored. The example is the ubiquitous Hel