13,001 reputation
11741
bio website google.com
location Manchester, United Kingdom
age 36
visits member for 2 years, 3 months
seen 37 mins ago

Oracle DBA, Unix admin.

Available for employment! ;)


Mar
27
revised row_number over partition at Version < Firebird 3
added 23 characters in body
Mar
27
reviewed Reject suggested edit on How to the get current date without the time part
Mar
27
reviewed Reject suggested edit on What makes an Oracle Applications DBA different from an Oracle DBA?
Mar
27
answered CASE_SENSITIVE on ORACLE DB
Mar
24
revised Move SQL Server XML column to a new table - slow performance
edited title
Mar
24
comment DB2 9.7, create or replace tablespace possible?
Doesn't really make any sense to implement such a feature for tablespaces, as they're storage, not code.
Mar
24
reviewed Approve suggested edit on Assign maximum memory limit for a particular database in sql server
Mar
22
comment Can I have Oracle primary 11.2.0.1 and standby 11.2.0.3?
Both must be identical. Keep all databases in your estate at the same version.
Mar
21
reviewed Approve suggested edit on Database update query for split and sum in another field using mysql
Mar
20
comment too many entries for one single session and serila# in V$Session_longops
Parallel query slaves?
Mar
20
comment Is US/Pacific timezone in MySQL automatically adjusting to DST?
The view isn't materialised, so you'll be fine
Mar
20
comment date formatting in Oracle
@miracle173 brilliant, thanks
Mar
20
comment in Oracle, which tables/indexes in query are responsible for disk reads?
Looking at the plan for the query will give you an idea. At the end of the day, Oracle has to look at your workload and age out blocks appropriately. If you're tablescanning, those blocks will never be cached (for example). The granular info you're asking for is probably not available without tracing.
Mar
20
reviewed Approve suggested edit on alt-linux tag wiki excerpt
Mar
19
comment From keyword missing in view
@ypercube A and c do get joined a.ORDS_ID=c.STSL_ORDS_ID
Mar
19
reviewed Approve suggested edit on A clarification of MERGE best practices
Mar
19
reviewed Approve suggested edit on Client times out, while MySQL query remains running?
Mar
19
comment index usages on table with recursive relationship
What SQL is actually being issued? When you say 500ms, how have you timed that?
Mar
18
comment date formatting in Oracle
Excellent find. Couldn't see that in the docs anywhere.
Mar
18
comment date formatting in Oracle
You'll have to concatenate.