OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Avoid chain rows (oracle, 9.2.0.4.0, SunSolaris)

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

Avoid chain rows [message #489532]

Mon, 17 January 2011 06:18

sathik
Messages: 196
Registered: August 2009
Location: INDIA

Senior Member

Hi,

There is coulmn called DATA in a table with LONG RAW datatype. we are facing more than 60% chained rows in this table because of this LONG RAW column.

It is very difficult to clean up these chained rows periodically. Since an application using this table is a business critical interms of high availability.

Hence, is there any other way in oracle to avoid chained rows permanently in future?

Report message to a moderator

Re: Avoid chain rows [message #489533 is a reply to message #489532]

Mon, 17 January 2011 06:25

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

With a LONG RAW column you cannot avoid chained rows.
Too bad you did choose an obsolete datatype.

Regards
Michel

[Updated on: Mon, 17 January 2011 06:25]

Report message to a moderator

Re: Avoid chain rows [message #489534 is a reply to message #489533]

Mon, 17 January 2011 06:28

sathik
Messages: 196
Registered: August 2009
Location: INDIA

Senior Member

Thanks for your response. It was designed more than 7 years back.
Please let me know what datatype i can choose here instead LONG RAW?

Report message to a moderator

Re: Avoid chain rows [message #489539 is a reply to message #489534]

Mon, 17 January 2011 07:14

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

LONG RAW are obsolete since the last century. Someone that designed such application 7 years ago was late of about 5 years.

You should use BLOB instead.

Regards
Michel

Report message to a moderator

Re: Avoid chain rows [message #489560 is a reply to message #489539]

Mon, 17 January 2011 09:17

sathik
Messages: 196
Registered: August 2009
Location: INDIA

Senior Member

Do u mean, if I convert the datatype from LONG RAW to BLOB, we can avoid the chain rows permanently in future?

[Updated on: Mon, 17 January 2011 09:25]

Report message to a moderator

Re: Avoid chain rows [message #489566 is a reply to message #489560]

Mon, 17 January 2011 10:40

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

No, you can manage them as BLOB can be stored in a separate segement (or even tablespace) and so you access this part ONLY when you need it.
On the other hand, you will likely have to change your application code.

Regards
Michel

Report message to a moderator

Previous Topic:	MEMORY_TARGET and MEMORY_MAX_TARGET
Next Topic:	AWR report in 11g standard not supported?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 02:00:45 CST 2024