The dba tag has no wiki summary.
7
votes
5answers
1k views
Are there any professional fulltime PostgreSQL DBA's?
For my job I work on a JavaEE application with PostgreSQL as the database. Although we have a sysadmin for our productions servers, who also manages our database servers, we have no full-time DBA ...
4
votes
1answer
116 views
Managing Access for DBA and IT Support
We are currently in the process of moving our development, test and live databases on to separate servers and instances and I am looking at how best to manage access for DBA tasks and also IT Support ...
3
votes
1answer
132 views
SQL Server Restore from one database to another
One of our devs backed up a dev database, and then restored it in production. It's a new database for a new app that was deployed last night intentionally to prod.
Now in the backupset table ...
2
votes
1answer
67 views
Do roles have an owner in oracle?
Suppose that i have logged in to oracle database using user X. then user X creates some roles using create role command. I want to know that is user X the owner of the roles? and can i select all ...
2
votes
0answers
65 views
SQL Server Online Training [closed]
I recently took an intro class for MySQL from www.oreillyschool.com and it was very helpful. The next class they offer is administering MySQL but I currently work with SQL Server. The first class was ...
1
vote
1answer
131 views
Oracle delete technique for table's segment size (data compactness)
I would like to ask if there is any effect on the following deletion technique of a database to the tablespace size. The existing code for clearing the data has the following style of code before:
...
1
vote
1answer
130 views
InnoDB, What would cause: “db1/tableABC contains 6 indexes inside InnoDB, which is different from the number of indexes 5 defined in MySQL”
MySQL 5.5.24 .
We have InnoDB tables that grew almost by double (from 50GB to 100GB - file-per-table enabled) in a few weeks due to a project we are working on.
The tables were freshly dumped and ...
0
votes
0answers
21 views
mysql deadlock while updating: ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction update
I am using the mysql version 5.5.29 in my production server. while executing set of update statement inside the procedure it is throughing the following error:
ERROR 1213 (40001): Deadlock found when ...
0
votes
2answers
46 views
How to manage constants within an Oracle Database
This question touches on a few different parts of Oracle that I'm not particularly familiar with so bear with me:
I am trying to redesign some of the procedures and functions within the database I ...
0
votes
1answer
65 views
Oracle tables replication options based on unique needs [closed]
We have a unique situation and I was wondering if some of you could chime in. I am no way close to DBA and that's why I am here.
Let me illustrate what we are trying to achieve.
Let's say we have ...
