Home » RDBMS Server » Performance Tuning » Pctfree (9i)
Pctfree [message #424784] Tue, 06 October 2009 00:38 Go to next message
abdulahads
Messages: 44
Registered: October 2009
Location: SAUDI
Member

Pctfree is set to 10 ,
Block in filled with insert rows.
Free space is 10,
While updating table if free space is filled
what will happen next ?
Re: Pctfree [message #424805 is a reply to message #424784] Tue, 06 October 2009 01:45 Go to previous messageGo to next message
Michel Cadot
Messages: 63818
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Next to what? In what conditions?

Regards
Michel
Re: Pctfree [message #424812 is a reply to message #424805] Tue, 06 October 2009 02:05 Go to previous messageGo to next message
abdulahads
Messages: 44
Registered: October 2009
Location: SAUDI
Member

as it is said that only free space is 10 if data is filled while update and this 10 is also finish and new update need some more space so what next? I think so it's clear now
Re: Pctfree [message #424813 is a reply to message #424784] Tue, 06 October 2009 02:10 Go to previous messageGo to next message
balakrishnay
Messages: 54
Registered: September 2009
Location: Pune
Member
Hi,

Then there is someting called row migrating & row chaining .. please go through the concepts properly.

Regards

Bala
Re: Pctfree [message #424817 is a reply to message #424813] Tue, 06 October 2009 02:22 Go to previous messageGo to next message
abdulahads
Messages: 44
Registered: October 2009
Location: SAUDI
Member

Thanks bala

I will be studying row migrating & row chaining I am new to database

Regards
Abdul
Re: Pctfree [message #424821 is a reply to message #424812] Tue, 06 October 2009 02:28 Go to previous message
Michel Cadot
Messages: 63818
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
abdulahads wrote on Tue, 06 October 2009 09:05
as it is said that only free space is 10 if data is filled while update and this 10 is also finish and new update need some more space so what next? I think so it's clear now

In this case, the updated row is moved into another block but its header is kept in the original block, and this row is named a migrated row.

Regards
Michel

Previous Topic: Histogram Issue
Next Topic: db_block_buffer
Goto Forum:
  


Current Time: Sat Oct 01 05:57:00 CDT 2016

Total time taken to generate the page: 0.07659 seconds