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! ;)


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
Oct
15
comment How to aggregate related rows
There's no 12:10:00 in your data. Where does it come from? Explain how trips are derived from points. Looks like 1,2,3,2,1 then 1,2,3,2,1 but, explain
Oct
15
comment Oracle 11 express vs Oracle 11 enterprise performance
Crappy comments so far. You need to compare the query plans on both instances
Oct
10
comment Oracle estimate cardinality on partitioned table
Your question makes no sense. Everything depends on how the table is partitioned and whether the indexes are local are global.
Oct
6
comment What is the use of Archivelogs?
Are you using rman to do your backups?
Oct
1
answered Can I perform a MAX over a pair of columns?
Oct
1
reviewed No Action Needed How do you capture the output message from a successful MERGE statement when using it in a procedure?
Oct
1
answered Problem with Oracle Rollback Segment Session