2
votes
4answers
303 views

Should I expect a great increase in Oracle performance in terms of handling multiple requests switching from single to dual core?

We have an Oracle database of roughly 100 GB that runs on top of a Windows Server 2k3R2 VM in ESX in a 1 socket, 1 core configuration. Whenever it has to handle a major query it seems to get "pegged" ...
1
vote
1answer
341 views

How does Oracle Database Standard Edition (One) benefit from running on a dual CPU server?

I am evaluating the impact of additional CPUs on Oracle database performance. I am looking to license Oracle Standard Edition One (SEO, being most cost effective) or Oracle Standard Edition (SE). As ...
1
vote
1answer
995 views

Oracle 11. Updating BLOB field. Db file sequential read inappropriately slow?

I've and Oracle (11 Enterprise) schema with a table CREATE TABLE USER.WSP_BUNDLE ( NODE_ID RAW(16) NOT NULL, BUNDLE_DATA BLOB NOT NULL ); CREATE UNIQUE INDEX USER.WSP_BUNDLE_IDX ...
0
votes
1answer
404 views

Oracle performance after rebuild TEMP

My application was running without any problems for almost one year. But recently someone executed a big select for a report, and the Oracle´s TEMP datafile has grown from 5GB to 30GB. The server then ...
1
vote
1answer
53 views

iSCSI and WAL for database (oracle 11g) performance

I am thinking about building a database system with iSCSI. But now I am thinking about the WAL. WAL shouldn't lag. WAL is implemented with a ring buffer, isn't it? So if I only care about the ...
1
vote
3answers
281 views

Experience with Intel X25-M 160GB and Oracle

We're considering building an Oracle database with 12 Intel X25-M G2 160GB drives in software RAID10. It'd be running Linux. Database gets some very heavy write activity during the early morning data ...
1
vote
1answer
259 views

CPU Performance on Virtualised Windows 2000 for Oracle 8.0.5

Can somebody suggest any steps I can take to improve the CPU performance of an Oracle 8.0.5 database on a Virtualised Windows 2000? Update New installed OS, Windows 2000 Server Advanced SP4 Oracle ...
2
votes
4answers
1k views

Why does this SQL run so much faster in a Oracle server with the same hardware/data than another Oracle server?

My application has a SQL that takes ~ 30 min to run in the Oracle server in production. It takes about the same in a test Oracle server. For some reason, in another Oracle server, it runs much ...
2
votes
2answers
4k views

Extremely High V_$SYSTEM_EVENT Wait Times on Oracle DB

I'm working on troubleshooting an oracle DB that's having some general performance problems. I ran the following query: SELECT event AS "Event|Name", total_waits "Total|Waits", ...
2
votes
9answers
5k views

Oracle Vs SQL Server to handle around 6-7 Terabytes of data

I am looking for some valid points to choose between Oracle Vs SQL Server to handle around 5-6 Terabytes of data. This data will get accumulated over a period of 8 Months. Any data older then 8 months ...
1
vote
1answer
475 views

Oracle: TRUNCATE sometimes takes ages

Usually, truncating a table takes 5-10 seconds. But when several people work on the same DB instance (but different tables), the operation can take more than an hour. How do I debug this?
2
votes
6answers
1k views

Why would Oracle query across network take 300+ times as long as when run on server?

I recently wrote a complex SELECT statement (based on many very, very complex views) that would take 1 hour and 50 minutes to execute when run from Toad on my desktop, and only a few minutes faster ...
2
votes
4answers
3k views

How to best optimize an Oracle database for writes?

How can I maximize the write performance without impacting reads?