Oracle VM Site Review - Oracle VM Health Check
view counter

Database Feed

Oracle Database, Oracle 10g, Oracle 11g, Oracle XE, Oracle RAC, Oracle Instant Client, Oracle Data Guard and Oracle Exadata resources, news, and support articles.

10.2 CRS startup issue

Today I faced a strange issue with CRS  post host reboot. CRS was not coming up and we could see following message in $ORA_CRS_HOME/log//client/clsc*.log cat clsc26.log Oracle Database 10g CRS Release 10.2.0.4.0 Production Copyright 1996, 2008 Oracle. All rights reserved. 2011-07-01 21:00:14.345: [ COMMCRS][2541577376]clsc_connect: (0x6945e0) no listener at (ADDRESS=(PROTOCOL=IPC)(KEY=CRSD_UI_SOCKET)) 2011-07-01 21:00:14.345: [ COMMCRS][2541577376]clsc_connect: (0x695020) no [...]

Partitioned Bitmaps

The following question appeared in a comment to an earlier posting on multi-column bitmap indexes and the inability of Oracle to create a bitmap index join when (to the human eye) the strategy was an obvious choice.

    I have a query which is using 2 indexes both are bitmap indexes (sizes are 37 and 24 Mbs) and table size is 17gb. While i ran the following query which can very well get the index itself, it takes around 6-8 minutes and using pga around 3 gb.

could you please explain me why ?

Add Bulk to your Parallel Updates

  Oracle Database server 11gR2 added several new Parallel Execution features. I had several questions on a recent Exadata administration course concerning parallelism, and an interesting discussion arose about these new features. Although parallel execution is useful in all Oracle Database Data Warehouse implementations, and often in batch systems, it is particularly relevant to Exadata. [...]

Finding Rows with Common Attributes – Roman to Find a Solution in Something New

July 1, 1011 A recent thread in the comp.databases.oracle.server Usenet group (actually two threads) asked an interesting question.  Assume that you had a detail table that contained several attributes for each of the unique key values.  How would one go about finding all of the unique key values that share the same set of attributes?  [...]

Learning Perl By Randal L. Schwartz, brian d foy, Tom Phoenix

What is Perl? Perl is a general-purpose programming language originally developed for text manipulation and now used for a wide range of tasks including system administration, web development, network programming, GUI development, and more.

HP BAC- End User Management(EUM)

HP Business Availability Center(HP BAC) is comprised of modular and integrated software components. These individual components provide best in class management capabilities and the ability to be implemented as a complete BSM solution. End User Management is one of the HPBAC application components.

End User Management is a centralized solution for monitoring applications and business services from the end-user perspective, using passive or active monitors that collect performance data for

HP Business Availability Center.

Features:

HP BAC- End User Management(EUM)

HP Business Availability Center(HP BAC) is comprised of modular and integrated software components. These individual components provide best in class management capabilities and the ability to be implemented as a complete BSM solution. End User Management is one of the HPBAC application components.
End User Management is a centralized solution for monitoring applications and business services [...]

Another cache buffers chains latch contention troubleshooting example using LatchProf

One of my blog readers recently dropped me an email noting that he had noticed some cache buffers chains latch contention recently and successfully troubleshooted it with LatchProf. I asked if he’d like to blog about it and here’s the article:

NoCOUG Needs Your Help

Dear NoCOUG Members and Friends, As NoCOUG gets closer to completing 25 years of service to the Oracle community in Northern California, I would like us to reflect on what made the first 25 years possible and what will make the next 25 years possible. Nine reasons for NoCOUG’s longevity can be found in the picture below. 2011 [...]

view counter