Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: My Ora is so slooooow...

Re: My Ora is so slooooow...

From: sean <sean_at_kistem.po.my>
Date: Tue, 26 Nov 2002 09:51:26 +0800
Message-ID: <aruk5m$od5$1@news6.jaring.my>


hi Mark,

How to get those v$session_wait and v$system_event ?

--
Regards,
sean_at_Denote
25-Nov 9.49a

"Mark D Powell" <Mark.Powell_at_eds.com> wrote in message
news:2687bb95.0211250837.651ab54b_at_posting.google.com...

> Sean, what made you think increasing the datafiles sizes would make
> any difference to begin with?
>
> 1 - An Oracle database should have more than 3 files so a brief
> description of the database file organization might be useful
>
> 2 - When the problem is occuring you need to capture a snapshot of
> system performance statistics and of database performance statistics
> to point you in the right direction. I would suggest you start by
> looking to see if you have any lock waited sessions and then look at
> the v$session_wait and v$system_event to see what Oracle is waiting
> on.
>
> 3 - Version 7.3 is getting to be OLD. You might consider upgrading to
> 8.l.7 or 9.2 once you get a handle on the problem at hand
>
> HTH -- Mark D Powell --
Received on Mon Nov 25 2002 - 19:51:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US