free Oracle DBA tutorial Oracle Jobs
Ask A Question
SQL Statement Tuning
Backup and Recovery Concepts
Oracle 11g New Features
Oracle E Suite & Others
Oracle Data Guard
Oracle DBA FAQ

Oracle DBA - Oracle Installations

Page :  1  2  3  4  5

Oracle Real Application Clusters Quick Installation Guide for Oracle Database Standard Edition 10g Release 1 ( for Windows

Oracle Real Application Clusters Quick Installation Guide for Oracle Database Standard Edition 10g Release 1 ( for Windows NOTE: OTN Acct Req'd (free)

Oracle's SPFILE - Part 1

Oracle requires an initialization file to define the attributes and characteristics of the starting instance and the connecting sessions there of. We are aware of the Initialization parameter file (also referred as init.ora file or PFILE). This file holds the setup parameters that define the attribute of the instance that is being started. Administrators can control, tune and optimize an instance by setting and modifying the initialization parameters in this file.

Oracle's SPFILE - Part 2

The first part of this series introduced the System Parameter file and its attributes. Below are some practical examples of working with the SPFILE.

Planning an Oracle Database

The planning and design phase of a database is the most influential factor in determining its performance and integrity. At this stage, the DBA should have identified the major business requirements. Now is the time to design a database to meet those business requirements. The DBA will look at the system architecture to determine where to put the database. This will depend largely on the type of application(s) the database will need to support. Next, the Unix/Linux server supporting the database will be selected based upon both technical and non-technical considerations. The DBA will then determine the physical structure and layout of the database files while focusing on performance and integrity. After these steps are completed and a solid database design has been created and reviewed, the actual process of building the system can begin.

Planning Extents

It is often said that there is another dimension to space, which is time. For DBAs that is the time that they spend managing their database space. That time is often considerable, and matched only by the strength of their opinions on the matter. The options are many, and the differences between versions are profound, making this a difficult topic to discuss. Nevertheless, the issue must be addressed prior to database creation, lest you end up with a mess that is going to waste a lot of time for both the DBA and the database.


A tablespace is a logical storage unit within an Oracle database. It is logical because a tablespace is not visible in the file system of the machine on which the database resides. A tablespace, in turn, consists of at least one datafile which, in turn, are physically located in the file system of the server. Btw, a datafile belongs to exactly one tablespace.

The Globalization of Language in Oracle - And Case-Insensitivity

In pre-Oracle10g versions of Oracle, in order to get this type of equality of characters you needed to use a combination of the NLS_UPPER and NLS_LOWER functions or use the NLS_SORT setting of GENERIC_BASELETTER. While these approaches worked they do have the flaw of having to programmatically code the NLS_UPPER or NLS_LOWER functions into every select statement. Or when using the GENERIC_BASELETTER you had a solution that was not a true linguistic solution for character comparison.

The Globalization of Language in Oracle - National Language Support

It is very important when talking about the globalization of language to understand the settings that you currently have on the database server and what you expect at the client side application. To do this, Oracle allows National Language Support (NLS) at the instance level as well as at the session level providing the ability to default the NLS parameters for our end users' client PCs to the instance settings or override them when needed because they are truly in a different locale. This article will introduce you to the settings that are available, how to determine what the values of these variables are and an export/import example that should prove enlightening.

Page :  1  2  3  4  5

More Tutorials on Oracle dba ...

Liked it ? Want to share it ? Social Bookmarking

Add to: Mr. Wong Add to: BoniTrust Add to: Newsider Add to: Digg Add to: Del.icio.us Add to: Reddit Add to: Jumptags Add to: StumbleUpon Add to: Slashdot Add to: Netscape Add to: Furl Add to: Yahoo Add to: Spurl Add to: Google Add to: Blinklist Add to: Technorati Add to: Newsvine Information

Want to share or request Oracle Tutorial articles to become a Oracle DBA. Direct your requests to webmaster@oracleonline.info

Oracle Forum   

Oracle DBA - Step 1
Oracle DBA - Step 2
Oracle DBA - Step 3
Oracle DBA - Step 4
Oracle DBA - Step 5
Oracle DBA - Step 6
Oracle DBA - Step 7
Oracle DBA - Step 8
Oracle DBA - Step 9
Oracle DBA - Step 10

SQL Statement Tuning
Backup and Recovery Concepts
Oracle 11g New Features
Oracle E Suite & Others
Oracle Data Guard
Oracle DBA FAQ