Re: performance tuning

> 1)how can see the fragmentation level? and what is its
> influence on performance.
> 2)what's MTS setup? and its influence.(we are a website
> database)
> 3)how can i see the waiting and locking?
> 4)how can i deside memory size correct (including sql area and
> database blocking)

Most of your answers can be found in the online performance tuning guide.

http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76992/toc.htm

-- 
Galen Boyer
It seems to me, I remember every single thing I know.