oracle9i database performance

[techdba]

Hi all,
we are having oracle9i on linux 7.o OS
we are also running apache server on same system.

we are having around 10 schemas ...which are configured for websites.

Oracle database hangs after some hits are reached on web sites...
and forces administrator to restart the machine..

all the database initial settings are by default as available when 9i is initially installed.

we have not modified any init.ora parameters..

can anyone throw me light regarding performance settings which are to be configured..

Thanks & regards
Prakash

[jovery]

You problem is too vague, performance tuning to too big a topic to discuss unless you can give specifics.

How big are you databases?
What is the confiuration of the hardware?
What is the application tier, how are users connecting?
How many users are hitting the database?
What sort of queries are being performed?
Is the problem a hardware/software resource problem?
Etc, Etc, Etc...

Regards

[Sameer]

Jim's suggestions +
I will suggest to change OPEN_CURSOR parameter from its default value and increase it.

[JChiappa]

The first issue, IMHO, is the "freezening" of the database : is it REALLY stoped OR it is waiting for something ? Check the wait and stats v$ view to know. And the OS stats (vmstat, top, sar, iostat), is the machine pagining ? Any hot disks ? And about the free mem ?

[]s

Chiappa

[techdba]

Hi
Following are some details regarding databases

How big are you databases?------Total database size is -- 350 MB
What is the confiuration of the hardware?-----512 Mb ram, PIII 500Mhz
What is the application tier, how are users connecting?---users access from web server thru Pure Java Driver
How many users are hitting the database?----Nearly 100 users
What sort of queries are being performed?---normal select, update queries, insert and a few subqueries
Is the problem a hardware/software resource problem?--we are not sure whether it is hardware or software resourece problem, but we suspect it is software resource.

do let me know any hints.

Thanks & Regards
Prakash

[techdba]

Following are detials

Total database size is -- 350 MB
Confiuration of the hardware?-----512 Mb ram, PIII 500Mhz
How are users connecting?---users access from web server thru Pure Java Driver
Number of users hitting the database----Nearly 100 users
Sort of queries are being performed?---normal select, update queries, insert and a few subqueries
Is the problem a hardware/software resource problem?--we are not sure whether it is hardware or software resourece problem, but we suspect it is software resource.

Also on the same machine we running apache server ...

If anyone has hints about this do suggest.

Regards
Prakash