tag:blogger.com,1999:blog-73225346967496832322008-07-25T03:53:23.564-07:00phenixnoreply@blogger.comBlogger74125tag:blogger.com,1999:blog-7322534696749683232.post-6474028666244819882008-07-25T03:45:00.000-07:002008-07-25T03:53:23.584-07:00

Installing and Configuring Oracle Enterprise Linux 5 with Oracle Database 11g Release 1 as a Paravirtualized Machine (PVM) on an Oracle VM Server This tutorial describes how to install Oracle Enterprise Linux 5 with Oracle Database 11g Release 1 as a paravirtualized machine (PVM) on an Oracle VM Server. This tutorial covers the following topics: Overview Prerequisites Preparing the

phenixnoreply@blogger.comtag:blogger.com,1999:blog-7322534696749683232.post-61399232763611606872008-07-23T22:44:00.000-07:002008-07-23T23:23:41.738-07:00

Drill-Down Monitoring of Database Servers The article presents a process for identifying and resolving problems with the performance of database servers. Learn how to monitor and tune databases, as well as how to recognize if a shared memory segment uses ISM (Intimate Shared Memory). Link: http://www.informit.com/articles/article.aspx?p=28709 Oracle Database Tuning For optimum performance an

phenixnoreply@blogger.comtag:blogger.com,1999:blog-7322534696749683232.post-33766929293674238412008-07-23T19:22:00.000-07:002008-07-23T19:24:07.185-07:00

All DBA's are required to set-up an Oracle monitoring infrastructure and the architecture of the monitoring system is directly dependent on the demands of management. Oracle system cost the end-user community millions of dollars, and the end-user often demand service-level agreements (SLA's) that impose strict monitoring tasks for the Oracle professional. - In many shops, the end-user community

phenixnoreply@blogger.comtag:blogger.com,1999:blog-7322534696749683232.post-6220811888638850022008-07-17T03:08:00.000-07:002008-07-17T03:46:04.876-07:00

Here is a very good introduction to Oracle architecture: this one Outline the Oracle architecture and its main components and list the structures involved in connecting a user to an Oracle Instance. Overview of Primary Components Establishing a Connection and Creating a Session Oracle Database Reference: Oracle Architectural Component

phenixnoreply@blogger.comtag:blogger.com,1999:blog-7322534696749683232.post-52848940433626136372008-06-06T23:30:00.000-07:002008-06-06T23:47:59.522-07:00

It used to be a challenge to size the various memory pools that comprise the Oracle System Global Area (SGA) for optimal performance. But that was before Oracle Database 10g. First introduced in Oracle Database 10g and further enhanced in Oracle Database 10g Release 2, Automatic Shared Memory Management (ASMM) automatically sizes many of the memory pools while the database is running, allocating

phenixnoreply@blogger.comtag:blogger.com,1999:blog-7322534696749683232.post-26739020858137035692008-06-06T23:15:00.000-07:002008-06-06T23:42:22.268-07:00

The Oracle shared pool provides critical services for sharing of complex objects among large numbers of users. Prior to 10g R1, DBAs often spent much time learning about the shared pool memory management to configure and tune shared pool usage; with the tight time constraints and ever-changing workloads, many found this task daunting. The Automatic Shared Memory Management (ASMM) features

phenixnoreply@blogger.comtag:blogger.com,1999:blog-7322534696749683232.post-13081057361196007882008-06-05T23:20:00.000-07:002008-06-05T23:23:38.966-07:00

Tuning is the art and science of modifying and reconfiguring your system in order to achieve better performance. Tuning and sizing are closely related, in that tuning hardware might require the addition of more hardware. Tuning is done on a live system that is in use or in test, whereas sizing is a theoretical exercise that is done without actually modifying the system. This paper covers some of

phenixnoreply@blogger.comtag:blogger.com,1999:blog-7322534696749683232.post-31200093252758325032008-06-05T21:08:00.000-07:002008-06-05T21:18:17.020-07:00

DBAs are constantly challenged to increase database performance while keeping costs down. This short paper discusses Resource Mapping Methodology (RMM) which defines a systematic process for performing Wait-Event analysis to optimize database performance. It includes a brief overview of Ignite for Oracle and the business benefits that Ignite users have demonstrated. More information : http://

phenixnoreply@blogger.comtag:blogger.com,1999:blog-7322534696749683232.post-74538651251301485232008-06-05T19:35:00.000-07:002008-06-05T21:07:31.912-07:00

Given the intimate relationship between the Oracle Database and the storage it resides on it is important to ensure the interface between the two is efficient and robust. This is why Oracle and the storage vendors have invested so much in the interface and interrelationship of database and storage. There is a stack of storage management software, programs, and practices available for the Oracle

phenixnoreply@blogger.comtag:blogger.com,1999:blog-7322534696749683232.post-22956910154925819052008-06-05T19:17:00.000-07:002008-06-05T19:22:02.724-07:00

Achieving optimal performance from the Oracle database is an art, not a science. Using the appropriate data structures, ensuring that there are adequate resources available, and leveraging the features of the Oracle database can help to avoid bottlenecks that reduce the performance of the system. This paper provides an overview of some of the tools within an Oracle database that will help one

phenixnoreply@blogger.comtag:blogger.com,1999:blog-7322534696749683232.post-76915328688985254452008-06-05T19:10:00.000-07:002008-06-05T19:12:48.929-07:00

As DBAs become more sophisticated in their self-tuning endeavors, many Oracle metrics may become self-tuning. In Oracle Database 10g, more self-tuning capability will be seen than ever before. For example, the dynamic memory allocation features of Oracle Database 10g make it possible to create a self-tuning Oracle SGA. By means of demonstration, in this paper the author will explain how to

phenixnoreply@blogger.comtag:blogger.com,1999:blog-7322534696749683232.post-16510194530919136842008-06-05T12:00:00.000-07:002008-06-05T23:28:18.606-07:00

Improvements in the Oracle Database 10g Optimizer make it even more valuable for tuning. In Oracle Database 10g, the cost-based optimizer (CBO) has two modes—the normal mode and a tuning mode that is invoked by the SQL Tuning Advisor (and many other Oracle Database 10g advisors, such as the SQL Access Advisor). The SQL Tuning Advisor is a great new tool for DBAs in Oracle Database 10g.

phenixnoreply@blogger.comtag:blogger.com,1999:blog-7322534696749683232.post-23309063924690840422008-05-28T22:16:00.000-07:002008-05-28T22:17:47.835-07:00

When loading large-volumes of data, you have several choices: 1 - Tune INSERTS - Parallelized programs doing concurrent INSERT statements 2 - Tune SQL*Loader - Using sqlldr Direct Load, and adjusting parameters improves INSERT performance. 3 - Tune imports - Use Oracle Data Pump (Formally Oracle import utility) - Here are tips for hypercharging Oracle import. Optimizing Oracle INSERT

phenixnoreply@blogger.comtag:blogger.com,1999:blog-7322534696749683232.post-37457265432251143982008-05-28T13:11:00.000-07:002008-05-28T13:12:40.400-07:00

Oracle BI Suite EE Plus represents significant opportunities and challenges for Oracle E-Business Suite (EBS) customers. Using automated conversion tools and services, there is now a cost-effective method of migrating that minimizes downtime and maximizes the benefits your organization receives from Oracle's next generation BI platform. Attend this Webcast to learn about successful strategies

phenixnoreply@blogger.comtag:blogger.com,1999:blog-7322534696749683232.post-27988787042450555562008-05-28T12:25:00.000-07:002008-05-28T12:27:09.667-07:00

Utility computing is all about enabling system resources, including the grid, server farm, and clustering, to be acquired for different types of applications. Many enterprises are adopting grid and utility computing technologies because of their benefits. This document discusses the growth of enterprise computing. Oracle Enterprise Manager provides these benefits: * Centralized control for

phenixnoreply@blogger.comtag:blogger.com,1999:blog-7322534696749683232.post-55242972928870688002008-05-28T12:22:00.000-07:002008-05-28T12:24:26.758-07:00

If Master data management (MDM) is defined as the processes and tools which centrally and persistently define non-transactional entities of an organization, then its execution requires consideration of many moving parts. There is the data itself, data governance, business rules, data storage and implementation. This white paper provides independent insight and guidance as to which approach might

phenixnoreply@blogger.comtag:blogger.com,1999:blog-7322534696749683232.post-63372349788056544292008-05-28T12:15:00.000-07:002008-05-28T12:19:24.153-07:00

Organizations are finding limitations in orchestrating processes across ERP, SCM and CRM applications. Business and IT leaders deploy middleware with a sharp eye on the health and performance of key business applications. Learn how you can narrow your short list significantly with a more strategic approach to IT portfolio management and application synergies. By considering the potential

phenixnoreply@blogger.comtag:blogger.com,1999:blog-7322534696749683232.post-59412947509177094402008-05-25T12:34:00.000-07:002008-05-28T12:38:52.083-07:00

Oracle 8i and 9i database customers are facing more urgency to upgrade to Oracle 10g or higher, particularly where more business-critical applications are supported. In many cases, cross-platform migrations may also need to occur along with the database upgrade. Despite this necessary IT project, users expect uninterrupted availability and/or SLAs (service level agreements) dictate uptime

phenixnoreply@blogger.comtag:blogger.com,1999:blog-7322534696749683232.post-7780000481718529242008-05-22T20:15:00.001-07:002008-05-22T20:15:53.855-07:00

CREATING THE DATABASE MANUALLY This method involves typing the create database statement within SQL*DBA. Using this method allows for more flexibility such as specifying the MAXDATAFILES parameter or specifying multiple SYSTEM tablespace database files. However by doing this manually there is also a greater possibility of syntax errors. In addition there is no logfile automatically created to

phenixnoreply@blogger.comtag:blogger.com,1999:blog-7322534696749683232.post-5622937530746403852008-05-21T12:42:00.000-07:002008-05-28T12:45:26.656-07:00

Oracle's launch of its Database 11g marks a major step forward in the relationship between Oracle databases and storage infrastructure. With 11g, Oracle has built Direct NFS (network file services) Client into Oracle, offering users the advantages of NAS for greater simplicity in deploying storage, easier storage management, lower cost, and superior scalability. Attend this mediacast/podcast

phenixnoreply@blogger.comtag:blogger.com,1999:blog-7322534696749683232.post-81747089043228229502008-05-17T10:24:00.000-07:002008-05-17T11:18:31.757-07:00

There are two SQL command syntaxes that can be used to change Oracle user password: first thing first log in to oracle database sqlplus "/ as sysdba" or sqlplus [user_name]@[service_name] 1. Use SQL command "alter user" to change your oracle user password (for every of oracle version). SQL>ALTER USER [user_name] IDENTIFIED BY [password]; 2. Use SQL command "PASSWORD" to change your oracle

phenixnoreply@blogger.comtag:blogger.com,1999:blog-7322534696749683232.post-61188002914904002342008-05-14T02:48:00.000-07:002008-05-14T02:53:48.465-07:00

EXP-00056: ORACLE error 12541 encountered ORA-12541: TNS:no listener EXP-00000: Export terminated unsuccessfully check your tnsname.ora or your server listener

phenixnoreply@blogger.comtag:blogger.com,1999:blog-7322534696749683232.post-31420420047037455792008-05-11T13:08:00.000-07:002008-05-28T13:10:29.026-07:00

Financial institutions are forced to collect more data and dig deeper into their databases in order to refine their analyses due to constant performance pressures and changing regulatory demands. A holistic, unified approach to data management, one that ensures a smooth flow of information throughout the organization, enables decision makers to see a complete picture of enterprise risk. This

phenixnoreply@blogger.comtag:blogger.com,1999:blog-7322534696749683232.post-343375475200086252008-05-11T12:51:00.000-07:002008-05-28T12:56:48.204-07:00

Oracle's launch of its Database 11g marks a major step forward in the relationship between Oracle databases and storage infrastructure. With 11g, Oracle has built Direct NFS (network file services) Client into Oracle, offering users the advantages of NAS for greater simplicity in deploying storage, easier storage management, lower cost, and superior scalability. Attend this podcast with Jeff Day

phenixnoreply@blogger.comtag:blogger.com,1999:blog-7322534696749683232.post-841013020091284542008-05-11T03:37:00.000-07:002008-05-11T05:43:38.422-07:00

The 32-bit operating systems such as Windows 2000 and Windows Server 2003 provide access to 4-gigabyte (GB) of virtual address space. The lower 2 GB of virtual memory is private per process and available for application use. The upper 2 GB is reserved for operating system use. All operating system editions, starting with Microsoft Windows XP Professional and later, including Windows Server 2003,

phenixnoreply@blogger.com