15,685 reputation
33879
bio website collectserver.info
location Maidenhead, United Kingdom
age 39
visits member for 3 years, 5 months
seen 11 hours ago

I'm an Oracle certified Database Administrator

I've worked extensively with both Oracle and Postgres, in various roles from DBA to developer. I have a basic working experience with SQL Server and MySQL.


Sep
12
revised FDW, replication and CREATE SERVER - will it work?
edited tags
Sep
6
asked Is this substring_index behaviour documented or a bug?
Sep
5
awarded  Nice Answer
Aug
29
awarded  Nice Question
Aug
26
comment Oracle monitor tool
Yes I can see the swap is used, but I also see 2371Mb free memory. Do you see that?
Aug
26
comment Oracle monitor tool
Your free -m is showing 2.4Gb free. Do you understand @Balazs's comment above? Read this too, and consider employing an Oracle DBA.
Aug
23
revised How the sys user gets the sysdba privilege?
deleted 545 characters in body
Aug
23
revised How the sys user gets the sysdba privilege?
deleted 545 characters in body
Aug
23
answered How the sys user gets the sysdba privilege?
Aug
23
revised How can I convert a string to a double precision in PostgreSQL?
added alternative `float` notation
Aug
22
awarded  Nice Answer
Aug
22
comment What makes yum difficult with RAID
@David there was a downvote as well (and I've just added mine). Thanks for trying to help the OP, but I've opted not to migrate because I don't think they'd accept it due to low research effort.
Aug
22
revised What is the meaning of “sga_max_size= # internally adjusted”
edited in comment
Aug
20
comment Is there a means to set the owner of all objects in a PostgreSQL database at the same time?
what's wrong with using Erwin's method? The fact that you have used the method without (apparent) issue gives me no confidence and neither should it: someone might equally say I've used RAID0 for years without issue.
Aug
15
awarded  Popular Question
Aug
15
awarded  Popular Question
Aug
14
comment Absent and Leave
Please do not post this question a third time - work on improving your original question instead.
Aug
13
awarded  Good Answer
Aug
12
comment Can anyone recommend a beginner DBA course in London
This question appears to be off-topic because it is about career advice
Aug
12
reviewed Approve suggested edit on Can anyone recommend a beginner DBA course in London