295 reputation
19
bio website
location London, United Kingdom
age 29
visits member for 2 years, 7 months
seen 2 days ago

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.


Apr
22
comment Numbering multiple dates per delivery
If you turn your query there into a sub-select then you don't need to worry about filtering...
Apr
19
comment DISTINCT not using an index
If there's a foreign key it does speed up the query @miracle, there's no need to query the original query; you can query a 5 row table instead. If this table exists you don't need to play around with different indexes, IOTs, ordered indexes, moving tablespaces onto different disks etc., you just query the 5 rows...
Apr
18
comment DISTINCT not using an index
It does @miracle173, by fixing the data-model you make the database work for you rather than having to change the structure of the database. It also means that if you massively increase the number of rows in the table you're not going to have another speed issue.
Apr
13
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
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.