-
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
Jim
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;
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;
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|