14,142 reputation
12350
bio website google.com
location Manchester, United Kingdom
age 37
visits member for 3 years
seen 6 hours ago

Oracle DBA, Unix admin.

Available for employment! ;)


Jan
31
comment Reorganize Objects in OEM - Host Credentials do not have enough privileges
It says invalid username or password?
Jan
31
revised InnoDB crashes frequently
deleted 143 characters in body
Jan
31
reviewed Reject SQL Server - Copy data from one database to another - identical tables, new identity values needed
Jan
31
comment ERP (Oracle) real time backup
What are the REAL requirements? How much data can you deal with losing? How much downtime can you suffer when you need to failover/restore? You have to think about the ways that the original database is likely to fail. With decent storage, it's going to be a host failure that most impacts you, not a disk failure. Active Data Guard is EXPENSIVE. Are you really running Enterprise Edition for 600Mb of data?!
Jan
31
comment Calulating savings between two schemes
Seems like a we thought out thing to do. What sort of answer are you expecting? "Yes"? :P Implement it. Not as if you're dealing with a pen drive worth of data
Jan
30
comment Datalink error when executing remote query
Did you read and try the suggestion in the blog post? There's nothing else you can do if you don't know the password. I quote from the blog post Use of IDENTIFIED BY VALUES is reserved for internal Oracle use only. .
Jan
30
comment Why are there more MySQL deadlocks on my 8-core machine than 16-core?
Sounds more like an application design issue than anything else....
Jan
30
comment Issue with MySql upgrade from 5.1 to 5.6 for Jboss SOA - p v 4.3
google.co.uk/…
Jan
30
revised Issue with MySql upgrade from 5.1 to 5.6 for Jboss SOA - p v 4.3
added 9 characters in body
Jan
30
answered Field Level Auditing in Oracle 11g R2
Jan
30
revised Field Level Auditing in Oracle 11g R2
edited tags
Jan
30
revised Datalink error when executing remote query
edited tags
Jan
30
revised Connection problem after a big impdp
edited tags
Jan
30
revised Database is slow once in a while
edited tags
Jan
30
answered SHA-256 hashing in oracle 11g
Jan
30
revised SHA-256 hashing in oracle 11g
edited tags
Jan
30
comment Datalink error when executing remote query
msutic.blogspot.co.uk/2012/09/…
Jan
29
comment Database is slow once in a while
Can he not help you with this?!
Jan
29
comment Database is slow once in a while
How big are your redo logs & how often are you switching? That could account for stalls if your web service is generating a large amount of data (waiting for the archiver basically).
Jan
29
answered Connection problem after a big impdp