Home » RDBMS Server » Performance Tuning » Help: chained rows
Help: chained rows [message #109552] Fri, 25 February 2005 13:59 Go to next message
Jadie
Messages: 64
Registered: January 2002
Member
Hi All,

I used the TOAD to heathy check the database, and I got the following information:

[Tables with > 5 % chained rows and > 500 total rows] Exec Time 0 seconds
! DHS01.CONSUMERS : 6% of rows chained, PCT_FREE = 10
! DHS01.CREATE$JAVA$LOB$TABLE : 27% of rows chained, PCT_FREE = 10
! DHS01.FORM_FACTORS : 7% of rows chained, PCT_FREE = 10
! MIS01.ACTIVE_CONSUMERS : 16% of rows chained, PCT_FREE = 10

Can anyone give me some ideas what is the procedure to fix the chained rows problem? I appriate any response. Thank you.

Jadie
Re: Help: chained rows [message #109566 is a reply to message #109552] Sat, 26 February 2005 02:00 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Maybe it would be a good idea to first read about chained rows. Read the docs, or google for <oracle chained rows>.

hth
Re: Help: chained rows [message #109585 is a reply to message #109552] Sat, 26 February 2005 10:01 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://www.orafaq.com/msgboard/tuning/messages/991.htm
MORE INFORMATION in docs.
Re: Help: chained rows [message #109754 is a reply to message #109585] Mon, 28 February 2005 11:03 Go to previous messageGo to next message
Jadie
Messages: 64
Registered: January 2002
Member
Thanks for your reply. I really appriate it.

I found an article:
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:4423420997870

it explains it better and also give me the answer of how to fix it. Thank again.

Jadie

[Updated on: Mon, 28 February 2005 11:04]

Report message to a moderator

Re: Help: chained rows [message #109760 is a reply to message #109552] Mon, 28 February 2005 11:13 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Thanks for the feedback. This will help others that search the forum!
Previous Topic: RAW datatype with NUMBER
Next Topic: Does Increasing Field Length Decrease Perf?
Goto Forum:
  


Current Time: Sun Mar 03 23:14:47 CST 2024