Tag: Oracle

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

Java coding done right

By Peter Coffee – If there’s one thing that a Java development platform should be able to produce and host, it’s a first-rate integrated Java development environment. Many candidates for that title have come through eWEEK Labs, but Oracle Corp.’s Oracle9i JDeveloper 5.0 (which we reviewed in its lat