Segment related question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Segment related question

  1. #1
    Join Date
    May 2001
    Posts
    25

    Unhappy

    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

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    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!

  3. #3
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    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.

  4. #4
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    /* 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
  •  


Click Here to Expand Forum to Full Width