14,016 reputation
12150
bio website google.com
location Manchester, United Kingdom
age 37
visits member for 2 years, 11 months
seen Dec 18 at 9:43

Oracle DBA, Unix admin.

Available for employment! ;)


Apr
24
answered Schema Migration for application upgrades
Apr
24
comment Two MySQL Server accessing same database over NFS
I wouldn't even think about it, in all honesty
Apr
24
answered How to check for existence of an INDEX on a column independent of used SQL database
Apr
24
comment Why does this simple select statement require quotes?
Never use double quotes when creating objects! It will only lead to pain. Just an observation too... Be careful when dealing with SSNs - don't store them unless you absolutely have to
Apr
24
comment How to make a role from schema A “grantable” in schema B
Sounds like you might want to investigate the WITH GRANT OPTION and WITH ADMIN OPTION clauses of the GRANT command
Apr
23
comment TNS-12535: TNS:operation timeout
Being able to tnsping doesn't rule out a firewall problem. When you actually establish a real connection with a client the connection gets handed off and a random return TCP port is assigned. I've seen it cause firewall issues in the past
Apr
23
reviewed Reject sql-audit tag wiki
Apr
23
reviewed Approve While importing 150 GB file on Amazon RDS, why connection is failing?
Apr
23
comment Importing a different character set export dump into another DB instance
Are you sure the dump file was created with exp and not expdp? Try importing it with impdp
Apr
23
revised App domain is marked for unload due to memory pressure
edited tags; edited title
Apr
23
reviewed Approve Inserting empty string on Windows MySQL doesn't use default value
Apr
22
comment Error while accessing remote mongo db
Sounds like a firewall problem
Apr
21
comment Adding new tables — memory usage increases
What is the exact problem you're having? You've configured mysql to use a certain amount of memory and it's using it. Do you want to restrict the amount if data cached?
Apr
21
comment Installing scott schema for oracle 11g express
Downloading the schema from a third-party websiteis not the best way to go about doing things. The other answer is correct
Apr
21
reviewed Reject SSD vs HDD for databases
Apr
20
comment ORA-12516 but max_utilization not reaching limit
Is it possible that there is a firewall that's half dropping connections so the client application pool thinks there are less open connections, but Oracle still sees the connections as open and doesn't terminate the associated background processes? If you're using Unix you should be able to track this down with netstat.
Apr
18
comment Is there a psql equivalent of bash's reverse-search-history?
Use rlwrap...
Apr
17
reviewed Edit A rollback on a production server that's been running too long
Apr
17
revised A rollback on a production server that's been running too long
corrected tag. added some breaks
Apr
16
reviewed Edit Latitude and Longtitude Distance Calculation