Miscellaneous Articles
 |
DBA
Basic Security Measures for Oracle - This article presents some basic steps to increase the security of your Oracle database servers.
Configuration of PHP with IIS on Windows 2003 - This article contains instructions for setting up PHP with IIS on Windows 2003.
Deadlocks - This article shows the steps necessary to identify the offending application code when a deadlock is detected.
Direct and Asynchronous I/O - Take advantage of the performance advantages associated with Direct and Asynchronous I/O.
Identifying Host Names and IP Addresses - This article presents a mixed bag of Oracle functionality relating to the identification of host names and IP addresses for Oracle clients and servers.
Killing Oracle Sessions - Kill Oracle sessions from SQL, NT and UNIX.
Manual Oracle Uninstall - Having trouble removing all Oracle software using the OUI? Try these methods.
Naming Conventions - Some of the typical naming conventions used for objects in Designer and the database.
Oracle Network Configuration - This article gives an example of each configuration file as a starting point for simple network configuration.
Oracle Shell Scripting - This article presents some some basic techniques for creating Windows batch files and UNIX/Linux shell scripts that connect to SQL*Plus and RMAN.
Oracle Universal Installations (OUI) Silent Installations - Use the Oracle Universal Installations (OUI) to create and use response files to automate the installation of Oracle products.
OS Authentication - A guide to configuring OS authentication on UNIX/Linux and Windows servers.
OS Backup Commands - A summary of the operating system backup commands you might encounter whilst backing up Oracle databases.
Partitioning an Existing Table using EXCHANGE PARTITION - This article presents a simple method for partitioning an existing table using the
EXCHANGE PARTITION syntax.Partitioning an Existing Table using DBMS_REDEFINITION - This article presents a simple method for partitioning an existing table using the
DBMS_REDEFINITION package.RAID - A summary of the most common RAID levels and their usage with Oracle files.
Recompiling Invalid Schema Objects - This article presents several methods for recompiling invalid schema objects.
Renaming or Moving Oracle Files - An explanation of how assorted Oracle files can be renamed or moved to a new location.
Stored Outlines and Plan Stability - Use stored outlines to maintain consistent execution plans regardless of changes in the system environment or associated statistics.
Schema Owners and Application Users - Protect your schema objects by defining application users with the necessary privileges on those objects, rather than allowing direct connections to the schema owner.
UNIX Commands For DBAs - A selection of UNIX commands including those for monitoring performance.
Virtual Indexes - Use virtual indexes to test alternate indexing strategies with no impact on the rest of your system.
Zend Core for Oracle v2 - Get a fully configured Apache + PHP server with full Oracle connectivity from a single installation.
|
Development
DBMS_PIPE - For Inter-Session Communication - This article presents a brief description of the
DBMS_PIPE package, explaining how it can be used
for non-secure inter-session mesaging.Dynamic IN-Lists - This article presents a number of methods for parameterizing the IN-list of a query.
Efficient SQL Statements - A brief non-version specific guide to writing efficient SQL statements.
LAG and LEAD Analytic Functions - Simple examples of how to use these analytic functions.
Literals, Substitution Variables and Bind Variables - The article compares the affect of using literals, substitution variables and bind variables on memory and CPU usage.
Object Views and Nested Tables - Use object views to present relational data as an object-relational model.
Populating Master-Detail Foreign Key Values Using Sequences - This article presents some safe methods for populating master-detail foreign key columns when using sequences.
RANK, DENSE_RANK, FIRST and LAST Analytic Functions - Simple examples of how to use these analytic functions.
Retrieving HTML and Binaries into Tables Over HTTP - This article gives two brief examples of how HTML pages and Binaries, such as images or documents, can be downloaded over HTTP and placed directly into tables.
Top-N Queries - Top-N queries provide a method for limiting the number of rows returned from ordered sets of data.
Web Scripting for Oracle (PHP, Perl, JSP, ASP and ASP.NET) - This article presents the basic syntax for several popular web scripting languages that connect to Oracle databases.
WITH Clause - Use the WITH clause to reduce repetition and simplify complex SQL statements.
|
Operating System Installations
Fedora 7 (F7) Installation - This article provides a pictorial guide for performing a basic server installation of Fedora 7 (F7).
Oracle Enterprise Linux 4.5 - This article provides a pictorial guide for performing a default installation of Oracle Enterprise Linux 4.5.
Oracle Enterprise Linux 5 - This article provides a pictorial guide for performing a default installation of Oracle Enterprise Linux 5.
Red Hat Enterprise Linux 2.1 and CentOS 2 Installation - This article provides a pictorial guide for performing a default installation of Red Hat Enterprise Linux 2.1 and CentOS 2.
Red Hat Enterprise Linux 3 and CentOS 3 Installation - This article provides a pictorial guide for performing a default installation of Red Hat Enterprise Linux 3 and CentOS 3.
Red Hat Enterprise Linux 4 and CentOS 4 Installation - This article provides a pictorial guide for performing a default installation of Red Hat Enterprise Linux 4 and CentOS 4.
Red Hat Enterprise Linux 5 and CentOS 5 Installation - This article provides a pictorial guide for performing a default installation of Red Hat Enterprise Linux 5 and CentOS 5.
Solaris 10 (x86-32) Installation - This article provides a pictorial guide for performing a default installation of Solaris 10 (x86-32).
SUSE Linux 10.1 Installation - This article provides a pictorial guide for performing a default installation of SUSE Linux 10.1.
Ubuntu 6.10 Installation - This article provides a pictorial guide for performing a default installation of Ubuntu 6.10.
|
