Re: Please Help: with tuning database

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Fri, 12 Jul 2002 20:36:31 +1000
Message-ID: <6cyX8.33497$Hj3.101301@newsfeeds.bigpond.com>

Hi Sirirut,

You haven't given us much to go on.

I suggest having a good look at the contents of v$system_event (joined with v$event_name) and v$sysstat (joined with v$statname). See what are causing the waits and any suz stats.

My stab in the dark (hmmm, where will I put my 2 cents). I know. Have you got the database in archivelog mode but you haven't started the ARC0 process ?

Fingers crossed. Good Luck.

Richard
"sirirut vanichayobon" <sirirut_at_ratree.psu.ac.th> wrote in message news:da9eb79f.0207112341.42940dec_at_posting.google.com...
> Dear All,
>
> I am using Oracle9i on Linux. I have encountered one problem. The
> problem is the database was hang while there were only 5-6 users. I
> have to shutdown and then start the database to slove the problem.
> I checked space on memory and datafiles. Both are fine. What
> should I check or tune my database to avoid this kind of problem?
> Any suggestions would be appreciated.
>
> Thanks in advance,
>
> sirirut
Received on Fri Jul 12 2002 - 05:36:31 CDT