Multiple Temporary Tablespaces in Oracle 10g :
The creation and use of temporary tablespaces has just taken another leap in
performance and manageability, which should make us all re-think how we have
created and assigned our users to temporary tablespaces. Transferring Operating System Files from within Oracle :
As new versions of Oracle are released, we are less likely to access the
operating system. The ability to move data files from within Oracle is just one
more great hook to the operating system that aids DBAs in their daily tasks. Using Oracle's SQL Functions - Part 2 :
The second article of this series looks at 11 SQL-related functions commonly
used in statistics: count, sum, average, standard deviation, variance and
covariance (standard deviation and variance have three each; covariance has
two). Using Oracle's SQL Functions : Oracle
provides quite an array of functions when it comes to manipulating data via
SQL. Of particular interest for this new series, are the functions related to
numbers. Learn how this relates to your job as a DBA. Installation Cookbook: Installing Oracle Application
Server 10g (9.0.4)Forms and Reports Services : Support for
versions older than Oracle 9i is coming to an end--users wanting to view data in
a database via forms will have to move to Oracle 9i/10g forms. The big show
stopper on that process is that you need to have Application Server installed
and running to view 9i/10g forms on the web. Learn how to install Application
Server and make the connection to your databases. Installation Cookbooks: Installing Oracle9i Developer Suite
: Most people can muddle through Oracle product installations on
their first one or two attempts. But what happens when you run into the
occasional lemon-like installation guide, such as the one for Oracle9i
Developer Suite (iDS)? Steve Callan offers a detailed, step-by-step
installation cookbook for installing Oracle9i Developer Suite (9.0.2, including
a patch) on a Sun Solaris platform. Installation Cookbooks: Installing Oracle Forms &
Reports 6i : More often than not, the DBA owns everything
related to Oracle, whether or not the DBA has anything to do with that 'other'
Oracle stuff. It's time to shake off the narrow-minded view about what a DBA
does and expand your knowledge of Oracle's installation process. Installation Cookbooks: Installing Oracle9i :
In his new series, Installation Cookbooks, Steve Callan lays out a methodology
for installing Oracle products on UNIX-based systems (primarily using Solaris).
The Trigger-Happy DBA - System Triggers – Part 3 :
The use of system triggers can greatly expand a DBA's ability to monitor
database activity and events. Join Steve Callan as he examines the creation and
use of system triggers. The Trigger-Happy DBA - Part 2 : What a
form trigger can do, and has in common with the "pure" development
type of trigger, is generate the ORA-04091 mutating table error. Learn how to
work your way around this error by taking your DML elsewhere. The Trigger-Happy DBA : Triggers can be an
effective tool to manage and control data, and to enforce business rules and
logic. Some of the more commonly used areas include auditing, enforcement of
business rules, and behind the scenes DML-related operations. This first
article in the series focuses on DML triggers. Oracle: Preventing Corruption Before it's Too Late - Part
2 : Marin Komadina discusses Oracle data-block corruption,
describing several features of Oracle that may be used at an early stage to
detect database corruption. Part 2 of this series explores Oracle soft and bug
corruption. Preventing Corruption Before it's Too Late: Part 1 :
Marin Komadina discusses Oracle data-block corruption, describing several
features of Oracle that may be used at an early stage to detect database
corruption. Oracle's Default TEMPORARY Tablespaces :
Using the SYSTEM tablespace as a temporary tablespace is to be frowned upon,
yet Oracle still lets us assign it as such. James Koopmann explores a better
way. What's In A Name - Naming and Idenifying Oracle Databases
and Instances : Identification of the database you are currently
working on can sometimes be somewhat confusing. James Koopmann examines the
parameters that need to be set and at the same time explains ways of
determining to which database and instance you are working and connected. Understanding Oracle's Locally Managed Tablespaces :
Locally Managed Tablespace (LMT), one of the key features in Oracle databases,
has been available since Oracle 8i. Amar Padhi offers some scenarios of note
for systems that are already using LMTs or planning to shift to LMTs. Using Index Hints in SQL statements - 'Cause we know more
about our application than Oracle does : Hints are used to give
specific information about our data and application, to Oracle. Ajay Gursahani
examines Index Hints, how they can improve certain SQL statements that might
otherwise be inefficient, and the advantages of doing so. Getting control of the Oracle Java Virtual Machine :
Being the master of your database means gaining control of Oracle's Java
Virtual Machine. Follow along with Marin Komadina as he explains installation
tricks and offers some practical JVM tips. Database Impact of Collecting Statistics in Oracle :
Oracle has given us a new parameter STATISTICS_LEVEL for collecting database
statistics. James Koopmann takes a deeper look at what to expect from your
database system when this parameter is set and statistics are being gathered. Implications of Setting Oracle9iR2's Statistics
Collection Level : Concerned about looking at statistics within
Oracle? You should take a quick look at Oracles' new method of turning
collections on or off. Explain Away Your Troubles : Determining
when things change in a database is the first step in zeroing in on problems.
One of the prime culprits to change is the very SQL that we attempt to run
every day. James Koopmann shares his no-frills method to help sniff out those
changes that occur. External Tables in Oracle 9i : Learn how
to run any SQL query against external data without requiring that the external
data first be loaded into the database. Leaving the History Behind with Oracle's Fine Grained
Access Control : Marin Komadina explains how to export tables
from a user schema--without having to export the history tables as well. That Darn Alert Log : Until Oracle decides
to give DBAs built-in direct access to the alert log, it will always be our
responsibility to continually check and maintain it. Here is a simple solution
that will help with this most basic of DBA task. Exploring the use of Directory Objects in Oracle 9i
: Nandeep explores the advantages of Oracle9i's Directory Object. Learn how to
set up a directory object, access data using external tables, and get directory
information from the database. Viewing and Managing Job Queues in Oracle 9i
: Learn how to schedule the periodic execution of user jobs using job queues in
Oracle 9i. Also covered are topics on viewing job queue information and
managing job queues. Remote Procedure Calls Will Get You the Cheese
: Ever need to pull information from a remote computer through Oracle? Here is
a method for getting the system date and time that you can easily expand on to
pull loads of other information. Managing Processes for External Procedures in Oracle
: In his first article, Ajay Gurshahani details the use of External Routines in
Oracle 8i/9i, which are helpful in eliminating the need for using CGIs and also
make it possible to create dynamic libraries and call them from PL/SQL. Sending E-mails from Oracle Database : In
his first article for DBAsupport.com, Amar Kumar Padhi details how to take
advantage of an e-mail server option in Oracle 8i that allows you to send mail
from within your code.Listen Software Solutions' "How To" Series:
Dynamic SQL : In the final article of the "How To"
series from Listen Software, author David Nishimoto discusses how to use
Dynamic SQL (select, insert, update, and delete) in stored procedures. Listen Software Solutions' "How To" Series: The
Listener Server : In the twenty-fifth article of the "How
To" series from Listen Software, author David Nishimoto discusses how to
start and stop the listener server and how the client and server use the
listener server. Listen Software Solutions' "How To" Series:
Using the Net 8 Assistant : In the twenty-fourth article of the
"How To" series from Listen Software, author David Nishimoto
discusses using the Net 8 Assistant to create a connector descriptor, using
Host, Port, Sid, and logical names.Listen Software Solutions' "How To" Series: SQL
Tuning - File I/O Performance : In the twenty-third article of
the "How To" series from Listen Software, author David Nishimoto
offers tips and tricks for improving File I/O performance, with tuning topics
focusing on the library cache, data dictionary cache, data cache hit ratios,
sorting, utlbstat and utlestat, and rollback wait stats.Listen Software Solutions' "How To" Series: SQL
Tuning - Performance : In the twenty-second article of the
"How To" series from Listen Software, author David Nishimoto presents
sample SQL code to analyze the library cache, data cache hit ratio, buffer hit
ratio, and shared pool free memory.Listen Software Solutions' "How To" Series: SQL
Tuning - Optimizer Hints: In the twenty-first article of the
"How To" series from Listen Software, author David Nishimoto offers
hints to help improve the optimizer's performance.Listen Software Solutions' "How To" Series: SQL
Tuning - The Explain Plan: In the twentieth article of the
"How To" series from Listen Software, author David Nishimoto guides
you through creating and using the explain plan to tune your SQL statements.Listen Software Solutions' "How To" Series:
Performing an Incomplete Recovery : In the nineteenth article of
the "How To" series from Listen Software, author David Nishimoto
provides a step-by-step guide to performing an incomplete recovery of your
database.Listen Software Solutions' "How To" Series:
Troubleshooting Tips : In the eighteenth article of the
"How To" series from Listen Software, author David Nishimoto offers
troubleshooting tips for types of database failures, alert logs, and recovery
views. Listen Software Solutions' "How To" Series:
Backup and Recovery Strategy : In the seventeenth article of the
"How To" series from Listen Software, author David Nishimoto details
cold and hot backup steps with incomplete and complete recovery strategies.Listen Software Solutions' "How To" Series:
Calculating Tablespace and Table Byte Sizes : In the sixteenth
article of the "How To" series from Listen Software, author David Nishimoto
offers information on how to calculate tablespace and table byte size.Listen Software Solutions' "How To" Series: Tablespaces
: In the fifteenth article of the "How To" series from Listen
Software, author David Nishimoto presents information and code for creating tablespaces,
adding a datafile to a tablespace, taking a tablespace offline and online, and
performing a hot backup of a tablespace. Listen Software Solutions' "How To" Series:
PL/SQL Commands and Syntax : In the fourteenth article of the
"How To" series from Listen Software, author David Nishimoto offers
information and examples on creating cursors, functions, procedures, packages,
and triggers.Listen Software Solutions' "How To" Series:
Tables : In the thirteenth article of the "How To"
series from Listen Software, author David Nishimoto shares information on
creating tables, adding Primary key constraints and foreign key constraints,
and rebuilding indexes.Listen Software Solutions' "How To" Series:
Oracle Functions : In the twelfth article of the "How To" series from Listen
Software, author David Nishimoto offers an extensive list of pre-built Oracle
functions, including examples of string, time, number, and group functions.Listen Software Solutions' "How To" Series: A
Collection of DBA How To's: In the eleventh article of the "How To" series
from Listen Software, author David Nishimoto offers various tips and guides to managing
datafiles, tablespaces, indexes, rollback segments, snapshots, tables,
constraints, and much more.Listen Software Solutions' "How To" Series: The
Database Assistant : In the tenth article of the "How To" series
from Listen Software, author David Nishimoto offers instruction on using the
Database Assistant to create an Oracle instance.Listen Software Solutions' "How To" Series: SQL
Plus Reports and Commands : In the ninth article of the "How To" series
from Listen Software, author David Nishimoto offers examples of how to build
SQL Plus reports, including header, title, column names, linesize, pagesize,
format specification, and spooling commands.Listen Software Solutions' "How To" Series: Job
Management
: In the eighth article of the "How To" series from Listen Software,
author David Nishimoto covers job management, with examples of how to use the
snapshot process to create stored procedures that run as jobs, how to run
existing jobs, how to remove jobs from the job queue, and more.Listen Software Solutions' "How To" Series: The
Parameter File : In the seventh article of the "How To" series from Listen
Software, author David Nishimoto covers the parameter file, with definitions
and values for the various types of variables in the file.Listen Software Solutions' "How To" Series:
Rollback Segments : In the sixth article of the "How To" series
from Listen Software, author David Nishimoto covers rollback segments, offering
examples of how to create a rollback segment and how to bring a rollback
segment online.Listen Software Solutions' "How To" Series: Logfiles : In the fifth article of the
"How To" series from Listen Software, author David Nishimoto covers logfiles,
offering examples of how to reset a logfile, how to determine the status of
existing logfiles, how to add a logfile to a log group, how to drop a logfile
group, how to clear a corrupted logfile group, how to turn archiving on to
enable recovery, and more.Listen Software Solutions' "How To" Series:
Creating a Database : In the fourth article of the "How To" series
from Listen Software, author David Nishimoto offers examples for manually
creating a Oracle Database Instance or creating a database by using the
Instance Manager.Listen Software Solutions' "How To" Series:
Control File Backups : In the third article of the "How To" series
from Listen Software, author David Nishimoto provides two examples of how to
create backups of the control file, which can be used during hot backup
recoveries.Listen Software Solutions' "How To" Series:
Stored Procedures : In the second article of the "How To" series
from Listen Software, author David Nishimoto provides an example of how to
create a stored procedure, complete with types of input parameters, types of
data structures, conditional logic structures, and blocking statements.Listen Software Solutions' "How To" Series:
Normalization : In the first article of the new "How To" series from
Listen Software, author David Nishimoto covers the basics of normalization
guidelines.Adding Columns in a Synchronous Multi-Master Replicated
Environment : So you find yourself in a synchronous multi-master
replicated environment under Oracle 8i and need to add a column to a table.
Greg Johnson's step-by-step guide makes the process as painless as possible.
