13,746 reputation
12149
bio website google.com
location Manchester, United Kingdom
age 36
visits member for 2 years, 8 months
seen Sep 2 at 8:47

Oracle DBA, Unix admin.

Available for employment! ;)


Nov
25
answered How do I get the difference in minutes from 2 timestamp columns?
Nov
24
comment Oracle 12c on Ubuntu 12.04
You need to be logged in as Oracle, not root
Nov
23
comment Why are timestamps not always increasing with concurrent inserts?
"The rowversion data type is just an incrementing number and does not preserve a date or a time. To record a date or time, use a datetime2 data type." -- or maybe I'm missing something? Quoted from the link at the top of your answer.
Nov
22
answered Listener Log Oracle 11g R2
Nov
21
revised Optimizing query on a partitioned table
tagged, formatted
Nov
21
comment Oracle Logical IO / Consistent Reads inconsistent?
Are you aware that autotrace lies? kerryosborne.oracle-guy.com/2010/02/autotrace-lies . DBMS_XPLAN is your friend.
Nov
20
answered How can I find who has allocated a user lock via dbms_lock?
Nov
19
comment Different execution plan for the same query if I change a value in the predicate
Might be histograms...
Nov
19
comment Install 10g XE on 64bit linux
What type of database backup do you have? rman/exp/expdp/a SQL file?
Nov
18
comment Oracle - how to reference to a field%TYPE using database links?
Now, I thought that he wanted to use %TYPE against a user-defined type that didn't exist on the local database. Must have read into the question too much.
Nov
18
comment How to get columns from system tables or views like sys.database_files (SQL Server 2012)
sysobjects and syscolumns are your friends.
Nov
17
comment Oracle 10 column name resolution
You're 100% correct - it's a bug. I've read many blog posts and I think there was also a long discussion on oracle-l about it. This blog post hoopercharles.wordpress.com/2010/12/26/… has links to lots of Metalink bugs regarding ANSI joins.
Nov
15
awarded  Custodian
Nov
15
reviewed Reject suggested edit on What is the “proper” way to design a database architecture when entry counts belogning to different users may vary wildly?
Nov
14
comment SQL queries are very slow
Having said that, may just need an index to make the update faster if it's having to tablescan due to a lack of index & only a couple of rows are being updated. You'll need to edit your answer with EXPLAINs to get further help
Nov
14
comment SQL queries are very slow
Did you miss the 400 million rows (84Gb of data) part, or do you think it should be able to do that in a millisecond?
Nov
14
answered Oracle 11g increasing shared pool size and java pool size
Nov
14
answered Is it possible to list all user that accessed to specific table
Nov
14
answered MySQL: Error while reverse engineering database from a sql file
Nov
14
revised MySQL: Error while reverse engineering database from a sql file
added 180 characters in body