December 2012 Blog Posts (10)

Oracle Database Asynchronous Commit - Changing transactions Control

One of the most common concepts in Oracle Database is a transaction that is not completed while it definitely is not recorded in the Online Redo Logs. Once a COMMIT is executed, we can really make sure that transaction was written at Online RedoLog Files and the date are safe to use in case of Disaster.

 

Since Oracle 10gR2 this behavior can be changed using AC. (Asynchronous Commit).
Using the feature "Asynchronous Commit" it is…
Continue

Added by Victor Armbrust on December 18, 2012 at 1:00pm — No Comments

Wait Events: "Log File Sync and Log File Parallel Write"

In OLTP environments, one of the biggest performance problems is the excessive wait events for recordings Online Redo Log Files. Every time that Oracle Database waits for recordings in these files can observe events "Log File Sync 'and' Log File Parallel Write".

 



What is the expected event 'log file sync'?

 

When a session of a user or application executes a COMMIT, the information stored in memory Redo (LOG_BUFFER) are discharged in the…
Continue

Added by Victor Armbrust on December 16, 2012 at 4:30am — 2 Comments

Export Table statistics from one user to another

Introduction:

This article describes how to export / import table statistics from one user to another.

The goal is to import table statistics of the user wissem to a user wiss. The table conserned is named W_WRKFC_EVT_FS. Both users are in the same database. In the case of the users are created in different databases, the same steps can be used by using export/import datapump instead of create the table statistics using CTAS (Create Table As…

Continue

Added by Wissem EL KHLIFI on December 13, 2012 at 6:51am — No Comments

Facing OLAP's Shortest Board, What's the Remedy From BI Industry?

10 years ago, OLAP ushered the brilliant age of business intelligence. In the global market, it keeps growing at double digits. Enterprisers hope this new technology will help them implement the flexible and free data analysis, providing the truly valuable business decision, and telling them which are their cash cows and stars types businesses. With 10 years passed by, up to now, the splendid prospect of…

Continue

Added by Jim King on December 11, 2012 at 6:30pm — No Comments

Oracle Clusterware - Concepts and Architecture

Overview of Oracle RAC 



A cluster consists of multiple interconnected computers or servers that aims at sharing / process user requests for applications to end users. Oracle RAC allows a Database is clustered.Oracle RAC uses Oracle Clusterware as the infrastructure for processing several instances as a single system. 



Under the operation of Oracle RAC: …



Continue

Added by Victor Armbrust on December 11, 2012 at 3:04pm — No Comments

Need help with OEM grid control installation.

Can anyone put some articles about how to install OEM 11g grid control on VMware? How to troubleshoot OEM? Once you install oracle 11g for windows OEM grid control is automatically installed i know how to start and stop services on windows but on job you have to troubleshoot it on Linux.I have installed EM12CR. it takes 5.1 gb, i am new in the field and confused do i have to have a seperate vmware for this thing or i can install it on same machine, where my current database is installed? i…

Continue

Added by Mahrukh Khan on December 10, 2012 at 1:00pm — No Comments

Configuring DBFS on Oracle Exadata Database Machine

What is Oracle Database File System (DBFS)?
 
The DBFS (Database File System) is a native feature of Oracle 11gR2 found on Oracle Exadata Database Machine. The Purpose of DBFS is to provide a point-mont (File System) which is managed by the Oracle Database. The DBFS is similar to NFS since it provides a shared file system. As a NFS, works as client /…
Continue

Added by Victor Armbrust on December 10, 2012 at 4:40am — No Comments

How to make a Clone of an ORACLE_HOME

 

This procedure has as main objective conduct a CLONE of a ORACLE HOME in an existing installation of Oracle Database (10g or 11g) on ​​Linux / Unix. The Clone consists of an exact copy of binaries and configuration files.
 
Some relevant characteristics:
 
- Optimization of time for installation of a new ORACLE HOME;
- No need to installation media;
- Does not require downtime of existing ORACLE HOME;
-…
Continue

Added by Victor Armbrust on December 9, 2012 at 3:19pm — No Comments

Get Rid of Mistaken Thoughts of OLAP in Your Mind

OLAP is a type of BI software that emerged and gradually developed 20 years ago. OLAP can be used to handle the complex computation flexibly and rapidly according to the requirements of analyzers and present the result to the decision-makers in an intuitive and understandable style. The decision-makers can thus grasp the enterprise operating status accurately, understand the object requirements, and set the right scheme.



The original intention of OLAP is the arbitrary…

Continue

Added by Jim King on December 5, 2012 at 11:30pm — No Comments

11g; Sql Plan Management

Introduction:

This article describes how to manage optimal SQL execution plans using SQL plan management. SQL plan management preserves efficient execution plans and evaluates every changed plan. Plan changes can be due to the system change (Database upgrade, changes in database parameters, changes in optimizer parameters, changes in optimizer statistics, system configuration, etc …).

SQL plan management (SPM) is a proactive way to guarantee stable performance…

Continue

Added by Wissem EL KHLIFI on December 3, 2012 at 11:46am — No Comments

Monthly Archives

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

Oracle Community On

I'm not a fan of advertising, and so I will not be including any advertisements on OracleCommunity.net. However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations.

Donate Bitcoins

Badge

Loading…

Blog Posts

Do What You Do Best and Outsource the Rest

One of the most valuable assets of an organization, data lies at the heart of business. It impacts everything from customer service to email deliverability and ultimately revenue generation. If the data that you have is not accurate, it will have a direct impact on your company’s ability to meet…

Continue

Posted by Alvaro Dee on February 7, 2017 at 2:07am

Draw Actionable Insights and Make Better Decisions with Data Mining Services

Data Mining is the process of analyzing and extracting crucial information from a database and presenting the same in an appropriate way to help business cut cost and boost revenue. In simple words it is the process of drawing crucial and actionable insights, which is imperative for better decision making.

Data mining is crucial for effective management of your business. It is also used for verifying whether or not the strategies are going as planned so as to provide desired results.…

Continue

Posted by Alvaro Dee on February 1, 2017 at 4:02am

Attain Data Accuracy, Competitive Pricing, and Quick Turnaround Time by Outsourcing Data Entry Services

In order to focus on crucial business activities, organizations worldwide prefer outsourcing data entry services to reliable service providers. Though redundant but highly crucial, data entry still remains an important component of document management and requires vigorous quality checks. Outsourcing data entry tasks to experts ensures affordable and quality output while saving time and resources that can be…

Continue

Posted by Alvaro Dee on January 31, 2017 at 4:49am

Present and Exchange Documents Reliably With Portable Document Format

Are you having data in large volumes that needs to be converted from hard copy to PDF format? Can you imagine how much time it would take you to manually convert this data? Well, if you know, then what’s the point of putting in lot of efforts and time?

With the help of PDF data entry services, this task can be made a lot easier. Data entry experts can help you save time and efforts…

Continue

Posted by Alvaro Dee on January 25, 2017 at 3:38am

© 2017   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service