Database Architecture Manager (NYC) Next Step Systems US-NY-New York Post A Job | Post A Resume

Oracle Certification - The Last Word on OCP for Oracle8i : want to do and you have not started yet, today is the day you need to start studying--even if you are an old hand at Oracle.

Oracle's DBMS_PROFILER: PL/SQL Performance Tuning : When simply inspecting the code isn't enough, and explain plan leaves you hanging, it's time to pull out Oracle's DBMS_Profiler. Learn how to identify performance bottlenecks, as well as where excess execution time is being spent in the code.

New Features in Oracle 8i Release 2 : Oracle8i Release 2 (Version 8.1.6) is the first maintenance release of the Oracle8i database, and includes many bug fixes, performance improvements, and feature enhancements.

Transportable Tablespaces : Did you ever want to copy and paste the tablespaces between 2 databases. Now you can using the new transportable tablespace feature of oracle 8i.

DBMS_STATS and DBMS_OLAP : As a part of our datawarehousing series, This article gives a brief overview of the oracle supplied dbms_stats and dbms_olap packages, in managing warehouse data.

Function Based Indexes : Chris Kempster writes about Function based indexes and how they can be used to reduce the regular tuning problems faced by oracle professionals.

Index Organized Tables : Learn about index organized tables and how they can be created and used.

Locally Managed Tablespaces : Read about another new feature in oracle 8i that deals with Locally managed tablespaces and how they work.

Partitioning Options in Oracle 8i :Oracle 8 introduced the concept of range partitioning, but with 8i there are 2 new options hash and composite partitioning. This article discusses the difference between these options.

Materialized Views in Oracle 8i : An introduction to materialized views in oracle 8i, to help you speed up data aggregation.

Using Native Dynamic SQL in Oracle 8i : A short Lesson in using the native dynamic sql feature of oracle

Obsolete Parameters in Oracle 8i Init.ora parameters are added and obsoleted with the introduction of new versions of Oracle. In this article, we talk about how you can find the obsolete parameters and more...

Temporary Tables in Oracle 8i 8i central introduces you to the new concept of temporary tables. These tables are temporary either at a session or transaction level and are very useful...

Dropping a column from an Oracle 8i Table Learn about the new feature in oracle 8i that allows you to drop a column...

If you have an interesting column / article /short note etc., that you would like to share with the rest of the DBA world, please send it to contrib@dbasupport.com.

DBAsupport.com Home Page