tag:blogger.com,1999:blog-73225346967496832322008-06-29T00:58:49.641-07:00phenixnoreply@blogger.comBlogger701251925443http://www.feedburner.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.comtag:blogger.com,1999:blog-7322534696749683232.post-21688463932113163102008-05-07T11:42:00.000-07:002008-05-07T11:44:32.050-07:00

Oracle In-Memory Database Cache now offers Oracle Database customers lightning-fast transaction response times by caching frequently used data in the application tier. Based on the Oracle TimesTen In-Memory Database, the new option delivers a real-time, dynamic, updatable cache for frequently accessed data in the Oracle Database. By caching performance-critical subsets of an Oracle Database in

phenixnoreply@blogger.comtag:blogger.com,1999:blog-7322534696749683232.post-33086534458197160682008-05-04T00:27:00.005-07:002008-05-04T01:52:16.004-07:00

ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Cause: SGA is not allocated and instance is not started due to use the wrong oracle_sid and or oracle_home. Action: use the following command on your sqlplus set ORACLE_SID = grms sqlplus /nolog sql>conn system/manager as sysdba sql>shutdown abort sql>startup

phenixnoreply@blogger.comtag:blogger.com,1999:blog-7322534696749683232.post-68260353871556883282008-05-04T00:27:00.004-07:002008-05-04T01:30:15.669-07:00

ORA-06512 ORA-09936 ORA-00600 ORA-00904 ORA-00942 ORA-01034 ORA-600 ORA-06550 ORA-12560 ORA-01422 ORA-27101 ORA-20000 ORA-01555 ORA-01722 ORA-12500 ORA-01000 ORA-12514 ORA-01110 ORA-01017 ORA-00001 ORA-01843 ORA-01033 ORA-00054 ORA-07445 ORA-12638 ORA-06508 ORA-01652 ORA-00020 ORA-01113 ORA-12203 ORA-00922 ORA-01658 ORA-00923 ORA-03114 ORA-24324 ORA-01002 ORA-01502 ORA-29283 ORA-01461 ORA-12571

phenixnoreply@blogger.comtag:blogger.com,1999:blog-7322534696749683232.post-45576029727720029842008-05-04T00:27:00.003-07:002008-05-04T01:26:58.837-07:00

ORA-01034: ORACLE not available Cause: oracle database/ instance not started Action: start oracle oracle database/instance To start oracle simply just logon using sqlplus on local server sqlplus "/ as sysdba" then start the database using the following command sqplus> startup

phenixnoreply@blogger.com