November 2009 Blog Posts (4)

Which is best ORACLE SCM or CRM

Hi,

I want to know about oracle SCM, soon i am going to learn this course. could you guys help me in this regard. which is best CRM or SCM. Eagerly waiting for your guidance.

Added by farooq on November 24, 2009 at 8:45am — 2 Comments

New Series of Articles on SQL Access Path Tuning

Just a quick note from your friendly ex-Oracle instructor...



I'll be publishing a 10 or 12 article series on SQL access path tuning. The first article discusses how we need to become "database performance scientists" and provides some hints and tips on the selection or creation of our test lab environment. The second article (coming next week) will show how easy it is to… Continue

Added by Chris Foot on November 18, 2009 at 11:48am — 3 Comments

Archiving In RAC Database.....?

Hi Friends,
How to enable archiving in a RAC Database in oracle 10g..?
i am working on 2 node clusters.
I am having some confusion...please help me in this issue.?
Waiting for your great Reply..

Thanks
Bhupendra

Added by Bhupendra Singh Koranga on November 15, 2009 at 9:00pm — 2 Comments

How to investigate with "ROW CACHE LOCK"

Database had the problem and found "ROW CACHE LOCK"

Top 5 Timed Events Avg %Total

~~~~~~~~~~~~~~~~~~ wait Call

Event Waits Time (s) (ms) Time Wait Class

------------------------- ------------ ----------- ------ ------ ----------

row cache lock 509,761 1,259,315 2470 71.8 Concurrenc



I found out event in v$session before check in v$rowcache... and resolved

Example:…

Continue

Added by Surachart Opun on November 8, 2009 at 4:42am — No Comments

Blog Topics by Tags

Monthly Archives

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

Hello Oracle Community

Hello everyone in Oracle Community

We are from the Abo Akademi University, Finland.

Currently we are doing a scientific research study in the corporation between Abo Akademi University and Delft University of Technology (Netherlands) about online brand community and the engagement from members.



Oracle is one of the strong communities that we propose to do the research. We hope that you could save 10 minutes helping us doing the survey. If you agree, please follow this link…

Continue

Posted by Giang Nguyen on December 26, 2014 at 8:02am

Oracle AQ: working with PL/SQL asynchronous notifications

I'd like to share a basic example of how to consume Oracle AQ messages using PL/SQL: https://fcosfc.wordpress.com/2014/12/17/oracle-aq-working-with-plsql-asynchronous-notifications/

Posted by Paco Saucedo on December 17, 2014 at 12:45pm

flashback recovery in RAC enviorment using Data Guard Broker

I am trying to flashback recover using DGMGRL from the current primary node.

I am running the following command:

    dgmgrl> reinstate database pri

but I am getting the  error "ORA: 16653" every time when all the instances of failed primary database are up/running but if only one instance is up then it doesn't give any error.

So I want to ask that:

Is flashback recover is supported through DGMGRL or it is supported only in case of one…

Continue

Posted by Vishvendra Singh Rana on November 25, 2014 at 7:30am

Join and Union examples of related tables to show different SQL and esProc syntax

Join multiple tables with “join”

The SQL…

Continue

Posted by Jim King on October 15, 2014 at 12:02am

© 2015   Created by Steve Karam.

Badges  |  Report an Issue  |  Terms of Service