Database Applications - IT Library : ZDNet Asia

White Papers

Case Studies

Vendor Webcast

Show all content

Title Date Added Company

Automating Installation of Oracle Database 10g and Red Hat Enterprise Linux 2006-10-11 01:00:17 Oracle

One of the well accepted best practices in system administration is to automate routine tasks whenever possible. Oracle Database 10g includes a number of enhancements and new features that automate common deployment and configuration activities. Furthermore, with Oracle 10g, database installations can be performed more quickly and require less system resources than previous versions. This paper will briefly provide some insight into the tools and processes involved in building a Linux server from the ground up via this process. Specifically, the paper describes an approach that will install Oracle Database 10g and the Red Hat Enterprise Linux (RHEL) operating system on a test server.

Convert a Single Instance Database to Oracle RAC 10g on RHEL3 2006-10-11 01:00:17 Oracle

For those with limited hands-on experience, implementing Oracle RAC 10g can be an intimidating prospect. But it doesn't have to be that way. This paper provides the precise procedures for converting a single-instance Oracle 10g database to Oracle RAC on RHEL3. Oracle Automatic Storage Management (ASM), an integrated file system and a volume management solution built into the Oracle database kernel, is used for RAC database storage because it simplifies database storage management tasks while offering storage reliability and performance. To summarize on a very high level, there are several ways to convert the database to RAC.

Grasping for Data 2006-10-11 01:00:17 Oracle

The Linux operating system is a cup that overflows with files. There are files for configuration settings, text files, documentation files, log files - the list goes on and on. Quite often, those files contain information one needs to access to find important data. Although one can easily dump the contents of most files to the screen with standard utilities such as cat, more, and others, there are utilities better suited for parsing out relevant values. This paper examines utilities such as grep, cut, paste, join, sed, and awk, but it doesn't just reiterate man pages and run through why each utility exists.

Guide to Linux Archive Utility Mastery 2006-10-11 01:00:17 Oracle

Three archive facilities the users are most likely to encounter on Linux are GNU tar, GNU cpio, and rpm (Red Hat Packet Manager). "Tar" is an abbreviation of 'T'ape 'ar'chiver; it was originally written for backup onto magnetic tape. Cpio derives its name from "Copy input and output" and is similar to tar. First developed by Red Hat and released to the open source community, rpm is a specialized archive facility designed for packaging application software. By way of introduction to these facilities, this paper will focus on archiving files on a single-user system.

Improve Your Scripting With the test Command 2006-10-11 01:00:17 Oracle

The all too often underappreciated shell script is limited in power only by the ability of the person writing it. Every operation undertaken in a shell script, beyond the simplest grouping of commands, requires an examination of conditions. All shell script "Logic" - to use the term in its loosest sense - can usually be broken into one of three following broad categories: if {condition exists} then ..., while {condition exists} do ..., and until {condition exists} do ... Regardless of the subsequent action, each of these logic-based commands is dependent on knowing if a condition truly exists. The test command is the utility that makes it possible in every situation to determine whether or not the condition in question exists.

Guide to Linux File Command Mastery 2006-10-11 01:00:17 Oracle

Although GUI desktops such as KDE and GNOME help users take advantage of Linux features without functional knowledge of the command-line interface, more power and flexibility are often required. Moreover, a basic familiarity with these commands is still essential to properly automate certain functions in a shell script. This paper is a "Crash course" in Linux file commands for those who are either new to the operating system or simply in need of a refresher. It includes a brief overview of the more useful commands as well as guidance regarding their most powerful applications.

Tuning Oracle Database 10g on Linux Using ASM 2006-10-11 01:00:17 Oracle

With the explosive database size requirements and the proliferation of SAN (Storage Area Network) and NAS (Network-Attached Storage) disk technologies, the system administrator and the DBA must manage hundreds to thousands of disks - sometimes just for one database. Thus the task of planning, initializing, allocating, managing and tuning so many disks becomes unwieldy. Capitulation is often inevitable, and many shops simply treat the disk storage farm as a black box, thus abstracting that complexity away from the database. Frequently this black-box approach can lead to database I/O bottlenecks that are time-consuming to diagnose and remedy. Oracle Database 10g's new Automatic Storage Management (ASM) feature directly addresses these real-world scenarios by providing an effective and simple middle-ground solution.

Oracle Database 10g: Top Features for DBAs - Part 2: Manageability Features 2006-10-11 01:00:17 Oracle

The paper presents manageability features of Oracle Database 10g such as Automatic Storage Management (ASM) Command Line Tool, drop empty datafiles, direct SGA Access for Hung/Slow Systems, redefine a Partition Online, block integrity checking in memory, not just on disk, online limit changes, faster startup, managing multiple objects in Oracle Enterprise Manager, automatic segment advisor, and event-based scheduling.

Response-Time Analysis Made Easy in Oracle Database 10g 2006-10-11 01:00:17 Oracle

Historically, in trying to achieve maximum database performance, Oracle DBAs and performance analysts have fought an uphill battle to obtain solid response time metrics for system as well as user session activity. The problem facing DBAs has always had two facets: first, determining exactly "Where" the database or user sessions have been spending their time; and second, determining the objective nature of the user experience. Fortunately, those Oracle DBAs who have upgraded to Oracle Database 10g will find major response-time enhancements that allow a much better picture to be presented about system and session-level response-time metrics. This paper will explore the use of some of the historical mechanisms at the system, session, and SQL levels.

Trace File Manager: Managing Distributed Trace Files With Oracle and PHP 2006-10-11 01:00:17 Oracle

Initiating the trace is easy and can be applied to a session using the standard dbms_system.set_sql_trace_in_session call spec or alternately by invoking the "Deeper" trace utility dbms_support.start_trace_in_session, which in addition detects bind variable values and wait events. However, getting access to the generated trace file is sometimes a little bit more difficult; one has to ensure that access is available to the USER_DUMP_DIRECTORY on the server where the database lives. For DBA supporting lots of different databases on lots of different servers, the job of accessing generated trace files and using TKPROF to format them becomes even more difficult. This paper describes a solution to this problem, known as the Trace File Manager (TFM).

Jump to 1 2 3 4 5 [6] 7 8 9 10

Title	Date Added	Company
Automating Installation of Oracle Database 10g and Red Hat Enterprise Linux	2006-10-11 01:00:17	Oracle
One of the well accepted best practices in system administration is to automate routine tasks whenever possible. Oracle Database 10g includes a number of enhancements and new features that automate common deployment and configuration activities. Furthermore, with Oracle 10g, database installations can be performed more quickly and require less system resources than previous versions. This paper will briefly provide some insight into the tools and processes involved in building a Linux server from the ground up via this process. Specifically, the paper describes an approach that will install Oracle Database 10g and the Red Hat Enterprise Linux (RHEL) operating system on a test server.
Convert a Single Instance Database to Oracle RAC 10g on RHEL3	2006-10-11 01:00:17	Oracle
For those with limited hands-on experience, implementing Oracle RAC 10g can be an intimidating prospect. But it doesn't have to be that way. This paper provides the precise procedures for converting a single-instance Oracle 10g database to Oracle RAC on RHEL3. Oracle Automatic Storage Management (ASM), an integrated file system and a volume management solution built into the Oracle database kernel, is used for RAC database storage because it simplifies database storage management tasks while offering storage reliability and performance. To summarize on a very high level, there are several ways to convert the database to RAC.
Grasping for Data	2006-10-11 01:00:17	Oracle
The Linux operating system is a cup that overflows with files. There are files for configuration settings, text files, documentation files, log files - the list goes on and on. Quite often, those files contain information one needs to access to find important data. Although one can easily dump the contents of most files to the screen with standard utilities such as cat, more, and others, there are utilities better suited for parsing out relevant values. This paper examines utilities such as grep, cut, paste, join, sed, and awk, but it doesn't just reiterate man pages and run through why each utility exists.
Guide to Linux Archive Utility Mastery	2006-10-11 01:00:17	Oracle
Three archive facilities the users are most likely to encounter on Linux are GNU tar, GNU cpio, and rpm (Red Hat Packet Manager). "Tar" is an abbreviation of 'T'ape 'ar'chiver; it was originally written for backup onto magnetic tape. Cpio derives its name from "Copy input and output" and is similar to tar. First developed by Red Hat and released to the open source community, rpm is a specialized archive facility designed for packaging application software. By way of introduction to these facilities, this paper will focus on archiving files on a single-user system.
Improve Your Scripting With the test Command	2006-10-11 01:00:17	Oracle
The all too often underappreciated shell script is limited in power only by the ability of the person writing it. Every operation undertaken in a shell script, beyond the simplest grouping of commands, requires an examination of conditions. All shell script "Logic" - to use the term in its loosest sense - can usually be broken into one of three following broad categories: if {condition exists} then ..., while {condition exists} do ..., and until {condition exists} do ... Regardless of the subsequent action, each of these logic-based commands is dependent on knowing if a condition truly exists. The test command is the utility that makes it possible in every situation to determine whether or not the condition in question exists.
Guide to Linux File Command Mastery	2006-10-11 01:00:17	Oracle
Although GUI desktops such as KDE and GNOME help users take advantage of Linux features without functional knowledge of the command-line interface, more power and flexibility are often required. Moreover, a basic familiarity with these commands is still essential to properly automate certain functions in a shell script. This paper is a "Crash course" in Linux file commands for those who are either new to the operating system or simply in need of a refresher. It includes a brief overview of the more useful commands as well as guidance regarding their most powerful applications.
Tuning Oracle Database 10g on Linux Using ASM	2006-10-11 01:00:17	Oracle
With the explosive database size requirements and the proliferation of SAN (Storage Area Network) and NAS (Network-Attached Storage) disk technologies, the system administrator and the DBA must manage hundreds to thousands of disks - sometimes just for one database. Thus the task of planning, initializing, allocating, managing and tuning so many disks becomes unwieldy. Capitulation is often inevitable, and many shops simply treat the disk storage farm as a black box, thus abstracting that complexity away from the database. Frequently this black-box approach can lead to database I/O bottlenecks that are time-consuming to diagnose and remedy. Oracle Database 10g's new Automatic Storage Management (ASM) feature directly addresses these real-world scenarios by providing an effective and simple middle-ground solution.
Oracle Database 10g: Top Features for DBAs - Part 2: Manageability Features	2006-10-11 01:00:17	Oracle
The paper presents manageability features of Oracle Database 10g such as Automatic Storage Management (ASM) Command Line Tool, drop empty datafiles, direct SGA Access for Hung/Slow Systems, redefine a Partition Online, block integrity checking in memory, not just on disk, online limit changes, faster startup, managing multiple objects in Oracle Enterprise Manager, automatic segment advisor, and event-based scheduling.
Response-Time Analysis Made Easy in Oracle Database 10g	2006-10-11 01:00:17	Oracle
Historically, in trying to achieve maximum database performance, Oracle DBAs and performance analysts have fought an uphill battle to obtain solid response time metrics for system as well as user session activity. The problem facing DBAs has always had two facets: first, determining exactly "Where" the database or user sessions have been spending their time; and second, determining the objective nature of the user experience. Fortunately, those Oracle DBAs who have upgraded to Oracle Database 10g will find major response-time enhancements that allow a much better picture to be presented about system and session-level response-time metrics. This paper will explore the use of some of the historical mechanisms at the system, session, and SQL levels.
Trace File Manager: Managing Distributed Trace Files With Oracle and PHP	2006-10-11 01:00:17	Oracle
Initiating the trace is easy and can be applied to a session using the standard dbms_system.set_sql_trace_in_session call spec or alternately by invoking the "Deeper" trace utility dbms_support.start_trace_in_session, which in addition detects bind variable values and wait events. However, getting access to the generated trace file is sometimes a little bit more difficult; one has to ensure that access is available to the USER_DUMP_DIRECTORY on the server where the database lives. For DBA supporting lots of different databases on lots of different servers, the job of accessing generated trace files and using TKPROF to format them becomes even more difficult. This paper describes a solution to this problem, known as the Trace File Manager (TFM).