285 reputation
19
bio website
location London, United Kingdom
age 29
visits member for 2 years, 3 months
seen Apr 13 at 12:51

Officially, I'm a PM, running the UK's largest business database (according to the marketing bumpf). Yes, that does mean I work in business information; feel free to pity me. I'm actually a data(base)?((manag|develop)er|analyst) and an occasional DBA and Python programmer. I'm also a whizz at 4DOS, which I don't get enough opportunity to play around with.

I can normally be found hanging out in Oracle, SQL, and PL/SQL or on meta and avoiding Python as there are a lot amazing answerers there.


2d
comment How slow is slow in postgres?
Please don't cross-post... this question is on it's way over there shortly, but now there's no point. If you're doing this then you're not going to be able to put it all on RAM and you're only going to use one core so the biggest potential problem is going to be disk I/O. You need good disks...
Feb
20
comment Database throughful design vs Quick and dirty design comparison
I deal with hundreds of millions of addresses... all I can say is definitely this. More importantly you're highly unlikely to ever get address data of the "quality" implied by the OP - it's all likely to be more like you describe.
Feb
19
comment Oracle idle connections lost
If it only happens remotely it's unlikely to be Oracle's fault. You need to talk to your sysadmins; it can be the server dropping idle connections or maybe some special firewall/proxy settings.
Nov
11
comment Oracle upgrade, v$version what is it actually doing?
Oracle 8i is a little old... (extended support ended almost 8 years ago). Rather than trying to solve whatever problems you have why don't you export the data (as you say you can do) and import it into an 11.2 database?
Oct
1
comment MySQL innodb database creation…why do this?
I don't know how you can expect anyone to tell you whether they were set up by mistake? Did you ask at your company for the reason why?
Sep
18
comment Connecting to Oracle Database with ODBC/Python
The best way to connect to Oracle from within Oracle is cx_Oracle. However, you might want to consider using Jython instead which you could call easily from within Oracle...
Jun
16
answered Call pl/sql function and discard result
Jun
10
comment How can I arrange / control the order of objects beeing exported from SQL Developer to a sql-file?
Can you export into a dmp file instead? It'll do it in the necessary order for you...
Jun
8
awarded  Citizen Patrol
May
20
awarded  Caucus
May
15
comment Should I use two databases or two schemas?
Are you comfortable with testing on the same database as production?
Jan
11
awarded  Yearling
Oct
26
comment How can I identify and fix bottlenecks in an Oracle11gR2 import
As a little aside why are you assuming that you're having I/O problems. I recently upgraded a box; quadrupled the RAM and the number of cores and moved from SCSIs to SSDs. The box is CPU bound, which is definitely not what we were expecting as all work done on it is I/O.
Oct
26
comment How can I identify and fix bottlenecks in an Oracle11gR2 import
This is an absolutely massive question. The answer could, quite literally, be anything. If could be related to the disks, yes, or any one of your Oracle parameters, or the OS, or the new machine. It's unlikely that anyone will be able to give you good advice, even if you posted everything possible (you haven't posted anything relevant). There's a reason why DBAs and sysadmins get paid good money. Chances are you need to get both to look at your problem.
Sep
22
awarded  Critic
Aug
29
comment Oracle 11g .DMP viewer
What line did you run in order to generate the errors?
Aug
4
comment Power went out - Did query finish?
@Spudley, a UPS might - don't ask :-) - have stopped the problem happening in the first place but it won't help with finding out what happened after.
Aug
4
comment Power went out - Did query finish?
The logs... if you log things. If you don't I'd recommend starting.
Aug
2
comment Oracle 10.2g Character Set Migration
@JohnF., you can flag your question for a moderator to move it for you.
Jul
15
comment Database tables design
@DamirSudarevic, no I didn't vote for migration but it doesn't make that much difference. I don't believe that if something is on-topic on a site it should be migrated, even if would be equally on topic on another site.