13,584 reputation
12048
bio website google.com
location Manchester, United Kingdom
age 36
visits member for 2 years, 6 months
seen Jul 17 at 21:05

Oracle DBA, Unix admin.

Available for employment! ;)


Nov
5
comment INSERT INTO with SELECT subquery db2 9.5
Reading is always going to be faster than writing. What you are seeing is probably reasonable. How much data is involved?
Nov
1
comment Oracle 12c Installation in Windows 7 error INS-30131
Sounds like you're trying to install it without admin privileges.
Oct
31
comment How to get session parameters changed by the user in Oracle?
The only way of doing this is using session traces, as the relevant session information isn't exposed to other sessions. This is essentially the same as this question dba.stackexchange.com/questions/24456/…
Oct
31
answered Oracle Character set identification
Oct
31
answered Does Active Data Guard include Golden Gate?
Oct
30
comment MySQL showing non-linear behavior for a simple insert
Your analysis doesn't mean a great deal. Much of the difference will be due to caching "After deleting the records from aga and performing the last insert again, it just takes 0.68 seconds" -- so cached in memory!, plus write bottleneck and/or writeback cache saturation on the disk. Is is a physical machine or a VM?
Oct
30
comment My queries are slow under load
Are you aware of Statspack, AWR reports or similar? tkprof?
Oct
29
revised Flatten recursive hierarchy
added 4 characters in body
Oct
29
answered Flatten recursive hierarchy
Oct
29
comment Can I use RMAN to backup and restore data in a certain point in time?
@Confluence you state in your question that you want to perform some testing before restoring - he's just added that as a placeholder for your testing.
Oct
28
comment configure: error: SQLite3 library not found
Which Linux distribution? All you need to do is use yum or apt-get (depending on the package manager that your distro uses) to install sqlite
Oct
26
revised Managing user priviliges on schema objects
tagged
Oct
25
comment How to manage primary key while updating
You'd usually use a separate history table to store the history/changes, leaving your main table with just the current entries.
Oct
25
answered object oriented database
Oct
25
comment Managing user priviliges on schema objects
You need to re-think your security model. SELECT ANY TABLE means exactly that.
Oct
25
comment Replace minus symbol across whole document
Which RDBMS are you using and what are the documents stored in? Edit your question with the table definition.
Oct
22
answered How to find index organized table
Oct
22
answered What is the purpose of setting serveroutput in oracle?
Oct
22
revised Slow join behaviour with 'or' in predicate
edited tags
Oct
22
revised Is database partitioning for performance reasons meaningful in virtualized environment?
removed smily and user signoff