1,635 reputation
1614
bio website stackexchange.com/users/98359
location United Kingdom
age 42
visits member for 3 years, 6 months
seen Aug 19 at 22:12

I've been picking up hints, tips and information from a variety of sources over the years, but somehow have always been a taker and not a giver. I'm finally getting involved and trying to give something back to the community. Still learning far more than contributing though.

I'm a bit of a jack-of-all-trades in a small UK-based team within a US subsidiary of a Japanese company, doing work for a large UK telecoms provider. Production support, developer, part-time (a.k.a accidental) DBA in dev/test, analyst, consultant... whatever needs doing right now, generally. Mostly Oracle (since about 1995, versions 6 to 11g), Java, WebLogic, shell scripting, HTML, CSS, a bit of C when pushed, but whatever's needed today. Work is mostly on Oracle Linux, but dragged into Windows and networking issues fairly often, and a Mac user at home.


Mar
18
revised maximum number of interval partitions in Oracle 11g
Added note about maximum value
Jan
6
revised Oracle partition by interval using persian calendar
Added execution plan note
Jan
6
revised Oracle partition by interval using persian calendar
More useful query
Jan
6
revised Oracle partition by interval using persian calendar
Adjusted the partition slightly, so 2013-03-20 ends P0 and appears in the final output.
Feb
20
revised Oracle create user with privileges to grant references
Added least-privilege stuff.
Nov
14
revised User can't stop Oracle listener (TNS-01190)
Added note about deprecation
Jul
20
revised Is it possible to do a datapump import with a different user than did the export?
Formatting
Mar
13
revised oracle 11g seems to die every 2 days, how can i debug what's happening?
Updated beaded on alert log messages
Mar
5
revised ORA-01034: ORACLE not available
Corrected misinformation
Mar
4
revised ORA-01034: ORACLE not available
edited body
Mar
4
revised ORA-01034: ORACLE not available
Added crsctl reference
Feb
21
revised Virtual Oracle server for education?
Removed sql-server tag, fixed typos
Feb
15
revised How to use sqlplus to connect to an Oracle Database located on another host without modifying my own tnsnames.ora
added 162 characters in body
Feb
14
revised How to configure an Oracle Listener without SID_LIST_LISTENER in listener.ora?
Added another link
Jul
17
revised Oracle XE Fedora 15 Installation problem
added 281 characters in body
Jun
3
revised create incremental number in oracle sql query
added 235 characters in body