12,910 reputation
11741
bio website google.com
location Manchester, United Kingdom
age 36
visits member for 2 years, 3 months
seen 4 hours ago

Oracle DBA, Unix admin.

Available for employment! ;)


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.
Mar
18
reviewed Approve suggested edit on PGAdmin3 connection with non standard SSH port and SSH tunnel
Mar
18
reviewed Approve suggested edit on Utilizing a single core to 100% doesn't show in perf mon as single cpu being fully utilized
Mar
18
revised What is the instance name of the box I'm logged into?
added 107 characters in body
Mar
18
comment What is the instance name of the box I'm logged into?
All that tells you is the value of the $ORACLE_SID environment variable in the current shell. It tells you nothing about running services.
Mar
18
reviewed Reject suggested edit on Opimizing Mysql