OraFAQ Forum: Performance Tuning » Help: chained rows

Home » RDBMS Server » Performance Tuning » Help: chained rows

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Help: chained rows [message #109552]

Fri, 25 February 2005 13:59

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

Report message to a moderator

Re: Help: chained rows [message #109566 is a reply to message #109552]

Sat, 26 February 2005 02:00

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

Report message to a moderator

Re: Help: chained rows [message #109585 is a reply to message #109552]

Sat, 26 February 2005 10:01

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.

Report message to a moderator

Re: Help: chained rows [message #109754 is a reply to message #109585]

Mon, 28 February 2005 11:03

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

Frank
Messages: 7901
Registered: March 2000

Senior Member

Thanks for the feedback. This will help others that search the forum!

Report message to a moderator

Previous Topic:	RAW datatype with NUMBER
Next Topic:	Does Increasing Field Length Decrease Perf?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 22:43:44 CDT 2024