12,906 reputation
11741
bio website google.com
location Manchester, United Kingdom
age 36
visits member for 2 years, 3 months
seen 13 mins ago

Oracle DBA, Unix admin.

Available for employment! ;)


11m
comment restoring huge MySQL database would location of sql file on a mount significantly slow restore (linux)
You haven't stated how fast the disks are, how big the SQL file is that you're trying to import, or the percentage completed after "all night" hours. As it stands, it's impossible to answer this question.
42m
comment Oracle 12c installation error on windows 8.1 x64
I don't think Oracle 12c is yet certified to run on windows 8.1. Anyway, a google gives stackoverflow.com/questions/21546892/…
51m
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
10h
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
13h
reviewed Reject suggested edit on sql-audit tag wiki
13h
reviewed Approve suggested edit on While importing 150 GB file on Amazon RDS, why connection is failing?
20h
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
23h
revised App domain is marked for unload due to memory pressure
edited tags; edited title
23h
reviewed Approve suggested edit on Inserting empty string on Windows MySQL doesn't use default value
1d
comment Error while accessing remote mongo db
Sounds like a firewall problem
2d
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?
2d
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
2d
reviewed Reject suggested edit on 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 suggested edit on 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 suggested edit on Latitude and Longtitude Distance Calculation
Apr
16
revised Latitude and Longtitude Distance Calculation
more cleanup (typos, formatting)
Apr
16
comment Azure database copy seems stuck in a loop
Is this related to dba.stackexchange.com/questions/63363/… ? If so, you're better off editing that question with more information & deleting this question