OraFAQ Forum: Server Administration » Example about PCTUSED and PCTFREE in oracle 11g.

Home » RDBMS Server » Server Administration » Example about PCTUSED and PCTFREE in oracle 11g. (Oracle 11g, Linux 5.10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Example about PCTUSED and PCTFREE in oracle 11g. [message #624344]

Mon, 22 September 2014 05:16

trybestpro
Messages: 17
Registered: September 2014
Location: HCM

Junior Member

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 !

[Updated on: Mon, 22 September 2014 05:16]

Report message to a moderator

Re: Example about PCTUSED and PCTFREE in oracle 11g. [message #624346 is a reply to message #624344]

Mon, 22 September 2014 05:25

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1. Dump the blocks: Alter system dump datafile <filenb> block <blocknb>
2. Because it uses the dictionary to manage the extents and so every one wants to use it ans so it becomes a bottleneck.

Report message to a moderator

Re: Example about PCTUSED and PCTFREE in oracle 11g. [message #624351 is a reply to message #624346]

Mon, 22 September 2014 05:32

trybestpro
Messages: 17
Registered: September 2014
Location: HCM

Junior Member

Michel Cadot wrote on Mon, 22 September 2014 13:25

2. Because it uses the dictionary to manage the extents and so every one wants to use it ans so it becomes a bottleneck.

Can you answer more details ? oracle process how to make the performance worse ?

Report message to a moderator

Re: Example about PCTUSED and PCTFREE in oracle 11g. [message #624352 is a reply to message #624351]

Mon, 22 September 2014 05:37

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I could but it would take time for nothing, all tablespaces are now locally managed.
If you are really interested in old technology you can find articles on this on the web, just Google for it.

Report message to a moderator

Re: Example about PCTUSED and PCTFREE in oracle 11g. [message #624380 is a reply to message #624352]

Mon, 22 September 2014 07:09

trybestpro
Messages: 17
Registered: September 2014
Location: HCM

Junior Member

Michel Cadot wrote on Mon, 22 September 2014 13:37

I could but it would take time for nothing, all tablespaces are now locally managed.
If you are really interested in old technology you can find articles on this on the web, just Google for it.

Hi,

I know it's old technology, Oracle not recommended this.
But my teacher ask me explain why it is bad performance.
I search Google, I received answer that it use a free list and used list, but I don't know how detailed the.
Thanks.

Report message to a moderator