13,831 reputation
12150
bio website google.com
location Manchester, United Kingdom
age 36
visits member for 2 years, 9 months
seen 7 hours ago

Oracle DBA, Unix admin.

Available for employment! ;)


2d
reviewed Close CLOB data type is not working as expected
2d
reviewed No Action Needed MYSQL Out of memory, table crashing
2d
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 Oracle SGA memory areas
It's just the way it's displayed, nothing more. Probably been like that for 30 years.
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 Leave Closed How to handle big table?
Oct
17
reviewed Leave Closed Why can't modern databases have unlimited columns
Oct
17
reviewed Close MySQL keeps inserting new rows automatically
Oct
17
reviewed Close triggers vs views
Oct
17
reviewed Close Query to convert existing rows to columns
Oct
17
reviewed Close 285GB sonar db and growing, on mysql 5.5
Oct
17
reviewed Close How to implement Master Slave Replication using mysql
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
reviewed Close Sybase ASE 12.5 on VMWare extremely slow cursors
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