Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2014
    Posts
    5

    Unanswered: Example about PCTUSED and PCTFREE in oracle 11g

    Hi all,
    1. I need a example to see the effect of PCTUSED and PCTFREE in oracle 11g.
    Such as I want see how to see this block is full (free space less than PCT_FREE), and new rows has been inserted to new blocks,......
    2. why use a dictionary tablespace management is bad performance?
    Thanks !

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Sep 2014
    Posts
    5
    Ohh !
    This is my thread.
    I received answer but I not really satisfied.

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Is it because it requires you to do some reading? As far as I can see, Michel posted some links and you seemed to be quite happy with that. Did you lie?

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >but I not really satisfied
    What is needed for you to be satisfied.

    After you are satisfied, how will you behave differently?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •