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
