howto ANALYZE index organized table to find chained row(overflow)

Hi All,

Have anyone try to analzye index organized table to find chained row (that mean overflow).

I found this from Oracle document:

After choosing a threshold value, you can monitor tables to verify that the value you specified is appropriate. You can use the ANALYZE TABLE LIST CHAINED ROWS statement to determine the number and identity of rows exceeding the threshold value.

To analyze index-organized tables, you must create a separate CHAINED ROWS table for each and every index-organized table (to accommodate the primary key storage of index-organized tables). You can use the SQL scripts DBMSIOTC.SQL and PRVTIOTC.PLB to define the BUILD_CHAIN_ROWS_TABLE package definition, and then execute this procedure to create an IOT_CHAINED_ROWS table for an index-organized table.

You must execute both DBMSIOTC.SQL and PRVTIOTC.PLB in the 'SYS' schema to create the package definition. PUBLIC users have EXECUTE privileges for the procedures defined in the packages, so users in any schema can use them to create the LIST_CHAIN_ROW table.

---

I actually have to create a separate "CHAINED ROWS" table for
each index-organized table to store??

Have anyone do this before?

I am still not too sure how to do it.

If anyone has any idea.
I really appreciate,



DOM