Segment related question

[ctcyl]

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

[jovery]

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

[Shestakov]

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.

[Sureshy]

/* 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;