Lol :) Brilliant :D

Hang on I can't see that parameter in OEM have you a command line
instruction to set it ;)

Thank Gawd it's nearly Friday .....

-----Original Message-----
From: Panagopoulos Chris
[mailto:oracledba-ezmlmshield-x7898921.[Email address protected]
Sent: 31 January 2008 16:15
To: LazyDBA Discussion
Subject: RE: Database slow

Xoli

Just set the ora_fast parameter in your init.ora to UNLIMITED.

-----Original Message-----
From: Onicca Mnguni
[mailto:oracledba-ezmlmshield-x4144645.[Email address protected]
Sent: Thursday, January 31, 2008 1:47 AM
To: LazyDBA Discussion
Subject: Database slow

Hi Guys

My database is very slow, I need to know what could be causing it to be
slow.

Xoli


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




This message (including any attachments) is confidential and intended
solely for the use of the individual or entity to whom it is addressed,
and is protected by law. If you are not the intended recipient, please
delete the message (including any attachments) and notify the originator
that you received the message in error. Any disclosure, copying, or
distribution of this message, or the taking of any action based on it,
is strictly prohibited. Any views expressed in this message are those
of the individual sender, except where the sender specifies and with
authority, states them to be the views of Vanguard Health Systems.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




**************************************************************************
IMPORTANT NOTICE

This e-mail may contain information that is privileged, confidential or
otherwise protected from disclosure. It must not be used by, or its contents
copied or disclosed to persons other than the intended recipient(s).
If you have received this e-mail in error, please notify us immediately at
[Email address protected] and delete this e-mail from your system.
Any liability (in negligence or otherwise) arising from any third party
acting, or refraining from acting, on any information contained in this e-mail
is excluded.
It is the responsibility of the recipient to ensure that this message and its
attachments are virus free. UAP Limited are not responsible for any reliance
placed on the information contained in this e-mail and excludes all liability.
**************************************************************************

Oracle LazyDBA home page