0
votes
0answers
7 views

Can I reuse the same agent for 2 different Oracle Enterprise Manager servers?

I have two OEM (Oracle Enterprise Manager) servers administering 2 clusters (both administer both). We would like to use only one agent in each cluster, to be used by both OEM servers. Is it ...
1
vote
1answer
11 views

Relying on expected data

I'm relatively new to Database Design and I wanted to know the disadvantages to a particular decision I have made in the design of a database for a project. I don't think it will have an effect on the ...
1
vote
1answer
26 views

SQL Blocking, SPID of -2

We have some blocking going on in our database and when I run sp_who2, in the BlkBy field, I see "-2" for two of the rows. What does this mean? Running SQL Server 2008 R2
0
votes
1answer
7 views

transaction not processing?

I'm trying to test out an update prior to running it on our production server, however when running my transaction in sqlplus, I don't seem to be able to commit the transaction or get any data back ...
0
votes
0answers
14 views

Select script for selecting two columns in a table

I need help writing a Select script which selects data from two columns based on a condition. Say I have a table Table: X Columns: ID, Type , and Old_type Column "Old_type" has nulls or historic ...
1
vote
1answer
14 views

Good layout of 3d point data for spatial queries in Postgres?

Like shown in another question, I deal with a lot (>10,000,000) entries of points in a 3D space. These points are defined like this: CREATE TYPE float3d AS ( x real, y real, z real); If I am ...
0
votes
0answers
2 views

Does anyone use modules in DB2 LUW?

Our environment is currently DB2 9.7 Fix Pack 4 on AIX. I am in the processing of designing and coding some SQL PL stored procedures responsible for archiving data into an archive schema and then ...
0
votes
0answers
7 views

Amazon RDS CPU Usage keep increasing without any long running process in Show Processlist

We are using Amazon RDS(db.m2.2xlarge), CPU usage is suddenly increasing gradually even after we reboot the DB Server. This is happening just past 2 days and we didn't give any new build recently. I ...
0
votes
0answers
22 views

DB table design

We are building a database for a website which is related to the farmers land certification and storing the related data. Table : farmer_detail(id,name,address...) we store farmers details who ...
0
votes
2answers
17 views

Build replication from backup not publication source

I have an interesting scenario I am trying to find a solution to. We currently have the current setup. ProductionDatabase (publisher) is the publication for transnational replication to the ...
0
votes
3answers
10 views

Disable MySQL binary logging with log_bin variable

Default MySQL config file /etc/mysql/my.cnf installed by some debian package using APT often set log_bin variable, so binlog are enabled: log_bin = /var/log/mysql/mysql-bin.log When I want to ...
1
vote
1answer
16 views

MySQL server performance plummets

Part of our software solution is responsible for processing files that get uploaded to us by our clients. We want to process them as quickly as we can. Our system is architected so that there's a ...
3
votes
1answer
165 views

Formal name for functions that use the OVER clause

Is there a formal/academic name for the family of functions in Sql Server like ROW_NUMBER(), LAG, LEAD, RANK etc, that make use of the OVER(ORDER BY <PARTITION BY> ) syntax? How much of this is ...
0
votes
1answer
19 views

Show Non-NULL values from 2 columns in a single column

I need to take the non-null values from two columns and show in a new column: ‘D_Country’. C_Country(Customer) P_Country(Prospect) Each of these columns may have NULL values depending on who the ...
0
votes
0answers
20 views

How to optimize having bit_or?

Let's start with SQLFiddle http://www.sqlfiddle.com/#!2/64fc5/1 I have some urls and I am making some tasks (crons) related to them. Task can be successful or not. I want to try to do it only three ...
1
vote
1answer
9 views

Is 'internallength' always useful in custom type definition in Postgres?

In our database we use a custom type to store 3D locations: CREATE TYPE float3d AS ( x real, y real, z real); In many examples I see INTERNALLENGTH used as a parameter with the definition of ...
0
votes
2answers
28 views

how can I install Microsoft SQL 2005 Server Express Edition on window 8.1

I can't install Microsoft SQL 2005 Server Express Edition on window 8.1.
4
votes
2answers
27 views

InnoDB import performance

I'm struggling with bulk importing a quite big InnoDB-Table consisting of roughly 10 Million rows (or 7GB) (which for me is the biggest table I've worked with so far). I did some research how to ...
1
vote
2answers
36 views

Reindexing Clustered Primary Key

We need to reindex a Clustered Primary Key on quite a large table. Here is the definition of the table: Data Size: 22GB Index Size: 34GB Total Non-Clustered Indexes: 3 Row Count: 54 Million Data ...
1
vote
1answer
19 views

Schema design - Reference slightly different data in different tables

I'm trying to design a schema for a MySQL database and got stuck on the following. My database stores documents which should have relations with blocks of content. create table document ( `id` ...
-1
votes
0answers
15 views

Create a function that returns next working day [on hold]

I have a stored procedure that takes a date as input and returns if it is a holiday. I want to create a function that returns next working day based on that stored procedure and also exclude weekends ...
1
vote
1answer
34 views

Why do sys.columns and INFORMATION_SCHEMA.COLUMNS display different number of columns

Here i am try. Two method to display Particular column name in particular Database in sql server 2008 R2? Use INFORMATION_SCHEMA.COLUMNS SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE ...
0
votes
2answers
13 views

starting pgbouncer on startup

I installed pgbouncer and configured it and it starts only via using this command pgbouncer /etc/pgbouncer/pgbouncer.ini however using service pgbouncer start it dose not start. I then set up ...
0
votes
1answer
15 views

How can I restore ##MS_SSISServerCleanupJobLogin##?

At some point the SSIS cleanup job login (##MS_SSISServerCleanupJobLogin##) got deleted from my sql server (2012). I'm trying to upgrade to SP2 and I'm getting an error message I believe is related to ...
0
votes
0answers
6 views

mongodb import … taking very long time

I have json file of 432.6 MB, which i am uploading to mongodb database, I have mongodb setup on my OS X 10.9.4 mongoimport -d fastqdb -c seqcol --file /Users/loginname/FASTQ.json --jsonArray ...
0
votes
1answer
24 views

MySQL: How turning off the logging affect the performance?

OS: RHEL5 DB: MySQL 5.1.73 community edition DB size: ~1GB I have setup a testing environment and turned off all logging - general logs, binary logs, slow query logs etc. I am using Oracle ...
0
votes
0answers
16 views

MySql Doctrine ORM DB Design for simple app

I am pretty new to Doctrine and am building a simple app and need some help with some thinking. I have: TableA - call it soccer games TableB - days of the week these games are held on TableC - times ...
-1
votes
0answers
17 views

problem faced while starting up a database in oracle

I have created a database named 'test' in oracle 11g express edition.Now while I am trying to stratup "test" after shutdown of database, by default "XE" is getting started.How I solve this problem?
5
votes
2answers
268 views

Index seek much slower with OR condition compared with separate SELECTs

Based on these questions and the answers given: SQL 2008 Server - performance loss possibly connected with a very large table Large table with historical data allocates too much of SQL Server 2008 ...
-2
votes
1answer
27 views

How to display money in 12 Lc or 2 Cr

hi i want display money as 12Lc or 2Cr if money =1200000 as 12 Lc when 12000000 as 1.2 Cr how can i do this help me guys
1
vote
2answers
18 views

ib_logfile opened with O_SYNC when innodb_flush_method=O_DSYNC

mysql will react as below when innodb_flush_method=O_DSYNC Open log Flush log Open datafile Flush data O_DSYNC O_SYNC fsync () My ...
0
votes
0answers
25 views

Inserting INTO XML Column shows nothing at all

I am trying to populate xml in table by, Declare @docy xml = N'<elements>..... 6000 character file </elements>' SET IDENTITY_INSERT TableName ON INSERT TableName(Id, ID_A, ID_B, Xml) ...
1
vote
1answer
17 views

InnoDB internals - checkpoint, LSN, dirty pages

I'm looking into innodb internals regarding buffer pool and checkpoint, dirtypage. However there isn't enogh information to answer my question. When I run show global status, I can get ...
-4
votes
0answers
21 views

Oracle Tablespace issue

I'm trying to insert data in a table of an Oracle database.I would like to populate this table continuously by a java program but, after some hours of work, I have this exception: ORA-01691: unable ...
0
votes
0answers
7 views

MongoDB data directory space is increasing

I have a worry, mongoDB data directory space is increasing very rapidly: I have a two data files and each one has reached 2GB limit and starts spawning 2 GB file multiple files. Is there any where I ...
0
votes
1answer
23 views

Restore InnoDB to different machine

It was pointed to me from serverfault that the following question would be a better fit here so this is basically my original question from there. I currently have backups that were taken with ...
0
votes
1answer
34 views

Database design suggestions for a data scraping/warehouse application?

I'm looking into the database design for a data warehouse kind of project which involves a large number of inserts daily. The data archives will be further used to generate reports. I will have a ...
1
vote
1answer
22 views

MMS is assigning same alias to two data nodes of different shards and replicasets

I am using MMS to monitor a 13 node MongoDB Cluster(3 Config Servers, 4 MongoS, 2 replica sets with 2 members + 1 arbiter each). MMS was working properly since its installation, but now it is not ...
0
votes
0answers
12 views

Metadata database for Enterprise Data Inventory

Has anyone ever encountered either a tool or a fairly concrete implementation plan for recording a metadata inventory of all data within an enterprise. I'm envisioning a database that contains ...
0
votes
1answer
15 views

MySQL Referential Integrity Issue

I'm having a lot of issues and don't really know where to look. I'm pretty sure it's a referential integrity issue and has something to do with the addition of the Professor table and the Foreign Key ...
1
vote
2answers
38 views

update N rows with performance considerations

I have a table with OrderSequence, the schema looks roughly like this: id Name OrderSequence I have an arrays of ids ["1", "2", "3", "4"] from application, i want to set the SequenceOrder for ...
0
votes
1answer
20 views

Trigger on a Schema

Is it possible to create a Trigger on a Schema? I have to audit the changes on my tables. But I have a lot of tables and I don't one to create a trigger on them one by one. --Database level trigger. ...
2
votes
1answer
19 views

What is FT BATCH CMPLETE in the cmd column for sysprocesses?

I was trying to figure out what was causing high cpu usage in our sql server and found two processes that were consuming high CPU. When I queried sysprocesses to see what the spid was doing, it had ...
0
votes
1answer
10 views

How to minimize the writes needed to update a counter field multiple times

I need to minimize the number of queries that are executed just for updating a counter field. One of my example counter fields is raised by 1 everytime a page is visited, I was wondering what could ...
0
votes
0answers
19 views

Problems with foreign keys in a mysql database

I am trying to link both these tables with a foreign key. But I keep getting error message "ERROR 1452: Cannot add or update a child row: a foreign key constraint fails " the foreign key is pwalk_id ...
1
vote
1answer
40 views

Will Transactional Replication Work?

I have multiple site servers and a central server. Each has a Widget table with identical schema. There is currently a custom process that sends new Widget records from the site server that ...
0
votes
0answers
16 views

What is the cost to create Materialized View log

Recently I ran DBMS_ADVISOR.TUNE_MVIEW and it gives me several lines to CREATE MATERIALIZED VIEW LOG ON "MYSCHEMA"."COMPANY" WITH ROWID CREATE MATERIALIZED VIEW LOG ON "MYSCHEMA"."BOARD" WITH ...
4
votes
2answers
71 views

SQL Server: Create New GUID Values for Existing Index

I have an existing table with about 6 million rows. The relevant columns are: ID int not null PK Key uniqueidentifier not null Read/write on this table by Key lookup is probably something like 100 ...
1
vote
0answers
17 views

Replication of a remote MySQL database to local MySQL database

I'm the developer of my employers corporate private website, a HTML5/PHP/CSS powered site for company reports etc. The site, hosted on a shared hosting package, connects to a remote read-only MySQL DB ...
2
votes
1answer
14 views

Replicate single table from Postgres 9.3 replica

I have an existing Postgres 9.3 server acting as a read-only replica using the built-in streaming replication. I need to replicate a single table from a database on that server to another physical ...

15 30 50 per page