The discipline of Operational and Architectural Management of Database Systems.
3
votes
2answers
90 views
Two corrupted indexes found by DBCC CheckTable
I'm wondering if this problem is solvable by dropping/recreating the two indexes. Both are rarely used, nonclustered, non PK, non FK indexes.
Here is the dbcc output:
Table error: table ...
8
votes
2answers
22k views
oracle - list users with access to certain tables
I'm sure this has been asked before but I can't seem to find the relevant details for the following.
Is there some sort of pre-built table that can do the following (I have used dba_tab_privs but it ...
1
vote
2answers
89 views
An admin (GUI or shell tool) for managing all kinds of databases
I needed an interface/admin (web or desktop) from which I could manage all the databases in my system. Currently I use separate admins for each (phpmyadmin for mysql, pgadmin/phppgadmin for postgres, ...
5
votes
1answer
412 views
Stored Procedures Best Practices: Fenced or Unfenced?
I believe I understand the reasons behind fenced and unfenced stored procedures.
Fenced run "outside" of the database (in our case DB2) so as to prevent possible corruption of the database engine ...
0
votes
1answer
72 views
What is the maximum number of rows in a clustered index on datetime column?
I would like know what the max no of rows is in a clustered index (non-unique) on a datetime column table in SQL Server 2008R2.
16
votes
7answers
394 views
Where can I find some guidance on index strategies?
Most of us will probably agree that using database indexes is good. Too many indexes and performance can actually be degraded.
As a general rule, which fields should be indexed?
Which fields should ...
1
vote
2answers
105 views
Database Is In InRecovery Mode.
I have a database that has entered "Recovery Mode". It was working fine, but ended up in this status a few days ago.
I have been told that a cause can be the partition holding the datafiles running ...
3
votes
1answer
742 views
What queries is Oracle executing, how frequently, and time-taken?
I have a (Java) web-application, that of course executes many queries (selects, inserts, updates, deletes) to the Oracle Database.
I want to find out the following for last 7 days:
SQLQuery ...
2
votes
1answer
201 views
How to grant permission for am administrator account in SQL Server 2012? [closed]
I installed SQL Server 2012 on my laptop. I am trying to run a script to create a simple database.
SQL Server version: 11.0.3128
SSMS starting parameters:
server type: database engine
server name: ...
4
votes
2answers
239 views
How to Correctly Estimate the Average Number of I/O Operations my RAID 10 disk can offer?
The average Input/Output Operations per Second a disk can sustain is a very important factor in the tuning of MySQL / InnoDB databases, as it drives the speed with which Dirty InnoDB Buffer Pool pages ...
4
votes
3answers
10k views
Oracle 11g - Create Database fails?
I've just installed Oracle 11g and linked it to SQL Developer.
I want to create a database for my django install.
CREATE database 'django';
Error starting at line 1 in command:
create database ...
31
votes
11answers
2k views
How could DBAs be more 'programmer friendly'?
The answers and comments on the dba.se version and programmers.se version of the question "What are the arguments against or for putting application logic in the database layer?" are very revealing ...
0
votes
0answers
48 views
400GB Innodb table with deletes and no data_free?
I have an Innodb table which is over 400GB and performing quite a lot of deletes on it, so I thought I should try to optimize the free space kept it is probably creating. I ran this query to find out ...
2
votes
3answers
2k views
Unable to start SQL Server Instance 2008 R2 - DB file corrupt
I was not able to start the SQL Server 2008 R2 production DB instance. After reading the log file error message is
" The log scan number passed to log scan in database ‘master’ is not valid. This ...
5
votes
1answer
6k views
Is there any best way to reduce the size of ibdata in mysql.?
I have some Production servers whose ibdata increases in size day by day.
It has already consumed 290GB of space.
The tables in the servers are mostly InnoDB and there are high read and write ...
1
vote
3answers
341 views
Detecting SQL Server Utilization with a query
My current project will send queries to an sql server constantly and It may use 100% of the memory or CPU.
How can I check if the server is nearing full utilization in a stored procedure so that I ...
0
votes
2answers
178 views
Restore the latest backup on the database
We have a stored proc which takes the backup from a database to the specified location. Sometimes the backup process runs more than once. It causes having more than one backup set on the same file ...
0
votes
2answers
216 views
Remote database connection problem?
I have two systems with Windows XP. I have installed SQL Server 2005 on a system and tried to use SQL Server Management Studio Express on both to use the database.
I am able to use the database on ...
0
votes
1answer
202 views
mysql fine tuning: open_tables, opened_tables
I'm a novice to database administration and have been depending on forum suggestions and answers to help resolve my database hang ups and too many connections errors; I've managed to reduce the ...
-3
votes
1answer
52 views
Challenges of a data migration project? [closed]
Main problem I can think of is not migrating all the data accurately (e.g. not migrating data to the right place in the new database, or losing data in the migration process).
Other possible problems ...
1
vote
1answer
298 views
MySQL Tables crashing randomly
This is one of the many random Tables that get corrupted. Any ideas why and what would be causing this?
How do I keep MySQL tables from crashing and MySQL from crashing?
Repairing USR_wp537
...
9
votes
3answers
190 views
How to tackle a large undocumented database
I recently got hired as the only IT Guy in a certain Company X and I am tasked to fix their applications, and in my opinion, the best way to start is by understanding the database.
Their current ...
0
votes
0answers
14 views
what happens when closing berkeley db?
I have a program using berkeley db as data store, and when the program finishes its job and exits, it triggers berkeley db to close.
Ok, here is the problem. Nine times out of ten, my Linux system ...
2
votes
1answer
233 views
Mysql - show results from 3 tables excluding NULL or EMPTY values for certain fields
I have 3 simple tables with polls, users and votes. I'd like to show all polls ordered by clean count of votes (sometimes either poll_id or user_id don't get inserted).
Furthermore I'd like to show ...
2
votes
1answer
306 views
Solve conflict between affinity mask and I/O affinity mask?
I executed this on one of our SQL Server machines:
EXEC sp_configure 'show advanced options', 1
And then executed RECONFIGURE. This presented me with the following error message:
The affinity ...
-1
votes
1answer
133 views
How to calculate some specific things about a disk? [closed]
I have this situation where I need to calculate some things. I have following things with me,
Disk characteristics: number of cylinders;
number of heads;
# sectors/track;
...
2
votes
1answer
87 views
How can I rename a table, but also all FK etc. references to that table?
I would like to e.g. rename my Applicant table to ApplicantProfile, as applicant is an abstract entity that has a profile. The profile is not the applicant.
Simply renaming the table is hopelessly ...
0
votes
2answers
175 views
How to identify the db orphan mdf and ldf files
I want to identify the orphan mdf and ldf files on the disk and remove them. After searching on the internet, found the script below on MSDN forum. But when I run the script it returns many ...
0
votes
0answers
20 views
is there any strategy for back up the SharePoint Portal Server Farm?
We have many servers in our farm with SharePoint Portal Server and VSTS and Project Server. now we have up-to 100 DBs and back it up with STSADM.exe in schedule task.
But several of time this batch ...
3
votes
1answer
111 views
Easiest Way to Move 100 Databases
I need to move about 150 databases from one server to another server.
SQL Server 2008 Web Edition
SQL Server 2012 Preview (in a different datacenter - East Coast Azure)
I was planning on moving ...
3
votes
2answers
230 views
Perl vs Ksh for Unix Database Administration
I realize this is a somewhat more subjective question, but I am looking to the community for guidance.
Our company is fairly new to having DBAs. We used to use DB2 for i on the IBM's iSeries servers, ...
2
votes
2answers
141 views
How to login in database if we have lost password? [duplicate]
Possible Duplicate:
gain admin access to sql express 2008
Is there any idea if we lost our password to login in database using sql express management studio?
Is there any place where ...
1
vote
1answer
352 views
listener does not currently know of SID given in connect descriptor in oracle 10g and solaris 10 env
I have a oracle 10g database in solaris 10 system. The SID=OTRS, I can connect to oracle database from local server itself. But I can not able connect from another client. It is returning an error ...
1
vote
1answer
262 views
ERROR: database “dbname” does not exist
According to the documentation, so long as I'm not connected to a database, I can either delete a database in the console using:
DROP DATABASE dbname;
Or I can drop it using the wrapper tool ...
0
votes
1answer
42 views
PostgresSQL: Cannot get to console under different user name
I normally get to the console in UBUNTU by typing:
sudo -u postgres psql
But I need to delete a database owned by a different user.
When I type:
sudo -u username psql
It tells me "database ...
1
vote
1answer
355 views
Is there a progress indicator for OPTIMIZE TABLE progress?
MySQL 5.1.4x (Windows) | Innodb
I recently purged data from a mySQL DB (a few hundred thousand rows) and I'm planning to use
OPTIMIZE TABLE LOGTABLEFOO1,LOGTABLEFOO2,LOGTABLEFOO3;
to reduce the ...
4
votes
1answer
80 views
Expanding a partitioned table
I have a table that holds four years of data, where for each month I have a partition that is based on a filegroup with two files. Unexpectedly, I received eight more years of data and prepared the ...
2
votes
1answer
59 views
Searching transaction logs for changes
I currently have a database with an attached CMS. The CMS has about 50+ people with various permission levels that can log in etc... I would like to know if there is a way I can look at the ...
3
votes
2answers
182 views
How can I organize my tables?
My database contains more than 200 tables. When I want to modify or insert a table, I find it difficult to find it among all those tables.
Is there any way to collect related tables in a folder ...
4
votes
1answer
567 views
Appending backups while overwriting expired sets
I've been reading up on this, but the online documentation is a bit difficult to understand and seems awkwardly written. For example the INIT, NOINIT. One says it will try to overwrite everything. ...
1
vote
0answers
82 views
Database instance keeps restarting
From the past few days, our MySQL database instance has crashed and had to be restarted a few times. My MySQL version is 5.1.57-log. The CPU and memory usage was way below 50% during the crash time. I ...
2
votes
2answers
122 views
Database structure for a system with multisite
The system I'm working is structured as below. Given that I'm planning to use Joomla as the base.
a(www.a.com),b(www.b.com),c(www.c.com) are search portals which allows user to to search for ...
0
votes
1answer
360 views
Achieve log transfer to standby (Data Guard)
I am not able to transfer my archive logs from primary to standby. I executed the following query:
archive log list
Database log mode Archive ...
2
votes
2answers
328 views
Standby controlfile error
I am doing dataguard. I have manually done a backup for the standby database. It was working fine. Problem arose when I used the standby controlfile. On the primary, I have created a standby ...
4
votes
2answers
159 views
Isolation Level for a Data Warehouse
We are building out a data warehouse (and also some data marts as well) in our organization. My DBA skills have mostly been on OLTP type applications, but I am moving into supporting OLAP for our ...
-4
votes
1answer
98 views
Advice for designing a complex/multipart application [closed]
I'm designing a software application for my medical carrier.
It is very complicated, with many parts and many small details.
Some experts advised me to divide it to parts, then design the database ...
0
votes
1answer
709 views
DBF file exist while user has been dropped?
I am new to Oracle. I have dropped some users from my database using:
DROP USER username cascade;
The issue is that the .dbf file still exists in the $ORACLE_HOME/dbs/oradata/ directory, which is ...
3
votes
1answer
377 views
Moving postgresql data to different drive
I am using AWS as my cloud environment. I installed PostgreSQL on the same drive as my root instance volume. I have attached and mounted the second drive to my instance. Now I want to move all my ...
3
votes
1answer
159 views
Can I check what the allocation unit size is on my drives via a query?
Assuming that I do not have access to windows server, can I run a script from SSMS that would allow me to check whether allocation unit size is formatted with 64K?
1
vote
1answer
156 views
mysql session logging tables
I've been building a session logging system for our sites. We get around ~15m hits a year and at the moment we're really only interested in stats about people who logon to our sites.
Our table ...
