| to decide pctused,pctfree in Oracle8i (merged) [message #338878] |
Wed, 06 August 2008 03:02  |
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.
|
|
|
|
|
|
| to decide pctused,pctfree in Oracle8i [message #338896 is a reply to message #338878] |
Wed, 06 August 2008 03:57  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
