(Anant Verma) There are times when one needs to see the path that Oracle will choose for a particular query WITHOUT actually running it. It may be a very long-running query and trying to iteratively tune the query can take a lot of time. There is a command (SET AUTOTRACE TRACEONLY EXPLAIN), which wh

Stephen Andert covers sessions on Oracle SQL tuning, I/O tuning, and 9i’s automatic database management capabilities in his latest dispatch from this year’s International Oracle Users Group conference in San Diego.

By D Busfield – Our development environment has over 10 databases active at one time. This script will start or shut down a particular database.

By Ganesh Variar – Business-Savvy SQL Develop and execute complex business-intelligence queries quickly and efficiently in SQL, using Oracle9i’s analytic SQL features.

By Ed Parry – Do one of the 20 things seasoned DBA and Oracle expert Rachel Carmichael of Dragonfly Consulting LLC listed in her presentation at the Oracle user event International Oracle Users Group (IOUG) Live!, and you could find yourself holding a pink slip faster than you can say “Victoria’s Se

By Venu G. – The purpose of this article is to help you become familiar with one of Oracle9i’s new features, the server parameter file – aka SPFILE.

by Sravan Patharla – Usually there are no dictionary views that can be used to find the space usage information about Indexes. Oracle, however, has a package, DBMS_SPACE, that you can use to find the space usage information of either an index or a table, but only for one object at a time.

By Dusan Djuric – Suppose you need to see a full (10 minutes, half-hour, one hour, etc) time map for a given date with user_objects changes counter. And you need to do this in one SELECT statement, with no additional tables, views, packages, procedures, or functions. Is it possible? Yes, it is! Here

by Navin Kumar – Assume there are three tables of interest: T1, T2 and T3. Depending on the value of a local variable VAR, you want to join two tables out of the three. The requirement is: If value of VAR is ‘X’ then join T1 and T2; otherwise, join T1 and T3. The value of VAR is determined at […]

(Ben Vigil) Oracle used last week’s AppsWorld 2002 in San Diego, Calif. to showcase its newest E-Business Suite, release 11i.Nearly every keynote address at the four-day show related to what 11i could do for customers. Mark Barrenchea, senior VP of market development, said that the principle