Home » RDBMS Server » Server Administration » Database Compression (Oracle 10g)
Database Compression [message #318671] Wed, 07 May 2008 09:19 Go to next message
kudur_kv
Messages: 75
Registered: February 2005
Member
Hello,

I have been asked to 'COMPRESS' a 10g database.

Is this a possibility? Up to what level can the 'database' be compressed?

I know that there is an option to perform table level and tablespace level compression in 10g R2.

Can some one please provide me with some more details or documentation on this topic.

Appreciate your help.

Thank you.
KV

Report message to a moderator

Re: Database Compression [message #318681 is a reply to message #318671] Wed, 07 May 2008 10:00 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member
Are you talking about backupset compressed?
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/bkup002.htm#BRBSC138

Report message to a moderator

Re: Database Compression [message #318682 is a reply to message #318671] Wed, 07 May 2008 10:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You can't compress an Oracle database.

For documentation on existing compress features, go to:
http://www.oracle.com/pls/db102/search?remark=quick_search&word=compress&tab_id=&format=ranked

Regards
Michel

Report message to a moderator

Re: Database Compression [message #318945 is a reply to message #318681] Thu, 08 May 2008 08:40 Go to previous messageGo to next message
kudur_kv
Messages: 75
Registered: February 2005
Member
No I am not talking about compressed backup set. This is the RMAN feature in 10g that gives the binary compression of backup pieces. I have used it to good effect.

Report message to a moderator

Re: Database Compression [message #318947 is a reply to message #318945] Thu, 08 May 2008 08:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Did you read the link I posted?

Regards
Michel

Report message to a moderator

Re: Database Compression [message #318949 is a reply to message #318682] Thu, 08 May 2008 08:46 Go to previous messageGo to next message
kudur_kv
Messages: 75
Registered: February 2005
Member
Michel,

I found a white paper which talks about compression. May be you will find this helpful.

Cheers
KV
http://www.oracle.com/technology/products/bi/db/10g/pdf/twp_data_compression_10gr2_0505.pdf

Report message to a moderator

Re: Database Compression [message #318950 is a reply to message #318949] Thu, 08 May 2008 08:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Thanks to share it with us.

Regards
Michel

Report message to a moderator

Re: Database Compression [message #318951 is a reply to message #318949] Thu, 08 May 2008 08:56 Go to previous message
kudur_kv
Messages: 75
Registered: February 2005
Member
Michel,

the link that you gave came up with some search results.

But if you see the link that I have sent, I am sure you will know what I meant!

Did the link you sent lead to somethink like the white paper?

Cheers,
KV

Report message to a moderator

Previous Topic: update sys.props$ set VALUE$='AL16UTF16' how to recovery
Next Topic: Database link in use
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 02 01:46:39 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.