Database administrator

learn more… | top users | synonyms

7
votes
5answers
2k 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 ...
5
votes
3answers
2k 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? Can I select all roles ...
4
votes
1answer
458 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 ...
4
votes
1answer
209 views

The future of DBAs with ORM [closed]

I am an aspiring DBA (I'd say in ~3 years I would be ready to apply for a job) and I currently am a programmer. I relayed my future goals to a friend of mine who is part of an Agile SCRUM team in a ...
4
votes
1answer
213 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 ...
2
votes
3answers
186 views

Transaction log back up

Another accidental DBA question. We have a DB instance that host 10 databases. This DB server doesn't have any maintenance plan set up. I want to set up a decent maintenance plan that will do a full ...
2
votes
2answers
235 views

Multiple Instance with different service packs in SQL Server

I would like to install a Default instance with SQL Server 2008 R2 RTM and I want to install another named instance with SQL Server 2008 R2 SP2. Is this possible?
2
votes
1answer
2k views

Migrate / Copy Huge data from Oracle to SQL Server

I have huge tables in oracle database, appx 1 crore+ (10 million+) rows and want to migrate / copy those table and data in sql server. Currently I am using Import functionality of SQL Server for this ...
2
votes
1answer
132 views

Junior DBA hopes for advice [closed]

This is the 7th month of my DBA career, and I just graduated as a master, no experience before. My daily work for now is pretty much about backup/restoring databases in different environments ...
2
votes
0answers
97 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
166 views

Copy Database from Production to Development

I need to copy database from production to development instance in SQL Server 2012 as I don't want to mess up the production server database. Can someone suggest how I can do this ?
1
vote
1answer
972 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
71 views

Delete back ups more than 2 weeks in sql server

I am not a DBA, I need to delete the USER_DATABASE backups older than 2 weeks. Is this below stmt work for this scenario? EXECUTE dbo.DatabaseBackup @Databases = 'USER_DATABASE', @Directory = ...
1
vote
2answers
2k views

Free up disk space on sql server

Assuming I have a sql database server with disk space as follows: D Drive: 10GB (For the MDF file) E Drive: 10GB (For the LDF file) And I have only one database on the server with the following ...
1
vote
2answers
33 views

To what extent can we monitor jobs/suspended queries as DBO

Short Background: I work for company A, at company A we have a DBA that should not be. When we are tasked with items for troubleshooting which require quick turn around, it generally takes quite a ...
1
vote
1answer
892 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 ...
1
vote
1answer
53 views

Incorrect unit allocation size. error comes when Tuning the Database

Here I am Using the SQL IDERA tool for checking the Index and performance of the Database, then i found below error, can any one tell what is it talking about. Incorrect unit allocation size. ...
1
vote
0answers
191 views

PLSQL Compilation error for other users/

I created a plsql procedure that queries the database and dumps the result onto a CSV file. I am an application developer and I have dba rights to my oracle database. I'm able to compile and run the ...
1
vote
0answers
57 views

How many Maximum Number of database can be created in single instance of PostgreSQL? [closed]

How many Maximum Number of database can be created in single instance of PostgreSQL 9.x?
1
vote
1answer
199 views

How to become a sql dba [closed]

I'm working as a software consultant with about 3+ years of experience in Microsoft .NET with SQL Server 2008 and 2012. I'm having interest in SQL Server and possess basic knowledge of SQL that i can ...
1
vote
1answer
116 views

Difference between sql agent account logged in as NTLM and UPN?

Can someone please tell the difference between a sql agent account logged in as NTLM and UPN? What is the difference if the sql agent account is logged in as: domain\username and username@domain.com? ...
1
vote
1answer
258 views

cons of linked server providers not running in “allow in process” [closed]

what are the cons of having linked server providers not running in "allow in process"? SQL box crashed due to oracle provider crashing and it provider was running in "Allow in process", now have been ...
1
vote
0answers
56 views

Integration Service cannot be upgraded/removed

I have Sql Server 2005 Integration Services installed in our server whose version is 5292. It needs to be upgraded to version 5324. After running the patch the summary report says it is upgraded ...
1
vote
1answer
234 views

I need advice on these queries

could you help me optimize these queries? here are queries, please note that you see something like OR 1=1 OR those are values I pass via php and may change. query#1: SELECT posts.status, ...
0
votes
3answers
188 views

index rebuild/reorganize frequency

I am a dba by accident. I am doing index rebuild/reorganize. I would love to use some scripts once I become comfortable doing these tasks. I did go through some of the forum pages regarding this ...
0
votes
2answers
4k views

Reclaiming data file free space after deleting a large amount of data

I am an accidental DBA. We have a sql cluster that hosts 10 databases. Suddenly the size of one of the database increased drastically from 100GB to 250GB. When we checked the datafile, the size had ...
0
votes
3answers
126 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
38 views

Can PostgreSQL results include the query?

I run the following command to run 2 queries in a sql file. Could be 1, could be 50 queries. Depends on the deployment. psql -U <username> -h <servername> -d <databasename> -f ...
0
votes
1answer
69 views

Exadata RMAN vs. Non-Exadata RMAN - any differences?

Can you please let me know the differences, if any, in the architecture of the non-Exadata RMAN vs. that of the Exadata-RMAN from an SBT plugin perspective? Have you observed from your vast ...
0
votes
1answer
51 views

Index file - size changed

I realised today that my index file(which is about 250GB) is smaller than yesterday for about 7GB. Everything, I done in the meantime, was index rebuild. Is it possible that index rebuild is the ...
0
votes
1answer
78 views

Maintenance plans

I am an accidental dba..I did post a message a while ago about Index fragmentation and some of you suggested maintenance plan and others suggested custom Olla's scripts. I have downloaded his scripts ...
0
votes
2answers
194 views

Restoring Oracle DB using RMAN

I am a application developer doing DBA work. I have to restore an oracle database on our test server. The databases are backed up using RMAN and the last db restore that was done on this server was in ...
0
votes
1answer
30 views

What is the risk of doing a rebuild to my indexes in sql server 2012?

What is the risk of doing a rebuild to my indexes in SQL Server 2012? I have to do a REBUILD, but I don't know what are the risks . The server is running and a lot of information is going in and out. ...
0
votes
1answer
96 views

I am upgrading from 11.1.0.7.0 to 11.2.0.3 with R12.1.3 while pre upgrade/catupgrd.sql erroring out ORA-00600

While upgrading from 11.1.0.7.0 to 11.2.0.3 with R12.1.3, during running the pre upgrade script catupgrd.sql, it is erroring out ORA-00600: internal error code, arguments: [qcisSetPlsqlCtx:tzi ...
0
votes
1answer
65 views

Database simulator [closed]

I've been studing theory of database, but I can't have a concrete image on terms of functionality. I want to be a DBA, I'm studing for it so I want to understand how a database works. Is there any ...
0
votes
1answer
22 views

Error on mongos server

Firstly,I am new to mongodb. when we executed the below command on mongos server. /usr/bin/mongos --configdb X.X.X.1:20001,X.X.X.2:20002,X.X.X.3:20003 --port 27017 --chunkSize 1 we are getting the ...
0
votes
1answer
114 views

Error when trying to add a shard set in Mongo db

I'm trying to add a shard set in mongos I got this error and . Kindly help. mongos>db.runCommand( { addshard : " firstset/ip_1:port_1,ip_2:port_2,ip_3:port_3" } ); { "ok" : 0, ...
0
votes
1answer
40 views

How to do Mysql migration from 5.0 (320bit windows) to 5.6 (64 bit windows)?

I want migrate My Mysql 5.0 windows 32 bit to Mysql 5.6 Windows 64 bit? Please suggest me the best way to do migration, i have around 10gb of data present in Mysql 5.0.
0
votes
1answer
83 views

Can anyone recommend a beginner DBA course in London [closed]

My organisation is in need of a SQL Server DBA and as the companies only "SQL Guy" my boss has suggested me to take SQL Server DBA course. My general T-SQL knowledge is fairly good, I can write ...
0
votes
1answer
193 views

Select Into Regexp_replace doesn't write changes into newly generated table

I have been using this query in postgres 9.1 in order to remove '' from existing data. Below is a sample of the data before running regexp_replace. 6'' 6'' 6'' 20'' 12'' 18'' 20'' 8'' 10'' '' '' ...
0
votes
1answer
94 views

Timestamp with time zone

Please can you explain the meaning of this sentence! Two TIMESTAMP WITH TIME ZONE values are considered identical if they represent the same instance in UTC, regardless of the TIME ZONE offsets ...
0
votes
2answers
7k views

SQL Server Management Studio - connection with SQL Server database engine

This question is in regards with SQL server 2005 and 2012. I have a database server with two instances of SQL Server. Through SQL server management studio I was able to connect to both instances by ...
0
votes
1answer
142 views

Install and Configure Oracle 11g using c# program [closed]

I need to create a windows application program using c# which will allow me to install oracle client 11g and also configure ODBC automatically with just one click, as my customers have limitations in ...
0
votes
0answers
11 views

Proper Partition Alignment SQL Server [migrated]

I'm trying to follow the advice from this technet article about partition alignment. Our San is an EMC, the disks are in a 4 disk raid 10. This is a SQL Server with an I/O intensive application, ...
0
votes
0answers
16 views

Can't see any services listed in Configuration Manager

I am using SQL Server 2014 and am logged in my desktop as my user account with admin rights. When opening Config Mgr, I do not see any services listed whatsoever. Could this be an issue that ...
0
votes
0answers
45 views

MySQL replication: most important config parameters on slave for performance on master server?

This query is almost the same as this question. But in this case, a configuration to make the master perform faster or just the same. Case We have a Master-Slave setup on a Mysql 5.0.77 - MariaDB ...
0
votes
2answers
37 views

How can delete an orphaned temporary table on Mysql Innodb?

I was issuing an Alter table statement and suddenly the server crashed, Now i can not run any alter table to that table because it shows me the error 1050 and it says that a table named #sql1504d ...
0
votes
0answers
9 views

Why do I get this CMN_1021[ORA-03135: Connection lost to contact

My Informatica application throws this error not every time but randomly. Not sure of what is the root cause of this ..
0
votes
1answer
43 views

How to directly query other user tables

I am trying to learn Oracle database and I am having difficulties on importing a backup file with impdp command. I googled deeply but couldn't find answers to my problems. What have I done until now ...
0
votes
1answer
45 views

Mysql JOIN with 25million rows

Recently I got stucked with a table where its grown to +25million and I have got a query that's doing a JOIN on it. The query take 2.5hours to execute even though I got Good 96GB RAM and RAID10 with ...