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

Oracle DBA, Unix admin.

Available for employment! ;)


Apr
15
reviewed Approve suggested edit on galera tag wiki excerpt
Apr
15
reviewed Approve suggested edit on MySQL Query for combobox
Apr
15
reviewed Approve suggested edit on neo4j tag wiki
Apr
15
reviewed Approve suggested edit on What is the difference between uniqe index/unique/unique key/unique constraint keywords?
Apr
13
revised Oracle edition-based redefinition
added 17 characters in body; edited tags
Apr
13
comment Oracle edition-based redefinition
Edit your question with the output of SELECT * FROM DBA_EDITIONS
Apr
12
answered Delete all types created by a user
Apr
12
comment SQL Server DTC: is it possible to automatically replicate data that is created on Oracle DB?
You can use Oracle Golden Gate to do this
Apr
10
comment MySQL - prevent OS cache for query
The cached data will be released if any processes actually need the RAM. "Cache" is actually classed as "free" memory. You don't need to worry about it.
Apr
10
comment what is better in terms of allocated space in Oracle Tables: NUMBER or BINARY_FLOAT?
Do the numbers have to be stored precisely? I ask because BINARY_FLOAT cannot store all numbers precisely - see docs.oracle.com/cd/B12037_01/server.101/b10759/…
Apr
9
revised are temporal relationships a good candidate for Oracle cubes?
Tagged
Apr
9
reviewed Edit suggested edit on What mongodb database layout would fit better
Apr
9
revised What mongodb database layout would fit better
little syntax editing
Apr
9
comment oracle timesten in-memory database connection
Have you read this and done as it says? docs.oracle.com/cd/E13085_01/doc/timesten.1121/e13068/…
Apr
7
awarded  Enlightened
Apr
7
awarded  Nice Answer
Apr
5
comment Large RAM use after import database - ubuntu server
Why would you want to free cache? Linux will automatically allocate the cache to processes when it's needed.
Apr
4
comment SQL INDEX - how it works?
BTrees: en.m.wikipedia.org/wiki/B-tree surprised there wasn't an algorithms course at your university that explained this
Apr
4
comment Importing dump file contents to another DB with different schema using Oracle Data Pump
It will create the schemas for you. You may need to run with remap_tablespace if the target databases physical structure is different. Are you saying you have created 10Gb+ of objects in the SYSTEM schema?
Apr
4
comment Importing dump file contents to another DB with different schema using Oracle Data Pump
The SYSTEM schema contains internal Oracle objects, and you shouldn't have created any objects in it yourself - it doesn't need importing. Does the database you're importing into already contain any data? Sounds like you just need to do the import as SYS without remap_schema