3,330 reputation
21323
bio website datajini.com
location Frösön, Sweden
age 42
visits member for 2 years, 8 months
seen 15 hours ago

I'm an Oracle Database Specialist at DataJini, an Oracle consultancy that specialises in building solutions using MDD techniques.


Mar
27
comment Can I setup database triggers to run on a defined secondary set of servers only?
What are you logging? Inserts/updates/deletes on certain tables? How many users do you have? What volume of transactions? We do it for our back-office systems to keep track of changes on key tables; these triggers cause us very little extra overhead. And it's functionally exactly what we need.
Mar
27
comment Can I setup database triggers to run on a defined secondary set of servers only?
Triggers happen synchronously in the original user's transaction. What you are proposing would decouple that. The results wouldn't be seen immediately but a short time after. Is that what you want?
Mar
27
revised mysql - order by first condition in where clause
Corrected query and made it more generic.
Mar
27
answered mysql - order by first condition in where clause
Mar
27
reviewed No Action Needed mysql - order by first condition in where clause
Mar
27
reviewed Close Need a table schema for general store app
Mar
27
reviewed Close Quorum settings in failover clusters
Mar
27
reviewed Close can we create a user defined groups with different users and different schemas in oracle11 g
Mar
27
reviewed No Action Needed Mysql cursor alternative / Optimization - each row updates are too slow
Mar
27
reviewed Reviewed Subquery optimization
Mar
27
revised Subquery optimization
Removed chattiness.
Mar
27
reviewed No Action Needed delete query performance issue on mysql
Mar
27
reviewed Reviewed master-slave vs masterless architecture
Mar
27
reviewed Reviewed Migrating from 32 bit using pg_basebackup
Mar
27
revised Migrating from 32 bit using pg_basebackup
deleted 22 characters in body; edited tags
Mar
27
reviewed Close How to Insert geom line in geom geometry column?
Mar
27
reviewed Close Guidance in creating a database for parks division attendance data
Mar
27
reviewed Close Retrieve user Permissions on a database
Mar
27
reviewed Close What will be the Better database design for following table?
Mar
27
reviewed Close Can anyone convert this SQL into Rational Algebra Format