• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Liutauras Vilda
  • Campbell Ritchie
  • Tim Cooke
  • Bear Bibeault
  • Devaka Cooray
Sheriffs:
  • Jeanne Boyarsky
  • Knute Snortum
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Ganesh Patekar
  • Stephan van Hulst
  • Pete Letkeman
  • Carey Brown
Bartenders:
  • Tim Holloway
  • Ron McLeod
  • Vijitha Kumara

Oracle DCN Notification performance issue  RSS feed

 
Ranch Hand
Posts: 39
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
We have implemented solution using oracle Data Change Notification(DCN) and it works well.But some times we are having heavy load i.e about 50-100k records insert,which is causing too much current notification and CPU starvation.This in turn causing other java process to hung.

Is there any way to control or limit the number of concurrent DCN notification or is there any other solution solution..

Appreciate your response on this.

Thanks
A.ArockiaRaj
 
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
When I was using Oracle DCN (in the Oracle 11 database), the documentation specifically mentioned that the functionality is meant for tables which are mostly read-only, ie. only rarely modified. It probably wasn't designed for the heavy updates you're experiencing in your DB. We had much lower volume of updates and still decided to ditch DCN, as it wasn't practical for us.

Are the inserts made by a single, or a few large transactions, or are there lots and lots of small transactions inserting a few rows each? The latter would quite certainly be more problematic, as it would trigger lots and lots of notifications. I'm afraid you might have to choose a different solution to the entire problem.
 
Arockia Raj
Ranch Hand
Posts: 39
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Martin,Ours is having 50 to 100k small transactions.,commit for every transactions...I think we have to go for different solution..
 
Sheriff
Posts: 11338
177
AngularJS Chrome Eclipse IDE Hibernate Java jQuery MySQL Database Spring Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Arockia Raj wrote:Is there any way to control or limit the number of concurrent DCN notification or is there any other solution solution..


As mentioned by Martin, according to the documentation it is mentioned as one of the best practices to use it only when your tables are mostly read-only (and modifications are the exception rather than the rule).

Best Practices wrote:For best performance of change notification, the following guidelines are presented. Registered objects are few and mostly read-only and that modifications to those objects are the exception rather than the rule. If the object is extremely volatile, then it will cause a large number of invalidation notifications to be sent, and potentially a lot of storage in the invalidation queue on the server. If there are frequent and a large number of notifications, it can slow down OLTP throughput due to the overhead of generating the notifications.It is also a good idea to keep the number of duplicate registrations on any given object low (ideally one) in order to avoid the same notification message being replicated to multiple recipients.



Hope it helps!
Kind regards,
Roel
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!