Home » RDBMS Server » Server Administration » Example about PCTUSED and PCTFREE in oracle 11g. (Oracle 11g, Linux 5.10)
Example about PCTUSED and PCTFREE in oracle 11g. [message #624344] Mon, 22 September 2014 05:16 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: Example about PCTUSED and PCTFREE in oracle 11g. [message #624351 is a reply to message #624346] Mon, 22 September 2014 05:32 Go to previous messageGo to next message
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 ?
Re: Example about PCTUSED and PCTFREE in oracle 11g. [message #624352 is a reply to message #624351] Mon, 22 September 2014 05:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: Example about PCTUSED and PCTFREE in oracle 11g. [message #624380 is a reply to message #624352] Mon, 22 September 2014 07:09 Go to previous messageGo to next message
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, Laughing
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.
Re: Example about PCTUSED and PCTFREE in oracle 11g. [message #624381 is a reply to message #624380] Mon, 22 September 2014 07:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

http://www.orafaq.com/node/3.
http://www.databasejournal.com/features/oracle/article.php/2223631/Understanding-Oracles-Locally-Managed-Tablespaces.htm

Re: Example about PCTUSED and PCTFREE in oracle 11g. [message #624391 is a reply to message #624381] Mon, 22 September 2014 08:30 Go to previous message
trybestpro
Messages: 17
Registered: September 2014
Location: HCM
Junior Member
Hi, Laughing Laughing
I'm thank you very much.
Previous Topic: Object Movement Between Datafiles
Next Topic: Simulator transaction in oracle 11g
Goto Forum:
  


Current Time: Thu Mar 28 09:28:42 CDT 2024