Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
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: 47
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: 2197
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: 15243
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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: 47
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: 15243
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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: 47
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: 15243
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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: 47
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) ] [ ]

Current Time: Sat May 17 01:26:36 CDT 2008

Total time taken to generate the page: 0.15024 seconds
.:: Forum Home :: Site Home :: Wiki Home :: Contact :: Privacy ::.