15,785 reputation
33880
bio website collectserver.info
location Maidenhead, United Kingdom
age 39
visits member for 3 years, 6 months
seen 10 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.


1d
comment 500 databases or 1 database with 500 tables or just 1 table with all the records?
I've closed this as 'primarily opinion-based', but I also note that it's been posted in identical form on two other sites: we expect cross-posted questions to be tailored to the different pools of expertise on offer at each site.
2d
revised How is the default tablespace determined when creating a table?
ALL_USERS doesn't have DEFAULT_TABLESPACE column: http://docs.oracle.com/cd/E18283_01/server.112/e17110/statviews_2129.htm
Oct
1
revised Truncate parent table in Oracle when child table is empty
elaborated
Sep
30
awarded  Explainer
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