meta user
network profile
| bio | website | google.com |
|---|---|---|
| location | Peak District National Park, United Kingdom | |
| age | 35 | |
| visits | member for | 1 year, 4 months |
| seen | 1 hour ago | |
| stats | profile views | 575 |
Oracle DBA, Unix admin.
Available for employment.
|
May 13 |
reviewed | Approve suggested edit on Dealing with empty strings while loading a table from a CSV |
|
May 12 |
comment |
Why is MySQL order by performance poor within a single partition of a partitioned table? Unless you post query plans for all of the scenarios, we can't really help you. Edit your question |
|
May 12 |
revised |
Disk space full but logical space available in database Poor accepted answer. Cleaned up the typos |
|
May 12 |
comment |
Why is MySQL order by performance poor within a single partition of a partitioned table? A few seconds for that volume of data is also OK. Not sure what you're expecting. People whinge on here about dealing with 1000 rows - you're dealing with plenty more than that |
|
May 12 |
comment |
Why is MySQL order by performance poor within a single partition of a partitioned table? An ORDER BY involves a sort. of course it's slower. If the working set for the sort doesn't fit in memory it'll have to go to disk, which makes it even slower. |
|
May 12 |
reviewed | Leave Open Queries getting stuck on very simple COUNT queries |
|
May 12 |
reviewed | Close Data dictionary best practices in SQL Server 2008 r2 |
|
May 12 |
awarded | Enlightened |
|
May 12 |
awarded | Nice Answer |
|
May 12 |
comment |
How to remove all hidden parameters from Oracle Database Upvote for you. Didn't know about the RESET clause! |
|
May 11 |
comment |
Mistake during Oracle 11g PITR Awesome - keep me updated! |
|
May 11 |
comment |
Mistake during Oracle 11g PITR I thought they looked too small to be full - any idea hiw big the data is? I only had a quick skim read - on the iPhone from the pub :) |
|
May 11 |
comment |
Mistake during Oracle 11g PITR Another thing, do a "LIST INCARNATION OF DATABASE yourdb" to see if there's been a resetlogs. |
|
May 11 |
comment |
Mistake during Oracle 11g PITR A quick glance suggests you're stuffed, as there's only incremental backups and no full backups. One suggestion - copy the datafiles to another directory, then (I quote the documentation) "Record a datafile copy as a level 0 incremental backup in the RMAN repository, which enables you to use it as part of an incremental backup strategy.". Catalog the copies, then try the restore again. Have you checked what SCN the current datafiles are at? |
|
May 10 |
comment |
How to “swap” out production tables in MySql Why not just do an insert followed by a delete in the same transaction? Or is the MySQL isolation level too crap to cope with something like that? |
|
May 10 |
comment |
Seeting up a PostgreSQL database on another hard drive than my system one on OS X? Yeah, same. Thought a symbolic link was nice and transparent & needed no config changes. |
|
May 10 |
answered | Seeting up a PostgreSQL database on another hard drive than my system one on OS X? |
|
May 10 |
answered | How to remove all hidden parameters from Oracle Database |
|
May 10 |
reviewed | Approve suggested edit on Select records that do not have associations outside a certain list |
|
May 10 |
comment |
Select records that do not have associations outside a certain list What RDBMS are you using? Have you tried writing a query? |
