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

Streamline Your Business Process with Real Estate Data Entry Services

People in the real estate business have to deal with huge volumes of data on a regular basis. It includes the data that is generated from legal documents, property valuation statements, latest commercial and non-commercial property information, etc. This database should be regularly updated and processed properly to help you in your business procedures. With access to relevant real-time data, your business organization can thrive in the commercial real estate market. In…

Continue

Posted by Alvaro Dee on March 27, 2017 at 2:48am

Augment the Speed and Efficiency of Website Development with Joomla

Over the past few years, Joomla has emerged out as one of the greatest platforms for designing, developing, and deploying websites and web applications worldwide. Joomla scales up extremely well, uses less memory and gives a brilliant performance. Hire skilled and experienced Joomla developers to use Joomla CMS for developing simple and complex corporate websites. You can even enhance the functioning of your existing website by using this open source platform.

By outsourcing Joomla…

Continue

Posted by Alvaro Dee on March 20, 2017 at 4:00am

Top 10 Interview Questions & Answers for Java Developers

An organization hiring a Java developer is looking for someone who can code the applications flawlessly. For the period after Java training, the following is a very important list of ten Java interview questions. Make sure you tap the benefits of this comprehensive list of questions shared by our Java counterparts to crack your next interview.

1. What is immutable…

Continue

Posted by Michael Warne on March 17, 2017 at 3:00am

Get the Best Website for Your Business in a Set Time Frame

If you sell products online, you must be knowing how time-consuming and mundane it is to upload products. There are chances of you looking for someone to handle your product data entry tasks. A company that has a wealth of experience and is known for providing its customers with data entry services for a variety of eCommerce solutions can deal efficiently with high volumes of work without any hassle.…

Continue

Posted by Alvaro Dee on March 17, 2017 at 2:47am

© 2017   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service