Dear friends ...
I want to know, which of the following segments types usualy have the lowest turnover in the oracle database.
What do you mean by 'turnover'? (reads, updates, deletes, etc) and the result can vary depending on the type of application the database serves.
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
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;
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
order by d.name;
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.
Click Here to Expand Forum to Full Width