meta user
network profile
| bio | website | |
|---|---|---|
| location | London, United Kingdom | |
| age | 28 | |
| visits | member for | 1 year, 4 months |
| seen | 9 hours ago | |
| stats | profile views | 32 |
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.
|
21h |
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. |
|
Jul 14 |
answered | Database tables design |
|
Jul 14 |
comment |
Database tables design @FahimParkar, it's been asked before |
|
Jun 26 |
comment |
Why does connecting to a database use tempspace? I mentioned the locks, just to clarify that the trigger wasn't doing much... You say seem... how does this explain why the local session worked and the non-local didn't? |
|
Jun 25 |
comment |
Why does connecting to a database use tempspace? There aren't really any appropriate tags and I can't create them. <authentication> doesn't really fit. |
|
Jun 25 |
asked | Why does connecting to a database use tempspace? |
|
Jun 20 |
comment |
Optimization of an Oracle query Have you tested it? Which was quicker? Can you post the output of the explain plan on the view. It sounds like you're missing some indexes. Generally Never use PL/SQL when you can use SQL. This sounds like the wrong way to go. |
|
Apr 29 |
comment |
MySql - How can I improve this query? Thanks @ypercube, didn't know! |
|
Apr 29 |
comment |
MySql - How can I improve this query? remove the ORDER BY id DESC... the group by will destroy the ordering anyway. |
|
Mar 8 |
accepted | Does an IOT guarantee order in a select? |
