179 reputation
11
bio website database-architect.com
location Calgary, Alberta
age 32
visits member for 2 years, 7 months
seen 2 days ago

Database architecture

We're offering database architecture and SQL performance optimization services. Technologies:

  • Oracle
  • MySQL

Feel free to request a quote if you are interested.


2d
comment DESCRIPTION_LIST in tnsnames.ora
Our configuration is for failing over a standby database using a different service name, so we cannot use the scan listener. But thanks for the idea though, it made me think of something else
2d
comment DESCRIPTION_LIST in tnsnames.ora
ok, thanks, that's the answer.
2d
revised DESCRIPTION_LIST in tnsnames.ora
edited tags
Jan
23
asked DESCRIPTION_LIST in tnsnames.ora
Nov
28
revised issue granting privileges in a hierarchical user configuration
edited tags
Nov
28
asked issue granting privileges in a hierarchical user configuration
Aug
6
awarded  Tumbleweed
Jul
30
revised Can I reuse the same agent for 2 different Oracle Enterprise Manager servers?
added 85 characters in body
Jul
30
asked Can I reuse the same agent for 2 different Oracle Enterprise Manager servers?
Jul
24
asked How to verify that a certain commit has been transmitted to standby
Jul
18
comment RAC, data guard, physical stand by and impdp
Do you think the slowdown would be that consequent even though standby and primary are on 2 different servers?
Jul
12
comment A single, simple update takes 10+ seconds
nb2: your edit4 makes me think that it must be a lock problem
Jul
12
comment A single, simple update takes 10+ seconds
nb: you should not use commas around integers when they are handled as so in the database.
Jul
12
comment Datatype for different categories in a database
Why would you put all this in 3 different tables to begin with? Are they totally different concept, from the way your business uses it perspective? Something sounds weird by reading them. Maybe you should have only one table, I'm not sure
Jul
11
awarded  Editor
Jul
9
comment Disable procedures for data load in MySql using Innodb engine
You mean triggers? You can disable them, you don't have to drop them
Jul
9
accepted RAC, data guard, physical stand by and impdp
Jul
9
comment RAC, data guard, physical stand by and impdp
Thank you, I really needed a confirmation that dropping users and impdp would reflect to the standby database.
Jul
9
comment Building a Trending query
If you don't care about days with 0 inspections, just use a regular sum/group by query. Otherwise you'll need interval and windowed functions
Jul
9
comment Question on MySQL insert race condition
you're right! forums.mysql.com/read.php?21,37304,37308#msg-37308