Home » RDBMS Server » Performance Tuning » Avoid chain rows (oracle, 9.2.0.4.0, SunSolaris)
Avoid chain rows [message #489532] Mon, 17 January 2011 06:18 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 17:03:03 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.