15,086 reputation
12553
bio website google.com
location Manchester, United Kingdom
age 37
visits member for 3 years, 2 months
seen 1 min ago

Oracle DBA, Unix admin.

Available for employment! ;)


Mar
19
comment Sql*Plus ERROR: ORA-12154: TNS:could not resolve the connect identifier specified
does tnsping AARCER1 work? Or sqlplus a549189/myPassword@AARCER1?
Mar
19
comment Server has antivirus. Do I need to enable external locking on MySQL?
Linux or Windows. You've tagged with both.
Mar
18
reviewed Close MongoDb Upgrade from 2.6 to 3.0 Issue
Mar
18
comment MongoDb Upgrade from 2.6 to 3.0 Issue
I'm voting to close this question as off-topic because it should be on serverfault
Mar
18
reviewed Close What is the ideal backend for global apps?
Mar
18
comment Count data using multiple date ranges
+1 for providing a fiddle to work with. Wish others would
Mar
18
reviewed Approve Merge-Replication: New column doesn't get replicated down by update command
Mar
18
reviewed No Action Needed SQL database normalisation within C#
Mar
18
comment Failed to connect to oracle SQL Plus
Copy your attempt to connect along with the sqlplus error messages when it fails, and edit your question with the output. Impossible to answer your question without more information
Mar
18
reviewed Leave Open Consolidating 2,000+ databases into a single database with up to 20,000 concurrent users
Mar
18
comment What is the best query to get the latest row version based on time?
I love the windowing function/cte combination. So much power, so easy to read
Mar
18
revised How to find pairs of attributes who did the same thing in a same entity?
added 16 characters in body
Mar
18
reviewed Edit Configuring slave from EC2 master to Amazon RDS slave
Mar
18
revised Configuring slave from EC2 master to Amazon RDS slave
formatting
Mar
18
comment Can an active session in oracle be dead?
What does v$session_longops say? you can use sofar/totalwork to see what percentage done it is. If that draws a blank, trace the session and see if anything appears in the trace file
Mar
18
revised What's the difference between Object.bsonsize and avgObjSize returned by db.collection.stats?
added 5 characters in body
Mar
18
comment How to find pairs of attributes who did the same thing in a same entity?
Edit your post with your attempts at writing SQL
Mar
18
answered Oracle grant select on a table
Mar
18
comment Oracle grant select on a table
Oracle uses grants that revolve around users and roles, not where they are logging in from
Mar
18
comment What is the best query to get the latest row version based on time?
Which RDBMS are you using?