OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Table compression (Oracle 11gr2,Linux 6)

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

Table compression [message #601962]

Wed, 27 November 2013 19:33

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Hi,

Could you tell me which is the one that will delete the duplicate values and compress the data ?

1.Table compression.

2.Table defragmentation.

Thanks

Report message to a moderator

Re: Table compression [message #601963 is a reply to message #601962]

Wed, 27 November 2013 19:56

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Jack14 wrote on Wed, 27 November 2013 17:33

Hi,

Could you tell me which is the one that will delete the duplicate values and compress the data ?

1.Table compression.

2.Table defragmentation.

Thanks

Are you unable or unwilling to run test cases to learn the answer yourself?

By the way, how does brain dead software actually determine which records should be classified as duplicate values?

Report message to a moderator

Re: Table compression [message #601964 is a reply to message #601963]

Wed, 27 November 2013 22:54

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Quote:

By the way, how does brain dead software actually determine which records should be classified as duplicate values?

Only you should be knowing it.

Report message to a moderator

Re: Table compression [message #601966 is a reply to message #601964]

Wed, 27 November 2013 23:09

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Jack14 wrote on Wed, 27 November 2013 20:54

Quote:
By the way, how does brain dead software actually determine which records should be classified as duplicate values?

Only you should be knowing it.

HUH?

I have no input or impact when you do either table compression or table defragmentation.

What is duplicate for you may not be duplicate for me.
If every table has PK, then by definition no duplicates exist.
In a well designed application, duplicate records NEVER exist.

Report message to a moderator

Re: Table compression [message #601968 is a reply to message #601962]

Wed, 27 November 2013 23:57

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Jack14 wrote on Thu, 28 November 2013 07:03

Could you tell me which is the one that will delete the duplicate values and compress the data ?

1.Table compression.

2.Table defragmentation.

I don't know much about the defragmentation technique. However, advance table compression in 11g works well as publicized by Oracle. It is specially designed for the OLTP tables and works at block level. You can make use of the "Oracle Advanced Compression Advisor" package.

A good read for you.

Report message to a moderator

Re: Table compression [message #601980 is a reply to message #601968]

Thu, 28 November 2013 01:42

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Thanks a lot. Useful as well.

Report message to a moderator

Previous Topic:	Table Change Detection - Databases
Next Topic:	Migrating MS SQL into Oracle database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 18 15:51:33 CDT 2026