| row chaining [message #60431] |
Sat, 07 February 2004 17:42  |
ashokmote
Messages: 56
Registered: December 2003
|
Member |
|
|
|
in my 8i DB row chaining occured.how can i avoid row chaining in oracle8i(8.1.5).
|
|
|
|
| Re: row chaining [message #60510 is a reply to message #60431] |
Wed, 11 February 2004 09:39  |
ilver
Messages: 50
Registered: January 2004
|
Member |
|
|
Hi,
You need to adjust your pctfree and pctused to reflect the "activity" in your tables.
In addition to that you can do a reorganisation (export / import) when nescessary.
Row chaining is a symptom of updates that cannot be handled whitin the current storage definitions.
When a row is created it get a rowid that is physical, if that row later is updated and there isn't sufficient room for the update you got chained row(s)
/ilver
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
