0
votes
0answers
2 views
Oracle ASM failover strategies
I inherited a production system with the following setup:
Disk A, Failgroup AB
Disk B, Failgroup AB
Disk C, Failgroup CD
Disk D, Failgroup CD
Diskgroups AB and CD are configured with normal ...
2
votes
1answer
26 views
removing group by clause with SUM
So lets say I have a table, MyBigTable that has student scores of an examination. So lets say the structure looks something like
id
name
school
board
exam_partA_score
exam_partB_score
Then I need ...
0
votes
0answers
5 views
sqlite table displaying spaces as?
Im using a Mac with OSX Lion. When using the terminal
sqlite3 databasename
, spaces in fields queried are replaced with '?'.
I have tried
select replace(moveName,'?',' ') from Moves;
But ...
1
vote
1answer
13 views
exposing common parts of a script to another part
I just want to know how you deal with long scripts and redundant information. Here is an example:
Suppose you have three tables. table1, table2.
And you have
SELECT
id = 1
org = 'company'
...
2
votes
1answer
28 views
Relationship with a default value
Firstly, I know my title is somewhat misleading, but I couldn't think of a better title.
Here is my current relationship
CREATE TABLE Events
(
ID INT IDENTITY(1,1) NOT NULL,
Name ...
3
votes
2answers
27 views
Converting RTF in a text column to plain text in bulk
I have a legacy system with about 10 million rows in a table. In that table there is a column of type text, most of them are standard text but about 500 thousand rows have RTF markup in them. I need ...
3
votes
1answer
18 views
Can this be accomplished with Oracles Fine Grained Auditing?
We need to audit when a table is accessed (either select, update or delete) and I know Oracles Fine Grained Auditing can handle that. The issue we are having is that all of our users use the same ...
2
votes
2answers
71 views
Is it OK to create hundreds of databases in SQL Azure versus one big one and run the risk of deadlocking
I need to create highly scalable solution - where field devices in thousands of sites are delivering data in real time to a back end system, and SQL Azure seems to fit the bill nicely in terms of ...
2
votes
1answer
28 views
After dropping the clustered index, it is still attempting to do a clustered insert
I am trying to convert data from one database system to another. One of the tables I need to transfer and format contains over 10 million rows.
I am running the following script to do it:
USE ...
0
votes
0answers
14 views
Error on installing Oracle 11gR2 on Oracle Linux (64-bit)
I was installing oracle 11gr2 on a 64-bit oracle linux 6 box but I was get an error like:
"Invalid source path '../stage/Components/oracle.jdk/1.5.0.17.0/1/DataFiles' specified for unzip. Unzip ...
1
vote
1answer
25 views
PostgreSQL vs MySQL benchmarks when a 2nd level cache is included
Has anyone been able to find any benchmarks comparing PostgreSQL and MySQL performance when they are used by a system through Hibernate (or another comparable ORM) and the 2nd level cache (backed by ...
4
votes
4answers
90 views
What is the easiest way to get started using databases with real data?
I have a project that could benefit from using a database, but I have no experience with databases, don't have access to a server, and have relatively little experience working with things living ...
8
votes
3answers
66 views
Which PowerShell technique should I use to talk to SQL Server?
I'd ultimately like to use PowerShell to replace the old KornShell scripts we use for SQL instance monitors. I'm having a hard time, though, getting my brain around all the different ways that ...
0
votes
0answers
31 views
Oracle extents - why do I have so many?
This is a different question than the one with the almost-identical title.
Again, this is more curiosity about how Oracle Database works than anything I need to change (yes I know multiple extents ...
-2
votes
0answers
24 views
Oracle extents - how is it possible to get so many?
This is more curiosity about how Oracle Database works than anything I need to change (yes I know multiple extents are fine, I read Tom Kyte too).
I have an index with the following characteristics:
...
