Home » RDBMS Server » Performance Tuning » to decide pctused,pctfree in Oracle8i (merged)
to decide pctused,pctfree in Oracle8i (merged) [message #338878] Wed, 06 August 2008 03:02 Go to next message
chinmayikkalki
Messages: 11
Registered: April 2008
Junior Member
Dear Experts,
Its urgent.
I have the data available with me i.e.
TABLE_NAME,
NUM_ROWS,
BLOCKS,
EMPTY_BLOCKS,
AVG_SPACE,
CHAIN_CNT,
AVG_ROW_LEN from user_tables;

I need a perfect solution on
How to decide pctfree,pctused values and for which tables(means the tables whose avg_row_len>xyz or whose chain_cnt>xyz etc)

1. Tables where always inserts r there.
2. tables where insert+select is there.
3. Tables where lot of updates r there.

Regards,
Chinmay.

Re: Pctused,pctfree [message #338881 is a reply to message #338878] Wed, 06 August 2008 03:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't rate your own question above all before anyone answer it.
Read forum guide and don't use words like "urgent".
Read forum guide and format your post.
Read forum guide and post your version with 4 decimals.

Quote:
I need a perfect solution on

Perfection is not of our world so can't answer but documentation gives hints on this, so read it.

Regards
Michel
to decide pctused,pctfree in Oracle8i [message #338896 is a reply to message #338878] Wed, 06 August 2008 03:57 Go to previous messageGo to next message
chinmayikkalki
Messages: 11
Registered: April 2008
Junior Member
Dear Experts,

I have the data available with me i.e.
TABLE_NAME,
NUM_ROWS,
BLOCKS,
EMPTY_BLOCKS,
AVG_SPACE,
CHAIN_CNT,
AVG_ROW_LEN from user_tables;

Do u have a good idea on
How to decide pctfree,pctused values and for which tables(means the tables whose avg_row_len>xyz or whose chain_cnt>xyz etc)

1. Tables where always inserts r there.
2. tables where insert+select is there.
3. Tables where lot of updates r there.

Regards,
Chinmay.
Re: to decide pctused,pctfree in Oracle8i [message #338902 is a reply to message #338896] Wed, 06 August 2008 04:11 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't create a new topic for the same question.
You still don't post your version.
Don't use IM speak.
The answer is the same.

Regards
Michel

[Updated on: Wed, 06 August 2008 04:11]

Report message to a moderator

Previous Topic: buffer cache handles
Next Topic: sql consumes more cpu
Goto Forum:
  


Current Time: Sat Dec 03 18:09:35 CST 2016

Total time taken to generate the page: 0.10271 seconds