Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: My Ora is so slooooow...
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...Received on Mon Nov 25 2002 - 19:51:26 CST
> 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 --