Oracle 9i Transaction Performance (Real World vs. TPC)?

Advertisement
Hello:
I was curious if anybody reading this forum has a server/disk architecture that has achieved over 10,000 Oracle Database transactions (with logging enabled) per second?
If so, can you please supply me with the clustered or standalone server and disk farm (NAS, SAN, DAS) details.
Thanks,
Robert
[email protected]
310-536-0018 x124
http://www.imperialtech.com
Advertisement

Replay

Hi,
have a look at http://publications.uu.se/theses/.
This site is now up for nearly one year. We're using Oracle 8.1.7, Apache 1.3.24 and Tomcat 4.0.3. We've got about 4500 hits per day with a maximum up to 9000 hits.
Regards Uwe Hi there Uwe,
Given you are running this in a production environment, are you running the XSQLRequest object or are you running the servlet directly. Running the servlet directly in particular, is just not production ready, unless I am missing something.
1. There are no direct filesystem logging capabilities in the servlet. Doing inserts into a db table for the purposes of logging, is not adequate as the critical points in the servlet operation is either connecting to the database or in the post query phase during the xml transform.
2. Errors like invalid db connections, timeouts, invalid xsql/xsl files, ie All xsql-xxxx errors other than query errors are not trappable from the servlet either via xml or otherwise. They get written directly to the Output stream as text.
Using the XSQLRequest object programmatically, we can work around some of these limitations, but that defeats the purpose and the otherwise ease of use of this servlet in a XML envirnoment.
- Manish

Weblogic-oracle max transactions

Hi, I have to design a system for process ordering in my company in which I am planning to use weblogic. I have a bug concern about database performance. The fact I face is that the systems concentrates its workload during half an hour each day, duri

Any real-world e-commerce application using HTMLDB?

Hi, Any real-world e-commerce application using HTMLDB? If yes, can you please provide the web links? Thanks! SteveThat's why I said "depends on your definition" According to the Wikipedia, the definition of e-commerce is - "Electronic comm

Infocubes - TRANSACTIONAL - STANDARD - REAL TIME

<h3>Some clarity has to be brought in to these three types of CUBES. <h5> I am using SALES ANALYSIS & SALES BUDGET here as an example. <h1>Assumptions & Scenario: <h5>1. Sales Budget is prepared once a year, Division / Grou

R.A.C. - real world solutions&numbers

Does anyone know/have some real world examples, implementations of Real Application Clusters? I need the exact numbers - throughput increase, etc. Preferably from some "Oracle independant" firm :-). I looked in oracle.com, but couldn't find real

RAID test on 8-core with real world tasks gives 9% gain?

Here are my results from testing the software RAID set up on my new (July 2009) Mac Pro. As you will see, although my 8-core (Octo) tested twice as fast as my new (March 2009) MacBook 2.4 GHz, the software RAID set up only gave me a 9% increase at be

ESATA 6g, USB 3 on PCI, real world

I am looking to buy a CalDigit FASTA-6GU3 2 Port USB 3.0 & eSATA 6Gb/s Host Adapter to put in my 2008 Mac Pro PCI slot to run an external Blu-Ray writer and hard drive enclosure off the eSATA ports. Looking for info on what real-world Gps/Mbps the Ma

Real World Battery Life of Macbook Pro (Feb 2012)?

I keep seeing that the Macbook Pro (Feb 2012) has up to 7hrs of battery life. I can't find any real world ACTUAL use results. What have those who bought this model been getting in real world use?I meant a June 2012 Macbook Pro.Read other 2 answers

Real world battery run time of new 15" mbp retina?  (on-board graphics vs. video upgrade)

Considering a new Mac Book Pro 15" retina to use as a dedicated DAW in the studio.  Primarily audio production work but would also do some video editing (Youtube videos, etc.)  Will be primarily in studio but 10 - 15% in the field.  (Hence the MBP ra

RAISE EVENT usage in real world

Hi, I wonder what is the advantage of the statement RAISE EVENT in contrast to a normal call to a class method. Given the following example coding: METHOD pai_0100.   CASE ok_code.     WHEN 'START'.       RAISE EVENT read_sflight_data_event EXPORTING

EJB 3.0 in a real world open source project. Great for coding reference!

If you are interested in seeing EJB 3.0 implemented in a real world project (not just examples) or if you are interested in learning how to use them I suggest you to take a look a the open source project Overactive Logistics. It has been written tota

Link for SAP NetWeaver in the Real World Part 2

Hi,     I can see Part 1 3 4 & 5 but not part 2, of SAP NetWeaver in the Real World pdf. Can someone please give me the link for Part 2 if it exists It is not XI though ! cheers danushi, you can find it on this page: https://www.sdn.sap.com/irj/sdn?r

How to convert pixel Measurment values to real world cordinate systems ( 2D & 3D)

Hello  All I am very new to Image processing and I stuck in a position where i have to convert the pixel measurement value in the real world X,Y,Z  coordinates, and after then that value can be send to the robot arm. For more understanding i have att

Check Point 620 Wired Appliance: Real World Throughput and Experiences

I am considering a purchase of the Check Point 620 wired appliance.   If you have used the 620, I would like to request some help: 1. What real-world throughput have you seen with all blades active?  The internet speed at our site is 120 Mbps 2. What

Can i use "Oracle Database 12c: Performance Management and Tuning " training for getting certification on "Oracle Database 11g: Performance Tuning 1Z0-054"

i have taken "Oracle Database 12c: Performance Management and Tuning new" training from oracle university. Now i would like to get certified on "Oracle Database 11g: Performance Tuning 1Z0-054" exam. Is it possible ?I essentially endor

As a number of Oracle Connections created - Performance Issue

Hello, We are using Oracle 9i as a backend and VB 6.0 as Frontend. For one client one connection will be opened in the Database Server, if 200 clients open the application then 200 connections will be opened in the Database Server, due to that perfor

Oracle 11g Database Performance

We have Oracle 11g (11.1.0.6) database on HP-UX (IA). It's around 200G database, and we have lot of batch job and reports running against this database. This database is performing really bad, whenever we restart the application and the database its

Oracle EBS Application performance tuning course

May I know Oracle EBS r12 application performance tuning course available in Oracle University?Hi Azar, As far as I know there is no course as EBS performance Tuning course. As you know this is the complete Oracle training courses available: Oracle C

Oracle on Linux vs. Oracle on NT (Performance)

Does someone have information about some benchmarks studies of Oracle on Linux vs. Oracle on NT? Thanks so much, AndreI looked at this for a data warehouse project. Same hardware (multi-boot) with various Linux distros (Red Hat, SuSE, and Mandrake) v

Interest frequency of Additional Details in Oracle Treasury Transaction

Dear all, We are using Oracle Treasury. Our client request to input the time deposit with interest payment period so that the system can generate the interest payment per frequency. i.e. a 2 year time deposit with annual interest payment. We found th