RE: Project stocks having problems.

From: John Wong <jonwon_at_catcha.com>
Date: Thu, 9 Dec 1999 11:21:50 +0800
Message-ID: <82n783$u6f$1@clematis.singnet.com.sg>

Hello everyone,

Background:
3 days ago, everything was acting correctly and well, ie. our program to decode the raw data feed from stock exchange.

But 2 days ago, problem exists. The program starts to act slowly. Until last night, we are able to isolate the problem, i.e. the query to Oracle has slowdown.

We cannot pinpoint Oracle but have couple of these questions.

We have started our db for about a month already. We cleared out tables everyday. Why is it that the performances of the database is very slow ?
The size of the rollback segments is 500M now, is this a reasonable size? How do i go about tuning it ?
Any ways of increasing the performances of the database within a few days?
noticed that the rollback segment increases when we clear all our tables, why ?
could it be the cpu problem too ?

I would like to hear from you if you have suggestions/feedback. I would also
appreciate if you can direct these to some of your expert friends.

Meanwhile, i am waiting/looking for an oracle consultant. If you know any, please let me know. Thanks.

Regards,
John Wong

John Wong
Chief Technical Officer
Catcha.com

Phone: (65) 733 6166
Fax: (65) 733 0915
Handphone: (65) 9655 2247

South East Asia's No.1 Search Engine Portal www.catcha.com www.catcha.com.sg
www.catcha.com.my www.catcha.co.id

Received on Wed Dec 08 1999 - 21:21:50 CST