Wednesday, December 10, 2008

Benchmarking Oracle 10g XE

Free to develop, deploy, and distribute...

Yes, that's the tagline for Oracle Database 10g Express Edition (XE), an entry-level database based on the 10g R2 code base. Certain handicaps are imposed: only one database can be installed per machine, user data is limited to 4GB, only one CPU shall be used, and only up to 1GB of memory.

Although there are several database benchmarking tools available, I've decided to try Benchmark Factory. The licensed version allows you to simulate 100 users whereas the freeware version is limited to only 20 virtual users.

My target database is an Oracle XE installed on a 32-bit Windows XP Pro system. I ran Benchmark Factory on another unit connected via a 100Mbps Ethernet LAN. Here are the workload benchmark results for 5, 10, 15, and 20 virtual users.


I encountered ORA-12519 errors (TNS:no appropriate service handler found) before the number of virtual clients reached 20. This was resolved by increasing the number of processes specified in the server parameter file (spfile). This is done via the following SQL commands:

SQL> alter system set processes=300 scope=spfile;
SQL> alter system set sessions=300 scope=spfile;

Restart the database and verify that the new parameter values have taken effect. Execute the following SQL command to display the current values:

SQL> select name, value from v$parameter where name in ('processes','sessions');

XE's response times did not falter even up to 100 users. Here is the transaction-time vs user-load comparison graph for 20 to 100 virtual users.


The 1GB memory restriction may have been breached at around 350 virtual users when I encountered ORA-12518 errors (TNS:listener could not hand off client connection). At 325 virtual users, the maximum qualified throughput (MQTH) is computed at 469.221 tpmC. The highest published TPC-C result can be found at TPC.org.

40 comments:

EdwinaHugh said...

免費視訊7mmdvd
免費視訊celia免費視訊5403
免費視訊551281免費視訊mat免費視訊kww
免費視訊icandy免費視訊go
免費視訊ggo
免費視訊ggoo免費視訊聊天aqaq
免費視訊聊天medbooks免費視訊zhaoyu免費視訊yuusnow
免費視訊topchurch
免費視訊twaric免費視訊sage link免費視訊pinker
免費視訊next免費視訊monico
成人視訊onelinux成人視訊qk176成人視訊tdecoshow成人視訊williamsalon成人視訊wu chiueh成人視訊ynbcom成人視訊zk成人視訊zk成人網站googoo色聊天室ipkgirl色聊天室qk176免費交友ggo免費交友go免費交友gogo免費聊天66k免費聊天firework免費聊天聯盟d760免費視訊5403免費視訊551281

痛苦 said...

朝著既定的目標走,就不會迷失。..................................................

腰痠 said...

「不可能」這個字詞,在聰明人的字典中是找不到的。 ..................................................

春天來嚕 said...

very popular to u! ........................................

佩怡 said...

cool blog,期待更新........................................

侯淑真 said...

how do u do?................................................................

上宜俊宇芳心 said...

所有的資產,在不被諒解時,都成了負債......................................................

MichellSommerville0202 said...

thank for share, it is very important . ̄︿ ̄

惠IdellA_Fecteau1231蘋 said...

愛惜生命的人,不可浪費時間,因為時間是組成生命的元素. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

G702aynelleKress0 said...

但行好事,莫問前程. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

美書 said...

你不能左右天氣,但你可以改變心情 ..................................................

BokHaile8854 said...

動不一定每一次都成功,但坐而不行,絕無任何成功可言 ....................................................

jojo said...

How are you~.................................................................

韋于倫成 said...

Many a true word is spoken in jest..........................

Tro0223y_Millan said...

從人生中拿走友誼,猶如從生活中移走陽光..................................................

退 said...

愛情不是慈善事業,不能隨便施捨。..................................................

Dorath政儒yN_ said...

認清問題就等於已經解決了一半的問題。..................................................

王周宏儒 said...

we‘re so proud of you!............................................................

政倫政倫 said...

Never put off till tomorrow what may be done today.................................................................

溫淑芬 said...

支持你!!!期待你的更新!!!相信一定會更好!!!!.................................................................

佳燕 said...

生存乃是不斷地在內心與靈魂交戰;寫作是坐著審判自己。......................................................................

鈺禎蕭 said...

良言一句三冬暖,惡語傷人六月寒。.................................................................

雅琪 said...

卡爾.桑得柏:「除非先有夢,否則一切皆不成。」共勉!............................................................

王名仁 said...

人生是故事的創造與遺忘。............................................................

芸茂芸茂 said...

人因夢想而偉大,要堅持自己的理想哦..................................................................

吳婷婷 said...

不簡單..一路走來辛苦了-..................................................................

盈廖生家秀蔡 said...

肯定與支持你!!!加油囉~..................................................................

richardsbishop20199 said...

真得很不錯的blog,留言加油!............................................................

陳佑發 said...

一個人的際遇在第一次總是最深刻的,有時候甚至會讓人的心變成永遠的絕緣。............................................................

誠紋 said...

找一個懂妳的人也期許自己做一個人懂別人的人............................................................

琬安琬安 said...

生存乃是不斷地在內心與靈魂交戰;寫作是坐著審判自己。..................................................

承蘋承蘋 said...

良言一句三冬暖,惡語傷人六月寒。......................................................................

張志亦劉美玲 said...

愛情是一種發明,需要不斷改良。只是,這種發明和其他發明不一樣,它沒有專利權,隨時會被人搶走。.................................................................

承蔡蔡芸 said...

不要去想沒拿到的東西,多想想自己手裡所擁有的..................................................

淑涂涂華 said...

如果成為一支火柴,也要點亮一個短暫的宇宙;如果是一隻烏鴉,也要叫疼閉塞的耳膜。............................................................

黃子黃麗旺軒 said...

Say not all that you know, believe not all that you hear.......................................................................

凱許倫 said...

我的痛苦會停止,但求我的心能征服它。................................................

惠桂刁惠桂刁惠桂刁 said...

不會從失敗中找尋教訓的人,成功之路是遙遠的。.................................................

said...

生存乃是不斷地在內心與靈魂交戰;寫作是坐著審判自己。..................................................

恩宛玲如 said...

心平氣和~祝你也快樂~~............................................................