Re: Performance View

anarayth.zata_at_gmail.com wrote:
> Hi,
>
> I have several questions in Oracle server performance, any experts out
> there could answer my questions. Thanks very much.
>
> 1) When I experience the Oracle server is very slow, which performance
> view should I see in order to determine the caused?

None. In 9i run StatsPack in 10g, if licensed for it, AWR: Otherwise StatsPack.

> 2) How do I know if my SQL running in Oracle has sufficient resources
> to run, e.g. memory, cpu, etc.

Pick up a copy of Cary Milsap's and Jonathan Lewis' books.

> 3) How do I know which task running in Oracle is resources demanding?

Pick up a copy of Cary Milsap's and Jonathan Lewis' books.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org