13,956 reputation
12150
bio website google.com
location Manchester, United Kingdom
age 37
visits member for 2 years, 10 months
seen Nov 23 at 12:19

Oracle DBA, Unix admin.

Available for employment! ;)


Oct
29
comment Oracle 10gR2 - fix for SSL version following Poodle attack
Think you're going to be out of luck on 10.2 - it's too old.
Oct
29
comment Expdp with metadata_only gives way too large dump. Why?
Hmm, how many tables/indexes are there, and how big are their initial extents? Have the tables got lots of partitions?
Oct
28
reviewed Close T-SQL Parsing XML escaped in format %3E (less than)
Oct
28
reviewed Close Can you use CDC on a subscriber for transactional replicaiton
Oct
28
reviewed Close Transform it into 3NF
Oct
28
comment Why is this SQL query illegal?
Did you even bother looking at the error message? Was it complaining about not being a group by expression? Edit your question with the error message. Help us to help you.
Oct
24
comment Why does this query take 32 sec to execute?
Edit your question with the create table DDL for each table in the query
Oct
23
comment Trying to connect to AWS RDS from an AWS EC2 instance
You need to add MySQL permissions for that user/box combination. There are a million other answers on this site & a google search away for this...
Oct
23
comment Transforming a relation to 3NF
Think logically. The major has to exist so that the student can take it.... So it has to be an entity.
Oct
20
reviewed No Action Needed MYSQL Out of memory, table crashing
Oct
20
reviewed No Action Needed Importing CSV file using SQL Server Import and Export Wizard (SQL Server Express)
Oct
20
comment Mysterious LOAD DATA LOCAL INFILE
Obviously there's something else going on - I'll summon @RolandoMYSQLDBA - he can tell you how to work out what else is going on at the time. It could be due to disk IO or CPU issues at the slow times though
Oct
19
comment Unit of COST in an Oracle execution plan
Go and read Cost Based Oracle Fundamentals by Jonathan Lewis. Amazing book
Oct
17
comment Configuring sqlnet.ora and tnsnames.ora on the client side
Those settings are meant for disabling OCI signal handlers, by the looks of things - nothing to do with logging. Don't really see how it'll help troubleshooting a problem with a java app. What's the actual problem you're trying to diagnose? (Ignore everything you've been told to do, tell us the original problem)
Oct
17
reviewed Looks OK postgres removing user from role membership
Oct
17
reviewed Close MySQL keeps inserting new rows automatically
Oct
17
reviewed Close triggers vs views
Oct
17
reviewed Close SQL Server, Mount Points and File Groups design
Oct
17
reviewed Close Can you put a SQL DB on a NAS?
Oct
17
comment ORA-27100: shared memory realm already exists oracle
Edit your question with the output of ipcs -a|grep oracle and ps auxww| grep pmon