The tag has no wiki summary.

learn more… | top users | synonyms

13
votes
3answers
1k views

Does my Oracle DBA need root access?

My Oracle DBA Colleague is requesting root access on our production servers. He is arguing that he need it to perform some operations like rebooting the server and some other tasks. I do not not ...
1
vote
2answers
130 views

Training and transitioning in a new sysadmin [closed]

Company is hiring a new sysadmin. Because we growing more rapidly, I'm transferring my sysadmin duties over so I can concentrate on managing and leading the development team. How can I make this ...
3
votes
1answer
3k views

Maintenance of tables: do I need to REINDEX a table after truncating and repopulating?

I have a table with about 2 million rows in it of transactional data that we use for analytics. Every week we reload this with new data, so we've been using TRUNCATE to clear it out and then inserting ...
0
votes
0answers
86 views

sa account automatically disable itself

I am having trouble logging into SQL Server 2005 with the sa account because the account disables itself after i have enabled it. I checked the server properties ; the account is configured for "SQL ...
1
vote
1answer
54 views

Sql Server - Minimum rights to be able to grant other people similar rights

I would like to grant someone on our web dev team the ability to grant other users (other web developers as well as application users they create) datareader, datawriter, and exec sproc in our Dev and ...
1
vote
2answers
363 views

[MySQL]multiple-masters single-slave

Is is possible to have a setup where multiple mysql servers (containing different databases) are replicated in a single mysql slave server ? If yes, how to do it ?
1
vote
4answers
765 views

Recommended MySQL monitoring tool [closed]

I am looking for a good all-in-one monitoring tool for a single MySQL server and underlying Linux OS. I need something that gives me a quick graphical view of what is going on right now and that ...
2
votes
1answer
290 views

What are the best practice for monitoring Oracle's rollback segment?

Occasionally, we run out of rollback segment space causing the query/update to fail. What are the best practices that I can expect from an Oracle DBA to ensure that this is monitored pro-actively and ...
2
votes
1answer
149 views

Oracle Backup Strategy

I have recently inherited a smallish Oracle database running on a SPARC Solaris 10 Server. I have been asked to implement a sensible backup strategy. The database has about 3000 odd tables and is ...
0
votes
2answers
138 views

The Transactional Log is Full

I am getting below error. The transaction log for database 'CRM_QA_V6' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases likely ...
3
votes
4answers
189 views

Moving SQL Server database from old production server to new server

We had single production server for website and SQL Server database. We have plan to have a new production server for website and SQL Server. We need to move the SQL Server database from the old ...
1
vote
1answer
2k views

Can I recover an Oracle database to an instance with a different SID?

I've implemented a backup (and recovery) plan for an Oracle 11gR2 database as follows: Installed the same version of 11gR2 on production and disaster recovery (DR) servers Created identical Oracle ...
0
votes
1answer
411 views

Allocation error in Database in sql server 2008?

I have found following errors when I use DBCC CHECKDB command. I don't have idea to fix the error. please help me. CHECKDB found 124 allocation errors and 0 consistency errors not associated with ...
0
votes
1answer
68 views

What is the best way to control access at the level of MySQL Client?

What is the best way to implement access control to production MySQL instances? The aim is not ban the developers from accessing the MySQL but performing LDAP authentication and audit logging of ...
2
votes
2answers
109 views

Restoring a SQL database in a production environment as an update mechanism

I'm a sysadmin who has recently been landed with some SQL DBA responsibility. Not reluctantly I might add, this is a world I'm very much looking to get immersed in. I am curious about one of the ...
-1
votes
1answer
562 views

problem in run oracle server please help

I used Oracle 11g, from few days ago I face below error: SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 7 07:33:19 2011 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: ...
0
votes
1answer
128 views

SQL server port is blocked on client machine [duplicate]

Possible Duplicate: SQL server port is blocked on client machine I have a client machine on which sql server is installed. This machine is using the internet though a proxy machine. On the ...
0
votes
1answer
1k views

Weird MySQL query plan: why is this query using temporary & filesort? How to optimize it?

I have a query: SELECT * FROM amp_ads,amp_c,amp_c_countries WHERE (amp_c.zone = '24' OR amp_c.zone = '25') AND amp_ads.ad_complete = '1' AND amp_ads.ad_type = '17' AND amp_ads.accept = '1' ...
0
votes
4answers
1k views

MySQL server CPU usage shot up for no apparent reason. Any idea why?

I have a server dedicated to MySQL. In the middle of the night its CPU usage just shot up for no apparent reason. Here're the graphs: As you can see CPU usage just shot up at Fri 3:30am. Most of ...
1
vote
3answers
469 views

Any open source software for measuring & monitoring MySQL performance?

I'm working on improving the performance of a MySQL server. I'm looking for something to measure & monitor the performance of MySQL (as query per second) over time so that I can measure any ...
0
votes
2answers
374 views

Linux: everyday at the same time, my MySQL would shutdown, revert to previous version, and then restart on its own. How to fix this?

I recently migrated from MySQL 5.0 to Percona Server 5.1. I used yum remove mysql-server mysql-client to remove the old version. Then I installed Percona Server using yum. Since then, everyday at ...
2
votes
2answers
4k views

MySQL: how to enable Slow Query Log?

Can you give me an example on how to enable MySQL's slow query log? According to the doc: As of MySQL 5.1.29, use --slow_query_log[={0|1}] to enable or disable the slow query log, and ...
2
votes
4answers
2k views

MySQL: how to convert many MyISAM tables to InnoDB in a production database?

We have a production database that is made up entirely of MyISAM tables. We are considering converting them to InnoDB to gain better concurrency & reliability. Can I just alter the myISAM ...
1
vote
3answers
1k views

How to tell if any MySQL connections has been dropped or timed out?

A client is using PHP to connect to MySQL. The PHP scripts and the MySQL database are located on 2 different Linux servers. He complained that database connections were being dropped or timed out and ...
1
vote
2answers
152 views

Linux: How to rename old mysqld when upgrading MySQL?

I'm upgrading MySQL from MySQL 5.0 to Percona Server 5.1. I'm planning to just use yum remove and yum install to do the upgrade. However, I read in the documentation that it's a good idea to rename ...
1
vote
3answers
2k views

How to migrate from regular MySQL to Percona Server in production?

I'm running MySQL 5.0 in production on CentOS. How do I migrate to Percona Server 5.1 safely? The documentation of Percona Server doesn't include any information on migrating. Any help is greatly ...
0
votes
1answer
123 views

Is there any problems in mysql5.1 server with mysql5.0 client?

We are going to replace DB servers with mysql5.1. Our dba team recommend that using mysql5.0 client because, they have enough skill and know-how with mysql5.0 client. Is there any problems in ...
1
vote
3answers
753 views

How do I find the query parameters for a prepared statement in an oracle .trc file?

I have an oracle query generating a 3137 error, and the trace file contains the query. For example: select x from y where z = :1 I think it would help to isolate the problem if I could determine ...
1
vote
1answer
759 views

SQLS Timeouts - High Reads in Profiler

I've audited a SQLS2008 server with Profiler for one day.. the overhead didn't seem to trouble this new client my company has. They are using a legacy VB6 application as a front-end. They're ...
1
vote
1answer
563 views

sp_reset_connection taking a long time to run

I've got an application where all the sprocs are running nice and quick, but the sp_reset_connection calls between them are taking anything up to 20 seconds. I've looked at locking and blocking but ...
0
votes
1answer
333 views

Possible to programmatically ALTER multiple MySQL tables?

I have multiple MySQL tables with names of the form "Shard_0", "Shard_1", "Shard_2" ... "Shard_n" All of them have identical table structure. They all live in the same database. Say I want to add a ...
1
vote
2answers
4k views

Any way to copy the schema from one MySQL database to another?

I have a MySQL database that contains almost 100 tables. I want to set up N additional MySQL databases on the same server, each running on a different port. And I want each additional database to ...
6
votes
3answers
6k views

Becoming a DBA, what do I need to know?

Im sure this has been asked, but times change and so do SQL preferences etc... I figure this place would be the best place to ask this im sure many DBA's come here. But what do I need to know ...
0
votes
1answer
227 views

deny create function to user on postgres

How does one go about explicitly denying the create function ability of a non superuser in postgres? I looked into the documentation, but was unable to find anything of value.
0
votes
2answers
263 views

shrink database or file

Does anyone know the diff between shrink database or file? and what would the pros and cons? in what circumstances you wish to do either one? thanks
1
vote
2answers
141 views

What sort of training is required to become a SQL Server DBA?

not sure if this question rely belongs here but what sort of training would someone need to become a SQL Server DBA? Going for a job as a junior DBA which includes training so just wondering what that ...
1
vote
1answer
133 views

Are there any pitfalls with having multiple MySQL databases on 1 server node?

I want to prepare my database for sharding in the future. But right now I only need 1 node. What I'd like to do is to shard the database into virtual shards, say 12 shards, and put all of them onto ...
2
votes
1answer
687 views

How to move MySQL partitions from one machine to another?

I have a MySQL table: CREATE TABLE tweets ( tweet_id INT NOT NULL AUTO_INCREMENT, author_id INT NOT NULL, text CHAR(140) NOT NULL, PRIMARY KEY (tweet_id) ) ENGINE=InnoDB PARTITION BY HASH(tweet_id) ...
0
votes
1answer
584 views

Postgresql vs. MySQL: how do their data sizes compare to each other?

For the same data set, with mostly text data, how do the data (table + index) size of Postgresql compared to that of MySQL? Postgresql uses MVCC, that would suggest its data size would be bigger In ...
0
votes
1answer
231 views

Does index fill factor become meaningless on large tables?

At work we have a 250GB database with several very large tables. One of the maintenance plans that runs every 48 hours performs a reindex on all tables. This takes about four hours, and is currently ...
6
votes
3answers
383 views

when is it time to hire another SQL Server DBA?

Been searching the web and asking my contacts, but other than some opinions, I'm not finding any kind of numbers nor matrix nor formula to guide on when it's time to add another DBA. Are there any ...
0
votes
3answers
585 views

sql server 2005 instance unresponsive and all db's are 'in recovery'

we've got a sql server 2005 instance that one of our guys messed up, i believe they killed the sql server service and restarted the computer, and when it came back all of our databases are "in ...
1
vote
1answer
952 views

“Classic” activity monitor in SQL Server Management Studio 2008?

Right now I'm using SQL Server Management Studio 2005 to manage all my SQL servers (2000, 2005, 2008). I'd love to be able to take advantage of all the cool new features in SSMS 2008, the only thing ...
0
votes
1answer
317 views

MySQL: stopping just one DB to allow it to be moved

I want to do some work on the files that make up a few MySQL DBs (moving the files to a different partition and symlinking the original location to this) and if possible I'd like to shutdown just the ...
1
vote
1answer
799 views

Oracle 10.2.0.1 --> 10.2.0.4 patchset errors on Advanced Queuing tables. Serious or not?

We're running Oracle on RHEL 5.4 64-bit. We recently did an upgrade from 10.2.0.1 to 10.2.0.4. Many errors were generated during the upgrade (sample listed below from trace.log) but during ...
0
votes
2answers
2k views

ORA- 01157 / Cant connect to database

this is a follow up from this question. Let me start by saying that i am NOT a DBA, so i'm really really lost with this. A few weeks ago, we lost contact with one of our SID'S. All the other ...
2
votes
1answer
823 views

SQl server 2008 permission and encryption

i have made columns in some of the tables encrypted in sql server 2008. Now as i am a db owner i have the access to encode and decode the data using the symmetric key and certificate. But some other ...
3
votes
3answers
98 views

Creating MS SQL Server Logins

i have SQL server 2008 local installation and my xyzdomain/user has the access to the SQL server . Now my machine is moved to abcdomain and i am not able to access the Database server because the only ...
6
votes
5answers
425 views

What proportion of DBA skills are platform-independent?

Problem: we've grown to the point where we need a real DBA. Real DBAs are hard to find. Possible solution: I know someone with extensive experience (currently working on MSSQL) who is looking for a ...
15
votes
5answers
902 views

Is my new Oracle DBA talking sense

When we setup FC LUNs for our MSSQL boxes we rarely have to present them with more than about 8 distinct LUNs of various kinds (Quorum, MSDTC, TempDB, Data, Logs, Backup and a few others). We have a ...