Segment related question

Dear friends ...

I want to know, which of the following segments types usualy have the lowest turnover in the oracle database.

Temporary segments
Table Segments
Undo Segments
System segments

Thanks
Sandeep

What do you mean by 'turnover'? (reads, updates, deletes, etc) and the result can vary depending on the type of application the database serves.

Regards

And then: What did u mean when wrote "SYSTEM SEGMENT"
What is it?
This is TABLE/INDEX ... segment in system tablespace?

This type of segment doesn't exists in Oracle database.

SQL> select distinct SEGMENT_TYPE from dba_segments;

SEGMENT_TYPE
------------------
CACHE
CLUSTER
INDEX
LOBINDEX
LOBSEGMENT
ROLLBACK
TABLE
TEMPORARY

If u read about this type of segment in book "Introduction ... Z030..." then u have to know
that the book is collection of errors, typos and conceptual mistakes.
Read this book very carifully.

/* Check disk i/o per file and determine bottlenecks */

select phyrds, phywrts, d.name
from v$datafile d, v$filestat f
where d.file#=f.file#
order by d.name;