Transitioning to Locally-Managed Tablespaces :
Oracle 8.1.6 offered a new format for tablespace storage management –
locally-managed tablespaces – that offers significant improvements in
tablespace performance and free space management. Oracle 9i Release 2 improved
upon segment storage in locally-managed tablespaces with the Automatic Segment
Storage Management option. This article delves into the advantages of using locally-managed
tablespaces over dictionary-managed tablespaces and suggests practical methods
to achieve the transition. Oracle's Wrap Utility : With Oracle's wrap
utility, you can turn the inner workings of your code into an impenetrable
black box, for the most part, to protect your property. Learn how in this
article from Steve Callan. Striking Gold with LogMiner - Part 1: Getting Started :
Oracle's LogMiner utility has been around for several years now, and it
originally appeared as a new feature (as opposed to being an improvement of
something else). The purpose of this series is to help demystify some of the
procedures, illustrate some examples of using LogMiner, and to recommend cases
where LogMiner should be a DBA's primary tool for recovering lost data. Decrypting Oracle's DBMS_OBFUSCATION_TOOLKIT :
To secure sensitive data, Oracle provides developers with the
DBMS_OBFUSCATION_TOOLKIT, an industrial strength version of the DBMS_RANDOM
package. You may feel the need of a decoder just to keep track of all the acronyms
and to decrypt the errors in Oracle's sample code, but once you see how easy it
is to use, you'll be able to take Oracle's code example and modify it for your
own use. Generating random numbers and strings in Oracle :
Generating random numbers or strings is oft-times a necessity. Oracle provides
a random number generator that is faster than writing your won random
generation logic in PL/SQL, and can generate both character and alphanumeric
strings. Perhaps it is time to learn more about the DBMS_RANDOM package. Unwrapping Oracle's DBMS Packages: Understanding Oracle's
Random Number Generator : Beginning with later versions of
Oracle8, Oracle has provided a means of generating random numbers. This
built-in package, DBMS_RANDOM, is fairly simple to use, and can generate random
numbers which are generally good enough for the needs of most users. Learn more
as Steve Callan unwraps the first DBMS package of this series.Oracle Database Resource Manager, Part 3: Conclusion :
Oracle Database Resource Management (DRM) provides tools that allow any Oracle
DBA to manage a database server's CPU resources effectively for application
user groups and during different resource demand periods. This final article
builds upon the concepts in the two previous articles, including the construction
of more complex resource plans, monitoring DRM utilization, and general DRM
maintenance. Oracle Database Resource Manager, Part 2: Resource Plan Management
: Oracle Database Resource Management (DRM) provides tools that
allow any Oracle DBA to manage a database server's CPU resources effectively
for application user groups and during different resource demand periods. This
article builds upon the concepts in Part 1 to build and maintain more complex
resource plans, assign users to resource consumer groups, and manage users and
session utilization of DRM resources. Oracle Database Resource Manager, Part 1:Overview :
Oracle Database Resource Management (DRM) provides tools that allow any Oracle
DBA to manage a database server's CPU resources effectively for application
user groups and during different resource demand periods. This article provides
a brief overview of how DRM works and then delves into the preparations
necessary to implement a simple DRM configuration. Oracle Optimizer: Moving to and working with CBO - Part 7
: The final installment of this series covers the basics of
using Stored Outlines and Oracle Application specific information. Oracle Optimizer: Moving to and working with CBO - Part 6
: Previous installments of this series have covered how the Cost
Based Optimizer works and behaves. In part 6 of the series, learn how to assist
the optimizer to do its job properly. Oracle Optimizer: Moving to and working with CBO - Part 5
: This month in Moving to and working with CBO, Amar Kumar Padhi
examines the data skewness problem and the use of the Monitoring option for
updating statistics on the fly.
Oracle Optimizer: Moving to and working with CBO - Part 3
: In this months installment of "Oracle Optimizer and how
to move to CBO," Amar Padhi covers the Initialization parameters and
Hidden or Internal Oracle parameters that influence the Optimizer in choosing
execution plans. Oracle Optimizer: Moving to and working with CBO - Part 2
: In this months installment of 'Oracle Optimizer: Moving to and
working with CBO,' Amar Padhi covers the Initialization parameters and Hidden
or Internal Oracle parameters that influence the Optimizer in choosing
execution plans. Oracle Optimizer: Moving to and working with CBO :
Learn about the Oracle Optimizer and various efficient ways of moving to Cost
Based Optimizer. Part 1 of a five part series. Oracle9iR2 Shared Pool Advisory : Learn
how to get the most out of your Oracle database using the Shared Pool Advisory.
Excel Document Management with the Oracle iFS (Internet
File System) : Marin Komadina explains one of the lesser-known
methods of controlling information chaos using Oracle iFS. Learn how Excel
documents can be securely stored and retrieved from the Oracle database using iFS.
Oh Danny Boy, The DBMS_PIPES Are Calling :
Oracle pipes have been around for a long time but just how many use this
powerful mechanism? James Koopmann explores this feature, reminding us all that
it is not dead yet. It All Depends on the CONTEXT: Using the SYS_CONTEXT Function
: The SYS_CONTEXT function is the recommended replacement method
for obtaining information about users and environment variables instead of the
deprecated USERENV function. This versatile function has been expanded in
Oracle 9i to provide a plethora of information about the Oracle database and
its processes as well as its users and sessions. Document Management with Oracle Text :
Powerful procedures for handling image, audio, video and the text data in
various formats are incorporated in the Oracle database kernel code. Marin Komadina
looks at the ins and outs of the feature originally known as ConText, then interMedia
Text, and finally Oracle Text. Altering Oracle's SQL*Plus Help Facility :
Everyone needs a little help now and then. James Koopmann finds new ways to
provide information to users of SQL*Plus through the Help Facility. So You Want to Use Oracle's SPFILE :
Oracle's traditional method of storing parameters in the INIT.ORA file has
given way to a more robust method-- the server parameter file (SPFILE). Learn
what truly works in converting and maintaining your parameters without ever
having to use an editor again. Change data capture implementation in Oracle Data
warehouses – Part 3 : Our author continues his series on
change data capture implementation in Oracle Data warehouses. Learn about the
change data capture model and how to publish subscribe to change data. Change data capture implementation in Oracle Data
warehouses - Part 2 - Oracle Streams implementation : In part-1
of the series, we discussed the overall view of Oracle Streams and the process
of information sharing between databases. Part-2 of this article, presents a
scenario to demonstrate a simple and "straight-forward" configuration
for Oracle Streams. Change Data Capture Implementation in Oracle Data
Warehouses - Part 1 : The first of this three part series
gives an overview of Oracle Streams. Part 2 of the series will focus on a
simple implementation of Oracle Streams followed by part 3, which will describe
the Change Data Capture framework of Oracle.Getting ANSI About Joins : The new ANSI
format for joins in Oracle 9i may appear alien at first, but they have the
potential to become part of a DBA's arsenal for clarifying SQL and PL/SQL code.
This article discusses the new join formats including NATIVE, CROSS, and OUTER
and includes examples for review and comparison to the "traditional"
join mechanisms. DDL Generation--Oracle's Answer to Save You Time and Money
: The days of building your own DDL extraction utilities are
almost gone; Oracle has given us a simple way to generate the DDL for objects
defined in the database. Join James Koopmann as he delves into
DBMS_METADATA.GET_DDL. Get the init.ora parameter value using DBMS_UTILITY :
Ajay Gursahani explains how to get the values for the parameters specified in 'init.ora'
by using the GET_PARAMETER_VALUE procedure supplied with the DBMS_UTILITY
package. Recompiling PL/SQL Objects using DBMS_DDL package
: Learn how to compile PL/SQL objects that are, already stored in the database
using DBMS_DDL Oracle supplied package. Web Reports from SQL *Plus in Oracle 8i/9i
: Learn how to build complete HTML Reports using SQL *Plus, Oracle's
interactive query tool. Using Resume Operation in Oracle 9i :
Learn how to suspend or resume operations using the new RESUME option in Oracle
9i An Updated Guide to the SPFILE : This
recently revised article from Venu G. will help you become more familiar with
one of Oracle9i’s new features, the server parameter file – aka the SPFILE. The
article has been updated with new sections on the V$SPPARAMETER dynamic
performance view and on using the SPFILE with RAC (Real Application Server).Introduction to Real Application Clusters : Real Application Clusters is
one of the revolutionary features in Oracle 9i Database, but before using this
new feature, we must first understand how Real Application Clusters works, what
resources it requires, and how to effectively deploy it.A Detailed Guide to the SPFILE : This article from Venu G. will
help you become more familiar with one of Oracle9i’s new features, the server
parameter file – aka the SPFILE.Oracle Migration Workbench : Oracle recently released Oracle
Migration Workbench to help developers quickly and easily migrate applications
from IBM DB2/AS400 to Oracle9i Database. RMAN Enhancements in Oracle 9i : This note discusses some
important new features that have been introduced in Oracle 9i RMAN. A brief
discussion of some new features, commands etc.
Undo Tablespaces in Oracle 9i : As a part of our Oracle 9i
Feature Series, This article gives a brief overview of Undo Tablespaces, Init.ora
parameters that affect them and creation, management and monitoring of the Undo
Tablepspaces
Database Management ( DBA ) Enhancements in Oracle 9i : As a part of our Oracle 9i
Feature Series, This article gives a brief overview of the new features in
Oracle 9i that help database administrators get administrative chores done
quicker.
Datawarehousing ( ETL) Enhancements in Oracle 9i : As a part of our Oracle 9i
Feature Series, This article gives a brief overview of the new features in
Oracle 9i that improve the data processing / data warehousing features of
Oracle.
