14,031 reputation
12150
bio website google.com
location Manchester, United Kingdom
age 37
visits member for 2 years, 11 months
seen 5 hours ago

Oracle DBA, Unix admin.

Available for employment! ;)


Nov
6
reviewed Close Time Series data for controllers connected to other devices
Nov
6
reviewed Close Composite Foreign key to single primary key
Nov
6
reviewed Close Which version is the right one to begin with Oracle
Nov
6
reviewed Reviewed Why postgres is using an odd index with no relation to the query
Nov
6
reviewed Reviewed What are the main causes of deadlocks and can they be prevented?
Nov
6
comment Best design to handle multiple query keys
This question appears to be off-topic because it is about performance tuning, given requirements that are restrictive for no good reason. As a result the question cannot be answered
Nov
6
comment Best design to handle multiple query keys
You can change the structure of a single table to anything, yet cannot use more than one table? What is your reasoning, other than that you prefer it? I'll add that many of us on here we're dealing with "big data" before the term was even invented. I suggest you close the question if you're not even willing to listen to reasoned arguments. Even considering using comma seperated values in a column and using LIKE is a terrible solution, for example, but you're willing to give it a go because it uses a single table. Makes zero sense.
Nov
6
comment Cannot remove char 0x00 from NVARCHAR column
This looks like it's going to be a fun question to follow :-)
Oct
30
reviewed Close How can i make dump of big mysql table?
Oct
30
reviewed Close is there some way to give me the order in which inserts should be made so all FK constraint are met?
Oct
30
comment ORACLE Query error contains lots of caret at symbols (i.e. ^@^@^@)
It's probably a CR/LF problem, or some crappy invisible characters in your source file. Take a look at the file in a hex editor. ^@ are normally messed up backspaces I think?
Oct
30
comment Update on table deletes the record
If what you say really is the case, check that it is truly a table and not an updateable view.
Oct
29
comment Simplest way to log in as Oracle user different from schema user and still see all tables,… of schema?
ALTER SESSION SET CURRENT_SCHEMA will work, but you still need to do all of the grants.
Oct
29
comment MySQL UDF - wrong ELF class: ELFCLASS32
That's the problem. Your .so needs to be compiled 64-bit
Oct
29
comment MySQL UDF - wrong ELF class: ELFCLASS32
Not on your shared object udf_median.so - run it against the actual mysql server daemon executable.
Oct
29
comment MySQL UDF - wrong ELF class: ELFCLASS32
Run the file command on the mysql binary to check whether its 32 or 64-bit.
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 Can you use CDC on a subscriber for transactional replicaiton
Oct
28
reviewed Close Transform it into 3NF