13,956 reputation
12150
bio website google.com
location Manchester, United Kingdom
age 37
visits member for 2 years, 10 months
seen Nov 23 at 12:19

Oracle DBA, Unix admin.

Available for employment! ;)


Dec
16
awarded  Nice Answer
Dec
15
reviewed Approve suggested edit on determine redo log size, number of redo log files
Dec
15
revised What is the meaning of tinyint(N)?
added 213 characters in body
Dec
15
answered What is the meaning of tinyint(N)?
Dec
14
answered 64bit SQL Server with total virtual address space of 4GB. How could this be?
Dec
14
comment 64bit SQL Server with total virtual address space of 4GB. How could this be?
I don't know enough about SQL Server to help you - others will be along soon; I'm an Oracle DBA. I do, however, know my X86 from my X64 :P
Dec
14
comment 64bit SQL Server with total virtual address space of 4GB. How could this be?
I think I win a prize.
Dec
14
comment 64bit SQL Server with total virtual address space of 4GB. How could this be?
"Intel X86" - you installed the 32-bit version?
Dec
14
comment How to ignore optional prerequisites when installing Oracle database in silent mode?
They're pre-requisites for a reason. You need root access as part of the installation anyway (there are 2 root scripts that need executing)...
Dec
14
answered What is Oracle Database Vault and how does it work?
Dec
14
comment Should I be worried about duplicate entries in the Oracle all_dependencies table?
Things can be dependant on each other. You need some CONNECT BY in your query.
Dec
13
comment How many blocks is my database
where segment_name = 'YOURTABLENAME'
Dec
13
comment How many blocks is my database
Use USER_EXTENTS or ALL_EXTENTS instead
Dec
13
answered How many blocks is my database
Dec
13
comment OEM 11g alerts and notifications arrive together
@jcho360 "are you saying that this won't work because they need to be separate" -- Well, how do you think it can send alerts if it's down?
Dec
13
comment can I quickly create tables for each partition?
Do you need to keep the data in the original partitioned table?
Dec
12
comment How do I identify the column(s) responsible for “String or binary data would be truncated.”
If I knew that, I'd have answered it. Hence my suggestion of changing your script and doing it in perl.
Dec
12
comment How do I identify the column(s) responsible for “String or binary data would be truncated.”
Alter your perl script to query sys.columns (max_length) for the table, then compare the lengths of the strings you're trying to insert when the insert fails. 5 minute coding job
Dec
12
answered Postgresql behavior at end of sequence
Dec
12
comment Stored Procedure Performance using Temporary Tables
Or, carry on regardless if it already existed and continue to fill it with stuff in another thread, which them might also use it? I've no idea what isolation level MySQL uses, but dirty reads spring to mind