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?

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

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


Any suggestion is apprepciated.

On 24 Mag, 07:11, anarayth.z... (AT) gmail (DOT) com wrote:
all V$ are performance views. v$sgastat, v$sesstat, v$session are
most important, but also verify server performance (ram,I/O,CPU)

v$session and some dictionary views are useful (dba_tables,
dba_segments, etc.) with dba_stats package to make statistics

V$session joined with V$sesstat

see Oracle DBA Performance Tuning on-line documentation

anarayth.zata (AT) gmail (DOT) com wrote:
None. In 9i run StatsPack in 10g, if licensed for it, AWR: Otherwise
StatsPack.

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

Pick up a copy of Cary Milsap's and Jonathan Lewis' books.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org